Skip to main content

Introduction

Qobra can connect to your AWS account and synchronize csv files from an S3 bucket. This integration is readonly and will not write anything in your S3 buckets.

Access & setup

  1. Create the S3 bucket that will hold your synchronized csv files.
  2. Create an AWS policy with the least access needed for the integration to work:
    • s3:ListBucket: lists S3 buckets (among restricted resources)
    • s3:GetObject: retrieves documents from S3 buckets (among restricted resources)
    The policy should look something like this:
    Attach the policy to the IAM user or role to give us access to the S3 bucket. If you are using resource based policy, make sure the bucket policy is updated accordingly.
  3. Fill in your bucket information in the application: S3 setup in Qobra

Synchronization

CSV file requirements

Qobra reads the file line by line and splits each line on ;. It does not interpret quotes, so a file that breaks the rules below fails to import, or imports wrong values.

File

  • The file has the .csv extension, in lowercase.
  • The file keeps the same name and path: Qobra reads it from the path you entered when you added the data table.
  • The file is encoded in UTF-8, without a byte order mark (BOM). Some tools, such as the CSV UTF-8 format of Excel, add one: the name of the first column then starts with an invisible character.

Lines and columns

  • The first line is the header: the names of the columns, separated by ;. Give each column a different name.
  • Each following line is one record, and ends with a line break. Use Unix line endings (\n): with Windows line endings (\r\n), each value of the last column ends with an invisible carriage return.
  • Every line has as many columns as the header, empty values included. A record with no value in its last two columns ends with ;;.
  • No value contains a ; or a line break. Quotes do not protect them: "Acme" is imported with its quotes, and a ; between quotes still starts a new column. Remove or replace these characters when you export the file.
  • Empty lines are skipped.
A line with more or fewer columns than the header stops the import. The error names the line by the identifier of the line just before it. You can add columns to the file at any time. If you rename or remove a column that a field of the data table reads, the import fails until you restore the column.

Required columns

  • A unique identifier column: each line has its own value, which never changes.
  • A name column.

Values

An empty value imports as an empty field. Other values follow the type of the field that reads them:
  • Text: any text, such as Acme renewal.
  • Date: YYYY-MM-DD, such as 2026-01-15.
  • Number and amount: . as decimal separator and no thousands separator, such as 12000.50.
  • Percentage: with %, such as 12%, or as a fraction, such as 0.12. Without %, 12 reads as 1,200%.
  • Boolean: true or false, or 1 or 0, in any case. Any other value reads as true.
  • User: the user’s email by default. You can choose another user identifier when you add the data table.
  • Picklist: the option, such as Europe.
  • Multipicklist: the options, separated by , without spaces, such as Europe,Americas.
The currency of an amount comes from a column named after the amount column followed by _currency, such as amount_currency, holding a currency code such as EUR. Without this column, or with a code Qobra does not know, the amount takes the currency of your company.

Example

Total synchronization

This integrations does total synchronization, meaning the whole document will be synced at every refresh.

Refresh Schedule

By default, we perform one Full Refresh per day to keep your data up to date. However, you can customize both the frequency and timing of these refreshes to better suit your needs:
  • Default Schedule: one Full Refresh per day
  • Customizable Options:
    • Adjust the number of daily refreshes
    • Set specific hours for the refreshes to occur
    • Configure the schedule through your integration settings
  • On-Demand Updates: Need the latest data right away? Just click the refresh button in your integration settings
Refresh schedule setup in Qobra