To expand upon the below fixes, you can also do the following in a text
editor.
Find/replace function, making sure that "regular expression" is selected. A
typical CSV file is comma double quote format. (Ex: "Name","Address","")
Where the 2 double quotes with no data between them would be an empty
field. The described problem would like ("Name","Address",) instead of
("Name","Address","") To fix this in a text editor look for (,\n) and
replace with (,""\n) The \n is the return character to go to thye next line
or in our case, next record. I'm sure that a large portion of users that
work with the data already know this, but hopefully this can help others
who do not.
I didn't mean to hijack Rob's response, but the more ways to fix a problem
the better.
Carl
"Rob Domaschuk"
<[EMAIL PROTECTED]
able.com> To
"FusionPro Users Forum"
06/16/2008 01:54 <[email protected]>
PM cc
Subject
Please respond to [fusionpro] RE: Instance data
"FusionPro Users
Forum"
<[EMAIL PROTECTED]
printable.com>
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
--
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
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
--
