DBBM, import/export data to mobile SQLite file

DBBM, Importing data from the SQLite database

1. Data source - Select as „Data source“ manual entry in the next window click "Select" and browse the PC archive data that was sent in SQLITE format.  
2. Target database - Select where the data is to be imported, usually „p3g_data“ or „palstat_data“
3. Parameters - Select:
   • Transfer data
   • Erase - This option deletes the existing data in the target database
4. Table selection - After selecting „Data source“, the available tables contained in the submitted archive are displayed. Select all
5. Start-up - After setting the transer up, click „Start“
6. Result - After starting the conversion, results can be monitored.

DBBM, Exporting data to the SQLite database

1. Data source - Select the database to which the data is to be exported.
2. Target database - Select "Manual entry" and switch to "SQLite" then "New" on the PC create a file to which the data is to be exported.
3. Parameters - Select:
   • Transfer data
   • Erase- This option deletes the existing data in the target file
4. Table selection- After selecting „Data source“ the available tables contained in the submitted archive are displayed. Select the required tables. 
5. Start-up - After setting the transfer up, click „Start“
6. Result - After starting the conversion, results can be monitored.

Caution: incorrect usage of the program may cause data loss. Before using the program backup databases and close PALSTAT applications on all workstations.

- Run program ./apl/dbbm.exe Login je: ADMIN / PalStaT123