Zikula Community

• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 752

  Posted: Apr 28, 2005 - 09:40 AM

  Hey Guys,
  
  I want to have a block on my site that allows for the searching of specific words and thier definition. Really error codes.
  
  What module would you recommend (that is still being supported) that will query specific categories or words.
  
  example:
  
  Search [__Error 1___] [ALL] <-dropdown* Selected
  [Computer]<-dropdown
  [Phone]<-dropdown
  
  The result would be for all
  Category: Computer
  Error 1 = There is a loose nut behind the keyboard
  
  Category: Phone
  Code Error 1 = Please insert 25 cents to make a call
  
  I have a massive database that will have to be hand inserted 25K words + Definitions so I want to have something that works with future version of Postnuke or that still has some active community. Also it should have it's own search block so it doesn't search postnuke but Postnuke search block should all you to search it too.
  
  I have module"database" installed but I don't think there is any support for it.
  
  What do you guys recommend?
  
  Thanks for any suggestions.

  • 
  •  
• Slugger
  
  

  • Rank: Expert
  • Registered: Mar 11, 2003
  • Last visit: Oct 21, 2009
  • Posts: 1104

  Posted: Apr 28, 2005 - 12:58 PM

  Mark West is working on an update of the old encyclopedia module called pn_Glossary. You might want to check that out.
  
  As for hand entering 25k rows of data...why?
  
  If you have it organized, you can map it to any database.
  
  Slugger

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 822

  Posted: Apr 28, 2005 - 01:01 PM

  Sorry for my ignorance and jumping here, could you explain a bit more what you mean by mapping.?? Could you provide an example?
  
  Regards!

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 752

  Posted: May 05, 2005 - 02:24 AM

  Hey SLugger, it in a PDF right now and I don't know of a way to get it into something useable.
  
  I guess I could copy and paste from the pdf to a text file but then I still wouldn't know how to make it into something a database could read.

  • 
  •  
• Slugger
  
  

  • Rank: Expert
  • Registered: Mar 11, 2003
  • Last visit: Oct 21, 2009
  • Posts: 1104

  Posted: May 06, 2005 - 06:33 AM

  Oops...sorry for not answering. Should have subscribed to this thread.
  
  edfel, what I mean by mapping is taking a data field in one database, lets say name, and setting it to import to another field in another database, lets say nom. Or, you could have field 2 in one database import to field 7 in another. In other words, you're "mapping" where the data will end up.
  
  rixride, is the pdf locked? It's easier to do if it's unlocked.
  
  It's also easier to explain if I know what you are starting with and what you want to do with it but lets look at how you can do it with tools you probably have at hand.
  
  Yes, you can copy from the pdf and paste into a text file for manipulation. If there is little to do, you may be able to complete all manipulation from within the textfile or maybe you'll just get it to the point that you can put it into an Excel spreadsheet where you can use the text functions to do even more.
  
  My company has more sophisticated ways of doing this but every now and then we'll use Excel because it's so easy. But I must give you fair warning. Excel will only handle something around 65 thousand rows of data. Second, you must take care not to let Excel reformat your data which can be bad news if you're working with zip codes, license numbers, etc.
  
  From whatever format you start with, you'll reformat it into a delimited file for import into your database. For example:
  
  Let's say your pdf is set up as a normal address book. You'll be starting with
  
  Bob Smith
  1234 Any Street
  Anytown, Anystate 12345
  (123) 456-7890
  bobsmith@notsowell.com
  www.notsowell.com
  
  or even better,
  
  Name: Bob Smith
  Street: 1234 Any Street
  City: Anytown
  State: Anystate
  Zip: 12345
  Email: bobsmith@xyzfoobar.com
  website: www.xyzfoobar.com
  
  You're going to want to reformat it to
  
  "Bob Smith","1234 Any Street","Anytown, Anystate 12345","bobsmith@xyzfoobar.com","www.xyzfoobar.com"
  
  Your starting from a situation where a group of lines equals a record and each line represents one (or more) field(s).
  
  You'll need to change that to where each line will represent one record and each delimited item will be data for a field. If it has an empty field (ie no email address) it will look like this
  
  "Bob Smith","1234 Any Street","Anytown, Anystate 12345","","www.xyzfoobar.com"
  
  To do this, use logic. Depending upon what you're starting with, it might be very simple to do with a search and replace such as Name: marks the begininning of the first field (replace with ") and Street: marks the end of the first field and the beginning of the second field (replace with ",") and so on.
  
  Or, it may take several steps to get to this
  
  "Bob","Smith","1234 Any Street","Anytown","Anystate","12345","bobsmith@xyzfoobar.com","www.xyzfoobar.com"
  
  For example, using the space in the name field of the first iteration to mark the end of the first name and the start of the last name and the comma in the city state zip field of the first iteration to mark the beginning of the state to mark the end of the city field and the start of the state field which (if abbreviated) is equal to two characters before marking the start of the zip field which may be 5 digits (US) and/or 7 mixed characters (Canada) and/or 10 digits (US Zip Plus 4) etc.
  
  If you want to post some examples of what you're starting with I might be able to give you a more specific plan.
  
  Slugger

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 752

  Posted: Dec 13, 2005 - 10:53 AM

  Anyone have other suggestions for a future proof encyclopedia or database module?
  
  Something with it's own Search Block, so I don't clutter up searches with stuff I don't need.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Dec 15, 2005
  • Posts: 3

  Posted: Dec 13, 2005 - 11:19 AM

  There is an Encyclopedia module available. Encyclopedia 1.0.71x will allow you to build volumes and then add all kinds of additional information. For some reason the image upload feature doesn't work...but everything else seems to operate as advertised.
  
  PN_Glossary module also supports a search function. It also works well, but orders entries based on ID, not alphabeticaly. :(
  
  JBS

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 752

  Posted: Dec 13, 2005 - 05:04 PM

  Hey I was wondering, I think the Knowledge Base Module in Pagesetter make work for this. I just wonder if I can get a block for searching only that publication?
  
  What I am trying to do is make a quick searchable way to find error messages specific to something I am working on.
  There are many category of error messages like
  
  Error
  BSD
  HELP
  
  Etc each category has up to 1000 error definitions.
  
  So i..e
  
  Error
  
  err0001- You have an error
  err0002- You have a bigger error
  err0004- You have a loose nut behind the keyboard, please remove your nuts and.....
  
  etc... So I think I can replicate this in Pagesetter knowledge base but I want to make sure I can have a quick access search block to it from my homepage.
  See example: http://postnuke.pbxinfo.com/
  
  Anyone have an idea if this can be done?

  • 
  •  
•  
•  

Users on-line

• slam

This list is based on users active over the last 60 minutes.