Microsoft Dynamics NAV (Archived)

RapidStart Customer and Contact relationship import fail

(0) Share

Report

Posted on by Community Member

Hello,

I am doing to migrate data from NAV 2009 to NAV 2015 using RapidStart.

In NAV 2009 there are heaps of broken data exist

as a result, I need to refine data before import.

I do not know I am doing proper way to achieve the goal.

However, how do I import the data from NAV 2009 is

Create a Worksheet table which I want to import the data in RapidStart
Select the table and click Export to Template in Excel Ribbon tab.
Insert the data into the Excel Table
Refine the data in Excel and Save
Click Import from Template.

Do I select the proper way to import data?

There is a better way to do this using SQL Query?? (in Excel it is quite painful and slow)

Anyway using above job process what I did is

Imported data which is related to Contact and Customers
Such as Territory, Salutation, Service Zone, Currency, Posting Groups etc (Success)
Imported all contacts (Success)
Imported all customers (Fail)

Error Msg - There is no Contact Business Relation within the filter. Filters: Link to Table: Customer, No.: CE00001
Field Caption: Primary Contact No.
I know there is middle table "Contact Business Relation"

Try Imported Contact Business Relation (Fail)

Error Msg - Business Relation Code SYSCUST is used when a Contact is linked with a Customer.
Field Caption business Relation Code

How can I import all customer with proper contact relationship?

Best Regards,

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Verified answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Donam,

First import Customer and Contact Business Relation with "Skip Table Triggers" is true, and not validate all fields. Then, import them again with table triggers and validate needed fields.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

Problem is with your trigger validations. So in the initial import skip the table triggers. You can do this by ticking the "Skip Table Triggers". By doing this it will allow you to import data without checking any validations or relationships.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

Does the above solution work for you?

Please verify the solution.

Best Regards,

MMV

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you TUNG KHOA. However I am hard to find the option in worksheet records page. Where is the"Skip Table Triggers" option?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you TharangaC However I am hard to find the option in worksheet records page. Where is the"Skip Table Triggers" option?

Was this reply helpful? Yes No
Verified answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Donam,

- Skip Table Triggers: in Config Worksheet, select needed table line and click Package Card action. Config Package Card opens, there is Skip Table Triggers boolean column in detail part.

- Not validate fields: in detail part of Config Package Card, select needed table line and click on Table -> Fields. Config Package Fields opens, there is Validate Field boolean column.

For more information, you can refer to my YouTube.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you so much TUNG KHOA

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

You're welcome!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have problems importing contacts and read your article. I have a problem removing the validation when importing table 5054,contact realtions as descibeed in your answer . I'm a bit desperate and I would like to have a procedure in place rather quickly. Thanks in advance.

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

Hi MrMFF,

1. Import Customer with "Skip Table Triggers" is true, and not validate selected fields.

2. Import Contact Business Relation with "Skip Table Triggers" is true, and not validate selected fields.

3. Import Customer with "Skip Table Triggers" is false, and validate selected fields.

4. Import Contact Business Relation with "Skip Table Triggers" is false, and validate selected fields.

For Skip Table Triggers and Not validate fields:

- Skip Table Triggers: in Config Worksheet, select needed table line and click Package Card action. Config Package Card opens, there is Skip Table Triggers boolean column in detail part.

- Not validate fields: in detail part of Config Package Card, select needed table line and click on Table -> Fields. Config Package Fields opens, there is Validate Field boolean column.

Was this reply helpful? Yes No