¿Cómo actualizo Milsoft (Windmil) con datos de nombres de ensamblajes sin hacerlo manualmente?

AmandaOpp

<\/HEAD>

Trabajo con recolectores de datos de campo usando Collector for ArcGIS de ESRI. El sistema se publica en ArcGIS Online desde ArcMap. Se recopilan datos sobre Pole Assemblies así como altura, clase y especie. Puedo actualizar la altura, clase y especie bastante fácilmente en Windmil con estos datos que han recopilado, pero nos falta una forma rápida de actualizar los ensamblajes recopilados. <\/SPAN><\/P> <\/SPAN><\/P>En el pasado, revisaba uno por uno los datos y actualizaba los ensamblajes uno a la vez. Como puedes imaginar, este es un proceso que consume mucho tiempo y es tedioso. Me comunico para ver si hay alguna manera de agregar rápidamente estos datos (todos preformateados) de nuevo a Windmil? <\/SPAN><\/P> <\/SPAN><\/P>En el primer archivo adjunto, tenemos todos nuestros datos y el segundo archivo adjunto es donde queremos convertir todos nuestros datos. Cualquier idea o solución alternativa es muy apreciada.<\/SPAN><\/P><\/P>windmilmap<\/P>windmil<\/P>milsoft<\/P><\/BODY><\/HTML>

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