Cross-reference tables for any-to-any maps

This section provides instructions on using cross-reference tables with any-to-any maps.

Adding a new cross-reference table

1. On ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.

2. On the Cross Reference Tables menu, select File > New from the menu. The New Cross Reference Table window displays.

3. ECMap inserts the name of the current project and map, but you type values in the following text boxes:

   1. In the File Name text box, type the name of the new cross-reference table, using 8 characters or fewer. This field is required.

   2. In the Source Field Length text box, type the length of the application data field upon which the table lookup is being performed.

   3. In the Destination Field Length text box, type the length of the application data field that is being provided by the table lookup.

   4. In the Description text box, optionally type a brief description of the data elements being cross-referenced in the table.

4. Click Create.

   If you are missing the file name or if a field length exceeds 100 characters, you get an error message.

5. Correct errors and click Create again.

   If you have no errors, ECMap creates the cross-reference table, and the Cross Reference Table Properties window displays.

At this point you have created and defined a cross-reference table, but you have not yet created the entries in the table. You can enter the values for the entries in the cross-reference table now, or you can enter them later. See “Modifying an entry in a cross-reference table”.

Deleting a cross-reference table

1. In ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.

2. Highlight a table from the list, right-click it and select Delete from submenu. The program asks you to confirm your decision before it actually removes the table (file).

   WARNING! If you accidentally remove a table, you need to create it again.

3. Click Yes to delete the table or No to return to the Cross Reference Table window.

Finding a cross-reference table

1. In ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.

2. Select Edit > Find from the menu. The Find window displays.

3. In the Search String text box, type the character string you want the program to search for and slick Find. Each time the program finds the character string, you can click Find Next to search for the next occurrence of the string.

Displaying unreferenced cross-reference tables

Cross-reference tables are often kept in a common directory where multiple maps can access them. This practice saves mappers the unnecessary work of recreating cross-reference tables and entries. If all cross-reference tables are stored in a common directory, the Directory Scan utility lets mappers view all of the cross-reference tables in the cross-reference directory (for example, the common directory) that the current map is not using. Mappers can then select any of these unreferenced (currently unused) cross-referenced tables and have ECMap automatically define the selected cross-reference tables in the current map.

1. On ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.

2. On the Cross Reference Tables window, select File > Directory Scan from the menu.

   • If there are no unused cross-reference tables, you receive a message telling you that no unreferenced cross-reference tables were found in the map directory.

   • If there are unused tables, the Cross Reference Directory Tables window displays.

3. To have ECMap automatically define a cross-reference table in the current map, highlight the table on the Cross Reference Directory Tables window and click OK.

   You can select multiple tables, using the Shift and Ctrl keys:

   1. To select multiple contiguous tables, click to select the first table, press Shift, and click the last table in the list. The entire group of tables is highlighted.

   2. To select non-contiguous tables, click to select the first table, press Ctrl, select the next table, press Ctrl, and so on, until you have highlighted all the tables you want to select.

4. The selected table or tables are defined and you return to the Cross Reference Tables window.

Adding entries to a cross-reference table

1. To add entries to or modify entries in a cross-reference table, highlight the table and choose Properties from the Edit menu on the Cross Reference Tables window.

   The Cross Reference Table Properties window displays. If this is an existing cross-reference table, there is a list of all the entries in the highlighted table. If this is a new table, there are no entries.

2. From the Cross Reference Table Properties window, you perform actions on the entries in a cross-reference table. Whether you are creating a new cross-reference table or modifying one, you can add a new entry to the table, edit or delete an entry, or search for an entry.

Adding an entry to a cross-reference table

1. On ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.

2. On the Cross Reference Table window, highlight a table, right-click it and and select Properties from the submenu. The Cross Reference Table Properties window displays.

   If this is an existing cross-reference table, there is a list of all the entries in the highlighted table. If this is a new table, there are no entries.

3. On the Cross Reference Table Properties window, select File > New from the menu. The New Cross Reference Entries window displays.

4. In the Table text box, ECMap inserts the name of the current cross-reference table. You cannot change this value; however, you must type entries in the remaining text boxes:

   1. In the Source Value text box, type the input value which ECMap uses to look up another value.

   2. In the Destination Value text box, type the output value, which is generated by the table lookup.

   3. In the Description text box, type a brief description of this entry in the cross-reference table. This is a required field.

5. Click Next to add another cross-reference entry or OK to return to the Cross Reference Table Properties window. The new entries display in the list of table entries.

Modifying an entry in a cross-reference table

1. On ECMap’s main window, select Tools > Cross Reference Tables form the menu. The Cross Reference Tables window displays.

2. In the Cross Reference Table window, right-click a table and select Properties from the submenu. The Cross Reference Table Properties window displays.

3. In the Cross Reference Table Properties window, right-click a table entry and select Properties from the submenu.The Cross Reference Entry Properties window displays.

4. In the Table text box, ECMap inserts the name of the current cross-reference table. You cannot change this value; however, you must type entries in the remaining text boxes:

   1. In the Source Value text box, type the input value which ECMap uses to look up another value.

   2. In the Destination Value text box, type the output value, which is generated by the table lookup.

   3. In the Description text box, type a brief description of this entry in the cross-reference table. This is a required field.

5. Click Next to edit another entry or select OK to return to the Cross Reference Table Properties window.

Deleting an entry in a cross-reference table

1. On ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.

2. In the Cross Reference Table window, right-click a table and select Properties from the submenu. The Cross Reference Table Properties window displays.

3. Right-click a table entry and select Delete from submenu. The program asks you to confirm your decision before the entry is permanently removed.

   WARNING! If you delete an entry in a cross-reference table by mistake, you must re-enter it as a new entry.

4. Click Yes to delete the table or No to return to the Cross Reference Table Properties window.

Finding an entry in a cross-reference table

1. Choose Find or Find Next from the Edit menu on the Cross Reference Table Properties window. The Find window displays.

2. In the Search String text box, enter the character string you want the program to search for and select Find. Each time the program finds the character string, you can select Find Next to search for the next occurrence of the string.

Toggling between ALL RECORDS and REFERENCE ONLY

1. On ECMap’s main menu, select Tools > Cross Reference Tables from the window. The Cross Reference Tables window displays.

2. In the Cross Reference Table window, right-click a table and select Properties from the submenu. The Cross Reference Table Properties window displays.

3. From the menu, select Options > Modify View to toggle back and forth between the full EDI code list and an abbreviated list of only those EDI elements that have corresponding application values in the cross-reference table.

   Look at the View text box to see which view you are in. For example, ALL RECORDS shows the full EDI code list, while REFERENCE ONLY displays an abbreviated list.

---

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF