[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: using mvend/bin/update to modify fields
****** message to minivend-users from Ryan Hertz <rhertz@gyb.baits.com> ******
Try making a symbolic link in /usr/lib/sendmail that points back to
/usr/sbin/sendmail.
At 02:55 PM 4/21/99 , Ezra Gilbert wrote:
>****** 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
>
Ryan Hertz tel 520-645-3812
Webmaster tel 800-645-BAIT
Advertising Director fax 520-645-2588
Gary Yamamoto Custom Baits, Inc. http://www.yamamoto.baits.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
