Hoping To Get Help

[Sharon]

I run a rare cancer website for patients, suvivors, and family of rare
adult cancer patients and pediatric cancer patients. Recently my
hosting company updated my account to php5 and I have been fixing and
chasing problems eversince. I have had to upgrade and modify software
to even begin to get myself back to 'square one' and that is, of
course, upsetting my users.

I have been searching everywere to get a 'dictionary' package to
replace the cancer dictionary that I had in place at the time. The
old package could not be upgraded, easily, and it was really out of
date as far as features.

That is why I am here. Glossword, I believe, will do all that I
need. I have it installed and ready to go. My major problem is
bringing my old database into Glossword. I REALLY don't want to have
to do it manually, since I have 5383 word entries. I have the file in
an SQL format, and in an Excel CSV format. All that is there is
record number, term word, and definition. Should be an easy convert
but I am really confused about the format of Glossword dictionary
tables.

I tried to load up just 10 records of my Excel csv file through the
Glossword import, but all of the data, for each record, goes into the
term, term-uri (with record number first), and (I believe) the term
order. Each record is displayed, on a separate line, in large orange
font, on the user display page.

I setup a test dictionary, entered a couple of words, and then
downloaded the files (using phpmyadmin) in csv, Excel csv, and sql
format. I could tell right away that some elements seem to be
assigned 'on the fly' by Glossword. And, it looks like the definition
itself is formatted with xml coding, wrapped around it.

I would love to do an import, since everything will be assigned
properly, but I don't know how I can massage my csv file to import
properly. Can anyone here help me?

Take Care, Sharon
www.rare-cancer.org

[Dmity-Sh]

This document should help:
http://code.google.com/p/glossword/wiki/KB1875151697

[Sharon]

Sorry, Dmitry, I tried to follow that, but it just did not help at
all. There are binary numbers, and term elements that are assigned
when the words are entered. For just the data, I have a table that
looks like this:

1 10 propargyl 10 deazaaminopterin A substance that is being studied
in the treatment of cancer. It belongs to the family of drugs called
folate analogs
2 12-O-tetradecanoylphorbol-13-acetate TPA. A drug that is being
studied in the treatment of hematologic cancer


MySQL dump that looks like this:

INSERT INTO `dictionary` (`id`, `word`, `definition`) VALUES
(1, '10 propargyl 10 deazaaminopterin', 'A substance that is being
studied in the treatment of cancer. It belongs to the family of drugs
called folate analogs'),
(2, '12-O-tetradecanoylphorbol-13-acetate', 'TPA. A drug that is being
studied in the treatment of hematologic cancer'),
(3, '13-cis retinoic acid', 'A drug that is used in the treatment of
acne and psoriasis and is being studied in cancer prevention. It
belongs to the family of drugs called retinoids. Also called
isotretinoin'),

I just don't see any way of importing this data. If anyone else does,
please let me know. I ask that you try to show me examples of
conversion because I am very confused at this point.

Thanks so much for any help you can give me.
Take Care, Sharon
www.rare-cancer.org

[Sharon]

I think I have it Dimitry. I just have to manipulate the csv file to
dump into a txt file properly, adding the ID number and a dash to the
first part of the URI. Then, I need to poke through the code to take
the Glossary name off of the URI for the entries and only offer me one
dictionary (it will be easier for my users). Hopefully I can do this
without any other help. Thank You!

Take Care, Sharon
www.rare-cancer.org

[Sharon Lane]

Nope, Been working at this all day yesterday and all day today and I cannot, for the life of me, get this data massaged in a way that it can be imported. 

 

It should be simple.  I have id#'s, words, definitions, in exactly the same txt format as those that I hand entered, and then exported as a csv file.  I think it has to do with the white space or something that I might not be visually seeing on the original entries when I exported them. I have it in a format that I THINK should work, but the very first word does not work at all. 

 

I am not about to 5,383.  I do like glossword, though. 

Long days, got nowhere.

 

Take Care, Sharon

--
Take Care,  Sharon
www.rare-cancer.org

[elmoch]

> Then, I need to poke through the code to take
> the Glossary name off of the URI for the entries and only offer me one
> dictionary (it will be easier for my users).  Hopefully I can do this
> without any other help.  Thank You!

To show just one dictionary do this:
Go to Control Panel /Dictionaries/Browse > Edit
Under System settings tick Assign this dictionary as main page.
Moreover, you can create your own theme in the back end.

I hope this helps when the rest is OK.

Regards.

[Sharon]

Thanks Emoch. I had already figured that out. Took a little bit to
do that though. LOL

Take Care, Sharon

[Sharon]

I have it figured out, but it was a real trial and error. I have
excel that only allows CSV formatted files to be saved. They kept
causing things to go haywire on import - for every single word, every
single time. Instead of that, I built XLS files, each containing 500
words. Then, I saved them as TXT files. Lastly I had to replace all
quote (") marks out of those text files. Some words had them, some
didn't, but none had them in the original xls file. Once I did that to
each, I could successfully import them. I have about 2000 words
loaded up right now and still going.