This repository has been archived by the owner. It is now read-only.
Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
53 lines (31 sloc) 2.6 KB

Data Processing

How is the CSV / Excel file data processed before it is imported into RosarioSIS database?

Excel files

Excel files are automatically converted to CSV format.

Note: Only the first spreadsheet is saved.

The tests/ folder contains several files that demonstrate how to use the module. The best way to get started is to import one of these files and look at the results.

CSV files

CSV (Comma Separated Values) is a tabular format that consists of rows and columns. Each row in a CSV file represents a user; each column identifies a piece of information about that user.

Value separators being used in the CSV file can be commas , or semicolons ;.

Use quotation marks " as text delimiters when your text contains line-breaks or reserved characters like the values separator (, or ;).

Make sure that the quotation marks used as text delimiters in columns are regular ASCII double quotes ", not typographical quotes like (U+201C) and (U+201D).

You can generate CSV file with all users inside it, using a standard spreadsheet software like: Microsoft Excel, LibreOffice Calc, OpenOffice Calc or Gnumeric.

You have to create the file filled with information (or take it from another database) and you will have to choose CSV file when you "Save as..." the file. As an example, a CSV file is included in the tests/ folder.

Profiles

In case you choose to import profiles from a column of your CSV / Excel file, here are the predefined profile values that will be accepted and detected:

  • admin or "Administrator"
  • teacher or "Teacher"
  • parent or "Parent"
  • none or "No Access" or "" (empty)

All data

Trimmed (spaces are stripped), examples:

  • " John " => "John"
  • " " => empty value (= NULL)

Field types

You can check the type of each field in the info tooltip (on the Import form) or in Users > User Fields.

  • Text / Pull-down / Auto Pull-down / Edit Pull-down / Export Pull-down: values are truncated if longer than 255 characters.
  • Long text: values are truncated if longer than 5000 characters.
  • Number: values are checked to be numeric (float, integer) and no longer than 22 digits.
  • Date: supported date formats.
  • Checkbox: only Y values are considered valid for the checked state. Any other value will be omitted. (Note that you can change the Y for a custom value in the Premium module).
  • Select Multiple from Options: semi-colons (;) and pipes (|) are detected as values separators (examples: Value 1;Value 2;Value 3 or Value 1|Value 2|Value 3).