Issue 77 - glossword - Search error after using CSV-import

Issue 77:	Search error after using CSV-import	‹ Prev 6 of 44 Next ›
	2 people starred this issue and may be notified of changes.	Back to list

Status:	Accepted
Owner:	----
Type-Defect
Priority-Medium

Reported by dohuutuan, Jul 24, 2008

= What steps will reproduce the problem?
1. running
2.
3.

= What is the expected output? What do you see instead?
Search results, nothing found but that word has in database

= What version of the product are you using? On what operating system?
1.8.10

= Please provide any additional information below.
Before i used version 1.8.7 now i installed 1.8.10 then i copy 
dictionaries into new version. Unfortunelately it doent work. When i 
search a word that has in database but the search result is nothing. 
Please help me. Thank you!

My website http://polodict.com

Comment 1 by PTjugg, Oct 09, 2008

Hi, I have a similar problem (I think)...
I'm a new user and was testing the import mechanism.

After importing my list of terms, I couldn't search them. They appear in the 
database as published, but the search engine doesn't find them.

I think this happens because no keywords are generated for the imported terms, 
whereas if I add them manually glossword generates them for me and eveything works 
fine.

Is this a bug? I think our problem is related so I appreciate if someone could 
help...

Comment 2 by xuhao82, Oct 23, 2008

me too!
version 1.8.11
for test,i install a brand new glossword 1.8.11 with demo term, these can be 
searched.Then I "export" the Example dictionary(as CSV),clean the Example 
dictionay,and "import" again,these demo term can't be searched any more.

Comment 3 by xuhao82, Oct 23, 2008

I have tested the recent releaseed version 1.8.7 - 1.8.11.The search function worked
fine for 1.8.9 and older,just does't work for 1.8.10 and 1.8.11.
Note that this problem is just founded in case "imported" terms.Terms added in
administration section can be searched correctly.

Comment 4 by xuhao82, Oct 23, 2008

Download link for 1.8.9
http://glossword.googlecode.com/files/glossword-1.8.9.zip
or u can change 1.8.9 to 1.8.8,1.8.7...and so on.

Comment 5 by oleg.bolden, Oct 23, 2008

I faced this problem much earlier, but it seems difficult to be solved.
So, I can't upgrade anyway from outdated 1.8.6 version for a quite pretty newer one.
May be from now on the problem will be addressed after all...
Let's donate from all over the world to support Dmitry!

Comment 6 by dmitry.shilnikov, Oct 24, 2008

(No comment was entered for this change.)

Summary: Search error after using CSV-import
Status: Accepted

Comment 7 by xuhao82, Oct 24, 2008

Wooo seemed to be Accepted by dmitry!Hope we can get the new release version as soon 
as possible :)
Good job dmitry , Tx a lot!

Comment 8 by oleg.bolden, Oct 28, 2008

I've found a way to make imported CSV-dictionary searchible.

1) Import CSV-formatted dictionary into Glossword
2) Export dictionary in XML format
3) Clean dictionary in Glossword
4) Import dictionary from previously saved XML-file

That's all

Comment 9 by xuhao82, Oct 28, 2008

I'll try tomorrow!
btw,the erported sql-format can't be searched too,such as CSV-format.Tested in 1.8.10
and 1.8.11.

Comment 10 by PTjugg, Oct 28, 2008

I tested the methodology proposed and it seems to working...
However it would be great if this issue could be resolved in a future version.

Thanks to all!

Comment 11 by efrodi, Dec 16, 2008

It worked fine. THANKS oleg.bolden

Comment 12 by 232515, Jan 02, 2009

I am using Glossword 1.8.11 and had the same problem of terms imported as csv not
being searchable. Exported as xml, cleared dictionary and imported xml as described
above and now the terms are searchable. Thanks oleg.bolden.

Comment 13 by grob109, Jan 03, 2009

Exporting as xml, clearing dictionary and importing xml worked for me. Note that one 
must browse for the file and upload, not copy and paste - assume the text editor I 
was using was causing some errors with the xml.