Glossary Bulk Add

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
Bill Hood
Posts: 1
Joined: Mon Feb 07, 2011 3:38 pm

Glossary Bulk Add

Post by Bill Hood »

I have a glossary of 6,500 industry terms that are needed in my glossary. Obviously, I do not want to add these individually. Is there a way to add them in bulk?
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten »

Hi,

currently not. Which format does your glossary list have?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
mariusswart
Posts: 2
Joined: Tue Feb 07, 2012 7:04 am

Re: Glossary Bulk Add

Post by mariusswart »

Hi,

Did you guys find a way to bulk up load a losy of glossary terms instead of adding them one at a time as I also have a large list I wouldlike to upload.

Marius
jason102178
Posts: 200
Joined: Tue Nov 02, 2010 9:08 am
Location: United States-Ohio
Contact:

Re: Glossary Bulk Add

Post by jason102178 »

No adding bulk glossary is something that is currently not supported, so there is currently no way add them by bulk.
phpMyFAQ Quality Assurance / Forum Moderator
Amazon.com Wishlist
JochenS
Posts: 121
Joined: Wed Feb 16, 2011 3:51 pm
Location: Schönaich
Contact:

Re: Glossary Bulk Add

Post by JochenS »

What about my MS Excel importer? If you know VBA, it should be an easy game to create an SQL importfile for the glossary table. See viewtopic.php?f=2&t=12104&p=35058&hilit=excel#p35058
Our public FAQ is proudly powered by phpMyFAQ: http://vhtfaq.ge51.honeywell.de/
Dawn
Posts: 95
Joined: Tue May 23, 2006 2:10 pm

Re: Glossary Bulk Add

Post by Dawn »

I think this should be possible if you do it directly via the database.
lilbiscuit
Posts: 5
Joined: Thu May 09, 2013 4:43 pm

Re: Glossary Bulk Add

Post by lilbiscuit »

I did add terms (374) to the database (table is "faqglossary") directly.

Works fine EXCEPT there are 25 pages now each containing all the glossary terms. Any thoughts on that ?
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten »

Hi,

which version do you use?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
lilbiscuit
Posts: 5
Joined: Thu May 09, 2013 4:43 pm

Re: Glossary Bulk Add

Post by lilbiscuit »

Hi Thorsten,

Sorry I forgot to mention version: 2.8.0-RC4

-David
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten »

Hi,

when you see 25 pages that's okay because I don't believe you want all glossary entries on one page.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
lilbiscuit
Posts: 5
Joined: Thu May 09, 2013 4:43 pm

Re: Glossary Bulk Add

Post by lilbiscuit »

Thorsten, you misunderstand me.

I have 25 glossary pages with the same words on each page. So....

I have 374 total in my glossay

There are 374 words on page 1
There are the same 374 words on page 2
.
.
.
There are the same 374 words on page 25
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten »

Hi,

ah, now I understand. I'll check it.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
lilbiscuit
Posts: 5
Joined: Thu May 09, 2013 4:43 pm

Re: Glossary Bulk Add

Post by lilbiscuit »

FYI - I made the id "autoincrement" when importing the records.
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten »

Hi,

could you please send me a dump of your faqglossary table to thorsten AT phpmyfaq DOT de? Thanks

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten »

Hi,

it's fixed now: https://github.com/thorsten/phpMyFAQ/co ... cbc21c3f1c

The code for pagination was missing, thanks for the hint.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply