Problems with csv import

Gustavo Peconick

• September 28, 2021 14:46

Is anyone having trouble to import CSV?

The importer is reading the file as shown below

 

At process time i'm being promped with an error message

 

Can anyone help me?

 

Regards,

Gustavo

0

• 

  Esther de Groot

  • April 18, 2023 06:27
  • Edited

  I get the same error. 

  In InfraNodus, there is an example file for CSV import. In Europe, the first step in Excel we need to take is replace the ; separator with the , separator. However, this was insufficient. In the example file, the column with the text shows that there are "   " around the text that InfraNodus will use to analyse (checked in Notepad ++) In your picture, the column with 'content'. But I am not able to make that column the same. When the column in Excel is of the type 'text', this does not make any difference.

  1. Are the "  " around the cells in the content column the problem?

  2. If so, how can I solve that? 

  (I checked also whether the file has a .csv extension and it does)

  Thank you! Esther

   

  0
• 

  Esther de Groot

  • April 18, 2023 20:50

  This did the trick:

  https://support.noduslabs.com/hc/en-us/articles/360016181379-Problem-My-CSV-MD-PDF-Text-Files-are-Not-Recognized

  it is very complicated, especially because you have to be careful with other applications, but for InfraNodus it worked.

  0

Please sign in to leave a comment.