ProspectComm Posted March 12, 2012 Share Posted March 12, 2012 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 Quote Link to comment Share on other sites More sharing options...
rpaterick Posted March 12, 2012 Share Posted March 12, 2012 Is it possible to attach the file here? Just a sample of the art/data? Quote Link to comment Share on other sites More sharing options...
ProspectComm Posted March 12, 2012 Author Share Posted March 12, 2012 Files Attached12110 Envelope.zip Quote Link to comment Share on other sites More sharing options...
step Posted March 12, 2012 Share Posted March 12, 2012 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. Quote Link to comment Share on other sites More sharing options...
esmith Posted March 12, 2012 Share Posted March 12, 2012 (edited) 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 March 12, 2012 by esmith ninja'd Quote Link to comment Share on other sites More sharing options...
rpaterick Posted March 12, 2012 Share Posted March 12, 2012 This rule worked: return Field("Newsletter"); Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted March 12, 2012 Share Posted March 12, 2012 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. Quote Link to comment Share on other sites More sharing options...
ProspectComm Posted March 13, 2012 Author Share Posted March 13, 2012 Thank you for all the input, Dan my apologies, I did search, but apparently I didn't use the right word phrasing in my search. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.