Mailing List Archive: Interchange: users

Products from second table not appearing in search results?

Index | Next | Previous | View Threaded

ic at tvcables

Jul 1, 2009, 12:35 PM

Post #1 of 15 (1699 views)
Permalink

Products from second table not appearing in search results?

Hi folks,

I have defined a second products table (products2) in catalog.cfg which
seems fine except that none of the products from this table appear in the
standard search results, does IC only search the default products table? Is
there something else I need to define to tell IC to search the second table
as well?

Thanks,
Andy.

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

gert at 3edge

Jul 1, 2009, 12:45 PM

Post #2 of 15 (1637 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup [mailto:interchange-
> users-bounces [at] icdevgroup] On Behalf Of IC
> Sent: Wednesday, July 01, 2009 10:36 PM
> To: interchange-users [at] icdevgroup
> Subject: [ic] Products from second table not appearing in search
> results?
>
> Hi folks,
>
> I have defined a second products table (products2) in catalog.cfg which
> seems fine except that none of the products from this table appear in
> the
> standard search results, does IC only search the default products
> table? Is
> there something else I need to define to tell IC to search the second
> table
> as well?

Maybe this is what you are looking for:
http://www.interchange.rtfm.info/icdocs/config/ProductFiles.html
http://www.interchange.rtfm.info/icdocs/config/DefaultTables.html

http://www.icdevgroup.org/docs/confs.html#ProductFiles

CU,

Gert

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic at tvcables

Jul 1, 2009, 12:59 PM

Post #3 of 15 (1645 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> > Hi folks,
> >
> > I have defined a second products table (products2) in catalog.cfg which
> > seems fine except that none of the products from this table appear in
> > the
> > standard search results, does IC only search the default products
> > table? Is
> > there something else I need to define to tell IC to search the second
> > table
> > as well?
>
> Maybe this is what you are looking for:
> http://www.interchange.rtfm.info/icdocs/config/ProductFiles.html
> http://www.interchange.rtfm.info/icdocs/config/DefaultTables.html
>
> http://www.icdevgroup.org/docs/confs.html#ProductFiles
>
> CU,
>
> Gert
>

Hi Gert,

I had already read these, DefaultTables is listed as an alias for
ProductFiles, in catalog.cfg I have tried just having the second table, I
can load the skus in flypage ok but nothing in the search results.

I currently have in catalog.cfg:-

ProductFiles products2

Any ideas?

Thanks,
Andy.

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Jul 1, 2009, 1:08 PM

Post #4 of 15 (1640 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

On 07/01/2009 12:59 PM, IC wrote:
>>> Hi folks,
>>>
>>> I have defined a second products table (products2) in catalog.cfg which
>>> seems fine except that none of the products from this table appear in
>>> the
>>> standard search results, does IC only search the default products
>>> table? Is
>>> there something else I need to define to tell IC to search the second
>>> table
>>> as well?
>> Maybe this is what you are looking for:
>> http://www.interchange.rtfm.info/icdocs/config/ProductFiles.html
>> http://www.interchange.rtfm.info/icdocs/config/DefaultTables.html
>>
>> http://www.icdevgroup.org/docs/confs.html#ProductFiles
>>
>> CU,
>>
>> Gert
>>
>
> Hi Gert,
>
> I had already read these, DefaultTables is listed as an alias for
> ProductFiles, in catalog.cfg I have tried just having the second table, I
> can load the skus in flypage ok but nothing in the search results.
>
> I currently have in catalog.cfg:-
>
> ProductFiles products2
>
> Any ideas?

Your search is explicitly set for "fi=products". You can explicitly
change it to "fi=products2" or remove the designation in which case it
will search all tables listed in DefaultTables.

http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_search_file_fi

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic at tvcables

Jul 1, 2009, 1:20 PM

