Re: INDEX and [area scan

[Craig Oettle <craig_oettle@dynasty.net>]

mikeh@minivend.com wrote:
> 
> ******    message to minivend-users from mikeh@minivend.com     ******
> 
> Quoting Ed LaFrance (edlafrance@printexusa.com):
> > >
> > >I have two small problems.  The first is that [area scan doesn't like
> > >categories such as Diamond 80, it works just fine with Diamond_80.
> > >Apparently is doesn't like spaces in the category names, is there a work
> > >around?
> 
> The FAQ says "when in doubt, quote".
> 
>         [area href=scan
>                         arg="
>                                 di=category
>                                 dl=Diamond 80
>                                 "]
> 
> If you can tell me that doesn't work, then submit a bug report. 8-)

I'm using the demo pages and just changing the category names in the
leftside and products.asc files.  The only way to get the example below
to work is to edit products.asc.8 manually and add "Diamond 80
PHUA08N03201" etc to the file.  I'm not saying it's a bug, I'm saying
it's not building an INDEX (products.asc.category or products.asc.8) and
I didnt' know if it should do it automatically or if I was supposed to
do something to trigger the index build.  I am using MiniMate latest
version to add items to the products database.  

<TR><TD VALIGN=top [var TABLEFG] ALIGN=right width=100%><A HREF="[area
scan
	 di=category
	 df=yes
	 dl=Diamond 80]"><FONT SIZE=2 FACE=ARIAL,HELVETICA
style="text-decoration: none"><B>Diamond
80&nbsp;</FONT></A><BR></TD></TR>
> 
> If you have a database of less than several thousand items, then it is just
> as well to use the plain text search and not bother with indexing.

Right now I don't have many items in the products database, but that
will change soon.

In the manual it says:
If the title field is the fourth column in the products database table,
a file products.asc.4 will be
built, containing two tab-separated fields something like: 

    American Gothic   19-202
    Mona Lisa         00-0011
    Sunflowers        00-342
    The Starry Night  00-343

In the demo catalog "category" is the ninth field if you include "code"
as the first field, but the index in the demo is "products.asc.8" so I
was wondering if I should rename the file "products.asc.9" or if the
"code" field is ignored.  I'm not trying to be difficult just trying to
become more knowledgeable about this powerful program.  I'm sure my lack
of knowledge of perl or any other language is a real handicap.  I
appreciate your help.
> 
> The second is the INDEX for the products.asc.  It says in the
> > >manual that anytime the database is changed it will build a new INDEX
> > >the next time it is accessed.  My system is not building a new index, is
> > >there a way to force it to build a new one?
> 
> One way is to "touch" the file to make sure it imports after
> exporting. You can do that pretty easily with a usertag.
> 
> MV3.14 has a little tag called "index" which can build a bunch of
> different indexes without rebuilding if it isn't necessary.
> 
> [index table=products
>         extension=category
>         spec="
>                                 rf=category,0
>                 ra=yes
>                 tf=category
>                         "
> ]

So you would just put this inside a page?

> 
> Or you can index it yourself with the convoluted:
> 
>         [tag op=flag type=write]products[/tag]
>         [tag touch write]products[/tag]
>         [tag op=log
>                 file=products/products.asc.category
>                 type=text
>                 interpolate=1][loop search="ra=yes/ml=100000/rf=category,0"][loop-code]
> [/loop][/tag]
> 
> Spacing on that little beast must be exactly as above.
> 
> This is one of the first areas I will clean up in MV4. I might
> keep the existing stuff as a UserTag, or I might just nuke it
> as unrecoverable. 8-)
> 
> --
> Mike Heins                          http://www.minivend.com/  ___
>                                     Internet Robotics        |_ _|____
>                                     131 Willow Lane, Floor 2  | ||  _ \
> It's a little-known fact            Oxford, OH  45056         | || |_) |
> that the Y1K problem caused         <mikeh@minivend.com>     |___|  _ <
> the Dark Ages. -- unknown           513.523.7621 FAX 7501        |_| \_\
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-- 
Craig Oettle