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 » Mon Feb 07, 2011 4:26 pm

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: 15076
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten » Mon Feb 07, 2011 6:51 pm

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 » Thu Feb 09, 2012 2:05 pm

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 » Thu Feb 09, 2012 11:10 pm

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 » Fri Feb 10, 2012 10:25 pm

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 » Thu Feb 16, 2012 1:19 pm

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 » Thu May 09, 2013 4:46 pm

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: 15076
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten » Thu May 09, 2013 5:21 pm

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 » Thu May 09, 2013 9:37 pm

Hi Thorsten,

Sorry I forgot to mention version: 2.8.0-RC4

-David

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

Re: Glossary Bulk Add

Post by Thorsten » Fri May 10, 2013 5:16 am

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 » Fri May 10, 2013 5:39 pm

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: 15076
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten » Fri May 10, 2013 6:29 pm

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 » Fri May 10, 2013 9:14 pm

FYI - I made the id "autoincrement" when importing the records.

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

Re: Glossary Bulk Add

Post by Thorsten » Sat May 11, 2013 8:47 am

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: 15076
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Glossary Bulk Add

Post by Thorsten » Sat May 11, 2013 3:33 pm

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