Announcement

Collapse
No announcement yet.

Still not searching product reference field

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    #16
    Thanks Bob,

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

    Comment


      #17
      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
      Regards, Tom

      Comment


        #18
        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ŠŒŽšœžŸÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýþÿ
        Bob Ladden

        Comment


          #19
          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
          Regards, Tom

          Comment


            #20
            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 "
            Regards, Tom

            Comment


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

              Comment


                #22
                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
                Regards, Tom

                Comment


                  #23
                  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?).
                  Bob Ladden

                  Comment


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

                    A minor change in syntax.
                    Bob Ladden

                    Comment


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

                      Comment


                        #26
                        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.
                        Regards, Tom

                        Comment


                          #27
                          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.
                          Bob Ladden

                          Comment


                            #28
                            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.
                            Bob Ladden

                            Comment


                              #29
                              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.
                              Bob Ladden

                              Comment


                                #30
                                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?
                                Regards, Tom

                                Comment

                                Working...
                                X