Lionslayer
၁ ဩဂုတ် ၂၀၀၉ အချိန်တွင် ချိတ်ဆက်ခဲ့သည်
Content deleted Content added
အရေးမကြီး →duplicate entry |
|||
စာကြောင်း ၈၄ -
:There are even same villages names for same township. We need to go with village tract names. Problem is that the list only comes with English names except for main village names. I have only finished only for Yangon region. We can manually create different articles later, but it's a lot of works. I use excel formula to convert data to wiki format. The top line between three apostrophe will become article name. Any advice? [[User:Lionslayer|<span style="text-shadow:grey 0.1em 0.1em 0.1em; class=texhtml"><font size=2><font color=#000000><font face="BankGothic Md BT"><b><i>@==<font color=#330000>{<font color=#660000>Lion<font color=#990000>sla<font color=#FF0000>yer>]][[User_Talk:Lionslayer|<span style="text-shadow:grey 0.1em 0.1em 0.1em; class=texhtml"><font size=2><font color=#427224><sup>☎</sup></span></span></span>]] ၀၆:၃၂၊ ၁၅ ဧပြီ ၂၀၁၂ (UTC)
::Hi! sorry for late reply. pls download this excel for sample [http://dl.dropbox.com/u/41933615/village%20name%20combination.xlsx drop box excel file], and let me know if it is not ok ,cant send file directly to u as i dont know ur mail. [[User:Aunghtike|Aunghtike]] ([[User talk:Aunghtike|talk]]) ၁၂:၁၅၊ ၁၈ ဧပြီ ၂၀၁၂ (UTC)
:::It's in WinInnwa. We need it in Unicode of course. Here is my example formula for converting to Wiki format. The Excel sheet I used was for Rakhine, 7-villages tab, start from R2. Formula is as below.
<source lang="latex">="{{-start-}}"&CHAR(13)&"'''"&L2&"ရွာ'''"&CHAR(13)&"{{Infobox settlement"&CHAR(13)&"|official_name = "&L2&CHAR(13)&"|pushpin_label_position = bottom"&CHAR(13)&
"|pushpin_map = Myanmar"&CHAR(13)&"|pushpin_map_caption = "&L2&" တည်နေရာ၊ မြန်မာ။"&CHAR(13)&"|pushpin_mapsize = 300"&CHAR(13)&"|subdivision_type = Country"&CHAR(13)&"|subdivision_name = {{flag|Myanmar}}"&CHAR(13)&"|subdivision_type1 = [[မြန်မာနိုင်ငံ ပြည်နယ်များ|ပြည်နယ်]]"&CHAR(13)&
"|subdivision_name1 = [[ရခိုင်]]"&CHAR(13)&"|subdivision_type2 = [[မြန်မာနိုင်ငံ ခရိုင်များ|ခရိုင်]]"&CHAR(13)&"|subdivision_name2 = [["&D2&"]]"&CHAR(13)&"|subdivision_type3 = [[မြန်မာနိုင်ငံ မြို့နယ်များ|မြို့နယ်]]"&CHAR(13)&"|subdivision_name3 = [["&F2&"]]"&CHAR(13)&"|subdivision_type4 = [[မြန်မာနိုင်ငံ ကျေးရွာစုများ|ကျေးရွွာစု]]"&CHAR(13)&
"|subdivision_name4 ="&H2&"<ref>GAD, Feb 2011.</ref>"&CHAR(13)&"|latNS = N"&CHAR(13)&"|latd = "&N2&CHAR(13)&"|longEW = E"&CHAR(13)&"|longd = "&M2&CHAR(13)&"|P-code = "&I2&CHAR(13)&
"}}"&CHAR(13)&"==ကိုးကား=="&CHAR(13)&"<references/>"&CHAR(13)&"[[Category:မြန်မာနိုင်ငံ ရွာများ]]"&CHAR(13)&"[[Category:ရခိုင်ပြည်နယ်]]"&CHAR(13)&"[[Category:BotUpload]]"&"{{-stop-}}"</source>
CHAR(13) is new line for Excel for Mac. You can use CHAR(10) for Windows. The result will be as follow.
<source lang="latex">"{{-start-}}
'''အဘောင်တော်ရွာ'''
{{Infobox settlement
|official_name = အဘောင်တော်
|pushpin_label_position = bottom
|pushpin_map = Myanmar
|pushpin_map_caption = အဘောင်တော် တည်နေရာ၊ မြန်မာ။
|pushpin_mapsize = 300
|subdivision_type = Country
|subdivision_name = {{flag|Myanmar}}
|subdivision_type1 = [[မြန်မာနိုင်ငံ ပြည်နယ်များ|ပြည်နယ်]]
|subdivision_name1 = [[ရခိုင်]]
|subdivision_type2 = [[မြန်မာနိုင်ငံ ခရိုင်များ|ခရိုင်]]
|subdivision_name2 = [[Sittwe]]
|subdivision_type3 = [[မြန်မာနိုင်ငံ မြို့နယ်များ|မြို့နယ်]]
|subdivision_name3 = [[Ponnagyun]]
|subdivision_type4 = [[မြန်မာနိုင်ငံ ကျေးရွာစုများ|ကျေးရွွာစု]]
|subdivision_name4 =Gant Gar (Rakhine)<ref>GAD, Feb 2011.</ref>
|latNS = N
|latd = 20.44173
|longEW = E
|longd = 92.92945
|P-code = 196264
}}
==ကိုးကား==
<references/>
[[Category:မြန်မာနိုင်ငံ ရွာများ]]
[[Category:ရခိုင်ပြည်နယ်]]
[[Category:BotUpload]]{{-stop-}}"</source>
You can send directly to slayeroflion gmail for any update. Thanks. [[User:Lionslayer|<span style="text-shadow:grey 0.1em 0.1em 0.1em; class=texhtml"><font size=2><font color=#000000><font face="BankGothic Md BT"><b><i>@==<font color=#330000>{<font color=#660000>Lion<font color=#990000>sla<font color=#FF0000>yer>]][[User_Talk:Lionslayer|<span style="text-shadow:grey 0.1em 0.1em 0.1em; class=texhtml"><font size=2><font color=#427224><sup>☎</sup></span></span></span>]] ၁၃:၀၈၊ ၁၈ ဧပြီ ၂၀၁၂ (UTC)
| |||