[Dacaptain1615]

Hello

I am working on a conjugate heat transfer model using Maxwell and CFX. Maxwell i am using to determine the ohmic losses of a conductor and then using those losses and the heat input into the system of the conductor in a box. My question pertains to an error i am getting once i try to input these losses as a .csv file. CFX gives me an error that i do not know how to solve. i read other threads on here but could not fix my issues after reading them. I attached both a snip of the error and mu .csv excel file.


Thank you for your help, i appreciate it.

[Opaque]

Remove the _ from the [Name], i.e. Current Inlet 1

[Dacaptain1615]

Thank you for the suggestion opaque, but i had already tried that before.

[Opaque]

It seems a small file.

Could you attach it to the thread? or copy/paste the full file in the thread?

[Dacaptain1615]

I tried uploading the file but the file was way too big. it had about 250k rows of data. i uploaded a truncated version.

[Opaque]

Seen this before with Excel. It saves the file assuming all the rows have the same number of columns, and it adds several commas for the missing columns.

Open the file in Wordpad/Notepad or any text editor, remove the commas after the section header, i.e. [Name], [Spatial Fields], [Data], etc.

Another advice, be careful with Excel floating point format. You may have a .csv file with several significant digits, and Excel with truncate your values to two/three significant digits by default (depending on your preferences if I recall)

Summary: careful with Excel when editing .csv files for ANSYS CFX

[Dacaptain1615]

I see, the format i am using in excel is wrong in some way. Maxwell outputs the data in a .fld ( field file) and i need a .csv in CFX. Is there another way to easily convert between these different file formats? other than excel,

I also opened the files in notepad and removed the extra commas, attached a picture below and i am still receiving the same error.

[Opaque]

I removed the commas, and it worked for me.

Could you attach the latest version? and post the latest error message?

[Dacaptain1615]

yea here it is, the error message is the same as the initial error i was getting before. can you also upload the one that you did so that i can see the difference between your and mine. I might just take the one you did and paste the data for all my parts below that.

[Opaque]

Uploading mine will not help you much since you will not know what is happening on your side.

Something is not standard on how the file was saved.

If I open it in Notepad, minor modification, saved it and reload I get same error

However, if I open it in Wordpad, same minor modification, saved it and reload the error goes away.

How are you editing the file, which editor?

[Dacaptain1615]

I am using Notepad.

[Dacaptain1615]

OMG that completely fixed it. it was notepad this entire time, cause i previously removed those extra commas on notepad before you said that it can be an issue and saved it as a .csv. but now that i did it in wordpad it worked.

You are the best, thank you for all your help. you just fixed 2 days of frustration not knowing what was wrong.

[mz_uon]

Hello

I am trying to import coordinates for a point cloud in CFD-post. See the CSV file in the image. However, I keep getting an error when I try to import. Could you please suggest how can I fix this? None of the solutions described above solved my problem, hence posting this.

Thank you

Originally Posted by Dacaptain1615

OMG that completely fixed it. it was notepad this entire time, cause i previously removed those extra commas on notepad before you said that it can be an issue and saved it as a .csv. but now that i did it in wordpad it worked.

You are the best, thank you for all your help. you just fixed 2 days of frustration not knowing what was wrong.

[Opaque]

You are using an incomplete mixed format for import

Either delete the [Data] section, or add the [Name] and [Spatial Fields] section

For example,

X [m], Y [m], Z[m]
..
..

or

[Name]
MyPointCloud

[Spatial Fields]
X, Y, Z

[Data]
X [m], Y [m], Z[m]
..
..

The last one should import in CFX-Pre if additional data columns are provided. If I recall CFD-Post should import both formats.

[mz_uon]

Hi

Thanks for your answer, but I still get this error (see image).

Originally Posted by Opaque

You are using an incomplete mixed format for import

Either delete the [Data] section, or add the [Name] and [Spatial Fields] section

For example,

X [m], Y [m], Z[m]
..
..

or

[Name]
MyPointCloud

[Spatial Fields]
X, Y, Z

[Data]
X [m], Y [m], Z[m]
..
..

The last one should import in CFX-Pre if additional data columns are provided. If I recall CFD-Post should import both formats.

[mz_uon]

Hello

Does anyone know how to resolve this? Will greatly appreciate your help. I am just trying to extract data (in CFD-post) from a list of user input points (.csv file etc.).

Thank you

[ghorrocks]

Isn't the file format fully described in the documentation? See CFD-Post documentation section 8.8.1.

[mz_uon]

Originally Posted by ghorrocks

Isn't the file format fully described in the documentation? See CFD-Post documentation section 8.8.1.

Hello

Thanks for your comment. I have seen the document but it is not clear. I posted the question in another forum with my sample .csv file, but it did not load. Can you please share one if you have?

Thank you