Jak mohu aktualizovat Milsoft (Windmil) s daty názvů sestav bez ručního zadávání?

AmandaOpp

<\/HEAD>

Pracuji s terénními sběrači dat používajícími ESRI9s Collector for ArcGIS.  Systém je publikován na ArcGIS Online z ArcMapu.  Data jsou sbírána o Pole Assemblies stejně jako o výšce, třídě a druhu.  Jsem schopen poměrně snadno aktualizovat výšku, třídu a druh v Windmil s těmito daty, která nasbírali, ale chybí nám rychlý způsob, jak aktualizovat nasbírané sestavy.  <\/SPAN><\/P> <\/SPAN><\/P>V minulosti jsem procházel data jeden po druhém a aktualizoval sestavy jednotlivě.  Jak si dokážete představit, je to časově náročný a únavný proces.  Obracím se na vás s dotazem, zda existuje způsob, jak rychle přidat tato data (všechna předformátovaná) zpět do Windmil?  <\/SPAN><\/P> <\/SPAN><\/P>V prvním příloze máme všechna naše data a druhá příloha je místo, kde chceme převést všechna naše data.  Jakékoliv nápady nebo řešení jsou velmi vítány.<\/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