CSV

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

Omni Loader supports the following authentication schemes:

SQL Server
This is the standard username/password combination stored in and verified by the SQL Server.
AAD password
This is Azure Active Directory password authentication.
AAD multi-factor
Azure Active Directory multi-factor authentication will show a pop-up authenticating you as a separate step.
AAD integrated
Azure Active Directory integrated authentication is an equivalent of what was used to be called Windows authentication for SQL Server.

Connecting to CSV

Storage

Local
‍The file is on the same machine or a network path accessible from the machine.
Azure Data Lake
‍The file is stored in an Azure Data Lake storage account.
Azure Blob
‍The file is hosted in Azure Blob Storage.
Amazon S3
‍The file is kept in an Amazon S3 bucket.

Compression

None
‍No compression is applied, which can be suitable for scenarios where processing speed is more critical than saving storage space or when the data is already compressed.
Snappy
‍A fast compression and decompression library that provides a balance between speed and compression ratio, often used for real-time data processing.
Gzip
‍A widely used compression format that offers a good trade-off between compression ratio and the speed of decompression, suitable for network data transmission.

Database Folder

Specify the directory path where the CSV file is located. This can be a folder path on the local system or the path within the chosen cloud storage service.

Optional

First Row Contains Field Names
‍Tick this if the first row of the CSV file contains header names for the columns.
Include Subdirectories
‍Check this option if the data is spread across multiple CSV files within subdirectories of the specified database folder.

Charset

Choose the character set encoding of the CSV file or leave it as (autodetect) to have the system determine it automatically.

Value Delimiter

Indicate how values are separated. The default is a comma, but other delimiters like tab or a custom character can be specified.

Row Delimiter

Define how rows are separated. The default is a newline, but this can be changed to a custom delimiter if needed.

Data handling defines the way Omni Loader will generate the files and clean up:

Clear before run
Everything in the container folder will be deleted before the data copying starts.
Clear after run
Everything in the container folder will be deleted after the data copying completes.
Timestamped
Nothing is deleted. On each run, Omni Loader creates a new folder named as the current time, then place the files inside the folder. This allows for a complete history, but may generate a large amount of data after many runs.

We support three modes of storage authentication:

Connection string
This is the least secure mode which should not be used in production. It requires account key and grants full access to the whole storage account.
Managed identity
A secure authentication mode, leveraging AAD to grant access to the resource.
Shared access signature
A good middle-ground where one can easily grant access to either a whole account or a specific container only.

CSV