Upload Custmers from existing table

[anna]

I already have a huge list of customers in mySQL database, and I am wandering if I can just upload those instead of manually type them in.
Thank you

[ServiusHack]

Using some SQL or a small script you are able to import your data into Kimai. Take a look at the table kimai_knd, this is where customer data is stored. For group associations see kimai_grp_knd. But Kimai doesn't provide some sort of import functionality. So scripting or doing it by hand are the only possibilities I see.

Best Regards,
Severin Leonhardt

[anna]

Thank you, I appreciate your quick response. I am new to scripting and programming in general. Could you please give me some general example of a script and what file I could put it in. If I am asking too much, could you just lead me to files where I can see some examples.
Thank you

[ServiusHack]

A starting point might a SQL query like

Code:

INSERT INTO kimai_knd ('knd_name') SELECT customer_name FROM old_table

This copies all values in the column customer_name form table old_table into the table kimai_knd in the column knd_name.
Information about the INSERT INTO ... SELECT statement can be found for example at http://www.1keydata.com/sql/sqlinsert.html . If you need more information about this use your preferred search engine.

Also don't forget to add an entry into kimai_grp_knd for each new customer. A spontaneous idea:

Code:

INSERT INTO kimai_grp_knd ('grp_ID', 'knd_ID') SELECT 1, knd_ID FROM kimai_knd

You can execute those queries from a command line client or using something like phpMyAdmin.

I hope this helps you to find out how to do it. And please don't use your production database for testing this.

Best Regards,
Severin Leonhardt

[anna]

Thanks. It helped