Conversion from Jambook.. possible?

[bunglehaze]

Hi, I am using jambook on my old version J1.0x site and want to convert across to use Phoca instead, is there an import or conversion utility that will allow a straight conversion? I have over 400 entries so converting each one by hand will be out of the question.

Also have you got any plans to release a module that calls random entries from the guestbook like akobook used to?

cheers

leigh

[Jan]

Hi, there is an entry in feature request list - show last message (so it will be not a problem to add random message...)

There is no conversion utility... you can do it e.g. via phpMyAdmin...

- save your data into sql file
- get the table structure
- edit the data in text editor, that they have the same table structure as Phoca Guestbook has...
- insert these data via SQL query...

but conversion this was is very difficult...

Jan

[bunglehaze]

Thanks Jan, I cant really afford the time to do a complex conversion im afraid. Have you got any guidelines on what would need to be changed?

Also how long would you expect until the random message mod would become available please?

regards

leigh

[Jan]

no idea
no idea

I didn't do anything how to convert data from other product...I don't know the database structure of jambook

Now, I don't have time to do the random message, so the same answer

Jan

[dax702]

bunglehaze, see my latest posts on the subject of importing. I can tell you it can be done and I'm a novice with working with CSV files and PhpMyAdmin. I too started to use Jambook on my 1.0 site so I will be importing my jambook entries into Phoca.

You need to export the table that holds the jambook entries to a csv file. Open this csv file in Calc (openoffice.org) Then you can move columns around, etc. All you have to do is make sure that the columns in your csv file match the fields in the sql structure. It sounds complex, but if I can do it, anyone can