BG BGDatabase Home Setup How To Use Videos Example Breakdown Fields Export Import Data Binding Events Code Generation Addons

Excel

Main article about Export/Import is here

You can export/import BGDatabase data to/from Excel xls/xlsx format (supported by many programs, including Microsoft Excel, OpenOffice and LibreOffice)

Step 1: Import Excel plugin

Import this plugin

Step 2: Create Excel Datasource

Open BGDatabase window Window->BGDatabase

Select Export/import tab, then Data sources tab, press plus icon, set Datasource type to excel and click on Add button

Choose xls/xlsx file location.

Step 3: Create Export/Import Task

Select Export/Import tab, then Jobs tab, press plus icon, set Job type to excel and click on Add button

Select xls datasource, created in step 2. Include tables/fields you wish to update.

Step 4: Running Export/Import Task

Press Export or Import button to run the task you just created.

[Optionally] After job is finished, open Log tab to see full log of all actions performed. Pay attention to Warning messages (colored red). Every error or unexpected event happened during syncing will be colored red.

Target empty spreadsheet while exporting for the first time. Export job will create necessary sheets/header rows + data for you (more information)

What's next?

  1. Excel/Open Office plug-in docs: link
  2. Export/import overview page: link