Consultant

scheduling business importer processes on a folder

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?

Thanks community!

6 Replies
Intrepid explorer

Re: scheduling business importer processes on a folder

Hi,

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.



Consultant

Re: scheduling business importer processes on a folder

I will try, but how do you choose the template for update_status.csv?
is the file consumed after the usage or everyday it uses the same file updated?
0 Kudos
Community Manager Community Manager
Community Manager

Re: scheduling business importer processes on a folder

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.

(Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".)
Consultant

Re: scheduling business importer processes on a folder

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

0 Kudos