Not Reading the first line while importing

bobnavision · 2006-03-16

Hi,

I am using a dataport to import CSV file. The first line of the CSV file is having heading which I do not want to import .
How can we ignore the first line so that dataport does not give any error while importing because of the headings?

Regards,

jorgito · 2006-03-16

Two ways:

1. Remove the heading from the csv file and import

2. Use a variable iCount that increases in the OnAfterImportRecord. When the iCount = 1 (first line) do CurrDataport.SKIP;

bobnavision · 2006-03-16

I cannot use the first way because it will on client site,

The second way I tried but it didn't worked. I declared an integer variable
wrote the code CurrDataport.skip on OnBeforeImport but it wont work.
It never reaches to the code.

rgds

kriki · 2006-03-16

In the "OnPreDataItem()", put this code:

IF CurrDataport.IMPORT THEN BEGIN
  CurrFile.TEXTMODE(TRUE);
  CurrFile.READ(txt);
  CurrFile.TEXTMODE(false);
END;

And txt is a text1024-variable.

Savatage · 2006-03-16

http://www.mibuso.com/forum/viewtopic.php?t=7870

kriki · 2006-03-16

Just created a Tips&Tricks. This will also help if the headerline is more then 1024 chars: http://www.mibuso.com/forum/viewtopic.php?p=43344#43344

DenSter · 2006-03-16

awesome tip

bobnavision · 2006-03-20

Hi Kriki,

That amazingly works. I appreciate that.
what is this code doing and how CHAR works.
How we will make it to work for 2 lines ?

Regards

ara3n · 2006-03-20

to run it for two lines, just add put the code twice

IF CurrDataport.IMPORT THEN BEGIN
  CurrFile.TEXTMODE(TRUE);
  CurrFile.READ(txt);
  CurrFile.READ(txt);
  CurrFile.TEXTMODE(false);
END;

kriki · 2006-03-21

bobnavision wrote:

Hi Kriki,

That amazingly works. I appreciate that.

what is this code doing and how CHAR works.
How we will make it to work for 2 lines ?

Regards

CHAR is 1 character of a string, so I start to read 1 character per time.
In DOS/Windows, each end of line is finished with a CR/LF (carriage return/line feed) in ascii 13/10. So If I find the 10, I know that next char is a char of line 2 and stop reading.

And for 2 lines, you can just put an extra repeat-until. Otherwise you can use a counter.I'll put this code in the tip&tricks.

Not Reading the first line while importing

Comments

Categories