[Tip] How import contact in ContactViewer without Outlook
-
- [GoPal bis 3.x]
- medion78
-
-
-
Hi medion78,
I would appreciate it very much (and for sure some more other guys here in the forum without OL) if you could give us a short but comprehensive HowTo where we can reproduce the way of editing (and syncing) the contacts. :top :top
TIA!
-
Hi medion78,
it would give me a great pleasure if you may translate some parts.
Thanks for the link! -
Is the link dead or am I the only one who can not reach the site? :smt012
-
The link is OK.
TeSte
-
I can confirm TeSte. No probs. with the link yesterday and now on different PCs
-
Ok - now it works!
-
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.html1) 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,221052Id 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 numberIt'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 » screenSelect 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 » screenImage
- Do Database/ run SQL
- File/ Close to close TkSQLite applicationThen create a Contacts folder in \My Flash Disk and copy in contacts.db file.
-
Thanks a lot!
I started a new GoPal-WiKi Page:
http://www.wiki.gopal-navigato…x.php?title=ContactViewer to describe that in german in our "Knowledge Base .A amount of assistance by our german Users would be great
*looking around* -
yes german assistance but in english or french , sorry
-
Hallo Zusammen,
habe da ein Excel Makro geschrieben, das aus einer Excel Adress/Telefon Tabelle einen Sql Code generiert. Bei Anwendung des Sql Code mit TkSqLite wird eine Contacts.db für Gopal Navigator 3 erstellt.
Viel Spaß beim testen
NavNie -
Hallo NavNie und Willkommen im Forum
Vielen Dank für dein Tool. Wird bestimmt einigen Usern helfen.
Lade das Tool doch bitte einmal bei uns im Downloadbereich unter Tools hoch, dann können wir das dort einstellen und die User finden es schneller.
Gruß Navirunner
-
Zitat
- Double-clic Import table to see data
- Open Generer_Contacts.txt file in notepad and copy lines and paste them into TkSQLite « SQL Command » screenhello,
i don´t know how do this, please give me a report. the rest is easy and works, but i got a problem with this workstepp!it would be gereat if somebody can help me!
maybe in german -
wenn diese Fehlermeldung, kommt was bedeutet das?
PRIMARY KEY must be unique
insert into 'main'.'Import' values ('20087','Mustermann','Klaus','Speicherstr. 9','18200','Musterhausen','','03333-344308','','','','','0199-2341766','','','',''); -
Das ist eine Fehlermeldung vom Backend der DB: ein eindeutiger Schlüssel (vermutlich die 20087) ist bereits schon mal in der Tabelle vorhanden.
Versuche mal, diesem Satz eine andere ID zu geben, ihn erst zu löschen oder fang mit Deinen Angaben nochmal komplett von vorne an.