Schedule Dataport to Run

NavNoviceNavNovice Member Posts: 2
edited 2009-02-05 in Navision Financials
Is it possible to program a Dataport to run on a time schedule once a day with Navision Financials ver. 2.5?

My dataport exports data to a text file so that an SQL server can grab the file and import it into our web application.

I would love to be able to make these things happen automatically on a daily scheduled basis.

Comments

  • krikikriki Member, Moderator Posts: 9,110
    With the NAS it is not possible. Dataports don't work with the NAS. Actually I am not even sure 2.5 has a NAS.
    You have to create a form with property "TimerInterval" filled in.
    In the "OnTimer()"-trigger you can put code that once a day after a certain hour, launches the dataport.
    The problem is that if in the night you shut down the DB-server for some reason, in the morning you have to start the Navision-client again with that form.

    It is also best that you create a user that has only permission to launch that dataport and that can read/insert/delete the tables in needs for the dataport, and nothing more.
    In the user-setup, you can give a menu to be used for a certain user. Put in the ID of the form with the "OnTimer()"-function in it.
    The last 2 things is for security, because you have to leave a Navision-client running all the time.

    Other possibilities without Navision:
    1) if your DB is a SQL-DB, your other SQL-server can read the data directly from the Navision-table.
    2) you can create an external program and read the data with the help of ODBC and put this program in the Windows scheduler.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Dean_AxonDean_Axon Member Posts: 193
    Check out www.expandit.dk and look for the "launch Utility"
    Remember: Keep it simple
  • DenSterDenSter Member Posts: 8,304
    You can use the standard Navision Job Scheduler for this. The only downside is that you will have to have a computer logged into Navision running at the time that you schedule the object to run.
  • ChandlerscottChandlerscott Member Posts: 8
    has anyone had any luck running a dataport to run from a codeunit that is set to run from the NAS scheduler?
  • garakgarak Member Posts: 3,263
    the NAS can't run Dataports.
    So use a xml port, report (with File variable) or codeunit (with file variable) to import / export datas.

    Regards
    Do you make it right, it works too!
Sign In or Register to comment.