csv file import problem

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

Hi,

 

I have transfered an excel file into a csv format. After importing to the hypergraph, I got an error message telling me 'unable to recognize the file'. Please see the attachment for reference.

 

 

Regards,

 

<?xml version="1.0" encoding="UTF-8"?>post-7386-0-80589900-1382323068_thumb.jp

Tagged:

Answers

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited November 2013

    I got this error but it appears to be in a different way. I was opening a .txt file in excel on a Mac and when I went to save as a csv and open in hypergraph, it didn't work. I had to select save as a 'Windows comma separated file' and that solved my problem. Maybe from excel there are a few different ways to save as a csv and you could try a few?

     

    One of my IT guys explained it to me and it was something along the lines of creating it in a unix environment when it should have been a carriage return format.. (or something close to this)

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited January 2015

    May be you should try again with define curves button instead of build plots buttons

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited January 2015

    Hi,

     

    you need to export the csv from excel to a specific (sub-)format. I had trouble myself with it, but since i keep to the following rules, the import to HG works:

     

    When exporting csv from Excel always 

    • turn off thousands separator
    • use . as decimal separator
    • use csv (MS-DOS)-format, so there will be an CR und LF (virtual characters, dont ask me..)

Categories