Provisioning using SFTP

Overview

FUYL.io supports a fallback provisioning method using SFTP, allowing user and group data to be uploaded via CSV files. This is ideal when direct integrations (like Google Workspace or Azure) are unavailable, instead these files are uploaded and/or changed to provision FUYL.io.

This method allows systems such as School Management Systems, Library Management Systems, or other industry-specific sources of truth to become the data source for FUYL.io provisioning without requiring complex API integrations.

Example Scenarios

• School Management System (SMS): Export student and staff data, including groupings like classes or grade levels, as CSVs to provision users and groups in FUYL.io.
• Library Management System (LMS): Use library membership records exported as CSVs to manage and provision users and membership groups.
• Industry-specific Database: Any CRM, volunteer management, or healthcare system exporting user and group data as CSVs can serve as your source of truth for FUYL.io provisioning.

CSV Templates

Below are example CSV templates to start with (replace these placeholder links with your actual file locations):

• users.csv template (Users and their details)
• groups.csv template (Groups and their details)
• user_groups.csv template (Mapping Users to Groups)

Configuring Login ID

Including the login_id and/or rfid_credential columns in your users.csv enables FUYL administrators to configure provisioned attribute-based authentication methods for users. Each column should be populated with a unique identifier (such as a student ID, employee number, barcode, or card number).

user_id,email,first_name,last_name,login_id,barcode_credential,rfid_credential
1001,jane.doe@example.com,Jane,Doe,stu123,stu123_barcode,ACBDCE14
1002,john.smith@example.com,John,Smith,emp456,emp456_barcode,ACBDCE16

FUYL.io uses these columns to populate the appropriate fields for each user during provisioning.

Setup

1. Sign in to FUYL.io as an administrator.
2. Navigate to Settings > Users > Provisioning (Configure) and select the SFTP provisioning option.
3. Follow the wizard to generate SFTP credentials and set up your upload process.
4. Upload your prepared CSV files via SFTP. The wizard will guide you through verifying uploads and syncing.

Most technical details are handled by the FUYL.io wizard, which provides thorough guidance and validation to ensure smooth provisioning.

Automating updates with SFTP

Automating updates to FUYL.io may involve scheduling regular exports from the source of truth using built-in export features or custom scripts.

Exported files can then be automatically transformed to the FUYL.io CSV format, and uploaded to the designated SFTP directory on a defined cadence to keep a user base in sync without manual steps.

For assistance with setting up these automated workflows or for inquiries regarding best practices, contact FUYL support for tailored guidance.