Versions Compared

Old Version 4

changes.mady.by.user Dace Kvalberga

Saved on

compared with

New Version 5

changes.mady.by.user Dace Kvalberga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If some of register files are missing or ,  not recognized or emty, please check our documentation - How to setup Timed events correctly 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
titleData format

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.
 If the parameters are written incorrectly or given the wrong values certain functions will work incorrectly or not be available at all. Any changes made to the parameters after data has been imported will not affect any data. Parameters are only taken into account when data is being imported. So if you need to add or change a parameter or parameter value you need to delete all the data that would be affected by the parameter and re-import the data after the parameters have been adjusted.

To import data follow the step below:     For Flex.bi Cloud users - continue with Source application setup

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



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

  3. After selecting your application the following page will be displayed:



  4. 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:
    1. Object types - OTVc
    2. Customer classes - CCLassVc
    3. Item classes - DIVc 

    5. Select the data types or classes by clicking inside the appropriate Object types, Customer classes and Item classes data input boxes to make a drop down menu appear with the available types and classes, click on the type or class you want to import. Only the types and classes you have selected will be created as additional dimensions.  
    6.  Once all the necessary information has been entered press Import. 

  5. If everything was done correctly the following page will be displayed:


    If you have encountered errors while importing data it is possible that:
    1. You are importing the wrong data for your selected data cube,
    2. The imported data is formatted wrong and your selected Source Application can't read it.