Mapping

Using Dynamic Maps in Microsoft BizTalk

Using maps in a Microsoft BizTalk orchestration is pretty straightforward – create your source and destination schemas, map from one to the other, drop a Transform shape onto your orchestration, and configure the source and destination messages. But what if you need to apply different maps based on some property inside the message, or even who the message is coming from? In our case, we process X12 837 healthcare claim files. In the X12 schemas, the same piece of information can be stored in different ......

Android–Finding your SDK debug certificate MD5 fingerprint using Keytool

I recently upgraded to a new development machine, which means the certificate used to sign my applications during debug changed. Under most circumstances you’ll never notice a difference, but if you’re developing apps using Google’s Maps API you’ll find that your old API key no longer works with the new certificate fingerprint. Google's instructions walk you through retrieving the MD5 fingerprint of your SDK debug certificate - the certificate that you’re probably signing your apps with before publishing, ......

BizTalk–Mapping repeating EDI segments using a Table Looping functoid

BizTalk’s HIPAA X12 schemas have several repeating date/time segments in them, where the XML winds up looking something like this: <DTM_StatementDate> <DTM01_DateTimeQualifier... <DTM02_ClaimDate>2012... </DTM_StatementDate> <DTM_StatementDate> <DTM01_DateTimeQualifier... <DTM02_ClaimDate>2012... </DTM_StatementDate> The corresponding ......

BizTalk: Using the Flat File Mapping Wizard to map a NACHA financial file

If you've ever had to work with any financial ACH transactions (Automated Clearing House, think direct deposit...) then chances are you've run into a NACHA file. These are flat, positional files composed of repeating 94 character records. The basic structure looks like this: File Header Record Batch Header Record Entry Detail Record Entry Detail Record Entry Detail Addenda Record (optional) Batch Control Total Batch Header Record Entry Detail Record Batch Control Total File Control Record Notice ......

Geocoding with the Yahoo Geocoding API

Yahoo provides their Geocoding Web Service to allow you to find specific latitude and longitude for an address; it's also useful for cleaning addresses where you're not sure of the exact zip code, spelling of the street, etc. There are actually two web services - the orginal Yahoo Maps Web Service, and the new PlaceFinder service. The original web service has been deprecated, but that's what I'll be demonstrating today; the next post will be about the new PlaceFinder service. The first step is to ......