Importing guestbook entries from guestbook-free.de
Posted: 01 May 2011, 14:04
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
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