Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Source Files Files
For automated exports / imports
If you are using automated exports / import where files are sent to server by HAL package timed events, you do not have to upload files - they will show in Source files section automatically, just check if they show up in Souce files and are recognized as HansaWorld format. Then move to Source application section below.
If some of register files are missing, not recognized or emty, please check our documentation - Automated export setup with flex.bi provided HAL package.
For manual file export / import - In the flex.bi interface you have to find the tab Source Data > Source Files and upload the register files you prepared previously with "Browse ". If files after upload are recognized as HansaWorld files then you will see the HansaWorld logo appear under each file name. Result table should look like this or similar :
Note | ||
---|---|---|
| ||
If your files is not recognized as a HansaWorld file then: 1. Make sure files are in UTF-8 formatting, which is the HansaWorld export format. Please confirm that the files are the right format by opening the file and finding "UTF-8" in files header. 2. Make sure the file contains any data at all. 3. Try to re-export the data from HansaWorld again and allow some time for the new file to be populated with data, because exporting big files (several megabytes) can cause the files to appear as empty while they are being populated by data or |
Source application (HansaWorld)
Info |
---|
For Flex.bi Private version users - Before you import any data make sure the account parameters settings are correct. Read more about it here - Settings and parameters for new account. |
For Flex.bi Cloud users - continue with Source application setup
- In the flex.bi interface you have to find the tab Source Data > Source Applications and click on the "Add new Source Application" button.
The following page will be displayed: - Select one of the four available applications from which you wish to import your data.
To import HansaWorld data files you just uploaded please choose HANSAWORLD application import. When you click on the application a data window will open requesting that you enter a name for your data cube. You cannot create two or more cubes of the same application type on one account. - After selecting your application the following page will be displayed:
- To import data press the Import button. The following page will be displayed:
In the page you have to select and input the following data:
1. Select the cubes you want to import data for by checking the check-box next to the type of cube needed - Invoices, Financials, Sales Orders, Quotations or CRM or other your account plan is allowed to.
2. Select if you want to import additional sample reports by checking the check-box next to Import sample reports.
3, If you don't want to use Object types, Customer classes and Item classes as additional dimensions in Financials, Sales Orders, Quotations and CRM cubes then proceed to step 6.
4. If you want to use Object types, Customer classes and Item classes as additional dimensions in Financials, Sales Orders, Quotations and CRM cubes then you have to upload the registers that deal with the appropriate data in the Source Files tab of the Source Data page:- Object types - OTVc
- Customer classes - CCLassVc
- Item classes - DIVc
6. Once all the necessary information has been entered press Import.If everything was done correctly the following page will be displayed:
Source application errors
If you have encountered errors while importing data it is possible that imported data is formatted wrong and your selected Source Application can't read it.
You can find most common reported errors with solutions here - Source files import errors
Table of Contents |
---|