[Tip] How import contact in ContactViewer without Outlook

[medion78]

i found a way to enter contacts in Contactviewer for Gopal 3 without Outlook, it's explain in this page, it is in french but if some one needs i can explain here in (bad) english.

[Ralf25]

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!

[Webmaster]

Hi medion78,

it would give me a great pleasure if you may translate some parts.
Thanks for the link!

[GoPalFreak]

Is the link dead or am I the only one who can not reach the site? :smt012

[TeeSteinchen]

The link is OK.

TeSte

[Ralf25]

I can confirm TeSte. No probs. with the link yesterday and now on different PCs

[GoPalFreak]

Ok - now it works!

[medion78]

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/software/...-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.

[GoPalFreak]

Thanks a lot!

I started a new GoPal-WiKi Page:
http://www.wiki.gopal-navigator.de/i...=ContactViewer to describe that in german in our "Knowledge Base .

A amount of assistance by our german Users would be great
*looking around*

[medion78]

yes german assistance but in english or french , sorry