Re: Why won't SQL products import?

[Ryan Hertz <rhertz@gyb.baits.com>]

******    message to minivend-users from Ryan Hertz <rhertz@gyb.baits.com>     ******

I don't use SQL myself, yet, but I think that there is a [tag] required on
a page somewhere??  Or maybe NoImport is turned on in the minivend.cfg?
(I'm making guesses, I've seen this topic on the list before, try searching
the mailing list from minivend.com)

At 04:11 PM 3/26/99 , Chris Powell wrote:
>******    message to minivend-users from Chris Powell
<helios@brickandivy.com>     ******
>
>Hmmm, this one is really getting me down.  It _used_ to work.
>
>My SQL products database (using Solid) used to interface just fine with 
>Minivend.  I'd add products to the SQL database, and Minivend would 
>properly see them and import them into its products.asc file -- 
>everything would work.
>
>Now, for whatever reason (almost certainly human error on my part) this 
>mechanism is broken.  At some point I must have disturbed a setting in 
>the configuration, because now the products.asc file no longer seems to 
>refresh and get the new products added on the SQL end.  Here are my 
>relevant catalog.cfg lines:
>
>Database            products    products.asc      SQL
>Database            products    DSN               DBI:Solid:upipe 
>SOLIDMTNS
> 
>Database            products  USER xyz
>Database            products  PASS 123
>Database            products  KEY  sku
>Database            products    ChopBlanks     1
>
>Could someone offer a suggestion how I managed to break this 
>funcitonality?  I see nothing in the logs to suggest error conditions.  
>In fact, the Solid logs clearly show Minivend successfully logging into 
>the databse.
>
>How do I get Minivend to properly create/update the products.asc file 
>like it used to?
>
>Best regards,
>Chris Powell
>
>-- 
>Christopher Powell               Brick and Ivy Corporate Consulting
>helios@brickandivy.com                  http://www.brickandivy.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
> 

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