Manual
Import database
The import database function will import a database backup file in "dancer.data" format previously created by the export database function.
The function has to operating modes:
In all data mode it will import all information (i.e. all dancer, configuration and tip data) contained in the backup file. This will usually fail if your database is not empty. Therefore it is recommended to drop and create your database first (but be aware that you will loose all unsaved changes made to your database!) This operation will completely recreate a previous program state. Be aware of the fact that you might need to reset tip and dancer states before you can use the program again.
In only new dancers mode the program will only import new dancer records from the file. "New dancers" are ones that have a barcode number that is not yet present in the database. This function is useful for sharing dancer data between clubs.
In addition, in this mode also club names are imported (only if the dancer has no valid club name) and (new in v2.8) dancers in the local database will be marked as "deleted" if the imported file indicates that status for a dancer.
Possible messages during import: (List incomplete)
insert dancer failed: insert into taenzer (uid,name,nachname,vorname,boy,beau,belle,flags,partner,samesquare,code,isclass,present,locked,mid,level,deleted,club) values ( ...);: 1062: Duplicate entry ... for key 'PRIMARY'
You tried to import "all data" on a non-empty database. This cannot work. Either empty your database first (beware of possible data loss) or use "only new dancers" when calling the import.Dancer inserted.
The dancer was imported to your database correctly.Config import failed, ignored.
You tried to import config settings for properties that were already definied in your database. If you need them, make sure our database is really empty before the import (empty it and do not change anything on the Admin screen).Barcode present, ignored.
On a "only new" import that dancer barcode was already found in your database.All barcodes present, ignored.
On a "only new" import all the multiple barcodes of this dancer were already found in your database.No barcode, cannot insert.
On a "only new" import a dancer without barcode should be imported. This is not supported, the dancer was ignored.
Back to Program functions