COMMUNITY FORUM

Hi Mick,
 
The way to import the data to the particular company from the Excel sheet is to create a script to determine which records go to which companies.
 
Open your map and destination, then click on the companies button. In the Companies window, click on the “Define” option which will open the “Map Destination Definition” where you can script the definition of the destination company based on the particular column from the Excel sheet.
 
Make sure that you uncheck any columns in the companies window or data will go to the selected companies as well as the company defined by the script.
 
For example: if you have a column in your spreadsheet (COMPANY) that holds the company id the following script could be used.
 
C#
return _COMPANY;
VB
return _COMPANY
 
If more than one field determines the company then use an if or switch statement to return the correct code.
 
C#
If(_FIELD1 == “value1” && _FIELD2 == “value2”)
                return “TWO”;
return “ONE”;
 
VB
If _FIELD1 = "value1" AndAlso _FIELD2 = "value2" Then
                    Return "TWO"
Else
                    Return “ONE”
End If