Monday, May 12, 2014

UPDATE: Enhancement to EDI 852 Tool to CSV

The SDQ limitation has been lifted. The ZA02 (quantity), ZA03 (UOM), and N9*ST (location) will also be mapped to the CSV when present. Go to this page to convert an EDI 852 to CSV,

See more.

Tuesday, March 18, 2014

Convert an EDI 816 to Excel CSV File

Jobisez created another translation tool.  This new tool converts an EDI 816 to CSV file.  The Organization Relationship transaction set is sent by the retailers, and it contains store location information.

The EDI 816 typically contains Store Name, Duns or GLN number, Address, City, State Zip and Country.  It may also contain Contact Name, Phone, Fax and Email Address.  As well as Effective, Opening and Closing Dates of that Store.

If you do not have a Jobisez account, you can create an account for free.  Then visit the 816 Conversion page.  If you are already signed onto Jobisez, you can "Browse" for an EDI 816 transaction set on your computer and create an Excel file by clicking "Create CSV". Then wait a couple of moments and your initial and translated files will be emailed to you. Upon the receipt of the email, you can then open the CSV file attachment using Excel. Within Excel you can then analyze the Organization Relationships data using the Excel tools you are already familiar with. Please verify that the data generated is correct. (Currently only works with one 'ISA' interchange. The EDI data cannot be more than 250 KCs.)

Visit this page to learn more about the EDI 816 transaction set.

Please respond to this blog post with any questions you may have.

Thank you.

Sunday, February 9, 2014

More Upgrades to the to the EDI 852 to Excel Tool

Jobisez has added some additional improvements to the EDI 852 conversion to CSV tool.  See the "Improvements to the EDI 852 to Excel Tool" for previous upgrades.

As of February 9, 2014, the Tool also captures the CTP Pricing elements and the Pack and Inner-Pack on the PO4 segment.  These new elements are displayed in the CSV file, and you can manipulate these cells using Excel's features that you are already familiar with.

In addition to capturing these elements, the tool has been updated to email you the CSV file instead of displaying converted data on the webpage.  The email will contain your initial EDI file, as well as the converted file.  You can easily store both files together in your email system.

We are preparing to make several more changes in the near future, so keep watching this blog to be updated.  If you have any suggestions on improvements, please contact us.

Jobisez LLC.