dataport: importing data into table failure

JBeckJBeck Member Posts: 68
edited 2006-12-20 in Navision Financials
Hi,

I'm trying to import data into an empty table but after import it's still empty. e.g. Table G/L Entry.
Why doesn't it import properly and how can I slove this problem?

Thanks in advance,
JBeck

Merry Christmas :P

Comments

  • Captain_DX4Captain_DX4 Member Posts: 230
    Best practices state that you should never directly import into a ledger table. Alway try to go through a journal and post into the ledger.

    With that disclaimer out of the way, does the dataport have the correct permissions to insert into the table?
    Kristopher Webb
    Microsoft Dynamics NAV Developer
  • David_CoxDavid_Cox Member Posts: 509
    JBeck wrote:
    Hi,

    I'm trying to import data into an empty table but after import it's still empty. e.g. Table G/L Entry.
    Why doesn't it import properly and how can I slove this problem?

    Thanks in advance,
    JBeck

    Merry Christmas :P

    Populate the Gen. Journal Line table and then post the Journal.

    The reason you may not have values?
    have you added the fields to the field list?
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
  • kinekine Member Posts: 12,562
    JBeck wrote:
    Hi,

    I'm trying to import data into an empty table but after import it's still empty. e.g. Table G/L Entry.
    Why doesn't it import properly and how can I slove this problem?

    Thanks in advance,
    JBeck

    Merry Christmas :P

    Do not forget that if you run the dataport within designer (when designing it), the import will not be commited. You need to run the dataport outside designer (from object designer through RUN button) or you need to add commit in OnAfterDataport.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.