Data Import - Cost Structure Rows

Additional rows can be imported into an existing Cost Structure for your company via a Datacom only import. This import is not directly available for clients to use at this time. A minimum of one line must already exist in your Cost Structure in order to use this import (i.e. the import cannot create a Cost Structure in a newly created company)

Data must be supplied in the correct format using the supplied template which is attached to this page.

Information for filling out the template:

• A sample row has been left in the template as a guide - please remove this before submitting the file to the Support Team for import.
• The template has columns for an 8 level Cost Structure. Most companies do not use all 8 levels - if this is the case for you, simply leave the unused columns empty. Do not delete the unused columns from the file.
• The 'Company Code' column must be filled in for every row, however only one code can be used throughout the entire file - i.e. if you need to import for two companies you will need to use two separate import files.
• As with Company Code, there can only be one Level 1 Name and Level 1 Code used for the entire company. This must match what is already in your existing Cost Structure in DataPay.
• We would suggest against using codes with leading zero's such as '01' or '002' as when using these codes in reports they will often be trimmed to '1' and '2' causing difficulty.
• Do not remove, rename, or add any columns to the import file. 

Please note:

• Datacom charges our standard consulting rate for any imports completed on behalf of clients. There is a minimum charge of 1 hour.
• We are not able to alter / modify / make corrections to any data supplied.
• Data to import must be supplied in the correct format for our system to accept using the supplied templates. We cannot convert data into this format on your behalf.