Post #5 of 15 (1645 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> >>>
> >>> I have defined a second products table (products2) in catalog.cfg
> which
> >>> seems fine except that none of the products from this table appear in
> >>> the
> >>> standard search results, does IC only search the default products
> >>> table? Is
> >>> there something else I need to define to tell IC to search the second
> >>> table
> >>> as well?
> >> Maybe this is what you are looking for:
> >> http://www.interchange.rtfm.info/icdocs/config/ProductFiles.html
> >> http://www.interchange.rtfm.info/icdocs/config/DefaultTables.html
> >>
> >> http://www.icdevgroup.org/docs/confs.html#ProductFiles
> >>
> >> CU,
> >>
> >> Gert
> >>
> >
> > Hi Gert,
> >
> > I had already read these, DefaultTables is listed as an alias for
> > ProductFiles, in catalog.cfg I have tried just having the second table,
> I
> > can load the skus in flypage ok but nothing in the search results.
> >
> > I currently have in catalog.cfg:-
> >
> > ProductFiles products2
> >
> > Any ideas?
>
> Your search is explicitly set for "fi=products". You can explicitly
> change it to "fi=products2" or remove the designation in which case it
> will search all tables listed in DefaultTables.
>
> http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_search_f
> ile_fi
>
>
> Peter
>

Hi Peter,

I was referring to the built in search, ie typing in the search box of the
demo catalog, this will not search my products2 table despite me having
set:-

ProductFiles products2
DefaultTables products2

It always returns zero results.

Andy.

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

gert at 3edge

Jul 1, 2009, 1:23 PM

Post #6 of 15 (1646 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup [mailto:interchange-
> users-bounces [at] icdevgroup] On Behalf Of Peter
> Sent: Wednesday, July 01, 2009 11:08 PM
> To: interchange-users [at] icdevgroup
> Subject: Re: [ic] Products from second table not appearing in search
> results?
>
> On 07/01/2009 12:59 PM, IC wrote:
> >>> Hi folks,
> >>>
> >>> I have defined a second products table (products2) in catalog.cfg
> which
> >>> seems fine except that none of the products from this table appear
> in
> >>> the
> >>> standard search results, does IC only search the default products
> >>> table? Is
> >>> there something else I need to define to tell IC to search the
> second
> >>> table
> >>> as well?
> >> Maybe this is what you are looking for:
> >> http://www.interchange.rtfm.info/icdocs/config/ProductFiles.html
> >> http://www.interchange.rtfm.info/icdocs/config/DefaultTables.html
> >>
> >> http://www.icdevgroup.org/docs/confs.html#ProductFiles
> >>
> >> CU,
> >>
> >> Gert
> >>
> >
> > Hi Gert,
> >
> > I had already read these, DefaultTables is listed as an alias for
> > ProductFiles, in catalog.cfg I have tried just having the second
> table, I
> > can load the skus in flypage ok but nothing in the search results.
> >
> > I currently have in catalog.cfg:-
> >
> > ProductFiles products2
> >
> > Any ideas?
>
> Your search is explicitly set for "fi=products". You can explicitly
> change it to "fi=products2" or remove the designation in which case it
> will search all tables listed in DefaultTables.
>
> http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_searc
> h_file_fi

And by doing ProductFiles products2 does that not override the default
'products'?
So should it not be ProductFiles products products2 in the case you add a
second product file?

And perhaps your search is return items from products2 instead of products
...

But probably Peter is right and I really should go to bed :)

CU,

Gert

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic at tvcables

Jul 1, 2009, 1:29 PM

