ℹ️ In MOFFI, you can import your employees via a flat file (CSV or Excel). This process can be scheduled to run:

• once only,
• every day,
• weekly,
• or monthly.

💡 Automation ensures that your data stays up to date without repetitive manual actions.

Available automations

Upon request, we can set up two types of automation:

1. Export of users from MOFFI (CSV or Excel).
2. Import of users into MOFFI (CSV).
3. Import/export of absences.
4. Import/export of home office.

👉 The frequency is defined with you: daily, weekly, or monthly.

Where to place the file?

Two secure options are available:

• From your servers: you provide us with your SFTP server details and we retrieve the file.
• From a MOFFI server: we provide you with dedicated access (URL + credentials) with a secured folder specific to your company.

File naming convention

To simplify processing, we recommend the following naming convention:

• Users: users_YYYY-MM-DD.csv
• Absences: timeoff_YYYY-MM-DD.csv
• Home office: remote_YYYY-MM-DD.csv

Example: users_2022-07-01.csv

User file format

Each file must be UTF-8 encoded and comma-separated. The required fields are:

• action (mandatory): ADD/UPDATE (create or modify), DELETE, ENABLE, DISABLE
• email (mandatory)
• last name (mandatory if ADD/UPDATE)
• first name (mandatory if ADD/UPDATE)
• groups: separated by ;, automatically created if not existing in MOFFI
• job title
• department name
• building: must match an existing building in MOFFI (id or name)
• SSO ID: identifier required in case of SSO with OpenID Connect
• employee number
• language: fr-FR or en-GB
• welcome email:
  • ALWAYS: always sent
  • ON_CREATION: only if the user does not exist yet
  • ON_AFFILIATION: only if the user is not part of the company
  • NONE: never sent
• password generation link:
  • ALWAYS: always sent
  • ON_CREATION: only if the user does not exist yet
  • NONE: never sent

👉 Example template: CSV User Template

Absence file format

Mandatory fields:

• action: ADD (create) / DELETE (delete)
• email: email address of the absent employee
• date: formatted as YYYY-MM-DD
• period: MORNING, AFTERNOON, DAY
• type: MISC (other), TIME_OFF (paid leave), RTT, SICKNESS, TRAVEL
• reason (optional)

Work from home file format

Mandatory fields:

• action: ADD (create) / DELETE (delete)
• email: email address of the employee
• date: formatted as YYYY-MM-DD
• period: MORNING, AFTERNOON, DAY
• reason (optional)

Frequency of imports

You can choose to schedule imports:

• once at a specific time,
• daily,
• weekly (specific day and time),
• monthly (specific date and time).

How to activate this service?

To request flat file interconnection, simply fill out this form: 👉 MOFFI Interconnection Request

Our team will then contact you to finalize:

• the frequency (daily, weekly, monthly),
• the file deposit mode (your SFTP or ours),
• and validation tests.

⚡ Result: employees, absences, and remote work requests are always up to date in MOFFI, without manual effort.