Translate a site via database dump - searchable words?

Next topic

Author	Message
Zoltan Szabo	Thursday 06 November 2003 10:45:31 am I would like to ask one of my friends to translate my website (eZp 3.2). He don't has cheap internet-access, so that was my idea: I create a "translation" of the nodes (in the admin interface), and I put a QQQ (or something unique) before every sentence to be translated. Then I send the database dump to my friend, he searches for QQQ-s, makes the translation, and finally I fill back the database. The problem is that the ezsearch_word table won't be filled this way. I tried to modify some words after this "reload" - in hope that the system will recognize some new words - but there was no change in the ezsearch_word table. What is the way to make eZp to generate records in ezsearch_word? (I tried to examine kernel/search/plugins/ezsearchengine/ezsearchengine.php, but I couldn't find out, how it works. array_diff( $indexArrayOnlyWords, $existingWordArray) must be some important moment, but why was not I able to make it generate new records...?)
Marco Zinn	Thursday 06 November 2003 1:18:37 pm Hi Zoltan, there is a php script in the distribution called updatesearchindex.php (in update/common/scripts). I think, when you run this script from your ezpublish document root folder, it should re-index all objects. Marco http://www.hyperroad-design.com

Author

Message

Thursday 06 November 2003 10:45:31 am

I would like to ask one of my friends to translate my website (eZp 3.2). He don't has cheap internet-access, so that was my idea: I create a "translation" of the nodes (in the admin interface), and I put a QQQ (or something unique) before every sentence to be translated. Then I send the database dump to my friend, he searches for QQQ-s, makes the translation, and finally I fill back the database.

The problem is that the ezsearch_word table won't be filled this way. I tried to modify some words after this "reload" - in hope that the system will recognize some new words - but there was no change in the ezsearch_word table.

What is the way to make eZp to generate records in ezsearch_word?

(I tried to examine kernel/search/plugins/ezsearchengine/ezsearchengine.php, but I couldn't find out, how it works. array_diff( $indexArrayOnlyWords, $existingWordArray) must be some important moment, but why was not I able to make it generate new records...?)

Marco Zinn

Thursday 06 November 2003 1:18:37 pm

Hi Zoltan,

there is a php script in the distribution called updatesearchindex.php (in update/common/scripts). I think, when you run this script from your ezpublish document root folder, it should re-index all objects.

Marco
http://www.hyperroad-design.com

eZ debug

Timing:	Jan 31 2025 01:28:53
Script start
Timing:	Jan 31 2025 01:28:53
Module start 'layout'
Timing:	Jan 31 2025 01:28:53
Module start 'content'
Timing:	Jan 31 2025 01:28:53
Module end 'content'
Timing:	Jan 31 2025 01:28:53
Script end

Main resources:

Total runtime	0.0255 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	588.2578	151.2266
Module start 'layout'	0.0055	0.0046	739.4844	220.7344
Module start 'content'	0.0101	0.0135	960.2188	997.7109
Module end 'content'	0.0236	0.0019	1,957.9297	29.9922
Script end	0.0255		1,987.9219

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	12.6860	14	0.0002
Check MTime	0.0015	5.9077	14	0.0001
Mysql Total
Database connection	0.0008	3.0515	1	0.0008
Mysqli_queries	0.0030	11.7520	3	0.0010
Looping result	0.0000	0.0738	1	0.0000
Template Total	0.0014	5.6	1	0.0014
Template load	0.0012	4.6664	1	0.0012
Template processing	0.0002	0.8743	1	0.0002
Override
Cache load	0.0009	3.4783	1	0.0009
General
dbfile	0.0003	1.0919	8	0.0000
String conversion	0.0000	0.0271	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs