PDA

View Full Version : 148 Row Limit to Time Variable CSV Imports?



HWEI
February 6, 2014, 02:35 PM
Is the number of rows that you can import for flow or rainfall data fixed to 148 or can it be changed? I have flow and rainfall data that I would like to use for calibration purposes but it has datapoints every 5 minutes which for a 24 or 48 hr run generates way to many rows.

Robert Dickinson
February 7, 2014, 09:19 AM
Hello HWEI,
Can you send you CSV file to support@innovyze.com so we can look at your CSV file import issues? You should be able to import more than 148 rows of data.
Regards,
Bob Dickinson

Robert Dickinson
February 7, 2014, 11:43 AM
Hello HWEI,
Thanks for sending the CSV file.

It does import all of the rows but you have to define the columns for the time and date and all of the various event data. The time varying import dialog does seem to be limited to 148 rows but it will import all of your data once your define the cells for the date, time and event data along with the time step.
I did make one change to the header of your file – see this snippet below – I added a comma between your date and time as well as adding a time header.
I hope this helps.

"Inst" , "Time","FLOW (gpm)","Rain (in)","VELOCITY (fps)","Pwr Sply (V)","Lvl (in)","Vel (fps)","Flow (gpm)","Srg Lvl (in)","Srg Vel 2 (fps)","Temp (°C)","Srf Vel (fps)","Cnd 2"
08/25/2013, 12:00 AM,606.492976883979,0,1.817528,11.71996,7.876225,1 .817528,606.4928,0,,26.61,1.92,
08/25/2013, 12:05

Best Regards,
Bob Dickinson
Innovyze