私はESRIのCollector for ArcGISを使用してフィールドデータコレクターと連携しています。システムはArcMapからArcGIS Onlineに公開されています。データはPole Assembliesだけでなく、高さ、クラス、種別も収集されています。彼らが収集したこのデータを使ってWindmilで高さ、クラス、種別をかなり簡単に更新できますが、収集されたassembliesを迅速に更新する方法が不足しています。過去には、データを一つずつ確認し、assembliesを一つずつ更新していました。ご想像の通り、これは時間がかかり面倒な作業です。すべて事前にフォーマットされたこのデータをWindmilに迅速に追加する方法があるかどうかお伺いしたいです。最初の添付ファイルにはすべてのデータがあり、2番目の添付ファイルはすべてのデータを変換したい場所です。何かアイデアや回避策があれば大変ありがたいです。 windmilmap windmil milsoft

Amanda and I worked together on this and came up with a solution. The field user is editing the "Assemblies Count" string and the result is in the attached sample.csv file where one line represents each pole or other map point. There can be many assemblies listed on each line. The script parses that string and converts it to Milsoft .asm format (sampleAssemblies.asm) where each line lists one assembly. That file can be imported in WindMil or WindMilMap, updating the assemblies all at once. The field user has to be very careful not to alter the format of the Assemblies Count string. #------------------------------------------------------------------------------- # Name: sampleCsvToAsm.py # Purpose: prototype for Amanda at Flathead to read assemblies as collected during # field survey to Milsoft ASCII .asm format # Author: Tyler Grosshuesch # tgrosshuesch@acecwi.com # tdgrosshuesch@gmail.com # Created: 2017-06-23 #------------------------------------------------------------------------------- #Change these two paths as necessary input = r 'C:\TEMP\sample.csv' output = r 'C:\TEMP\sampleAssemblies.asm' asmHeader = 'Map Point Name,Assembly Name,Quantity' with open ( input , 'rb' ) as inFile : with open ( output , 'wb' ) as outFile : toWrite = asmHeader #start building the output string content = inFile . readlines ( ) [ 1 : ] #read the file and skip first line, https://stackoverflow.com/a/4796812 for line in content : firstCommaAt = line . index ( ',' ) mapPointID , assemblies = line [ : firstCommaAt ] , line [ firstCommaAt + 1 : ] . strip ( ) #split it into pieces with the map point ID and the list of assemblies and quantities assembliesWithQty = filter ( None , assemblies . split ( ',' ) ) #filter removes the nulls, split breaks them into a list of individual (qty)assembly pairs for aQ in assembliesWithQty : qty , assembly = aQ . replace ( '(' , '' ) . split ( ')' ) #get rid of the '(' character and split the qty and assembly into pieces on the ')' character print ( mapPointID + ',' + assembly + ',' + qty ) #for testing toWrite = toWrite + '\n' + mapPointID + ',' + assembly + ',' + qty #add each assembly to the output string on a new line outFile . writelines ( toWrite ) #write the output string all at once to the output file) #write the output string all at once to the output file

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Milsoft（Windmil）を手動で行わずにAssembly Names Dataで更新するにはどうすればよいですか？

AmandaOpp

<\/HEAD>

私はESRIのCollector for ArcGISを使用してフィールドデータコレクターと連携しています。システムはArcMapからArcGIS Onlineに公開されています。データはPole Assembliesだけでなく、高さ、クラス、種別も収集されています。彼らが収集したこのデータを使ってWindmilで高さ、クラス、種別をかなり簡単に更新できますが、収集されたassembliesを迅速に更新する方法が不足しています。<\/SPAN><\/P> <\/SPAN><\/P>過去には、データを一つずつ確認し、assembliesを一つずつ更新していました。ご想像の通り、これは時間がかかり面倒な作業です。すべて事前にフォーマットされたこのデータをWindmilに迅速に追加する方法があるかどうかお伺いしたいです。<\/SPAN><\/P> <\/SPAN><\/P>最初の添付ファイルにはすべてのデータがあり、2番目の添付ファイルはすべてのデータを変換したい場所です。何かアイデアや回避策があれば大変ありがたいです。<\/SPAN><\/P><\/P>windmilmap<\/P>windmil<\/P>milsoft<\/P><\/BODY><\/HTML>

タグ付けされた投稿をもっと見る

Accepted answers

TylerGrosshuesch1

Amanda and I worked together on this and came up with a solution. The field user is editing the "Assemblies Count" string and the result is in the attached sample.csv file where one line represents each pole or other map point. There can be many assemblies listed on each line. The script parses that string and converts it to Milsoft .asm format (sampleAssemblies.asm) where each line lists one assembly. That file can be imported in WindMil or WindMilMap, updating the assemblies all at once. The field user has to be very careful not to alter the format of the Assemblies Count string.

