I'm looking for a way to schedule daily or weekly a process created in the business importer, to start and act on xlsx files in a particular folder.
Is there a way to do that?
Any alternative solution?
Jan 11, 2021 09:45 AM
for a daily import I'm using a business adapter on the "Business Importer" tab on a beacon.
The business adapter use always the same input file (e.g. update_status.csv) with a schedule entry. Please correct me if I'm wrong, but for me it was working e.g. to change the status of inventory devices.
Jan 11, 2021 12:37 PM - edited Jan 11, 2021 12:39 PM
One approach to configure a process to import a set of files that are found in a directory would be to write a PowerShell script that invokes MGSBI.exe for each file that is found. Use your preferred task scheduler (such as Microsoft Task Scheduler) to automate execution of the script on an appropriate schedule.
I've attached an example of such a script. This script is not complete or usable as-is: it depends on a range of functions which are not defined in the script. So treat this as an example of a starting point for your own inspiration, not a complete working solution.
Jan 13, 2021 05:19 PM
I'm sorry for the confusion, I was meaning, I have a business adapter studio process ready to run, but I can run it only manually.
Can that process be automated? Thanks and sorry again. Maybe we could change thread title if it's leading to a misunderstanding
Jan 15, 2021 07:30 AM
@marcog - The main Business Adapter Studio application can be launched with Command Line parameters, specifying the name of the XML file you have created. You can then use Windows Task Scheduler to set up your business adapter to run on a scheduled basis.
Additional information can be found in the Flexera Business Adapter Guide and look in Chapter 2 for the command line interface:
Jan 15, 2021 08:46 AM