How can i import a data to navision without the XmlPort

Mounika22

I should Write a Code unit

Supremenerd88

Mounika22 wrote: »

Thank You for your kind reply

you're welcome

Supremenerd88

You can write a custom codeunit or a custom report, open file and stream and read data from the stream. I prefer codeunit and i always use this example code:

MyFile.OPEN(FullFileName);
MyFile.CREATEINSTREAM(StreamInTest);
WHILE NOT StreamInTest.EOS DO BEGIN
  StreamInTest.READTEXT(Buffer);
  // insert here your code
END;
MyFile.CLOSE();

MyFile is a File variable, StreamInTest is a InStream variable and Buffer is a text variable.

kriki

You can use a dataport in the older versions. But those don't work with the NAS.
Something that works with all versions is a codeunit and using a FILE variable (and with the newer versions best use also a stream instead of reading/writing directly to the file-variable).

mdPartnerNL

Supremenerd88 wrote: »

You can write a custom codeunit or a custom report, open file and stream and read data from the stream. I prefer codeunit and i always use this example code:

MyFile.OPEN(FullFileName);
MyFile.CREATEINSTREAM(StreamInTest);
WHILE NOT StreamInTest.EOS DO BEGIN
  StreamInTest.READTEXT(Buffer);
  // insert here your code
END;
MyFile.CLOSE();

MyFile is a File variable, StreamInTest is a InStream variable and Buffer is a text variable.

But in RTC you first need to copy the file to the server, correct?

Supremenerd88

mdPartnerNL wrote: »

Supremenerd88 wrote: »

You can write a custom codeunit or a custom report, open file and stream and read data from the stream. I prefer codeunit and i always use this example code:

MyFile.OPEN(FullFileName);
MyFile.CREATEINSTREAM(StreamInTest);
WHILE NOT StreamInTest.EOS DO BEGIN
  StreamInTest.READTEXT(Buffer);
  // insert here your code
END;
MyFile.CLOSE();

MyFile is a File variable, StreamInTest is a InStream variable and Buffer is a text variable.

But in RTC you first need to copy the file to the server, correct?

I prefer to use shared folder (i.e. \\192.168.1.100\share\file.txt) but yes, generally you need to copy file on server.

Mounika22

Thanks,
How should i add my code just give a example.

mdPartnerNL

above example is already given

Supremenerd88

Mounika22 wrote: »

Thanks,
How should i add my code just give a example.

hypothesize we need to import employees and we have a file lyke this

E00001Michael             Red                 
E00002Bill                Green               
E00003Jim                 Black

the code will be like this:

MyFile.OPEN(FullFileName);
MyFile.CREATEINSTREAM(StreamInTest);
WHILE NOT StreamInTest.EOS DO BEGIN
  StreamInTest.READTEXT(Buffer);
  CLEAR(Emp);
  Emp.INIT();
  Emp.VALIDATE("No.", COPYSTR(Buffer,1,6));
  Emp.VALIDATE("First Name", COPYSTR(Buffer,7,20));
  Emp.VALIDATE("Last Name", COPYSTR(Buffer,27,20));
  Emp.INSERT(TRUE);
END;
MyFile.CLOSE();

Emp is a record of Employee variable.

Mounika22

Thank You for your kind reply

Supremenerd88

Mounika22 wrote: »

Thank You for your kind reply

you're welcome