<SPAN class="comment token">#-------------------------------------------------------------------------------</SPAN>
<SPAN class="comment token"># Name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sampleCsvToAsm.py</SPAN>
<SPAN class="comment token"># Purpose:&nbsp;&nbsp;&nbsp;&nbsp; prototype for Amanda at Flathead to read assemblies as collected during</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field survey to Milsoft ASCII .asm format</SPAN>
<SPAN class="comment token"># Author:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tyler Grosshuesch</SPAN>
<SPAN class="comment token"><SPAN>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A class="jive-link-email-small" href="mailto:tgrosshuesch@acecwi.com" rel="nofollow noopener noreferrer" target="_blank">tgrosshuesch@acecwi.com</A></SPAN>
<SPAN class="comment token"><SPAN>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A class="jive-link-email-small" href="mailto:tdgrosshuesch@gmail.com" rel="nofollow noopener noreferrer" target="_blank">tdgrosshuesch@gmail.com</A></SPAN>
<SPAN class="comment token"># Created:&nbsp;&nbsp;&nbsp;&nbsp; 2017-06-23</SPAN>
<SPAN class="comment token">#-------------------------------------------------------------------------------</SPAN>

<SPAN class="comment token">#Change these two paths as necessary</SPAN>
input <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\TEMP\sample.csv'</SPAN>
output <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\TEMP\sampleAssemblies.asm'</SPAN>

asmHeader <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Map Point Name,Assembly Name,Quantity'</SPAN>

<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'rb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> inFile<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'wb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> outFile<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; toWrite <SPAN class="operator token">=</SPAN> asmHeader <SPAN class="comment token">#start building the output string</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; content <SPAN class="operator token">=</SPAN> inFile<SPAN class="punctuation token">.</SPAN>readlines<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"><SPAN>#read the file and skip first line, </SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fstackoverflow.com%2Fa%2F4796812" target="_blank">https://stackoverflow.com/a/4796812</A></SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> line <SPAN class="keyword token">in</SPAN> content<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; firstCommaAt <SPAN class="operator token">=</SPAN> line<SPAN class="punctuation token">.</SPAN>index<SPAN class="punctuation token">(</SPAN><SPAN class="string token">','</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mapPointID<SPAN class="punctuation token">,</SPAN> assemblies <SPAN class="operator token">=</SPAN> line<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN>firstCommaAt<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> line<SPAN class="punctuation token">[</SPAN>firstCommaAt<SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#split it into pieces with the map point ID and the list of assemblies and quantities</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; assembliesWithQty <SPAN class="operator token">=</SPAN> filter<SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> assemblies<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">','</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#filter removes the nulls, split breaks them into a list of individual (qty)assembly pairs</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> aQ <SPAN class="keyword token">in</SPAN> assembliesWithQty<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; qty<SPAN class="punctuation token">,</SPAN> assembly <SPAN class="operator token">=</SPAN> aQ<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'('</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">')'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#get rid of the '(' character and split the qty and assembly into pieces on the ')' character</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>mapPointID <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN> <SPAN class="operator token">+</SPAN> assembly <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN> <SPAN class="operator token">+</SPAN> qty<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#for testing</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; toWrite <SPAN class="operator token">=</SPAN> toWrite <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN> <SPAN class="operator token">+</SPAN> mapPointID <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN> <SPAN class="operator token">+</SPAN> assembly <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN> <SPAN class="operator token">+</SPAN> qty <SPAN class="comment token">#add each assembly to the output string on a new line</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outFile<SPAN class="punctuation token">.</SPAN>writelines<SPAN class="punctuation token">(</SPAN>toWrite<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#write the output string all at once to the output file) #write the output string all at once to the output file‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

sampleAssemblies.asm.zip

sample.csv.zip

sampleCsvToAsm.py.zip

health.png

ripple.html.zip

image003.jpg

All comments

TylerGrosshuesch1