Post #7 of 15 (1641 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> > >>> Hi folks,
> > >>>
> > >>> I have defined a second products table (products2) in catalog.cfg
> > which
> > >>> seems fine except that none of the products from this table appear
> > in
> > >>> the
> > >>> standard search results, does IC only search the default products
> > >>> table? Is
> > >>> there something else I need to define to tell IC to search the
> > second
> > >>> table
> > >>> as well?
> > >> Maybe this is what you are looking for:
> > >> http://www.interchange.rtfm.info/icdocs/config/ProductFiles.html
> > >> http://www.interchange.rtfm.info/icdocs/config/DefaultTables.html
> > >>
> > >> http://www.icdevgroup.org/docs/confs.html#ProductFiles
> > >>
> > >> CU,
> > >>
> > >> Gert
> > >>
> > >
> > > Hi Gert,
> > >
> > > I had already read these, DefaultTables is listed as an alias for
> > > ProductFiles, in catalog.cfg I have tried just having the second
> > table, I
> > > can load the skus in flypage ok but nothing in the search results.
> > >
> > > I currently have in catalog.cfg:-
> > >
> > > ProductFiles products2
> > >
> > > Any ideas?
> >
> > Your search is explicitly set for "fi=products". You can explicitly
> > change it to "fi=products2" or remove the designation in which case it
> > will search all tables listed in DefaultTables.
> >
> > http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_searc
> > h_file_fi
>
> And by doing ProductFiles products2 does that not override the default
> 'products'?
> So should it not be ProductFiles products products2 in the case you add a
> second product file?
>
> And perhaps your search is return items from products2 instead of products
> ...
>
> But probably Peter is right and I really should go to bed :)
>
> CU,
>
> Gert
>

Hi Gert,

Yes it did have both tables but since it wouldn't work I changed it to only
products2, but this still won't work with the default search (small search
component). Looking at the component it does not seem to limit a search to
any table so I cannot see why it doesn't work??

Andy.

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Jul 1, 2009, 2:48 PM

Post #8 of 15 (1637 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

On 07/01/2009 01:20 PM, IC wrote:
>> Your search is explicitly set for "fi=products". You can explicitly
>> change it to "fi=products2" or remove the designation in which case it
>> will search all tables listed in DefaultTables.
>>
>> http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_search_f
>> ile_fi
>>
>>
>> Peter
>>
>
> Hi Peter,
>
> I was referring to the built in search, ie typing in the search box of the
> demo catalog, this will not search my products2 table despite me having
> set:-
>
> ProductFiles products2
> DefaultTables products2
>
> It always returns zero results.

Look in templates/components/search_box_small for mv_search_file.

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic at tvcables

Jul 2, 2009, 1:30 AM

Post #9 of 15 (1640 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> On 07/01/2009 01:20 PM, IC wrote:
> >> Your search is explicitly set for "fi=products". You can explicitly
> >> change it to "fi=products2" or remove the designation in which case it
> >> will search all tables listed in DefaultTables.
> >>
> >>
> http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_search_f
> >> ile_fi
> >>
> >>
> >> Peter
> >>
> >
> > Hi Peter,
> >
> > I was referring to the built in search, ie typing in the search box of
> the
> > demo catalog, this will not search my products2 table despite me having
> > set:-
> >
> > ProductFiles products2
> > DefaultTables products2
> >
> > It always returns zero results.
>
> Look in templates/components/search_box_small for mv_search_file.
>
>
> Peter
>

There is no mv_search_file set in the component, I cannot find anything that
is limiting the search to products, any other suggestions?

Andy.

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Jul 2, 2009, 3:56 AM

Post #10 of 15 (1623 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

On 07/02/2009 01:30 AM, IC wrote:
>
>
>> On 07/01/2009 01:20 PM, IC wrote:
>>>> Your search is explicitly set for "fi=products". You can explicitly
>>>> change it to "fi=products2" or remove the designation in which case it
>>>> will search all tables listed in DefaultTables.
>>>>
>>>>
>> http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_search_f
>>>> ile_fi
>>>>
>>>>
>>>> Peter
>>>>
>>> Hi Peter,
>>>
>>> I was referring to the built in search, ie typing in the search box of
>> the
>>> demo catalog, this will not search my products2 table despite me having
>>> set:-
>>>
>>> ProductFiles products2
>>> DefaultTables products2
>>>
>>> It always returns zero results.
>> Look in templates/components/search_box_small for mv_search_file.
>>
>>
>> Peter
>>
>
> There is no mv_search_file set in the component, I cannot find anything that
> is limiting the search to products, any other suggestions?

