[silvai]

Hi!

My objective is to import to Fluent or CFD-post a data file done in Excel.

This Excel file have the "nodenumber", "x-coordinate", "y-coordinate", "new_parameter". This "new_parameter" was determined in Excel. So, I already have an Excel file, also a txt file (already converted) and csv file (already converted) like this:

nomenumber, x-coordinate, y-coordinate, z-coordinate, new_parameter
1,-0.00000123736464,-0.0017365363,0,0.763536373
2,0.00003425625,-0.0019373763,0,0.77660838383
3,-0.00006835662,-0.00736363,0,0.7798373732

I already tried to import the excel or txt or csv file to fluent or CFD-post (through several ways) but I can´t get.

After importing to Fuent or CFD-Post, my final objective is to obtain this "new parameter" drawn in 3D dimension of the geometry.


Do anyone know a simple way to import this file (excel, txt or csv) to fluent or CFD-Post?

I am wainting for an answer.
Thank you very much!

[t.teschner]

as far as my fluent knowledge goes, you can't just import csv data into fluent for visualisation. one option i can think of is to convert the excel file into a file that is readable by fluent, like cgns, which also offers the advantage that you can store flow solutions like this "new_parameter".

that is rather tricky and a long shot, but since you are using excel, i assume you are getting data out of fluent, do some post processing in excel and then you want to read the post processed values back into fluent / cfd-post, right? both fluent and cfd-post have their inbuild calculators so whatever you are doing in excel may be accomplished within fluent / cfd-post without the need to export and reimport data to/from a csv file.

can you elaborate on what you want to do exactly in this csv file (what is "new_parameter")?

[mprinkey]

If you have a base Fluent case already with the geometry, you can use a UDF to read in the data from the file (in any format that you care to parse) and put it into User-Defined Memory. You have "nodenumber" as a value. If the node information was pulled from the Fluent case/geometry in order, you can just write directly to the node storage using the N_UDMI macro.

If the nodes are not in the same order as the Fluent base case, your UDF is going to have to sort and search to get the node data copied into the right place. In any case, I doubt that there is anything in the excel spreadsheet that could not just be coded directly into the UDF and then compute the data in place, rather than dumping to files and parsing back and forth.

If however you don't have a base Fluent case/geometry and your intention is to just pull the x,y,z + data values into a CFD code in order to visualize them, you are wasting your time. A list of node location and function values represents only a point cloud--there is no connectivity/geometry and Fluent/CFX is not going to be able to make sense of it. Take a look at Paraview. I think they have some plugins to display pointcloud data. Or maybe here:

http://pointclouds.org/documentation...ualization.php

[silvai]

Thank you for everyone. I already found this problem.

However, consequently, I have another....
Do anyone know, how can I export from Fluent the matrix with the links between the nodes of the mesh?

Like this (for exemple):

[Faces]0, 1, 23, 4, 56, 7, 89, 10, 11(...)

Thanks in advance.

[silvai]

I mean, like this:

[Faces]

0, 1, 2

3, 4, 5

6, 7, 8

9, 10, 11

(...)

Thanks in advance.

[jyothsna k]

[QUOTE=mprinkey;526238]If you have a base Fluent case already with the geometry, you can use a UDF to read in the data from the file (in any format that you care to parse) and put it into User-Defined Memory.

can you please specify how this can be done.

[FilipaC]

Hi. I have exactly the same problem as you (the first problem). What you do for solve this? Thanks

[silvai]

Originally Posted by FilipaC

Hi. I have exactly the same problem as you (the first problem). What you do for solve this? Thanks

Hi!

Did you solve the problem yet?

[qin chunqiu]

I interpreted the following UDF, and allocated node memery, but Fluent reports an error: 'line 18: structure refrence not implemented'. I dont know why, so i am really grateful if anyone could tell me how to deal with this.
#include "udf.h"
DEFINE_ON_DEMAND(IG)
{
real x,y;
int n;
Domain *d;
Thread *t;
Node *v;
cell_t c;
d=Get_Domain(1);
thread_loop_c(t,d)
{
begin_c_loop(c,t)
{
c_node_loop (c,t,n) /*n is the local index number*/
{
v = C_NODE(c,t,n) ;/*to obtain the global cell node number*/
N_UDMI(v,0) =NODE_X(v);;
}
}
end_c_loop(c,t)
}
}

[qin chunqiu]

the N_UDMI macro should be compiled rather than interpreted

[bmexlj]

Originally Posted by silvai

Hi!

Did you solve the problem yet?

Hi, i am also wondering if this problem is solved.

[Ahmed Hassan]

How did you solve the first problem ?

[Leonardo.flores]

I have the same problem... how did you solve it?

[Rupali]

I had inserted a udf of velocity profile consisting of different values of velocity at different time steps in the .txt format. The magnitude of velocity as in my tabulated data is both negative and positive. So, the problem I am facing is that fluent is only reading the positive values of velocities and neglecting the negative values of velocities. Because of which the velocity profile is not exactly what I want to implement. Can anyone suggest a proper solution to my problem?

[Светлана]

Maybe you need two or three different velocity profiles. One for U, one for V, one for W. Then it can be negative

[Rupali]

I have attached the velocity profile graph. For this particular velocity profile I have written a UDF in tabulated form. I have data for time and velocity respectively. So, I am not able to understand how to construct two or three velocity profile from the tabulated data which I have? Please help me with this.

[vinerm]

Hi Rupali

Since the velocity is a function of time alone, you may use a transient profile instead of a UDF. As far as direction is concerned, you already know it. Currently, with the UDF, you already have a direction specification given at the boundary, default is Normal to Boundary. If it is default and the boundary is planar, then you know the direction.