Populating the dataload spreadsheets

For importing data, you must populate the appropriate dataload spreadsheets. When using the Data Management feature, you must use the dataload spreadsheets that are provided with this version of Remedy ITSM. Each spreadsheet includes instructions specific in the spreadsheet that simplifies the distribution of spreadsheet and entering data into the spreadsheet. This section provides general instructions for entering data in the dataload spreadsheets.

As you complete your spreadsheet, remember these tips:

• You can only use ARX files (and not Excel spreadsheets) to import BMC Service Request Management data.
• All of the articles in the knowledge base provided by BMC Knowledge Management have their own unique original article ID. This ID is referred to as the PrevDocId or KAM article Doc ID in the dataload spreadsheet. For all of the different knowledge article templates, the article ID and its version should be unique.
• The Data Management loads are single tenant. The Company is driven from the Data Management job. All of the data that is loaded by the Data Management job is associated with the company that you selected when your created the Data Management job. This means that you must create a separate spreadsheet for each company. In addition, you must create a separate Data Management job for each company spreadsheet.

To open and save Microsoft Excel 2007 (and later) files (.xlsx) with Excel XP or 2003, you need to apply Microsoft's compatibility patch as documented in KB924074 found at http://support.microsoft.com/kb/924074.

To populate data in the foundation dataload spreadsheets

1. Complete the spreadsheets according to the instructions on the Instructions tab and in the column headings. 
   All leading and trailing spaces and tab characters are stripped when the data is imported into staging forms.

2. Follow the instructions about saving your spreadsheet changes in Downloading and creating data load spreadsheets.