Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

Re: [mv] product.txt



******    message to minivend-users from "David Bronson" <dbron@roman.net>     ******

Thanks Ed,

Now that I am looking at the updated db, I see some pesky quotes that used
not to be there. Thanks for the help!

David
----- Original Message -----
From: Ed LaFrance <edlafrance@printexusa.com>
To: <minivend-users@minivend.com>
Sent: Thursday, April 27, 2000 11:36 AM
Subject: Re: [mv] product.txt


> ******    message to minivend-users from Ed LaFrance
<edlafrance@printexusa.com>     ******
>
> I have found that EXCEL will put quotes around data is some fields, if it
> believes the data is "text" (instead of numbers or single-word values).  I
> usually strip the quotes out before uploading.
>
> In versions 3 and 4 of minivend there is a catalog.cfg directive for
> databases specifically to handle this quoting issue (this is from the
docs):
>
> EXCEL
>       Microsoft Excel insists on surrounding any exported field that
> contains a comma with quotes, even for TAB-delimited exports. Set the
EXCEL
> attribute to 1 to fix this on import:
>
>           Database products EXCEL 1
>
> This is normally used only with TAB-delimited files.
>
> - Ed L.
>
>
> Printex Marking Technologies
> 12113 Kirkham Rd.
> Poway, CA  92064  U.S.A.
> 858-513-2418
> 800-982-1928
> 858-513-2419 FAX
> http://www.printexusa.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


Search for: Match: Format: Sort by: