Cannot open CSV File

[Former Member]

Hi guys,

I am trying to import a CSV File into a table with the following command:

IMPORT FROM CSV FILE 'path/test.csv' INTO "Consumption" WITH RECORD DELIMITED BY '\n\r' FIELD DELIMITED BY ';';

but I receive an error:

Could not execute 'IMPORT FROM CSV FILE ...' in 20 ms 759 µs .

SAP DBTech JDBC: [2]: general error: Cannot open CSV file, path/test.csv

What am I doing wrong??

I gave myself the Admin role and also GRANT SELECT priviledges to _SYS_BIC and SYSTEM.

Any idea what I can try??

Thanks in advance!

[Former Member]

Hi,

Please refer below document in 17th Page:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70e2ff67-587c-2f10-5da1-8e5ddbade...

Thanks & Regards,

V Srinivasan

[rama_shankar3]

Kristina,

Two things you need to check :

   1 - the file path - make sure it is correct

   2 - Make sure that the folder for the file path has chmod 777 on the folder (basically full access) - if you use filezilla you can do this by right clicking on the folder and mentioning full access.

Hope this helps.

[vivekbhoj]

Hi Kirsten,

Seeing your code you are using

FIELD DELIMITED BY ';';

instead of semi-colon you should use comma  ',' here.

FIELD DELIMITED BY ',';

Regards,

Vivek

[Former Member]

Hi Vivek,

thanks for your reply!

My CSV file uses semi colon instead of commas. But nevertheless, even if I use a comma the same error appears..

Regards

Kristina

[vivekbhoj]

Hi Kristina,

As per your error, the Wiki says that the problem is that CSV file doesn't exist or is not readable.

So please check that your file path is correct and file is readable.

You can check the Wiki here:

http://wiki.sdn.sap.com/wiki/display/inmemory/Common+Import+Errors