Wrong Units - Hydraflow Hydrographs Extension

[EngineeringSam]

I am attempting to manually create a hydrograph based off of a CSV file. However, when I try to open the CSV file I receive a warning that the CSV file is in SI units. I have no idea where hydraflow is even looking to obtain this information in the CSV file or how to change it so that it is in US customary units. The CSV file is created in Excel, has only 2 columns and I have tried with and without a header in the first row. Thanks in advance for the assistance.

[MattAndersonPE]

Add a header to your file that includes the units.

For example - the export of a hydrograph includes "Time (min)", "Q(cfs)".   This is sufficient to indicate imperial units.

m,cfs will also work.

[EngineeringSam]

I've tried both m cfs and Time (min) Q (cfs) and I still get the same message to change the program to SI. I've attached the CSV file that I've been using for reference. Thanks for the help.

[MattAndersonPE]

I have been able to sucessfully use this:

m,cfs

0,0

6,0

12,0

18,0

24,0

30,5

36,10

42,16

and it imports as an imperial file.

You csv file did not attach. 

[EngineeringSam]

Success and failure... Success: I decided to create a CSV file with notepad and loaded it. That worked fine. Then I decided to load the CSV file I created originally (with excel) and it worked! I did nothing different. Now I can load any CSV file. Failure: Nobody else can load a CSV file created with excel (but notepad works). I attempted to duplicate my success on a coworkers machine.... first, creating a notepad file, then opening it, then loading the excel CSV file and nothing. It still requests the program to change to SI units. There is another 15 coworkers with the same issue. FYI, we use C3D 2015. Thanks for any further input. (ps I tried loading the CSV file again but I'm not sure if I can being that I'm new to the forum)

[MattAndersonPE]

Can you send me your CSV file that fails?

[EngineeringSam]

Again, I am new to the forum so I do not have "privileges" to put files in a conversation or to message anyone.... if you know a way around this I would be happy to send it to you.

[Anonymous]

Was there ever a resolution to this?   I'm having the same problem and can't figure out why.   We are pumping out a quarry into our pond, and need to include a known Q at 1 minute intervals, and inputting that manually will take hours.

Thanks!

[EngineeringSam · Accepted solution]

The resolution we found was to go into excel, click on the cell with the unit's name and then place a single quote mark before it (presumably excel then recognizes this as text?)... either way it worked for us. So the solution is change min and cfs to

'min

'cfs

It has worked for over 2 months for us.

[hellafella]

 All the solution is in excel highlight both of the columns, Right Click...format cells...they are likely defaulting to general.  change them over to...Text    

[Anonymous]

I tried all of the above without consistent results. What I finally realized is that, for me anyway, it only works if the .csv file isn't open.

[ekohinke]

I'm having this problem with an excel file/csv that only has numerical values in it (no text unit names like "cfs" or "min"). I tried the next tip also to change the format of all cells from "general" to "text" but that did not work. Have tried the tip to create a .txt file in notepad and that still gives me the SI unit incompatibility error. Spending hours trying to outsmart the software to get it to work when it should just work right to begin with, on a known error over 5 years old. By the way, when you change the system units in Hydrographs to SI, the import function still does not work and it gives the same error message.

[ekohinke]

I think it is necessary to elaborate on this since it is marked as the "solution". The key tip is that you need to have text headers for your columns in the .csv or .txt file. You can't have just two columns of numerical data. I added "m,cfs" as the first line of my .txt file and it imported. Autodesk - please add clear instructions on how to do this in Hydrographs so users don't collectively waste 1-2 hours each trying to hunt down solutions on the chat forums?