I spoke with MaryJo offline to get a few more details and told her I
would post the answer in the forum as others may benefit from the
answer.
I asked her two questions, the answer to which I was certain would be
"yes".
1. Did the CSV file come from Excel?
2. Is the problematic field (SEQ-NO) the last field/column in
the Excel file?
There is a bug in Excel where, if you export the data (either CSV or
tab-delimited) and the last field IN ANY RECORD is empty, Excel screws
things up by not putting in enough delimiting characters. So, in a
17-field data file (for example), all of a sudden Excel starts putting
in only enough delimiters to show a 16 field file.
There are two simple work arounds:
1. If your number of records is less than 999, simply open the data file
in FusionPro (FusionPro > Data Definition > Edit Flat File...). Just
open it and save it without doing anything else. Our ilttle utility
automatically fixes the delimiter character issue. But it only handles a
maximum of 999 records.
2. Add another column of data to the Excel file and re-export. Just make
sure that there is a value in every single record. Since it's a dummy
field that you're using to work around the problem, call it "DoNotUse"
and just populate it with the number 1 (or something equally simple).
As long as there aer no records where the last field is empty, the
export will wok fine.
HTH,
Rob
________________________________
Rob Domaschuk
Training and Communications Developer
Avoid in-laws. Marry an orphan.
- Unknown
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable
Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--
