File reader

The File Reader is a powerful tool for importing data into Lumenore from flat files stored on your computer, server, or cloud storage. It’s a flexible option for importing common file types used in data exchange and storage.

How to use File Reader: 

Step 1: Upload Files

You can upload files in several ways:

• Drag & drop from your computer
• Browse files manually
• Use cloud storage like Google Drive, OneDrive, Dropbox, SharePoint, etc.
• Import from Server (button below)
• To use sample data

For the demonstration, we are uploading a file using the “Import file from server” option. Select a file and click “Add.” Once added successfully, proceed by clicking on “Select files.”

Select the tables and columns the user wants to include by checking the corresponding boxes. The user can also change the data type of the column.

Step 2: Advanced Configuration

Header Row

• The system starts reading column names from the row number you specify.
• The number 0 likely means the header is in the first row (row indexing may start at 0).

Use filename Column

• If set to “Yes“, the user can add a column with the filename, which is useful when processing multiple files together.
• Useful when importing multiple files and needing to track their source.

Delimiter

• A comma (,) is set as the delimiter, which is standard for CSV files.
• You can change this if your file uses another separator like; or |.

Enclosure

The text enclosure character in your file helps the system correctly read data values that contain special characters like commas or new lines.

Enclosure Options:

Double Quote (“) – (Common default for CSVs)

• • Text values are enclosed in double quotes.
  • Example:
    “John, Smith” will be read as one value, not two (despite the comma inside).

Single Quote (‘)

• • Text values are enclosed with single quotes.
  • Example:
    ‘John, Smith’ will also be treated as one field.

None

• • No enclosure is used.
  • The system treats commas (or other delimiters) as field separators without considering quote boundaries.
  • Use this only if your data does not contain delimiters inside text fields.

Is MultiLine

• • If “No”, the system expects each row in the file to be a single line.
  • If “Yes”, it will handle values that span multiple lines (e.g., addresses or descriptions with line breaks).

Apply globally

• • If checked, the settings would apply to all selected sheets.

Click “Save” to apply and store the advanced configuration settings.

Now, the file is loaded successfully.

Preview