import .csv table

Altair Forum User
Altair Forum User
Altair Employee
edited October 2020 in Community Q&A

Hello everyone! I am new so i welcome any help.
I am trying to create a load collector type TABLED1 which I am then going to use in PBUSHT. So what my table actually represents is stiffness over frequency. But instead of entering the values manually, I want to import the values from an excel file. Problem is I don't know the exact format it needs to be in csv/txt file so what I get until know when I import is a table of 2 columns of zeros.

Any help please? Any example maybe?

Thank you in advance

Tagged:

Answers

  • Rahul Rajan_21763
    Rahul Rajan_21763 New Altair Community Member
    edited July 2015

    Hi,

     

    You can import your table using  View:utility tab: tools:Table create.Import option for csv ,txt & .dat is available.

    See attached thumbnail.

     

    Regards

    Rahul R

    <?xml version="1.0" encoding="UTF-8"?>post-36845-0-43840700-1438076782_thumb.j

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited July 2015

    HI Nppo,

     

    Here is a small screen shot of a single lined XY data.

     

    In the image A represents X and B represents Y.

     

    Input the X and Y values in the excel sheet and save the same as .csv file.

    <?xml version="1.0" encoding="UTF-8"?>post-7616-0-74166900-1438077407_thumb.jp

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited July 2015

    Thank you for your answer and I am sorry I wasn't clear. that is what I have been doing but the problem is my .csv file I don't know how it has to be written. For example it looks like:

     

    100;17107
    101;18008

    102;18233

    103;18130

    103.25;18239

    etc...

    where 1st value is frequency and 2nd is stiffness, but this format doesn't work.

  • Rahul Rajan_21763
    Rahul Rajan_21763 New Altair Community Member
    edited July 2015

    Hi,

     

    In which format you are getting the Frequency vs Stiffness data(ASCII, dat etc).Looks like in your csv file you are not getting two columns.one for freq and another one for Stiffness.

    Or you are getting any error while running for discontinuty in data points?

     

    Regards

    Rahul R

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited July 2015

    Your are right, I only get one column. It is just an excel file I transformed into .csv because the acceptable formats are csv/txt/dat

  • Rahul Rajan_21763
    Rahul Rajan_21763 New Altair Community Member
    edited July 2015

    Try to get data in two columns.Then only Hm will read data correctly.

     

    Regards

    Rahul R

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited July 2015

    I tried it and it didn't work.  all values in both x and y in table are zero. it only works when I insert the values manually

    <?xml version="1.0" encoding="UTF-8"?>post-38736-0-99434800-1438095271_thumb.j

     

  • Rahul Rajan_21763
    Rahul Rajan_21763 New Altair Community Member
    edited July 2015

    Hi,

    I mean from which tool and in which format you are getting freq vs stiffness value.

    Regards

    Rahul R

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited March 2016

    I had the same issue for .csv import.

    The format I had in .csv file was:

    100;17107
    101;18008

    102;18233

    103;18130

    103.25;18239

    etc...

    This format lead to the right number of points but with 0 for all cells (same as nppo).

     

    I changed it to (replace ' ; ' by ' , '):

    100,17107
    101,18008

    102,18233

    103,18130

    103.25,18239

    etc...

    And table import works...

     

    May be an issue in Excel parameter for .csv format..

  • Rahul Rajan_21763
    Rahul Rajan_21763 New Altair Community Member
    edited May 2016

    Nice workaround.

     

    Regards

    Rahul R

Categories