Starting in December, we will archive content from the community that is 10 years and older. This FAQ provides more information.
Solved! Go to Solution.
Solved by EngineeringSam. Go to Solution.
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.
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.
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!
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.
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
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.
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.
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.