Entering data in the spreadsheets

Unknown macro: {multi-excerpt}

This section provides general instructions for entering data in the dataload spreadsheets.

To simplify the distribution of spreadsheets, so that others can also enter data into them, each spreadsheet includes instructions specific to the spreadsheet.

Notes

You can only use ARX files (and not Excel spreadsheets) to import BMC Service Request Management data. For information on the BMC Service Request Management dataload process, see Importing data from the Data Management Job Console.

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.

Tip

In order 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.

Recommendation

BMC does not support error handling for the CI relationship data from the Transactional-Asset.xlsx spreadsheet. Ensure that you enter valid normalized relationship type names into the spreadsheet. For more information about the normalized names, see the CI relationship types table in Loading BMC Asset Management data.

Entering data in the spreadsheets

Comments