Modifiying Existing Data in a table using XML Ports

chander
Member Posts: 12
Hello All,
Could you please help me in acheiving the task of modifying the existing record while importing data using xml port and can i generate a new unique code for the new record if it doesn't exist. I tried using different triggers but didn't work, then i opted for temporary table where the data will be stored and tried to run the code which will do the verification and then act accordingly but this too didn't work as navision gets restarted whenever that piece of code is run for ex.
Created xml port - Employee having its details
created a form for selecting the path to import or export the files
the form contains a button that calls codeunit to further call import function, after importing I want to update the original table with the data imported in temp table (not defined temp using temporary = yes, in this case temp means not in use by any other application) but navision closes when i try to do this, but if i remove the updatealreadyexisting function it works fine.
could anyone please share some experience and give me some advice.
Thanks in advance.
Could you please help me in acheiving the task of modifying the existing record while importing data using xml port and can i generate a new unique code for the new record if it doesn't exist. I tried using different triggers but didn't work, then i opted for temporary table where the data will be stored and tried to run the code which will do the verification and then act accordingly but this too didn't work as navision gets restarted whenever that piece of code is run for ex.
Created xml port - Employee having its details
created a form for selecting the path to import or export the files
the form contains a button that calls codeunit to further call import function, after importing I want to update the original table with the data imported in temp table (not defined temp using temporary = yes, in this case temp means not in use by any other application) but navision closes when i try to do this, but if i remove the updatealreadyexisting function it works fine.
could anyone please share some experience and give me some advice.
Thanks in advance.
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