To import Eclipse dictionaries to create an XML database schema:Use XML Schema Maintenance to define new XML database schemas. One way to create XML database schemas is to dictionaries directly from Eclipse files. Importing dictionaries saves you time if a similar dictionary is already defined for the XML database schema you want to create. You can also create XML database schemas from scratch without importing Eclipse dictionaries.
Note: You can also modify schemas or delete schemas using XML Schema Maintenance.
Use XML Schema Maintenance to complete the following tasks:
Importing existing dictionaries saves you time if a similar dictionary is already defined for the XML database schema you want to create.
To import Eclipse dictionaries to create an XML database schema:
From the System > Custom menu, select XML Schema Maintenance to display the XML Schema Maintenance screen.
In the XML Database Schema field, do one of the following:
Type the new name of the schema that you want to create and select New.
Press F10 to select an existing XML database schema to which you want to add information from an Eclipse dictionary.
In the Eclipse File field, enter or select the Eclipse file that contains the data you want to include in your schema. You can enter standard Eclipse files or user-defined files. Press F10 to select a valid file.
Press F10 for a list of files with dictionaries defined in your system.
Use the Import hot key to import the dictionary information for the file.
Note: If you are an internal Eclipse user, answer Yes at the Use New dictionaries Only prompt to import only the dictionaries that meet the new Eclipse dictionary naming conventions. If you are not an Eclipse user, you do not receive this prompt.
The system displays details for each dictionary defined in the file you imported. Update the information for each line, as necessary.
Do the following to complete the XML database schema:
|
To... |
Do this... |
|
define XML database schema translation properties for each line |
select the line for which you want to define translation properties and use the Properties hot key to display the XML Schema Properties screen. See Defining XML Database Schema Translation Properties for additional information about defining schema properties. Note: Setting translation properties for each line is required before you can close the XML Schema Maintenance screen and compile the XML for the schema. |
|
delete the data definitions that you do not want to map to using the Business Connect XML mapping utility |
select the line to delete and press Alt + Delete. You can only delete lines that you have added. You cannot delete standard Eclipse files that provide data essential for the supported transaction sets. |
|
modify the imported information for a data definition, such as the description listed in the XML Description field |
access the field and type the new information. Any updates that you make to the XML name and XML description are made only to the schema and do not apply to the dictionary that you imported. Note: Although you can change the values for attribute marks, value marks, and any sub-value marks, we recommend that you do not do so. Changing these markers affects how data is stored. |
Press Esc to save the schema and compile the associated XML.
You can create XML database schemas without importing Eclipse dictionaries, however, importing dictionaries does save time when creating schemas.
To create XML database schemas without importing dictionaries:
From the System > Custom menu, select XML Schema Maintenance to display the XML Schema Maintenance screen.
In the XML Database Schema field, type the name of the XML database schema you want to create and select New.
In the Eclipse File field, enter or select the Eclipse file that contains the data you want to include in your schema. You can enter standard Eclipse files or user-defined files. Press F10 to select a valid file.
In the XML Name field, enter the name of the data definition, such as Address1. The XML name format cannot contain spaces. Use uppercase letters to distinguish between words, such as FirstName in a contact record.
In the XML Description field, enter a detailed description of the data. For example, for an XML name of CreditCard, you might enter Default Credit Card Info in the XML Description field.
In the AM field, enter the attribute mark for the data in the Eclipse file.
In the VM field, enter the value mark, if any, for the data within the attribute in the Eclipse file.
In the SVM field, enter the sub-value mark, if any, for the data within the attribute in the Eclipse file.
With the line selected, use the Properties hot key and define the XML database schema translation properties.
Press Esc to save the schema and compile the associated XML.
You can add data definitions for your user-defined files to the default schemas set up with your system or delete an XML database schema that is no longer valid. Ensure that any schemas you want to delete are not currently used in an XML transaction map for a trading partner.
Note: You can only delete XML database schemas that you created, not those provided by Eclipse.
To modify XML database schemas:
From the System > Custom menu, select XML Schema Maintenance to display the XML Schema Maintenance screen.
In the XML Database Schema field, enter or select the XML database schema you want to modify and press Enter.
Do any the following to modify the XML database schema:
|
To... |
Do this... |
|
update XML database schema translation properties |
select the line for which you want to define translation properties and use the Properties hot key to display the XML Schema Properties screen. |
|
delete data definitions that you do not want to include in the schema |
select the line you want to delete and press Alt + Delete. You can only delete lines that you have added. You cannot delete standard Eclipse files that provide data essential for the supported transaction sets. |
|
modify the information for a data definition, such as, the description listed in the XML Description field |
for each line you want to change, access the field and type the new information. Note: Although you can change the values for attribute marks, value marks, and any sub-value marks, we recommend that you do not do so. Changing these markers affects how data is stored. |
Press Esc to save your changes to the schema and to compile the new XML.
To delete XML database schemas:
From the System > Custom menu, select XML Schema Maintenance to display the XML Schema Maintenance screen.
In the XML Database Schema field, enter or select the XML database schema to delete and press Enter.
Use the Delete hot key and type Delete at the prompt to confirm the removal of the schema.
See Also:
XML Schema Maintenance Overview
Defining XML Database Schema Translation Properties