Thanks Spencer. I do see the leading zeros when I open the file in Notepad and in Excel so I do know they're there and of course the million dollar question we will never have answered is "Why?" When I import the .csv into FusionPro without opening up the file in Excel those zeros are missing. I also tried Rob's suggestion this morning of importing a .txt file instead and that did not work either. My concern about using the leading zeros JavaScript rule is that not every field needs a leading zero. If I set it up so that the leading zero is added to each record, my barcodes will be incorrect.
It might just be my inexperience with using this rule in a Desktop template so here is a question for all forum members: When composing a template that will be mailed and barcoded what type of data file do you import? When your datafile consists of both Zip Codes that begin with leading zeros and those that do not how do you get those leading zeros to still appear as part of your barcode? This has completely baffled me! Lisa Brooks Brooks Litho & Digital Group -----Original Message----- From: Spencer Whetstone [mailto:[EMAIL PROTECTED] Subject: Leading Zeros dropping out of PostNet Barcode Rule When you save a file with leading zeros as a text file - either .CSV or .txt the leading zeros ARE there. But in one of those Heisenberg Uncertainty Principle moments, the act of observation distorts the result. When you open the .CSV or.TXT files with Excel, you will lose the leading zeros and you will think that you have lost your mind. If you open the data file with Notepad or other text editor you can verify that your zeros are indeed there. You could keep a copy of the data in .XLS format to preserve the leading zeros and regenerate the .CSV as needed. There is a built-in rule for padding fields with leading zeros. In JavaScript it looks like this: Var1="Zip"; LeadingZero="00000"; return FormatNumber(LeadingZero, Field(Var1)); Spencer Whetstone -----Original Message----- From: Lisa Brooks [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 12:02 PM To: FusionPro Users Forum Subject: [fusionpro] RE: Leading Zeros dropping out of PostNet Barcode Rule Rob, Still no good. The Tab delimited file drops out the leading zero as well. Any other thoughts/suggestions? Lisa Brooks Brooks Litho & Digital Group -----Original Message----- From: Rob Domaschuk [mailto:[EMAIL PROTECTED] Subject: [fusionpro] RE: Leading Zeros dropping out of PostNet Barcode Rule Hey Lisa, Are the zeros definitely in the data? I know Excel has an issue with leading zeros. What happens if you convert it to a tab-delimeted text file and run it again? Rob -----Original Message----- From: Lisa Brooks [mailto:[EMAIL PROTECTED] Subject: [fusionpro] Leading Zeros dropping out of PostNet Barcode Rule Hi all, Has anyone experienced an issue with the leading zeros dropping out when using the PostNet Barcode rule? I tried formatting all cells in my .csv file to text but that doesn't seem to solve the problem.. Lisa Brooks Brooks Litho & Digital Group +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Calling all FP Web Users! Do you have a question or lots of knowledge to share about FusionPro Web? If so, join our Printable Web to Print Users' Forum today! Send email to [EMAIL PROTECTED] to find out how! +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Calling all FP Web Users! Do you have a question or lots of knowledge to share about FusionPro Web? If so, join our Printable Web to Print Users' Forum today! Send email to [EMAIL PROTECTED] to find out how! +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- 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 -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Calling all FP Web Users! Do you have a question or lots of knowledge to share about FusionPro Web? If so, join our Printable Web to Print Users' Forum today! Send email to [EMAIL PROTECTED] to find out how! +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- 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 -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Calling all FP Web Users! Do you have a question or lots of knowledge to share about FusionPro Web? If so, join our Printable Web to Print Users' Forum today! Send email to [EMAIL PROTECTED] to find out how! +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- 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 --
