Importing guestbook entries from guestbook-free.de

[bkleine]

Hi,

I would like to share with you my experience when I exported an guestbook from guestbook-free.de and imported it into phoca-guestbook.

on the administrator page of guestbook-free.de I found entries in the following format:

Eintrag vom: 07.02.2011 um 23:24 Uhr
Name: name
IP: 192.168.1.1
homesite: www.mydomain.de
Email: name@gmx.de
Hallo, Mein...

These I took and removed everything disposable:
07.02.2011 23:24
name
192.168.1.1
www.mydomain.de
name@gmx.de
Hallo, Mein...

All entries were entered into a spreadsheet, horizontally which gave about 100 columns. I then transposed the spreadsheet and had 100 rows. Since not all entries had all lines, I had to check that email addresses and ip adress were correctly lined up and had to enter empty cells when necessary. Since the date format was not correct I used cell formatting and obtained the correct format jjjj-mm-dd hr:min.

The first row contained the column titles:
date, user, ip, homesite, email, content
I added an other column: catid and filled the cells with "1" which is the entry of my guestbook in #_phocaguestbook_books and which every entry in #_phocaguestbook_item refers to.

I added a new column "ordering" and labeled the entries from 1 to 100 in the order of the original export.

I should have entered another column "published" and filled that with "1", too. I would have save me handediting later on.

I save the spreadsheet as CSV using | as delimiter and ' as textdelimiter.

Using the phpmyadmin-interface for 1&1 I imported that table. Field Separator: |, Text delimiter: ' and listed the columns:
date, user, ip, homesite, email, content, catid, ordering, published

After importing, I removed the line with the column titles and found the entries in the guestbook.

Hope this helps!

Bernhard

[Jan]

Hi, thank you very much for your guide.

Jan