Is the variable MV_DEFAULT_SEARCH_TABLE set?

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic at tvcables

Jul 2, 2009, 10:25 AM

Post #11 of 15 (1611 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> >>>> Your search is explicitly set for "fi=products". You can explicitly
> >>>> change it to "fi=products2" or remove the designation in which case
> it
> >>>> will search all tables listed in DefaultTables.
> >>>>
> >>>>
> >>
> http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_search_f
> >>>> ile_fi
> >>>>
> >>>>
> >>>> Peter
> >>>>
> >>> Hi Peter,
> >>>
> >>> I was referring to the built in search, ie typing in the search box of
> >> the
> >>> demo catalog, this will not search my products2 table despite me
> having
> >>> set:-
> >>>
> >>> ProductFiles products2
> >>> DefaultTables products2
> >>>
> >>> It always returns zero results.
> >> Look in templates/components/search_box_small for mv_search_file.
> >>
> >>
> >> Peter
> >>
> >
> > There is no mv_search_file set in the component, I cannot find anything
> that
> > is limiting the search to products, any other suggestions?
>
> Is the variable MV_DEFAULT_SEARCH_TABLE set?
>

Not that I know of, this is a default IC 5.6.0 demo catalog, nothing else
has been changed.

Andy.

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Jul 2, 2009, 1:59 PM

Post #12 of 15 (1611 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

On 07/02/2009 10:25 AM, IC wrote:
>>>>>> Your search is explicitly set for "fi=products". You can explicitly
>>>>>> change it to "fi=products2" or remove the designation in which case
>> it
>>>>>> will search all tables listed in DefaultTables.
>>>>>>
>>>>>>
>> http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_search_f
>>>>>> ile_fi
>>>>>>
>>>>>>
>>>>>> Peter
>>>>>>
>>>>> Hi Peter,
>>>>>
>>>>> I was referring to the built in search, ie typing in the search box of
>>>> the
>>>>> demo catalog, this will not search my products2 table despite me
>> having
>>>>> set:-
>>>>>
>>>>> ProductFiles products2
>>>>> DefaultTables products2
>>>>>
>>>>> It always returns zero results.
>>>> Look in templates/components/search_box_small for mv_search_file.
>>>>
>>>>
>>>> Peter
>>>>
>>> There is no mv_search_file set in the component, I cannot find anything
>> that
>>> is limiting the search to products, any other suggestions?
>> Is the variable MV_DEFAULT_SEARCH_TABLE set?
>>
>
> Not that I know of, this is a default IC 5.6.0 demo catalog, nothing else
> has been changed.

Have a look in etc/catalog_before.cfg

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

gert at 3edge

Jul 3, 2009, 1:30 AM

Post #13 of 15 (1602 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup [mailto:interchange-
> users-bounces [at] icdevgroup] On Behalf Of IC
> Sent: Thursday, July 02, 2009 8:26 PM
> To: interchange-users [at] icdevgroup
> Subject: Re: [ic] Products from second table not appearing in search
> results?
>
> > >>>> Your search is explicitly set for "fi=products". You can
> explicitly
> > >>>> change it to "fi=products2" or remove the designation in which
> case
> > it
> > >>>> will search all tables listed in DefaultTables.
> > >>>>
> > >>>>
> > >>
> >
> http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_searc
> h_f
> > >>>> ile_fi
> > >>>>
> > >>>>
> > >>>> Peter
> > >>>>
> > >>> Hi Peter,
> > >>>
> > >>> I was referring to the built in search, ie typing in the search
> box of
> > >> the
> > >>> demo catalog, this will not search my products2 table despite me
> > having
> > >>> set:-
> > >>>
> > >>> ProductFiles products2
> > >>> DefaultTables products2
> > >>>
> > >>> It always returns zero results.
> > >> Look in templates/components/search_box_small for mv_search_file.
> > >>
> > >>
> > >> Peter
> > >>
> > >
> > > There is no mv_search_file set in the component, I cannot find
> anything
> > that
> > > is limiting the search to products, any other suggestions?
> >
> > Is the variable MV_DEFAULT_SEARCH_TABLE set?
> >
>
> Not that I know of, this is a default IC 5.6.0 demo catalog, nothing
> else
> has been changed.

