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 ContactPersonId is initialized in
ContactPerson.InitValue(), but that doesn't get called by the import
routine. To get your import to work, add this code to the Conversion
tab of the Table Setup of the Definition group for the Excel import:
;
contactPerson.contactPersonId =
NumberSeq::newGetNum(CompanyInfo::numRefContactPersonId()).num();
The message "Unknown type: 'VT_BSTR'" occurs when you try to import a
cell that is formatted as text into a field that is an integer. In the
Excel template, change the formatting of the cells in that column from
Text to either General or Number.
Jay Hofacker
BKD Technologies
------------------------ Yahoo! Groups Sponsor --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
