Documentation | User Guide

Documentation | User Guide

Load data from a CSV file into SIGTAS

SIGTAS allows the user to load CSV files (spreadsheet-based computer files with values separated by commas). This function is used for compiling and transferring data such as TIN or account numbers, etc. For example, a CSV file may contain opening balance(s), data or values used for assessments.

Loading CSV files in SIGTAS requires the data to be separated by a comma and to respect the encoded UTF-8-dom format. This format is important because it ensures compatibility between data from SIGTAS and the CSV file. Failure to comply with this format will result in hardware incompatibility and failure to download the requested data. In this case, SIGTAS will inform the user of the incompatibility. Once the data is loaded, SIGTAS validates the content, assigns an upload number and displays the result on the related page and module.

The following example explains how to load a CSV file into SIGTAS via the Import Data page (509:89000) in the Administration module. This procedure is standardized and also applies to all uploads of CSV files in SIGTAS.

  1. Go to the module Administration;
  2. Choose the Base Tables option;
  3. Select the Migration option;
  4. Click on the Import Data menu. This action opens the page Import Data (509:8900);
  5. Go to the Select a file and Load in Sigtas section;
  6. Choose the Data source type;
  7. Click on File and choose the type of file you wish to upload. This action displays the name of the CSV file that needs to be uploaded.
  8. Click on Start Loading. This action loads the data from the CSV file. Once the upload is confirmed, SIGTAS validates the content, assigns a loading number and updates the Import Data page (508:8900);
  9. Go to the Loading History section;
  10. Find the desired upload;
  11. Click on the line of the desired upload (the line turns grey). This action displays the loaded data in the section below.

Providing a successful upload, a Y (Y = yes) will be displayed in the Success column. A failed upload will result in a N (N = no) in said column and the reason for the rejection will be displayed in the Rejection Reason column.

  1. Go to the Errors section;
  2. Find the error you wish to display.