Jump to content

Empty Fields Issue


Recommended Posts

I am having an odd problem as of late. In my data I have a column titled Newsletter with some of the cells with an Astrix in them a most empty. When I choose suppress if empty I get {Newsletter} in the empty fields where data is "missing". This has worked in the past? Any ideas what I may have done incorrectly? It also appears if I compose the job?

 

Rick

Link to comment
Share on other sites

That field is literally not populated for some records. Specifically, 81-95, 560-575, 656 and 657. You need to go into the data and add a trailing comma to the end of those records in order to "populate" the field with no blank.
Link to comment
Share on other sites

The problem is in your data. If you look at record #80 (line 81) for example, the record is missing a comma after the Listname value so FP thinks that the field is missing and throws an "error" in the form of "{Newsletter}".

 

Records that correctly have a trailing comma (or a comma-asterisk) preview/compose fine.

 

EDIT: The Clemson ninja strikes again!

Link to comment
Share on other sites

This is a long-standing issue with Microsoft Excel and how it saves CSV files:

http://google.com/search?q=excel+csv+missing+fields

http://support.microsoft.com/?kbid=77295

 

I'll also remind everyone to please search the forum before posting a new question. If you search for "Excel missing," you will see that this question has come up several times:

http://forums.printable.com/showthread.php?t=707

 

This kind of thing is yet another reason not to use Excel as a database:

http://forums.printable.com/showthre...=5289#post5289

 

However, the workaround in FusionPro is to create a rule with the same name as the field, as rpaterick suggests.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...