Importing Data from CSV

Tempo Budgets allows you to import your data from a comma-separated value (CSV) file. CSV files are text files representing tabulated data and are supported by most applications that handle tabulated data (for e.g. Microsoft Excel, databases, etc.).

The CSV import feature allows you to import data from an external system which:

  • Tempo Budgets does not provide a dedicated import tool for and
  • Can export its data in a structured/tabulated format (CSV).

The CSV import process consists of:

  1. Preparing your CSV file (below).
  2. Running the CSV file import wizard (below).
    You can choose to map individual fields and field values during the import process.

Preparing your CSV file

Tempo Budgets assumes that your CSV file is based off a default Microsoft Excel-styled CSV file. Fields are separated by commas and any content that must be treated literally, such as commas and new lines/'carriage returns' themselves are enclosed in quotes.

(info) For Microsoft Excel and OpenOffice, it is not necessary to quote values in cells as these applications handle this automatically.

CSV file requirements

In addition to being 'well-formed', CSV files have the following requirements.

Each CSV file must possess a heading row with a columns header

The CSV file import wizard (below) uses a CSV file's header row to determine how to map data from the CSV file's 2nd row and beyond to fields in Tempo Budgets.

The header row should avoid containing any punctuation (apart from the commas separating each column) or the importer may not work correctly.

Commas (as column/field separators) cannot be omitted

For example, this is valid:


Type,Name,Description,Amount,Category,Frequency
"Rent","2231 Chiasson bvd","This is a desc","2,000.00",,

... but this is not valid:


Type,Name,Description,Amount,Category,Frequency
"Rent","2231 Chiasson bvd","This is a desc","2,000.00"


Encapsulating Tempo Budgets data structure in your CSV file

Capturing data that spans multiple lines

Use double-quote marks (") in your CSV file to capture data that spans multiple lines. For example, upon import,Tempo Budgets will treat the following as a valid CSV file with a single record:


Type,Name,Description,Amount
"Rent","2231 Chiasson bvd","This is on
a new line","2,000.00"


Treating special characters literally

Use double-quote marks (") around a section of text to treat any special characters in that section literally. Once this data is imported into Tempo Budgets, these special characters will be stored as part of Tempo Budgets' field data. Examples of special characters include carriage returns/enter characters (as shown in the example above), commas, etc.

To treat a double quote mark literally, you can 'escape' them with another double quote mark character. Hence, the CSV value:

  • "This is for the ""HQ"" rent"
    once imported, will be stored in Tempo Budgets as:
  • This is for the "HQ" rent

Running the CSV file import wizard

Before you begin: If your Tempo Budgets installation has existing data — We strongly recommend that you Back up your existing Tempo Budgets data  by backing up your JIRA data.

  1. Go to your folio in which you want to import some data.
  2. Select the mode (Budget, Costs, Revenues, Team) in which you wish to import some data.
  3. Click on     of the selected mode browser ---  (tick) Keyboard shortcuti 
     
  4. On the CSV File import page, select your CSV Source File.
  5. Specify the date format used in your CSV file. Use the syntax that complies with the Java SimpleDateFormat
  6. Select grouping and decimal separators
     
  7. Click the Next button to proceed to the Setup field mappings step of the CSV file import wizard.
  8. In the Tempo Budgets field column, select the Tempo Budgets fields you want to match to fields defined in your CSV file. For more information about matching CSV fields to Tempo Budgets fields, see Tips for importing CSV data into FOLIO fields below.
    (info) Note: If your CSV file contains more than one of the same field name specified in its header row, the last one will override all the previous ones.

  9. Click the Import button when you are ready to begin importing your CSV data into Tempo Budgets. The importer will display a complete report when the import is complete.
    (info) Note: You can access the latest report from the button. (warning) The latest report is stored only for the user session duration.

Congratulations, you have successfully imported your CSV data into Tempo Budgets! If you have any questions or encounter any problems, please contact Tempo Budgets support.

Folio section-specific CSV import