Still not searching product reference field

[JMK2]

Thanks Bob,

Unfortunately I cannot proceed due to another error which I just posted.

[JMK2]

For some reason I had to rename all my image files in the database and the folder they were in before I could update. Surely that is not a requirement for each update that the images files have to be changed each time.

Anyway, here is the log file results:
Version: 6
Date, Remote host, Customer ID, Buyer ID, Search words
2003/11/15 06:03, 205.206.127.196, 0, 0, "p4p800s"
2003/11/15 06:03, 205.206.127.196, 0, 0, " a7v600 "
2003/11/15 06:04, 205.206.127.196, 0, 0, "a7v600"

This is how they are in the database:
NC-AS-P4P800S
NC-AS-A7V600

[rmladden]

The change is working, but it is acting as if the - is still in the search word character set.
Delete all the .fil files on the server and refresh again (not an update).
I don't understand your other error.

My word character set is:
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'0123456789ŠŒŽšœžŸÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýþÿ

[JMK2]

Ah, looking at the log, now I see what you mean about it working after I had some sleep. I'll go back through everything and give it a try.

Thanks Bob

[JMK2]

Well, it appears to be removing the "-" OK, but it will not return any results at all now, even if I place the entire search string in there (possibly because I removed "-" from the list?).

I've removed those .fil pages and refreshed, and made sure that the "-" is not in the list.

This is the expression that is currently in Search.pm:
$$psSearchString =~ s/(\w*-)+/ /io;



Version: 6
Date, Remote host, Customer ID, Buyer ID, Search words
2003/11/15 06:03, 205.206.127.196, 0, 0, "p4p800s"
2003/11/15 06:03, 205.206.127.196, 0, 0, " a7v600 "
2003/11/15 06:04, 205.206.127.196, 0, 0, "a7v600"
2003/11/15 06:10, 205.206.127.196, 0, 0, "a7v600"
2003/11/15 06:11, 205.206.127.196, 0, 0, "neo tech negative"
2003/11/15 21:54, 64.230.63.187, 0, 0, "solar cells"
2003/11/17 00:16, 205.206.127.196, 0, 0, "a7v600"
2003/11/17 00:16, 205.206.127.196, 0, 0, " a7v600"
2003/11/17 00:17, 205.206.127.196, 0, 0, "kt600"
2003/11/17 00:25, 205.206.127.196, 0, 0, "nimh"
2003/11/17 00:51, 205.206.127.196, 0, 0, "33l5151"
2003/11/17 00:51, 205.206.127.196, 0, 0, "cr ib nb 33l5151"
2003/11/17 00:52, 205.206.127.196, 0, 0, "cr ib nb 33l5151"
2003/11/17 00:52, 205.206.127.196, 0, 0, " cr ib nb 33l5151 "
2003/11/17 00:53, 205.206.127.196, 0, 0, " cr ib nb 33l5151 "

[rmladden]

The l in 33l5151 is going to be another problem. Test with CR-AS-CD-S520 which search should convert to S520.

[JMK2]

Thanks Bob,

This is what we end up with:
2003/11/17 01:34, 205.206.127.196, 0, 0, "cr as cd s520"

But no results

[rmladden]

I don't know what is happening. The perl line is not doing the same thing on your server as on my PC. I tested it with this:
while(1)
{
$line = <STDIN>;
$line =~ s/(\w*-)+/ /io;
print "$line\n";
}


and CR-AS-CD-S520 changes to just S520.

Anyway, since it becomes cr as cd s520 it should still match a product reference CR-AS-CD-S520 because the S520 would be a seperate word without the - in the list. At least that was my theory. We must be close, but it is an ugly hack. We may need some more expert help (Zoltan?).

[rmladden]

Just for fun, try the line
$$psSearchString =~ s/(\w*-)/ /gio;

A minor change in syntax.

[rmladden]

And after that try:
$$psSearchString =~ s/(\S*\-)/ /gio;
Make sure that is a capital S.

[JMK2]

Here's the result of the 1st string suggested:

Version: 6
Date, Remote host, Customer ID, Buyer ID, Search words
2003/11/17 03:19, 205.206.127.196, 0, 0, "cr as crw 5224a"
2003/11/17 03:20, 205.206.127.196, 0, 0, "5224a"

But no reuslts returned either time. I'll try the other now.

[rmladden]

I'm not feeling optimistic.

Even with the - out of the character set, Actinic is still not indexing the segments of your reference string. I think it is still indexing the whole reference as a single word.

That processing is not in code we can modify. Sorry.

[rmladden]

My other thought is that if you have Actinic Business (I do not) is to create a new searchable property. Populate the property with the last segment of the reference. You may need another property with the entire reference. See page 51 of the advanced users guide.

[rmladden]

I hate to give up on these type of things. Anyone have any ideas? How is the word index built? Perhaps it is possible to replace the Actinic generated index with one of your own.

[JMK2]

Thanks Bob,

I was feeling too rotten with the flu bug yesterday so had to put it off till now.

I'm using business here so I can give that a try. The other thing I thought of trying just for fun. Right now I don't get any results from the Product reference field. I'll take aproduct and reverse the desc and prod ref fields and see what happens. It occured to me that perhaps to Prod Ref field is no longer being searched for some reason?