How can I make keyword AutoComplete work when a keyword has more than 30 characters?

Question:

I'm using keywords more than 30 characters long and I would very much like to have them displayed in full length in the lookup window and have them auto completed in full as well.

Answer:

By default, the keyword field length in the lookup table is 30 characters long. You can add as many keywords as you want for each reference. But when Biblioscape adds each keyword to a separate lookup table, keyword longer than 30 characters is cut off. To overcome this problem, you can use the DBSYS utility to increase the field length of Keyword field in the lookup table. For most users, 30 characters per keyword is enough. If you have many keywords that are over 30 characters long, you can do the following.

  1. Quit Biblioscape and BiblioWeb.
  2. Run "...\Biblioscape x\Tools\dbsys.exe".
  3. Go to menu command "Utilities | Restructure...".
  4. Click the "Select..." button and go to your Biblioscape database folder. From "Available Tables" list, select table "kw_x" and click the Open button.
  5. On the "Modify table structure..." window, increase "Keyword" field length from 30 to the number you want and click the Save button. Do not make the field length unnecessarily big.
  6. After you have made the changes to the keywords lookup table, quit DBSYS. Run Biblioscape and go to the menu command "File | Database | Update Lookup Index". Biblioscape will re-generate the keywords lookup table with the new field length.

Once you made the Keyword field length big enough, Biblioscape will not cutoff your keyword in lookup display and keyword AutoComplete.

Comments

Re: How can I make keyword AutoComplete work when a keyword has

Paul,

I just followed these instructions because I would like the entirety of 31+ character keywords displayed in 1) the Biblioscape Lookup window and 2) the keyword list on BiblioWeb, but this method didn't make any additional characters visible. I even tested keyword AutoComplete in Biblioscape and that also still suffered from cutoff after 30 characters. Is there a new fix?

Thanks,
Ben

PS: After changing the keyword field length in the kw_x lookup table failed to make more than 30 characters visible, I also changed the keyword field length in the kw_n lookup table, but that didn't help.

Ben, I have just updated the

Ben, I have just updated the instruction. Please run Biblioscape and go to "File | Database | Update Lookup Index" to re-generate the keywords lookup table with the new field length. Thanks, Paul