Source file

The Source File tab enables you to select the source data file to load. This is also where you provide details about how the source data file is set up. You must re-select the source data file before proceeding.

These are the options:

Option Description
Private Property Set Click Private Property Set to open the Property Set Options dialog box. See Property Set Options Dialog Box for further information.
Source File Shows the full path and name of the file containing the data to import. You can specify the file name directly into the box or you can browse to the location of the file. Valid file types for upload are set up by your Administrator.
Header Shows the location of the header row. The default value is 1. You can specify a new value or click the plus or minus signs to change the value. In the Preview section, the highlight moves to show you the new position for the header line. A header row is not required. If your source data file does not contain a header row, clear this check box. If you clear this check box, you must adjust the Start of Data option.
Start of Data Shows the location of the first row of data. The default value is 2. In the Preview section, the row where data starts is highlighted in gray. You can specify a new value or click the up and down arrows to change the value.
Delimiter Character used to delimit the columns. The default is a comma. You can specify a new value or select from these choices:
  • Comma
  • Semi colon
  • Tab
  • Pipe ( | )
  • None
Text Qualifier Character used to delimit the text. The default is None. You can specify a new value or select from these choices:
  • None
  • Single Quote
  • Double Quote
Period activity Financial data only. Indicates data is the profit and loss account activity for the period. The data is written directly to the period as specified by other settings.
Year-to-date balances Financial data only. Indicates data is the year-to-date balance for profit and loss accounts. The period activity is calculated and written to the period as specified by other parameter settings.
Period movement Financial data only. Indicates data is balance sheet movement data for the period. The period end balance is calculated and written to the period as specified by other parameter settings. See "Rules of operation when importing balance sheet movement data".
Period-end balance Financial data only. Indicates data is the period end balance for balance sheet accounts. The data is written directly to the period as specified by other parameter settings.
Perform in-batch accumulation of data for same cell Financial data only. Select this check box to accumulate earlier data in the file with data that is displayed later in the import file.
Note: If the check box is not selected, earlier data is overwritten with data that is displayed later in the import file. This option is selected by default.
Overwrite stored data Financial data only. Overwrites the existing data in the database. This option is selected by default. If this option is not selected, data from the source file is added to the data already in the database.
Reverse sign on credit Financial data only. All data stored in the CPM database is assumed to be positive. Some source systems store credits as a negative number. This option reverses the incoming data sign when the schedule line's (account) natural sign in CPM is a credit.
Reverse sign on debit Financial data only. All data stored in the CPM database is assumed to be positive. Some source systems store debits as a negative number. This option reverses the incoming data sign when the schedule line's (account) natural sign in CPM is a debit.
Preview Shows the first 100 lines of the source data file.