How replace Outlook to import contact in Contactviewer ?
(english translation of my french page)
Contactviewer store contacts in a SQLite database. So we need a free software which could import text files and execute SQL scripts.
For that we use TkSQLite. http://reddog.s35.xrea.com/wiki/TkSQLite.html
1) TkSQLite installation
Download Windows version here : http://reddog.s35.xrea.com/sof…qlite-0.5.2-win32-bin.zip
Unzip file, there is no installation. Double-clic on tksqlite.exe to start tksqlite.
2) Build your own contacts list
Download xania-kitcontacts.zip and unzip it in TkSQLite folder
Open contact.csv file with notepad or other text editor and enter contacts, keep header and all colums :
Id;LastName;FirstName;Street_H;PostalCode_H;City_H;Country_H;Phonenumber_H;Street_B;PostalCode_B;City_B;Country_B;Phonenumber_B;Longitude;Latitude
1;Durand;Syvie;1 Place du 11 Novembre 1918;92500;Rueil-Malmaison;France;+330112652345;57 Place de la Boule;92000; Nanterre;France;+330146474647;;
2;Dupond;Marc;1 rue de la Pompe;75001;Paris;France;+330101020304;;;;;;;
3;Delzon;Josianne;6 rue de Pommard;75012;Paris;France;;;;;;+330101020203;;
4;Delrieux;René;;;;;+330199019901;5 rue Saint-Sabin;75011;Paris;France;;;
5;Aupetit;Gilles;;;;;;61 avenue jules quentin;92000;Nanterre;France;+330104568709;;
6;Albiez;;;;Albiez;France;;;;;;;6,341065;45,221052
Id is a sequence number, 1 by 1
LastName is contact name
FirstName is contact firstname
Street_H, PostalCode_H, City_H, Country_H, Phonenumber_H are street name, postal code, city name, country name and home phone number
Street_B, PostalCode_B, City_B, Country_B, Phonenumber_B are street name, postal code, city name, country name and professionnal phone number
It's possible to enter only home address or professionnal address. Name city, name country and name street are mandatory.
Be careful to keep right number of semicolons !
A new possibility : you could indicate geographical data (longitude and latitude) instead of address. In this case city name and name country are mandatory.
3) Contact GoPal creation
Rename contacts_original.db file in contacts.db
Start TkSQLite
- Open… ,choose contacts.db file
- Double-clic on Country table to replace (or add if necessary) the name of the country. To replace double-clic on France and enter your name country
- File/ Import/ Text File…, choose contact.csv file
- Modify options in « Import Text Format » screen
Select Import table
Choose Custom Separator and enter ;
Cocher « First Line is FieldNames »
Clic on « Preview »
Clic on « OK » to start import
- Double-clic Import table to see data
- Open Generer_Contacts.txt file in notepad and copy lines and paste them into TkSQLite « SQL Command » screen
Image
- Do Database/ run SQL
- File/ Close to close TkSQLite application
Then create a Contacts folder in \My Flash Disk and copy in contacts.db file.