Document toolboxDocument toolbox

Support center for flex.bi version 3.2

Source files (.txt) - uploading in flex.bi

Owned by Dace Kvalberga
Last updated: Aug 16, 2016
2 min read

Source 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 :


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

-----------------------

Expand the lists below to see overview of the specific register names needed/supported for every flex.bi cube:

 HansaWorld Invoice cube registers
  1. Customer Class -  CCLassVc
  2. Item Class - DIVc
  3. Object Class - OTVc
  4. Objects - ObjVc
  5. Customers - CUVc
  6. Items - INVc
  7. Item Groups - ITVc
  8. Invoices - IVVc
  9. Invoice Balances - ArVc
  10. Users - UserVc

  11. Base currency setting - BaseCurBlock

    Item varieties and Item variety groups are not available in Job Costing, CRM and Financials cubes.

  12. Item varieties - VARVc

  13. Item variety groups - VARGVc


 HansaWorld Financials cube
  1. Accounts - AccVc
  2. Objects  - ObjVc
  3. Transactions - TRVc
 HansaWorld CRM cube
  1. Activity Types - ActTypeVc
  2. Projects - PRVc
  3. Activities - ActVc
 HansaWorld Quotations cube
  1. Quotations - QtVc
 HansaWorld Sales Orders cube
  1. Orders - ORVc
 HansaWorld Job Costing cube
  1. Projects - PRVc
  2. Project budget - TBBUVc
 HansaWorld Stock cube
  1. Location - LocationVc
  2. Item status - ItemStatusVc
  3. Item History - ItemHistVc
  4. Location classes - LocClTypeVc
  5. Location types - LocCLVc

Goods Receipt, Stock Depreciation, Stock Movement cubes require that the Stock cube is also imported with locations and the optional  location classes and location types.

 HansaWorld Goods Receipts cube
  1. Goods Receipts - PUVc
  2. Suppliers - VGVc
 HansaWorld Stock Depreciation cube
  1. Stock Depreciation - SDVc
  2. Standard Problems - StandProblemVc

 

  1. Stock Movements - StockMovVc