Latest Contributions by 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. #------------------------------------------------------------------------------- # 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‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more