[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
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
