Announcements
Due to scheduled maintenance, the Autodesk Community will be inaccessible from 10:00PM PDT on Oct 16th for approximately 1 hour. We appreciate your patience during this time.
Community
Civil 3D Forum
Welcome to Autodesk’s Civil 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Civil 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Wrong Units - Hydraflow Hydrographs Extension

12 REPLIES 12
SOLVED
Reply
Message 1 of 13
EngineeringSam
1841 Views, 12 Replies

Wrong Units - Hydraflow Hydrographs Extension

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.
Tags (3)
12 REPLIES 12
Message 2 of 13

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.



Matt Anderson
Product Manager
Message 3 of 13

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.
Message 4 of 13

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. 



Matt Anderson
Product Manager
Message 5 of 13

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)
Message 6 of 13

Can you send me your CSV file that fails?

 

 



Matt Anderson
Product Manager
Message 7 of 13

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.
Message 8 of 13
Anonymous
in reply to: EngineeringSam

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!

Message 9 of 13
EngineeringSam
in reply to: Anonymous

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.

Message 10 of 13
hellafella
in reply to: EngineeringSam

 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    

Message 11 of 13
Anonymous
in reply to: hellafella

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.

Message 12 of 13
ekohinke
in reply to: EngineeringSam

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.

Message 13 of 13
ekohinke
in reply to: EngineeringSam

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?

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Rail Community


 

Autodesk Design & Make Report