[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
using mvend/bin/update to modify fields
****** message to minivend-users from Ezra Gilbert <EGilbert@cybernex.net> ******
Yes, as you said, all I need to do is "upload a new pricing.asc file twice a day." That is precisely
what I don't want to do. I am looking to automate the process of updateing the products:price fields.
Think how tedious it would be for a person to go through a database of a thousand items changing the
prices of every item - twice a day!
What I need is a script to go through the database making modifications. In mvend/bin i found a script
"update" which is supposed to do precisely that (update a specific field for an item). If I can use that
it would be childs play to write another script to use 'update' to go through all the items in the
database. Unfortunately, every attempt to run 'update' results in the error msg:
>>Can't find executable ('/usr/lib/sendmail') for the SendMailProgram directive
>>
>>In line 0 of the configuration file 'minivend.cfg':
The reason it cant find sendmail is because it's running on FreeBSD and sendmail is in /usr/sbin .
According to all documentation I can define SendMailProgram in catalog.cfg. I have done so, restarted
the Minivend, and still the 'update' script persists to give me that error msg. I tried looking through
all sorts of config files to figure out why it thought sendmail was in /usr/lib (which is the default)
even though I had assigned it to /usr/sbin/sendmail.
If anyone is familiar with mvend/bin/update and has any useful information your assitance would be
greatly appreciated.
Thanks,
Ezra Gilbert
Thompson-Jordan wrote:
> ****** message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com> ******
>
> Seems to me like all you need to do is upload a new pricing.asc file twice
> a day with the price of metals in it and Minivend will take care of the
> rest automatically. Of course you will need to set up your pricing scheme
> correctly.
>
> Christopher Thompson
>
> > -----Original Message-----
> > From: owner-minivend-users@minivend.com
> > [mailto:owner-minivend-users@minivend.com]On Behalf Of Ezra Gilbert
> > Sent: Tuesday, April 20, 1999 9:58 PM
> > To: minivend-users@minivend.com
> > Subject: Re: Script to modify values in database
> >
> >
> > ****** message to minivend-users from Ezra Gilbert
> > <EGilbert@CYBERNEX.NET> ******
> >
> > The problem is I need actually change the value of each item in
> > my database, for instance say this is my products
> > database:
> > products.asc
> > code title weight price
> > 01 gold ring 13
> > (13*value_of_gold) <---- I know i can't put that in a
> > 02 gold necklace 22 (22*value_of_gold)
> > <---- database for the price field,
> > 03 gold pendant 17 (17*value_of_gold)
> > <---- but thats essentialy what i
> > ...
> > <---- need
> >
> >
> > To do what you're saying I'd essentially need a "PriceMultiply"
> > variable set to current value of gold say ... then
> > i'd set my price field in the database to the weight of the
> > item. So every price _would_ be the
> > weight*the_current_value_of_gold.
> >
> > I know it be possible to create a "PriceMultiply" variable in
> > the cfg file but how would I go about getting it to
> > modify the price of an item?
> >
> >
> > This method seems to have some promise but I can see I will run
> > into alot of bumps if I do it this way (different
> > metals have different values so I'd have to split each metal up
> > into its own catalog ... ) If I could write a
> > script that would physically change the price fields that would
> > be the ideal ...
> >
> > Thanks for the info Mike,
> > - Ezra Gilbert
> >
> > "Webmaster of Infothai CM Co., Ltd." wrote:
> >
> > > ****** message to minivend-users from "Webmaster of
> > Infothai CM Co., Ltd." <webmaster@infothai.com> ******
> > >
> > > I did something similar with exchange rates. I used the
> > "#include" functionality
> > > in the catalog configuration file to incorporate the contents
> > of the file. The
> > > file itself contained the exchange rate defined as a Minivend
> > localization
> > > paramter, e.g.:
> > >
> > > Locale en_TH PriceDivide 36.7979
> > >
> > > You could do something similar, or simply define your own variable.
> > >
> > > Whenever the file is updated, the affected catalog(s) must be
> > restarted.
> > > Perl can do this by calling the appropriate catalog restart scripts.
> > >
> > > Regards,
> > >
> > > Mike
> > >
> > > On Tue, 20 Apr 1999 21:21:32 -0400, Ezra Gilbert wrote:
> > >
> > > >****** message to minivend-users from Ezra Gilbert
> > <EGilbert@CYBERNEX.NET> ******
> > > >
> > > >I am working on a jewelry site where the prices are to be
> > based on the current exchange
> > > >rates of gold & silver. These prices are changed twice a
> > day. Basically, the price of
> > > >an item is it's weight(a field in the products database)
> > times the current value of
> > > >whatever metal it is. I have the current values of the
> > metals outputed to files twice a
> > > >day and I was wondering if anyone had any advice on how I
> > should go about modifying the
> > > >database. I use tab delimineted databases.
> > > >
> > > >I was thinking a Perl script should do the job but I am
> > still quite the novice when it
> > > >comes to Perl and am not positive it can do the job. If
> > anyone has ever done anything
> > > >like this or can offer some advice it would be greatly appreciated.
> > > >
> > > >Ezra Gilbert
> > > >
> > > >-
> > > >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
> > > >
> > >
> > >
> > webmaster@infothai.com
> > > http://www.infothai.com
> > >
> > > -
> > > 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
> >
> > -
> > 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
> >
>
> -
> 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
-
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
