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; } } }

How do I update Milsoft (Windmil) with Assembly Names Data without doing it manually?

AmandaOpp

I work with field data collectors using ESRI’s Collector for ArcGIS. The system is published to ArcGIS Online from ArcMap. Data is collected on Pole Assemblies as well as height, class and species. I am able to update the height, class and species fairly effortlessly in Windmil with this data that they have collected but we are lacking a quick way to update the collected assemblies.

In the past, I would go one by one through the data and update the assemblies one at a time. As you can imagine, this is a time consuming process and tedious. I am reaching out to see if there is way to quickly add this data (All preformatted) back to Windmil?

In the first attachment, we have all of our data and the second attachment is where we want to convert all of our data. Any ideas or workarounds are greatly appreciated.

windmilmap‌

windmil‌

milsoft‌

Capture.JPG

Capture2.JPG

Find more posts tagged with

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

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

AmandaOpp

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 ,

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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