Converting easy guestbook to phoca guestbook

[polleke]

Hi Jan,
i now use youre great guestbook component. But i feld sorry for the 80 items in my old guestbook.
So i converted the data from my easy gb (joomla-addons) to phoca gb.
i wrote the conversion in a text-file.
can i upload this some how. If you think others can use it?

regards Jan

[polleke]

or maybe so

How to convert Easy-guestbook (joomla-addons) to Phoca guestbook

Tools:
- Phpmyadmin
- Editor e.g notepad++

Shortly:
!! only use on an empty pocha-guestbook !!
With one guestbook created (id of this gastbook is also the 'catid'

Create a select statement on the easy-gb table select the fieldnames in the order Ph
oca needs them.
insert empty field (with default value).
Start the select and export the sql to file.
Open the file and delete the create paragraph and change the tablename from jos_easy
gb to jos_phocaguestbook_items

Extended explenation:
Open phpmyadmin on your database.
click on the table jos_easygb and click on the SQL button on top of the page.
Now the the following sql-statement appears in the editor.
e.g : SELECT * FROM `jos_easygb` WHERE 1
Now delete the * character and leave the cursor there.
On the right of the editor there is a listbox called "Fields" (Velden)
Now clickon the field "Id" and then on <<
Now the select looks like: SELECT `id` FROM `jos_easygb` WHERE 1
Now alos do that (in this order) with:
- name (will become username)
- email
- homepage
- ip
- content
- date
- published
- id (yes second time, now it will be used for ordering the record.)

select now looks like : SELECT `id``name``email``homepage``ip``content``date``publis
hed``id` FROM `jos_easygb` WHERE 1
now seperate the fiels with ,
so the select looks like:
SELECT `id`,`name`,`email`,`homepage`,`ip`,`content`,`date`,`published`,`id` FROM `j
os_easygb` WHERE 1

These are the fields both components use.
Now add the extra fields from Poch guestbook. You have to do that in the editor.
after 'id'
- catid value=1 (or the value of your phoca guestbook. if you have only it is 1.
You cab look in the table: jos_phocaguestbook_books what is under field : Id)
- sid value=0
after 'name'
- userid value=0
after 'ip'
- title value='' (or youre own title)
after 'published'
- checked-out value=0
- checked_out_tim value = '0000-00-00 00:00:00'
after 'id'
- ordering value=''
Mind there are some fields between '' and some not!!!

Now the select looks like this:
SELECT `id`,1,0,`name`,0,`email`,`homepage`,`ip`,'',`content`,`date`,`published`,0,'
0000-00-00 00:00:00',`id`,'' FROM `jos_easygb` WHERE 1

Now click on start.

The datascreen appears. below you will find the button/link 'Export'
Use it.
Now choose for sql
give it filename and send.
Now the file is on your locale disk.
open it with the editor (i use notepad++ )
delete the create paragraph
Change and replace the file from
INSERT INTO `jos_easygb` VALUES
into
INSERT INTO `jos_phocaguestbook_items` VALUES
and save the file.
Now you have the importscript for then phocguestbook table.
Select alle lines and copy them (CTRL+a and CTRL+c)

Now in PHPMYADMIN click on the table jos_phocaguestbook_items en then click on the S
QL link/button in the top menu.
Clean the editorscreen and paste the selected insert-items and click on start.

Now all the items are in the new table.
If you want you now can edit records for personalising.


(c) 2008 Jan Broos
www.broos.org
testing on www.broos.org/joomla15

[Jan]

Great, please send me the file to info[at]phoca[dot]cz, I will paste it into a download page

Jan

[Jan]

Hi, thank you for this guide.

Jan