Re: MV3.12 Help with database needed.

[Dirc Evans <dirc@workx.co.uk>]

******    message to minivend-users from Dirc Evans <dirc@workx.co.uk>     ******


Two things to look out for...

1) Make sure your application is exporting prices as pure numbers... I had
a problem with Access in that it added a currency symbol so minivend only
ever returned a price of zero
2) Make sure that the delimeter format is as you defined it in the config
file.


Dirc

At 10:47 16/05/99 -0500, you wrote:
>I am trying to get MV to use a database built on Lotus Approach and
>exported to the PC DOS/OS2 (should I use Windows ascii) format of type.
>I have tried several ways to get it running with the result always being
>that the price field yields only 0.00. I made the price field a
>"calculated" field in Approach and when I exported the file it looks OK
>in any ascii text viewer. Some items have 3 or 4 decimal places, is that
>the problem or is the fact that the field is calculated the problem. If
>I repalce my products.asc with the original simple catalog products.asc
>file everything works fine. I NEED to be able to have the prices
>calculated as that is how I establish the markup on my products. The
>database is way too large to manage by individual item (over 100,000
>items). Also I am wondering about the memory requirements for using MV
>on my machine with a DB of this size. I have it running on the following
>system:
>
>Dual Pentium CPU-166 x586
>Debian Linux Slink dist
>10Gb of drive space
>130mb swap file
>128 mb ram
>
>Running Servers Related to MV
>	MV3.12
>	Apache-ssl
>	WebMin with ShopAdmin modules to manage databases(especially MV)
>
>I ask this because The last time I tried to reload the database the
>entire system crashed and screwed op the filesystem (I rebooted from a
>second Linux drive and rebuilt the server file tree and restored
>everything so no problem there) however This has NEVER happened  before.
>Thanks!
>John
>Attachment Converted: "c:\internet apps\eudora\attach\jfoster.vcf"
>


-
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