I/O Task
The I/O task (Input Output) allows to import and export data from and to Docebo.
There are several pre-configured tasks written in php file format that manage these activities:
- Import/Export companies (connector.docebocompany.php)
- Import/Export organization chart (connector.doceboorgchart.php)
- Import/Export organization chart from xml file (connector.xmlorgchart.php)
- Import/Export user-course relation (connector.docebocourseusers.php)
- Import/Export course list (connector.docebocourses.php)
- Import/Export course list in SAP HR format (connector.coursesap.php)
- Import/Export course report (connector.docebocoursereport.php)
- Import/Export csv file (connector.csv.php)
- Import/Export docebo users (connector.docebousers.php)
- Import/Export users report (connector.userreport.php)
Creating a Connector means to activate it (there is a .php file that manages certain data)
Creating a connection means to assign a certain activity to a connector, in order to write and read some data stored in CSV file or DB.
To create a TASK means to associate a connector source to a connector destination where to archive (import/export) certain data. For instance, you can write to a CSV file or database starting from a Database or CSV.
Example: Import users from a csv file loaded nightly by ftp and write data inside DOCEBO DB.
Note: connectors are generally made in a way that recognizes data managed by connectors and data manually handled.
Using the input/output module it is possible to schedule a set of activities that read from a .csv or .xml file loaded through FTP by another application or sent by Docebo to another application.
Basic instructions for managing automatic import/export:
- Activities can be scheduled via the administration area using the I/O (input/output) module, which is placed in admin/main/configuration/IO task
- .csv files are placed in the files/common/iofiles directory by Docebo or third-party applications
- Import procedure is made by using cron o another scheduler and calling the doceboCore/tasks.php file
User list import (e.g.. filename users_aaaammdd.csv)
UserId, Password (e.g. “claudio.erba”, “pippo”). It is possible to add many other fields, if they should be handled by dropdown boxes then the fixed values have to be preloaded in the LCMS system. If authentication is managed with systems like LDAP it is not required to import passwords.
Course list import (e.g. filename courses_aaaammdd.csv)
Course code, course name (e.g. “001”, “Math”). It is also possible to add to the .csv file other fields as: complexity, course status, subscription policies, course language, start date, end date, extimated time.
Automatic user-course subscriptions import (e.g. filename AAAMMDDusercourses_data.csv)
UserId, Course code (e.g. “claudio.erba”, “001”). It is also possible to add an optional field that represents the level of the user in the course, if not specified the user will be added as student. 1 Ghost, 2 Guest, 3 Student, 4 Tutor, 5 Mentor, 6 Teacher, 7 Administrator.