Skip to main content
  Friday, June 15 2012
  2 Replies
  3.3K Visits
  Subscribe
Hello, i post here some instructions to convert terms from com_glossary to seoo glossary
Use these carefully and always keep backups

1. Open phpmyadmin
2. go to jos_glossary table and click on the SQL tab
3. paste this in the sql query
SELECT `id`,`published`,`checked_out`,`tdate`,`tterm`,`tfirst`,`tdefinition`,`tname`,`tmail`,`tcomment`,`tedit`,`catid`
FROM `jos_glossary` WHERE 1

4. Press the Go button, you can see now the results.
5. scroll down to the Query results operations and click in the Export link
6. in the new window in the Export type choose INSERT and uncheck the Structure option. Press the Go button and download the sql file
7. Open the downloaded sql file with a good text editor (Notepad++, gedit, komodo)
find the lines
INSERT INTO `jos_glossary` (`id`, `published`, `checked_out`, `tdate`, `tterm`, `tfirst`, `tdefinition`,
`tname`, `tmail`, `tcomment`, `tedit`, `catid`) VALUES

PROBABLY IT WILL BE MORE THAN 1 TIME in the sql file
and make them like this
INSERT INTO `j25_seoglossary` (`id`, `state`, `checked_out`, `checked_out_time`, `tterm`, `tfirst`, `tdefinition`, `tname`, `tmail`,
`tcomment`, `tedit`, `catid`) VALUES

8. Save the sql file and go back to phpmyadmin and import it

Please first of all make backups. Second pay attention in the prefix (mine was jos_ and j25_)
To the mods: sorry for my english. Please feel free to edit this post and spell check it
Thanks
H
11 years ago
·
#327
Hi corpus,

can you please explain more precise what it does?

Thank you!
A
11 years ago
·
#328
Hello
in joomla 1.5.x i used the following glossary component
http://extensions.joomla.org/extensions/directory-a-documentation/glossary/143?qh=YToyOntpOjA7czo4OiJnbG9zc2FyeSI7aToxO3M6MTA6Imdsb3NzYXJpZXMiO30%3D
the steps described above is the way you can migrate the terms from this old component to the new SEO glossary
  • Page :
  • 1
There are no replies made for this post yet.