Data Exchange

bekio

Hello Every one,

What i am trying to do is to make data exchange between NAV and POS. And the comunication should be with text files, one some shared folders. And i thought that i could use dataports calling from codeunit, because with Job Queue you can just use Codeunit and Reports. Data Exchange should be done every 15 min, so this is my problem.
But i have heard that dataports could not be run in Job Queue or NAS server. IS THAT CORRECT?
Do you have any better idea, of making data exchange between NAV and some POS. The comunications should be with text files, because it is now approved.

Any suggestions.

Thanks a lot of,

kine

Use report or codeunit and FILE variable to read/write the data.

bekio

Any example how to read and writte to text file with delimiter "|" and record seperator NewLine?


Thank you all.

kine

Read the line into text variable and split it in code ;-)

kriki

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

bekio

Can some one help me to read the text file lines using instream.
|25|D10|12/11/10||1||0
|27||12/11/10|ER01|1023||0

This is the structure of text files in.
FieldSeperator is "|".
I want each filed to be at adecuate variable(fields) on table.

How to get each filed seperated.
Any example.

Luc_VanDyck

If we write the code for you, then we will have to send you an invoice.

Lookup the commands STRPOS and COPYSTR in the on-line help. Use STRPOS to find out at which positions the '|' characters occur in the string. Use COPYSTR to copy only the relevant data. Use a FOR i := 1 TO STRLEN(yourstring) DO construction to repeat this for every character of the string.

Luc_VanDyck

Here is another wonderful resource: http://lmsmfy.com/?q=copystr+strpos

bekio

Thank you Luc,

I had in my mind to do with this, but i thought maybe is another solution that some one has used.

thanks again.

bekio

About Invoice, just not to be very expensive.

bekio

Just one more questions.
STRPOS -Searches for the first occurrence of substring inside a string.
So now do i have to use also DelsTR, to delet thos strings from variable, because STRPOS retreive just first occurence not second or ...


Thanks,

Savatage

Luc Van Dyck wrote:

Here is another wonderful resource: http://lmsmfy.com/?q=copystr+strpos

Did you look thru any of the posts that come up?

Luc_VanDyck

Savatage wrote:

Did you look thru any of the posts that come up?

Sure I did. Why do you want to know?

David_Singleton

Luc Van Dyck wrote:

Savatage wrote:

Did you look thru any of the posts that come up?

Sure I did. Why do you want to know?

bekio

Thanks to all.
I have looked to some posting.

And i testing that and it is working good.

Again thanks. =D>