<SPAN class="comment token">#-------------------------------------------------------------------------------</SPAN>
<SPAN class="comment token"># Name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sampleCsvToAsm.py</SPAN>
<SPAN class="comment token"># Purpose:&nbsp;&nbsp;&nbsp;&nbsp; prototype for Amanda at Flathead to read assemblies as collected during</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field survey to Milsoft ASCII .asm format</SPAN>
<SPAN class="comment token"># Author:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tyler Grosshuesch</SPAN>
<SPAN class="comment token"><SPAN>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A class="jive-link-email-small" href="mailto:tgrosshuesch@acecwi.com" rel="nofollow noopener noreferrer" target="_blank">tgrosshuesch@acecwi.com</A></SPAN>
<SPAN class="comment token"><SPAN>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><A class="jive-link-email-small" href="mailto:tdgrosshuesch@gmail.com" rel="nofollow noopener noreferrer" target="_blank">tdgrosshuesch@gmail.com</A></SPAN>
<SPAN class="comment token"># Created:&nbsp;&nbsp;&nbsp;&nbsp; 2017-06-23</SPAN>
<SPAN class="comment token">#-------------------------------------------------------------------------------</SPAN>

<SPAN class="comment token">#Change these two paths as necessary</SPAN>
input <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\TEMP\sample.csv'</SPAN>
output <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\TEMP\sampleAssemblies.asm'</SPAN>

asmHeader <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Map Point Name,Assembly Name,Quantity'</SPAN>

<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'rb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> inFile<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'wb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> outFile<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; toWrite <SPAN class="operator token">=</SPAN> asmHeader <SPAN class="comment token">#start building the output string</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; content <SPAN class="operator token">=</SPAN> inFile<SPAN class="punctuation token">.</SPAN>readlines<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"><SPAN>#read the file and skip first line, </SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fstackoverflow.com%2Fa%2F4796812" target="_blank">https://stackoverflow.com/a/4796812</A></SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> line <SPAN class="keyword token">in</SPAN> content<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; firstCommaAt <SPAN class="operator token">=</SPAN> line<SPAN class="punctuation token">.</SPAN>index<SPAN class="punctuation token">(</SPAN><SPAN class="string token">','</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mapPointID<SPAN class="punctuation token">,</SPAN> assemblies <SPAN class="operator token">=</SPAN> line<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN>firstCommaAt<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> line<SPAN class="punctuation token">[</SPAN>firstCommaAt<SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#split it into pieces with the map point ID and the list of assemblies and quantities</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; assembliesWithQty <SPAN class="operator token">=</SPAN> filter<SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> assemblies<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">','</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#filter removes the nulls, split breaks them into a list of individual (qty)assembly pairs</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> aQ <SPAN class="keyword token">in</SPAN> assembliesWithQty<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; qty<SPAN class="punctuation token">,</SPAN> assembly <SPAN class="operator token">=</SPAN> aQ<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'('</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">')'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#get rid of the '(' character and split the qty and assembly into pieces on the ')' character</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>mapPointID <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN> <SPAN class="operator token">+</SPAN> assembly <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN> <SPAN class="operator token">+</SPAN> qty<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#for testing</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; toWrite <SPAN class="operator token">=</SPAN> toWrite <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN> <SPAN class="operator token">+</SPAN> mapPointID <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN> <SPAN class="operator token">+</SPAN> assembly <SPAN class="operator token">+</SPAN> <SPAN class="string token">','</SPAN> <SPAN class="operator token">+</SPAN> qty <SPAN class="comment token">#add each assembly to the output string on a new line</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outFile<SPAN class="punctuation token">.</SPAN>writelines<SPAN class="punctuation token">(</SPAN>toWrite<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#write the output string all at once to the output file) #write the output string all at once to the output file‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

sampleAssemblies.asm.zip

sample.csv.zip

sampleCsvToAsm.py.zip

tyleracec, I would really like to get a little more help from you. I can kind of fumble my way through your directions and I get an error on everything. Would you email me your contact information. a.opp@flathead.coop

Thank you!

TylerGrosshuesch1

Hi Amanda,

If you're recording assemblies in Collector and trying to get them into WindMil, the ASCII import is the best way. The first picture that shows the format, it's a simple csv file. I typically do the import in WindMil rather than WindMilMap because it's faster. On the WM menu bar, File > Import, and work through the many options. In WMM, start an edit session, then on the menu bar, WindMilMap > Import Data and you'll get the same options you'd see in WM. You should be able to find the Milsoft WindMil ASCII format doc here, if you have the default install path: "C:\Milsoft\WindMilMap\Documents\file_layouts.pdf"

If you already see the assemblies in the Map Point Editor (your first picture) but not when you look at the same feature in its attribute table (your second picture), maybe your WMM config is out of whack. I see the same thing in both places and don't have to do anything to make that happen - it's built in to WMM (my second picture). You'll want to contact Milsoft support if that's the problem. They'd be able to go through the ASCII import process with you too.

Get in touch with me directly if you have any questions, I'd be happy to help another WindMilMap user!

Tyler, Adams-Columbia Electric Co-op

Milsoft ASCII .asm file structure ,

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.