| | 1 | [[TracNav(TracNav/ISO15926HowTo)]] |
| | 2 | |
| | 3 | = Creating a Mapping Spreadsheet = |
| | 4 | |
| | 5 | Status of this document: Working Draft |
| | 6 | |
| | 7 | This document is open for feedback, please post questions and comments in the forum at the bottom of this page. You will [WikiStart#Contactpoints need a login] to post in the forum. |
| | 8 | |
| | 9 | ---- |
| | 10 | |
| | 11 | [[PageOutline(2-4,Contents,inline)]] |
| | 12 | |
| | 13 | |
| | 14 | ---- |
| | 15 | == Creating a Mapping Spreadsheet == |
| | 16 | |
| | 17 | The first step is to look at the three sets of data and create a cross-reference list for each table. We want to be able to show equivalent database rows in the same row of the list. A spreadsheet is an excellent medium. |
| | 18 | |
| | 19 | Create a pair of columns for each participant, and three columns for ISO 15926-4 information: |
| | 20 | |
| | 21 | * 3D Table |
| | 22 | * 3D Column |
| | 23 | * Line List Table |
| | 24 | * Line List Column |
| | 25 | * Material Table |
| | 26 | * Material Column |
| | 27 | * ISO 15926 Class Label |
| | 28 | * ISO 15926 Class ID |
| | 29 | * ISO 15926 Description |
| | 30 | |
| | 31 | Sample Spreadsheet |
| | 32 | * attachment:MappingSpreadsheet_Blank.xls |
| | 33 | |
| | 34 | Examine the columns in each database listing and arrange equivalent column names on the same row. The example below starts with the columns in the 3D table, with the Line List columns next, followed by the Material columns. |
| | 35 | |
| | 36 | Sample Spreadsheet |
| | 37 | * attachment:MappingSpreadsheet_Columns.xls |
| | 38 | |
| | 39 | The first thing you notice is that there is not an exact match between the column names, and that each database contains information that neither of the other two does. This is OK. With ISO 15926 we do not have to share all of our information with our business partners, only that which has value. |
| | 40 | |
| | 41 | ---- |
| | 42 | |
| | 43 | == Back == |
| | 44 | |
| | 45 | * [wiki:ISO15926HowTo_Tutorial Back to Tutorials] |
| | 46 | |
| | 47 | |
| | 48 | ---- |
| | 49 | [[ViewTopic([Enter forum topic])]] |
