Skip to content

Tag: GINI.POS Wechsel

Export customer data from GINI.POS

To rescue your data from the GINI.POS system, this data must be rescued from the database file. We provide instructions here on how you can rescue customer data, color formulations and loyalty card balances.

Step 1: Find 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 customer data

Execute the following query:

select

t.MandCode,

date_format(t.BIRTH, "%d.%m.%Y") Birthday,

t.NAME1 Surname,

t.NAME2 First name,

if(t.KundeArtID = 1, "Ms", "Mr") Salutation,

t.STREET Street,

t.TOWN City,

t.TCode ZIP,

t.PUNotiz Customer note,

t.Phone Phone,

t.PhonePriv "Private phone",

t.HANDY Mobile number,

date_format(t.AnlageDatum, "%d.%m.%Y") "Customer since",

t.durchKundeID "referred by"

from tbKunde t

Step 4: Import into

Now import the CSV file into Belbo.

Transfer of GINI.POS Data

To save your data from GINI.POS system, you need to recover it from the database file. We provide here instructions on how you can save customer data, color formulas and bonus card balances.

Step 1: Find 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

Execute 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 result generated 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: Import the color formulas - for example in

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