Transfer of GINI.POS Data

To save your data from the GINI.POS system, this data must be saved from the database file. We provide instructions here on how you can save customer data, color formulas and bonus card balances.

Step 1: Finding the MDB file.

Find the MDB file in your GINI.POS installation. The file has an MDB file extension and stands for Microsoft Access Database.

Step 2: Opening the MDB file

Open the MDB file in an MDB tool. This can be, for example, OpenOffice (Windows only) or a paid tool.

Step 3: Export of color formulas

Run the following query:

select c.MandCode, k.Notiz, k.AnlageDatum, f.Notiz, f.Notiz1 from tbColorationFarben f

join tbColorationKopf k on k.MandCode=f.ColorationKopfID

join tbKunde c on c.MandCode=k.KundeID

The resulting data must then be exported. You have the option here to export the results directly to Excel or to process them further in another tool.

Step 4: Importing the color formulas - for example in Belbo

Then import the saved Excel file in "Settings" -> "Import Center" -> "Formulas".