Notes:
This task requires previous experience working with databases. Ask your technical staff for help if necessary.
Use only a Western character set to create records for an import file. If you use any other character set to create the field names and data in a record, the import fails for that record.
If you use Character Map (a Windows function) to insert special characters into the data that you plan to import, use only characters that belong to the Windows: Western character set. Otherwise, the characters are converted to the Windows: Western character set and may not appear as you want.
You can map one set of fields to another as follows:
One field to many fields (a one-to-many link).
One field to one field (a one-to-one link).
Many fields to one field (a many-to-one link).
You may need to specify a particular format or insert special characters. For example, if you map the City, State/Province/County, and Postal/ZIP Code boxes to a single ODBC database field, you may want the city to appear first, followed by a comma and a space between the city and the state, or you may want to spell out the states instead of using the usual two-character abbreviations. See Address Book Data Field Descriptions, Commodity Data Field Descriptions, Custom Package Type Data Field Descriptions, Customer ID List Data Field Descriptions, Dangerous Goods Data Field Descriptions, Freight Commodity Data Field Descriptions, Freight Shipment Data Field Descriptions, Reference Number and Qualifier Data Field Descriptions, Shipment Data Field Descriptions, Trade Direct Shipment Data Field Descriptions, and World Ease Shipment Data Field Descriptions.
You specify this formatting information with a translation.
To translate a one-to-many or one-to-one link:
Note: These translations usually include only text changes, such as Maryland instead of MD.
Select a one-to-many or one-to-one link in the What You Have Mapped So Far box.
Click the Edit button. The Mapping Connections window appears.
Click the Translate button. The Select a Common Map window appears.
Select a translation and click the OK button. The Mapping Connections window reappears with the selected translations.
Continue translating as needed:
To add a translation to the list box, type a value in the External Field box and the corresponding translation in the WorldShip Field box and then click the Add button.
To remove a translation from the list box, select it and click the Delete button.
To rename a translation, select it. WorldShip places the translation values in the External Field and WorldShip Field boxes. Type the changes in the WorldShip Field box and click the Rename button.
When you are finished, click the OK button.
To translate a many-to-one link:
Note: These translations usually include setting the order of fields and inserting punctuation and other characters, in addition to specifying text changes as described above.
Select a many-to-one link in the What You Have Mapped So Far box.
Click the Edit button. The Modify Connections window appears. The External Field box shows the fields mapped to the <table><field> specified in the window title. The Format box at the bottom of the window shows the current order and formatting of the translation.
To change the order of the fields as they appear in both the External Field box and the Format box, select a field in the External Field box and click the Up and Down buttons to move the field to the desired position.
To specify a text translation for a field, select it and complete steps 3 through 6 in the procedure above.
To insert punctuation or other characters, type directly in the Format box. The inserted characters remain in the Format box. For example, if the Format box displays <city>, <state> <zip> and you swap state and city, the Format box shows <state>, <city> <zip>. In other words, the comma remains after the first field, regardless of which field is first. To move the punctuation or other characters, delete and retype it.
When you are finished, click the OK button.