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!

Edited by esmith
ninja'd
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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...