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
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.