dataport: importing data into table failure

JBeck
Member Posts: 68
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
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
0
Comments
-
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 Developer0 -
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.com0 -
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.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions