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 formulas and loyalty 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 customer data
Execute the following query:
select
t.MandCode,
date_format(t.BIRTH, "%d.%m.%Y") Birthday,
t.NAME1 Last name,
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 Belbo
Now import the CSV file into Belbo.