utah-geological-survey / loggerloader

ArcGIS Toolbox for use with ArcGISpro that allows for import and trend processing of water-level transducer data
https://apps.geology.utah.gov/gwdp/
GNU General Public License v3.0
2 stars 1 forks source link

import csv isn't working well #30

Open rlee26 opened 1 year ago

rlee26 commented 1 year ago

Hey,

The new troll import option works great! However, I have some csv files that I'm processing. When I click import data, nothing seems to happen and the little popup doesn't popup either. It works with some wells but not others. I'll try to see if I can figure out what is different between the different csv files. The files worked fine with the previous version of LoggerLoader

rlee26 commented 1 year ago

Update: when I changed the column names in the csv, the import data button worked. Looks like it was the degree symbol in the temperature column.

Old names: Date Time, Barometric Pressure (kPa), Temperature (°C), Barometric Pressure (ft h2O)

New names: Date and Time, Barometric Pressure (kPa), Temperature (C), Barometric Pressure (ft H2O)

inkenbrandt commented 1 year ago

I made some additional updates that may have helped improve that function. There are certain characters that python has a hard time encoding sometimes. Most of those issues were improved with python 3, but they still show up sometimes.

inkenbrandt commented 1 year ago

@inkenbrandt allow for degree symbol and other special characters in headings of csvs (and other formats?)