2 Contact cards created for each company whit Data Migration
                
                    mart1n0                
                
                    Member Posts: 123                
            
                        
            
                    I'm using the data migration tool from Navision 5 to import customers from the by Navison generated excel sheet.
Apart from creating a customer for each line a contact is created too of the type company. What I do not get is why a second contact is created of the type person too for each customer.
It also creates a bunch of empty contacts of the type company without name or anything, just a No. field.
Can anybody clear this out for me please?
                Apart from creating a customer for each line a contact is created too of the type company. What I do not get is why a second contact is created of the type person too for each customer.
It also creates a bunch of empty contacts of the type company without name or anything, just a No. field.
Can anybody clear this out for me please?
0                
            Comments
- 
            Is there nobody that knows why this happens, or is the question not clear?0
 - 
            Customers are only connected to contact of type company. It can’t be connect to person type.0
 - 
            Let's try to explain it better.
When I import the customer list from excel with the data migration this is what happens:
For each customer a contact card is created, the contact card is linked to the customer trough the Business Relation of type Customer.
Apart from this an empty contact card is created of the type person, the number of this empty card is filled in in the Primary Contact field.
What I don't get is why it is creating an empty (primary) contact for each customer since I don't have this field filled in in the customer Excel file to import.
It does not create this empty contact card for customers where the Contact (¡not Primary Contact!) field is filled in.0 - 
            Check if in Excel file that contains Contact field you have a text with white spaces. If you insert several white spaces in a customer card it will create an empty Contact Card.0
 - 
            Hi nunomaia, I already tried that but it's not working seams like it's ignoring contacts with just whitespaces. Only thing that worked was putting an x in all contact fields but thats not a good solution of course, I really would like to know why the behaviour is like this.
Another strange thing, if I put the x in all the contact fields, it still makes the contact card of type company linked to the customer but it does not fill in any fields anymore, so no name, no address, ...
I really don't get the point of this whole data migration like this?0 - 
            Let’s try another option
Import Contact in 2 files. In second file ignore field Contact.0 - 
            I'm sorry I don't understand what you want to say here.
I try to use the data importation feature of the 5.0.
If I leave the contact and/or primary contact fields out it still created the empty contacts.
I don't see how importing trough 2 files would change this?
I understand that I can write a manual import but I just want to understand how the data import feature works. To see if it can really save me time using this instead of having to write import features.0 - 
            Hi mart1n0,
Did you find a solution to this issue?
Is it possible to import customers using the migration tool and not getting two records (company and person) in the contact table?
Regards,0 
Categories
- All Categories
 - 73 General
 - 73 Announcements
 - 66.7K 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
 - 323 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