Re: [Axapta-Knowledge-Village] Excel Import Error: ContactPerson Table

2005-05-09 Thread Jay Hofacker
The message "Field 'Reference' must be filled in" isn't referring to the reference field in ContactPerson, but in HRMVirtualNetworkTable. That field is related to the ContactPerson table by the ContactPersonId field, which is hidden and doesn't appear in the Excel template. Normally the ContactPers

Re: [Axapta-Knowledge-Village] Excel Import Error: ContactPerson Table

2005-05-09 Thread Subrahmanyam, Mamidi
Hi ,   If you didn't have luck yet, Please send me the file and I will try in my dev environment. My email Id is :  [EMAIL PROTECTED].   Best of luck, subbulukas nugroho <[EMAIL PROTECTED]> wrote: Before u upload your ContactPerson table you must upload HRMVirtualNetwork Table first which it c

RE: [Axapta-Knowledge-Village] Excel Import Error: ContactPerson Table

2005-05-09 Thread SATHIYANATHAN.P - Senior Software Specialist - SIS
hi   convert the excel into text file, then try it.   regards   p.sathi -Original Message-From: lukas nugroho [mailto:[EMAIL PROTECTED]Sent: Monday, May 09, 2005 8:12 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Excel Import Error

Re: [Axapta-Knowledge-Village] Excel Import Error: ContactPerson Table

2005-05-08 Thread lukas nugroho
Before u upload your ContactPerson table you must upload HRMVirtualNetwork Table first which it contains of referece of your contact id Dick Howard <[EMAIL PROTECTED]> wrote: Have successfully imported CustTable using an Excel template and now need to import over 800 Contacts for those customers

Re: [Axapta-Knowledge-Village] Excel Import Error: ContactPerson Table

2005-05-07 Thread Subrahmanyam, Mamidi
Hi,   I had faced the same problem earlier. As you know, I debugged the sysdataimportcline (?? ) class and found that Exapta maps the Fields to the Enums. When they don;t match , you get this type of errors. So the problem is due to the formatting.   what you can do is:   1. Cust and paste the

Re: [Axapta-Knowledge-Village] Excel Import Error: ContactPerson Table

2005-05-06 Thread Varden Morris
Hi Dick,   Are the State, County and Country fields data accurate? These are also reference fields in addition to the customer account number that need to have corresponding values in the state, county and country tables respectively.   Varden MorrisDick Howard <[EMAIL PROTECTED]> wrote: Have s

[Axapta-Knowledge-Village] Excel Import Error: ContactPerson Table

2005-05-06 Thread Dick Howard
Have successfully imported CustTable using an Excel template and now need to import over 800 Contacts for those customers to the ContactPerson table. Mostly am importing names and phone numbers. But the import issues the following error for each record... "Field 'Reference' must be filled in"