NAV RTC - IMPORT CSV ISSUES

Ravi_Thakkar

Dear All,

I have created an XMLPORT which is used to IMPORT the records in Production BOM Line Table.
Having some issues/doubts for the same.

1) After importing data successfully, and running the same XMLPORT again then system is showing me an error "An I/O exception occurred during the operation.. I found that EXCEL.EXE process of OS remains in running status. What can be the solution?

2) I want to read the data by skipping some columns from CSV file. How can it be done?

3) I want to skip the first row from reading the data, since it's a title of all columns. How can it be done?

Please, suggest.

kine

Hw the XMLPort import is connected to the Excel process?? It is not using it somehow, if you are not using excelbuffer for reading Excel files..

Ravi_Thakkar

I am importing CSV file through Xmlport in RTC.

Sog

1) After importing data successfully, and running the same XMLPORT again then system is showing me an error "An I/O exception occurred during the operation.. I found that EXCEL.EXE process of OS remains in running status. What can be the solution?
Remove all automation variables for Excel if you didn't start the xmlport from scratch.
Close excel before importing?
Don't open your CSV in excel?

2) I want to read the data by skipping some columns from CSV file. How can it be done?
Evaluate the columns you want to skip in a variable that will be never used afterwards

3) I want to skip the first row from reading the data, since it's a title of all columns. How can it be done?
create a boolean firsttime, oninit = true, when you start importing and begin at the first line, check firsttime, set firsttime on false and skip the record,

bob_up

I came to this thread because I also had the message "An I/O exception occurred during this operation" when running via the RTC. When I ran the same process in the classic client I got a more helpful message. The error was caused, in my case, because I was trying to read the file from the wrong folder. In other words, the message really meant "file not found".