If you set up automatic periodic export of data from HansaWorld you might want to automatically import them into you BIyour flex.bi account. To do that you need to do three things:
Create a folder for the files to be imported from
Ensure that the export files are placed in that folder (by any means available to you)
- Change configuration of the BI flex.bi to start checking those folders
...
You need to create one folder import in the root folder of the BI flex.bi server. This folder then will contain a folder for each BI flex.bi account you want to perform the automatic import. I.e. you might want to keep some accounts not up to date (historical data) and update others. This is why you need to create a folder for each of the accounts you want to automatically update. Name of each of these folders is the ID of that account. You can find out the ID of an account by looking at the URL when you open that account in the browser.
For example if you see a URL in your browser:
Code Block |
---|
httphttps://standardflex.bi/bi/accounts/12/source_data#source_files |
...
There are various ways how to move files from HansaWorld server to the BI flex.bi server and you should consult you IT staff for the best one available for you. Usually this will be done using either an FTP or SFTP server, mounting a folder as a network file system and then moving the files around with a shell or bash script.
Tip |
---|
The regularity of the file movements should be aligned with how often they are being exported from HansaWorld. |
Changing
...
flex.bi configuration
Finally you need to instruct the BI flex.bi server to check the created folder for data files to import. You can do this by editing configuration file:
Code Block |
---|
config/torquebox/eazybi_private-knob.ymltoml |
You need to add a new or modify the existing configuration block with contents to run every X minutes:
Code Block |
---|
jobs: start_automatic_file_import: job: SourceFile::StartAutomaticImport # execute every 30 minutes cron: # Add custom regular jobs and specify frequency in "every" or "cron" parameter [[regular_jobs]] job = "SourceFile::AutomaticImporter.start_automatic_file_import" # every = "15m" cron = "*/15 * * * * ?" description: "Start automatic source file import" |
Note |
---|
Make sure you get the indenting right and restart the eazybi flex.bi server for the changes to be applied. |
...