Schedule import excel file to load data

0
Hi everyone, I'm working with .xlsx files to populate my Mendix Database, and i'm wondering if there is a way to schedule import with Excel Importer. For example, trigger an import every day at 2a.m. or something like that. Maybe there is a better tool than Excel Importer in order to do that, I can also use .csv files.   Thanks for reading, have a nice day ! Pierre Welmant
asked
1 answers
1

With the scheduled event functionality of Mendix you can trigger microflows at a certain point in time (and repeat it). 

Since you want to import excel files you need a location where these files will be stored (e.g. a SFTP server or as a file in Mendix) allowing you to automatically retrieve the files. With the scheduled event you can retrieve the files and process them via the Excel importer microflows.

answered