There is a file in the interchange installation directory, not in your
catalog directory, called
catalog_before.cfg (and a catalog_after.cfg for that matter)

This file contains the following lines:
## Deprecated, could be removed in IC 5.2
Variable MV_DEFAULT_SEARCH_FILE products
Variable MV_DEFAULT_SEARCH_TABLE products

It does not seem too deprecated to me as it is overruling the ProductFiles
directive on catalog level (as you have noticed).

If you have access to the catalog_before.cfg file you can change the line
to:
Variable MV_DEFAULT_SEARCH_TABLE products products2

If you cannot access the Interchange installation configuration files then
alternatively you can add the following line to
templates/components/search_box_small :
<INPUT TYPE=hidden NAME=mv_searchtype VALUE="products,products2">

That should also have the results you are looking for.

All in all quite unclear and something that needs to be looked into, as the
deprecation does not seem to be very clear (not are the catalog_before.cfg
and catalog_after.cfg files imho).

CU,

Gert

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Jul 3, 2009, 3:57 AM

Post #14 of 15 (1595 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

On 07/03/2009 01:30 AM, Gert van der Spoel wrote:
> There is a file in the interchange installation directory, not in your
> catalog directory, called
> catalog_before.cfg (and a catalog_after.cfg for that matter)
>
> This file contains the following lines:
> ## Deprecated, could be removed in IC 5.2
> Variable MV_DEFAULT_SEARCH_FILE products
> Variable MV_DEFAULT_SEARCH_TABLE products
>
> It does not seem too deprecated to me as it is overruling the ProductFiles
> directive on catalog level (as you have noticed).
>
> If you have access to the catalog_before.cfg file you can change the line
> to:
> Variable MV_DEFAULT_SEARCH_TABLE products products2
>
> If you cannot access the Interchange installation configuration files then
> alternatively you can add the following line to
> templates/components/search_box_small :
> <INPUT TYPE=hidden NAME=mv_searchtype VALUE="products,products2">

...or just reset MV_DEFAULT_SEARCH_FILE in your catalog.cfg:
Variable MV_DEFAULT_SEARCH_FILE

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

gert at 3edge

Jul 3, 2009, 4:11 AM

Post #15 of 15 (1602 views)
Permalink

Re: Products from second table not appearing in search results? [In reply to]

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup [mailto:interchange-
> users-bounces [at] icdevgroup] On Behalf Of Peter
> Sent: Friday, July 03, 2009 1:57 PM
> To: interchange-users [at] icdevgroup
> Subject: Re: [ic] Products from second table not appearing in search
> results?
>
> On 07/03/2009 01:30 AM, Gert van der Spoel wrote:
> > There is a file in the interchange installation directory, not in
> your
> > catalog directory, called
> > catalog_before.cfg (and a catalog_after.cfg for that matter)
> >
> > This file contains the following lines:
> > ## Deprecated, could be removed in IC 5.2
> > Variable MV_DEFAULT_SEARCH_FILE products
> > Variable MV_DEFAULT_SEARCH_TABLE products
> >
> > It does not seem too deprecated to me as it is overruling the
> ProductFiles
> > directive on catalog level (as you have noticed).
> >
> > If you have access to the catalog_before.cfg file you can change the
> line
> > to:
> > Variable MV_DEFAULT_SEARCH_TABLE products products2
> >
> > If you cannot access the Interchange installation configuration files
> then
> > alternatively you can add the following line to
> > templates/components/search_box_small :
> > <INPUT TYPE=hidden NAME=mv_searchtype VALUE="products,products2">
>
> ...or just reset MV_DEFAULT_SEARCH_FILE in your catalog.cfg:
> Variable MV_DEFAULT_SEARCH_FILE

Don't think this one works in db searches ... only in textsearches.

CU,

Gert

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads