Home arrow Forum

Remository Forum

 


cjraven

Karma: 0  
Import terms into Glossary? - 2009/11/01 15:25 Hi all,
Is it possible to import terms into the Glossary as a .csv, XML or in some other format?

Regards & TIA
-Me
  | | Sorry, you do not currently have permission to write here.
admin

Karma: 101  
Re:Import terms into Glossary? - 2009/11/18 17:49 Yes, you can import directly into MySQL from a variety of formats, including csv. Just look at the details of the xxx_glossary table for the field information, and bear in mind that the catid field must point to the id of an entry in xxx_glossaries. Otherwise, there are no special dependencies. Martin Brampton aka Counterpoint
http://aliro.org
http://black-sheep-research.com
  | | Sorry, you do not currently have permission to write here.
unicoart

Karma: 0  
Re:Import terms into Glossary? - 2009/12/16 09:58 i had same problem, than i wrote script for my needs to import words in glossary.

You can find my code here:

http://pastebin.com/f37912925

please note this snippet is for text file that is formatted like this:

word (something.) - definition
or
word - definition

...

if you have your text formatted different it will not work and little modifications will be needed....

Post edited by: unicoart, at: 2009/12/16 10:00
  | | Sorry, you do not currently have permission to write here.
wdooley

Karma: 0  
Re:Import terms into Glossary? - 2011/06/22 22:23 I am having a hard time to get it to upload into the database. I exported the jos_glossary table as an excel file and added the terms and definition and tried importing it back. When I import it back I keep getting an error.

What is the best way to export and import back from excel. I have over 6000 terms I am trying to import.

Or how much will you charge me to import it?

I did try to use the importer php above, but I can't use the "-" as they are in the definition. I tried to change the "-" to a "%" and could not get it to import.

Thanks,
William

Post edited by: wdooley, at: 2011/06/23 00:08
  | | Sorry, you do not currently have permission to write here.

Login

Subscribe to Premium Support

Get priority support for Remository and Glossary, sign up now for a Premium Support monthly subscription:

Your Remository user name

Or purchase a year's support:

Your Remository user name

Recommended SEF

SEF Advance

Who is Online

Remository welcomes guests and visitors

We have 7 guest online