4 Replies Latest reply on Apr 14, 2016 11:18 AM by dchretien

    "Intelligent" mail barcodes

    megs_pvd

      Title

      "Intelligent" mail barcodes

      Post

      Is there a plug in to generate the USPS barcode in FileMaker 10 Pro or Advanced? I was looking to do this easily with FileMaker, but I haven't found a thing.

       

      Thanks

       

      Meg

        • 1. Re: "Intelligent" mail barcodes
          mrvodka
            

          Hi Meg.

           

          Yes there are a few options. You can use a plugin that will help generate the barcode, or you can install the font. You can just do a search for FileMaker barcode plugin and you should come across many options.

           

          You will want a PostNet barcode.

          • 2. Re: "Intelligent" mail barcodes
            jetblack

            Meg,

            I used FM for years sending USPS bulk mail with postnet bar code. Have you got anywhere with the New USPS Intelligent Bar Code? It is mandatory from the Post Office May 1, 2011.  The calculation I have used in the past is below.  Have you discovered the new calulation that will work with the new Intelegent fonts?

            The formula was--

            If(Substitute(ZipCode; "-"; "") = ""; ""; "\\" & Substitute(ZipCode; "-"; "") &

            If(
            GetAsNumber(
            Middle(Substitute(ZipCode; "-"; "");1;1) +
            Middle(Substitute(ZipCode; "-"; "");2;1) +
            Middle(Substitute(ZipCode; "-"; "");3;1) +
            Middle(Substitute(ZipCode; "-"; "");4;1) +
            Middle(Substitute(ZipCode; "-"; "");5;1) + 
            Middle(Substitute(ZipCode; "-"; "");6;1) +
            Middle(Substitute(ZipCode; "-"; "");7;1) +
            Middle(Substitute(ZipCode; "-"; "");8;1) +
            Middle(Substitute(ZipCode; "-"; "");9;1) +
            Middle(Substitute(ZipCode; "-"; "");10;1) +
            Middle(Substitute(ZipCode; "-"; "");11;1) +
            Middle(Substitute(ZipCode; "-"; "");12;1)) ≤ 9; 10 -

            GetAsNumber(
            Middle(Substitute(ZipCode; "-"; "");1;1) +
            Middle(Substitute(ZipCode; "-"; "");2;1) +
            Middle(Substitute(ZipCode; "-"; "");3;1) +
            Middle(Substitute(ZipCode; "-"; "");4;1) +
            Middle(Substitute(ZipCode; "-"; "");5;1) + 
            Middle(Substitute(ZipCode; "-"; "");6;1) +
            Middle(Substitute(ZipCode; "-"; "");7;1) +
            Middle(Substitute(ZipCode; "-"; "");8;1) +
            Middle(Substitute(ZipCode; "-"; "");9;1) +
            Middle(Substitute(ZipCode; "-"; "");10;1) +
            Middle(Substitute(ZipCode; "-"; "");11;1) +
            Middle(Substitute(ZipCode; "-"; "");12;1));

            If(Mod(GetAsNumber(
            Middle(Substitute(ZipCode; "-"; "");1;1) +
            Middle(Substitute(ZipCode; "-"; "");2;1) +
            Middle(Substitute(ZipCode; "-"; "");3;1) +
            Middle(Substitute(ZipCode; "-"; "");4;1) +
            Middle(Substitute(ZipCode; "-"; "");5;1) + 
            Middle(Substitute(ZipCode; "-"; "");6;1) +
            Middle(Substitute(ZipCode; "-"; "");7;1) +
            Middle(Substitute(ZipCode; "-"; "");8;1) +
            Middle(Substitute(ZipCode; "-"; "");9;1) +
            Middle(Substitute(ZipCode; "-"; "");10;1) +
            Middle(Substitute(ZipCode; "-"; "");11;1) +
            Middle(Substitute(ZipCode; "-"; "");12;1)); 10) < 1; 0; 10 -

            GetAsNumber(Middle(
            GetAsNumber(
            Middle(Substitute(ZipCode; "-"; "");1;1) +
            Middle(Substitute(ZipCode; "-"; "");2;1) +
            Middle(Substitute(ZipCode; "-"; "");3;1) +
            Middle(Substitute(ZipCode; "-"; "");4;1) +
            Middle(Substitute(ZipCode; "-"; "");5;1) + 
            Middle(Substitute(ZipCode; "-"; "");6;1) +
            Middle(Substitute(ZipCode; "-"; "");7;1) +
            Middle(Substitute(ZipCode; "-"; "");8;1) +
            Middle(Substitute(ZipCode; "-"; "");9;1) +
            Middle(Substitute(ZipCode; "-"; "");10;1) +
            Middle(Substitute(ZipCode; "-"; "");11;1) +
            Middle(Substitute(ZipCode; "-"; "");12;1));2;1)))) & "\\")

            • 3. Re: "Intelligent" mail barcodes
              ribs

              Hi Meg - Most USPS Intelligent Mail Barcode solutions requires a Plug-In which I usually avoid. There is a pure FileMaker coded example for sale here:

              http://www.picalo.com/fm/fmpurchase.html

              I have not found any other code, and I've done a lot of looking.

              ri~bs

              • 4. Re: "Intelligent" mail barcodes
                dchretien

                Hi Meg,

                 

                I know this is seven years after you asked, but I have finally managed to generate IM barcodes, but not entirely through Filemaker Pro.  I'm using the USPS XML address validator to validate addresses, and then I'm using their desktop IM Barcode generating application, calling it through AppleScript from within FileMaker Pro.

                 

                The way it works, is you enter the address information into FileMaker Pro.  Then, click a button to validate the address.  (I've not made this automatic at this point because it's hard to tell when someone has finished entering the complete address.)

                 

                When you click the button, it uses the USPS XML address validation system to obtain either a validated address complete with Carrier Route and Delivery Point, or an error message stating why the address could not be validated.  If there is no error, it then uses the information from the validated address in an AppleScript that calls the "USPSIMB Encoder v1.3 Mac" application, which returns the encoded barcode information.  (That system takes the twenty, or so digits that are needed for the barcode, and turns them into a 65 character string that's used for the barcode.  How's that for simplicity?)  In any case, I store the returned string in a field in that record in the FileMaker Pro database.

                 

                I did this on a Mac (obviously), but they have a version of the software for Windows, so you probably can implement something there, as well.

                 

                Now, I have to try to figure out how to handle mail.xml, but that's not looking promising at all...

                 

                --Dennis Chretien