Data Exchange

bekiobekio Member Posts: 204
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,

Answers

  • kinekine Member Posts: 12,562
    Use report or codeunit and FILE variable to read/write the data.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • bekiobekio Member Posts: 204
    Any example how to read and writte to text file with delimiter "|" and record seperator NewLine?


    Thank you all.
  • kinekine Member Posts: 12,562
    Read the line into text variable and split it in code ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • krikikriki Member, Moderator Posts: 9,086
    [Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • bekiobekio Member Posts: 204
    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_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Here is another wonderful resource: http://lmsmfy.com/?q=copystr+strpos
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • bekiobekio Member Posts: 204
    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.
  • bekiobekio Member Posts: 204
    About Invoice, just not to be very expensive.
    :(
  • bekiobekio Member Posts: 204
    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,
  • SavatageSavatage Member Posts: 7,142
    Here is another wonderful resource: http://lmsmfy.com/?q=copystr+strpos

    Did you look thru any of the posts that come up?
  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Savatage wrote:
    Did you look thru any of the posts that come up?
    Sure I did. Why do you want to know?
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • David_SingletonDavid_Singleton Member Posts: 5,479
    Savatage wrote:
    Did you look thru any of the posts that come up?
    Sure I did. Why do you want to know?

    :lol::lol::lol::lol:
    David Singleton
  • bekiobekio Member Posts: 204
    Thanks to all.
    I have looked to some posting.

    And i testing that and it is working good.

    Again thanks. =D>
Sign In or Register to comment.