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.

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.

EDI VAN Annual Budget

Many companies are planning their next year's annual budget soon.  This is a good time to revisit your current EDI VAN bills and determine if you are paying too much.  For those that are paying too much, you might be able to shave some cents off each KC. 

Some "cents" you say.  Sure!  Remember that a KC (Kilo-Character) is 1000 characters.  If you are exchanging 10,000 KCs a month at 10 cents per KC, that is a total bill of $1000/mo.  Trimming that down to 8 cents per KC would lower your bill to $800/mo.  Which is a saving of $2400 a year. 

Ah, now does it make sense? 

Some companies also offer tiered pricing.  This means, the more data you exchange, the lower the price per KC.  If you are interested in lowering your VAN bill, then fill-out the Jobisez EDI VAN form to find out what you could be paying per KC.  The form will ask only for your Name, Email Address and Number of KCs traded last month. 

After entering this information, you will receive an email stating the cost per KC and the advantages you would get from a tiered-1 VAN.  If you like the price, then you will receive an Agreement and we can get the ball rolling. 

Lowering your VAN bill is one of the easier things you can do to meet your company's budget constraints.

Convert EDI 315 to Excel CSV File

In a continuing effort to make your EDI job easier, Jobisez LLC created another conversion tool.  As mentioned in our first EDI Online Tools posting, we will be adding new tools as time goes on.  In this case we have added a tool that converts an EDI 315 to an Excel CSV file.

Similar to the EDI 852 conversion tool, all you will need is a valid EDI 315 transaction.  Go to the EDI 315 Conversion page, "choose" the file, then click "Create CSV."  In a few moments, the textbox will contain the EDI 315 in raw form.  At this point, you can click "save as" and open the EDI 315 in Excel. When Excel (or your favorite spreadsheet application, you can massage the data in the tool you are already familiar with.)

Let us know what you think and how you think we should proceed.  Your input is valuable to us!

Improvements to the EDI 852 to Excel Tool

Jobisez understands the necessity of understanding the EDI 852 Product Activity (POS) document.  We have defined the importance of this document in two of our blogs, What is the EDI 852 and Identifying Sales-Trends.

With this information, we created an Online Tool last year to create a CSV spreadsheet from an EDI 852 transaction.  This tool has been very popular and used quite often.

After careful analysis of the 852s being processed, we needed to add several more LIN qualifiers to the tool so it can be helpful to more companies.

With its new release today, the tool now looks for the following qualifiers in the LIN segment...
1.  UP - U.P.C. Consumer Package Code (1-5-5-1)
2.  UB - U.P.C. / EAN Case Code (2-5-5)
3.  ND - National Drug Code 
4.  UI - U.P.C. Consumer Package Code (1-5-5)
5.  UD - U.P.C. / EAN Consumer Package Code (2-5-5)
6.  IB - International Standard Book Number (ISBN)
7.  EN - European Article Number (EAN) (2-5-5-1)
8.  EO - GTIN-8
9.  UK - GTIN: U.P.C. / EAN Shipping Container Code (1-2-5-5-1)
10. VN - Vendor's (Seller's) Item Number
11. MG - Manufacturer's Part Number
12. VP - Vendor's (Seller's) Part Number
13. VC - Vendor's (Seller's) Catalog Number
14. VA - Vendor's Style Number
15. IN - Buyer's Item Number
16. PN - Company Part Number
17. BP -  Buyer's Part Number
18. PI - Purchaser's Item Code
19. CB - Buyer's Catalog Number
20. IT - Buyer's Style Number

Please feel free to post a comment on what other features you would like to see this tool do.  For instance, would you like the CTP values on the spreadsheet, or perhaps you would also like to see the Color and Size information too.