topic Re: Search for ?? in filenames in whole repo using webscript in Alfresco Archive

Search for ?? in filenames in whole repo using webscript

svytle — Thu, 19 Mar 2009 22:39:14 GMT

Hi,We have a strange issue which is bothering us. Actually there are some files which were created by the external system. So, Alfresco hosts the files of that external system, which posts the files to Alfresco using web scripts. Since our system is Latin1 and not UTF8, resulted in "??" for any In

Re: Search for ?? in filenames in whole repo using webscript

rogier_oudshoor — Fri, 20 Mar 2009 06:40:16 GMT

The ? is a wildcard in Lucene, just like the *. It will match any 1 character, where the * will match any number of characters.

That being said, i have no clue how to solve your issue. You could potentially crawl your system, simply checking each node in the relevant section of the repository via Java. That will however may cost you (if coded properly) up to 25 ms PER NODE (so 40 nodes per second), so use with caution!

Re: Search for ?? in filenames in whole repo using webscript

lista — Wed, 25 Mar 2009 07:46:40 GMT

Have you tried with a bit more exotic Lucene queries, using Fuzzy or Proximity searches?

http://lucene.apache.org/java/2_1_0/queryparsersyntax.html

Re: Search for ?? in filenames in whole repo using webscript

svytle — Wed, 25 Mar 2009 19:12:42 GMT

Thanks Lista for your suggestion but I couldn't solve the problem. May be I should follow the method suggested by Rogier.
I was trying a web script for folder iteration process instead of java based folder iteration. I will see if this helps!

Re: Search for ?? in filenames in whole repo using webscript

loftux — Thu, 26 Mar 2009 05:01:42 GMT

I just created a new wiki page on how to iterate nodes for mass update purposes
http://wiki.alfresco.com/wiki/Iterate_Nodes
It should be possible to adapt to your needs as well.

Not to go off topic, but any feedback on this way of doing mass updating is the correct way of doing things is appreciated. So far I've only tested this on smaller repositories.

Re: Search for ?? in filenames in whole repo using webscript

svytle — Fri, 27 Mar 2009 18:14:03 GMT

Thanks for the script Loftux. Even I code a similar webscript. I'll let you know once we are done with this update process about the pros and cons.

Re: Search for ?? in filenames in whole repo using webscript

svytle — Fri, 27 Mar 2009 18:14:27 GMT

Thanks for the script Loftux. Even I coded a similar webscript. I'll let you know once we are done with this update process about the pros and cons.