Importing a file with a Codeunit.

CDLSA

Is their anyone who has an example of a codeunit for importing a text-file (ASCII) in navision. Just to know how to find the first record of the txt-file and how to find the next record.

Without using a dataport so I would be able to call the CU with NAS to import the file.

Thanks.

wonmo

file.TEXTMODE(TRUE);
file.WRITEMODE(FALSE);
file.OPEN(file path and name);

REPEAT
file.READ(vstring);

// do something with vstring
UNTIL
file.POS = file.LEN;

This code reads 1 line of text at a time.

Remember, vstring can only be a max of 1000 characters so each line cannot be more than 1000 characters.

A dataport is much better to use because of this. You can also do the same thing with a dataport, some coding and the common dialog ocx.

bangswit

wonmo wrote:

file.TEXTMODE(TRUE);
file.WRITEMODE(FALSE);
file.OPEN(file path and name);

REPEAT
file.READ(vstring);

// do something with vstring
UNTIL
file.POS = file.LEN;

This code reads 1 line of text at a time.

Remember, vstring can only be a max of 1000 characters so each line cannot be more than 1000 characters.

A dataport is much better to use because of this. You can also do the same thing with a dataport, some coding and the common dialog ocx.

but dataport cannot import 1 record that consist of more than 1 line
isn't it?

julkifli33

wonmo wrote:

file.TEXTMODE(TRUE);
file.WRITEMODE(FALSE);
file.OPEN(file path and name);

REPEAT
file.READ(vstring);

// do something with vstring
UNTIL
file.POS = file.LEN;

This code reads 1 line of text at a time.

Remember, vstring can only be a max of 1000 characters so each line cannot be more than 1000 characters.

A dataport is much better to use because of this. You can also do the same thing with a dataport, some coding and the common dialog ocx.

for example my data is --> no,name,address
how to segregate ","
so no goes to field no, name goes to field name, and address goes to field address
thanks

bekio

After you read the line in .txt file, use STRPOS to determine delimiter of field, and COPYSTR to copy the string.

julkifli33

bekio wrote:

After you read the line in .txt file, use STRPOS to determine delimiter of field, and COPYSTR to copy the string.

i'm confuse how to use STRPOS and COPYSTR
here is my code and sample data
i want to segregate no,name and address
anyone can help?
thanks

OnRun()
SFile.TEXTMODE(TRUE);
SFile.WRITEMODE(FALSE);
SFile.OPEN('D:\TestImport\Test.txt');
REPEAT 
SFile.READ(vString);
vStringCode := STRPOS(vstring,';');
TestImport.No := UPPERCASE(vStringCode);
TestImport.INSERT;
UNTIL
SFile.POS = SFile.LEN;
MESSAGE('Import Done');

code2;Nama 2;Address 2
code3;Nama 3;Address 3
code4;Nama 4;Address 4
code5;Nama 5;Address 5

Luc_VanDyck

Search the forum on COPYSTR + STRPOS and you'll find some postings with sample code. For example:
viewtopic.php?f=32&t=44776
viewtopic.php?f=23&t=15461

julkifli33

Luc Van Dyck wrote:

Search the forum on COPYSTR + STRPOS and you'll find some postings with sample code. For example:
viewtopic.php?f=32&t=44776
viewtopic.php?f=23&t=15461

ok
thanks a lot for your help Luc

casanova

anyone how to import txt file without delimeter?
we use fixed length

geordie

What is your problem exactly, splitting file lines in several variables?