Archive Page 3

03
Apr

e-catalogs - how do you use them?

My take and thoughts from a post over on the EDI-L Yahoo group about the type of data to provide to a Catalog service.

There’s a lot of “push” these days - and has been for years? - about Electronic Catalogs.   Many of the bigger networks/VANs have a catalog service (Inovis & SPS Commerce come to mind) and there are probably more offered out there by companies - big and small - EDI network or not - that can house that data and provide it to your customer base.

This is where you, as a vendor/supplier/manufacturer, can store your product information data - colors, sizes, UPCs, style numbers, descriptions, and more - that can then be accessed by your buyers - the retailers and resellers - for their systems.  Some of the information is used by the end user and some is not.

Then on the flip side - there’s Me - the retailer.  I subscribe to the catalog service provider (in My case - Inovis) and look to that data for product information.  In our case, we’re pretty much only looking to verify the Style Number and UPC information.  Since we decided LONG AGO to not use the NRF size or color codes, that information is irrelevant to us.  Also, we tend to use our own item description that, again, makes your description somewhat irrelevant.  While some of your description is included in ours, we add extra information that may be related to a season (say, Spring, 2008) and other things that may not be included in your description and is very specific to our way of doing business.

The only thing that you provide to the catalog service that we use is the UPC and your published style number.  One of the reasons we don’t use the NRF color codes is that - well, think about your favorite sports team.  Now, think of their colors.  If you’re a San Francisco 49ers fan - it’s Red and Gold.  Oakland (LA) Raiders?  Silver and Black.  LA Lakers?  Purple and Gold.  Philadelphia Eagles?  Green and White.  LA Dodgers?  Blue and White.  So, pick one..

OK, I will.

Let’s say I’m a T-Shirt maker.  And I’m making a line of sports team T-shirts, those “raglan” style ones, where the body of the shirt is one color and the sleeves are another color and meet at the collar.  I think that they’re called “raglan”…  Oh, and the cuffs and color can contrast to the fabric that they’re attached to.  Think of the baseball style T-shirts you see..  Anyway, I’m getting off topic.

So, I’m making team color t-shirts.  And I’m setting up the one for the SF 49ers.  So I make the body of the shirt red - actually, it’s more of a burgandy - and the sleeves are gold.  So I go to the NRF color code list and - hmm - where do I put this shirt..?  Well, it’s red.  No, it’s DARK RED.  Oh, but here’s a number for Burgandy .. and here’s one that is maroon . . . . .

Or we’ll pick the Philly Eagles.  Green and white.  That’s easy.  Oh, wait - maybe not - is it emerald green?  kelly green?  forest green?  moss green? lime green? avacado, string-bean, sage, eucalyptus, clover…?  ARGH!!!!!  What happened to KEEP IT SIMPLE?!?!?!?

Then we get into the NRF codes for size!!!!  ACK!!!  ARGH!!!  Heart stopping.  Hair ripping..  Head exploding..!  While the size doesn’t have as much “wiggle room” as the colors do, there are still some issues to consider.  For example, we sell ammo for firearms.  And we have the caliber of the ammo as the size.  But what if the ammo provider uses the WEIGHT of the round as their size?

One of the things I’d mentioned in a reply to that post - remember the post I mentioned all the way up there at the beginning? - was that I agreed with another reply - in that he needs to follow any hierarchy set up by the catalog provider and to let the buyer - the retailer - to decide what information they were going to use and what information they’re not going to use.  As I said, we don’t pull down the NRF codes nor the description - we look to the STYLE number and UPC information pretty much only.

So, how do you use catalog information?  And do you push or pull the data - i.e. are you the manufacturer or the retailer?

Author: Craig Dunham - EDI Coordinator @ Big 5
Read more about Craig here: http://editalk.com/contributors/
31
Mar

GIS Fundamentals - Gentran Integration Suite - Day 1

Transitioning from Gentran to GIS… From what I hear this is going to be quite a big task migrating from Gentran, partly because its a whole different beast. I am in Lowell, MA this week to attend the GIS Fundamentals class, its a 5 day class that covers quite a bit of the main functions of the software. Today was day 1, and it was filled with a solid introduction of the basics and benefits of the Gentran Integration Suite. In addition to the introduction we covered the Graphical Process Modeler (GPM) and dove into BPML (Business Process Modeling Language) concepts and functions.

After the introduction was finished I felt I had a strong understanding to what GIS can do. It made me really start to think of all of the logic and business processes that we currently have in place on our AS/400 that are “hard coded” which take place after the translation process. It seems GIS will be able to handle all of the various checks and balances we have in place before dumping an order into our system. For example, on a 850 purchase order we check to see if a customer’s store exists in our customer master file or if that customer is allowed to order the product they are trying to order. All of these checks can be moved to the GIS system, although not with ease! There is going to be a learning curve to figure out the system and to transfer logic into a working business process.

We dove into BPML and how GIS utilizes this with the Graphical Process Modeler. Essentially the GPM builds the BPML for you, you can edit the BPML manually (and in some cases you have to).

Again, we only covered the basics today. I’ll report back with more later this week.

Has anyone else made the Gentran to GIS jump?

Author: John Burmeister
Read more about John here: http://editalk.com/contributors/
31
Mar

EDI Chargebacks!!!

WHOA!!!  In My readings, I just came across this article over at EC-BP.org!  Looks like we all get to start paying for our EDI transmissions!! 

Author: Craig Dunham - EDI Coordinator @ Big 5
Read more about Craig here: http://editalk.com/contributors/
31
Mar

EDI documents & Kiss

I was reading The Inovis Blog - yes, I do read other things! - but Meg Suggs (Inovis) talked about how McDonalds (over in Europe!) is “going green” with their fleet of delivery trucks. I commented (of course!) on how it would be great if the US and our automakers could be as forward thinking about the acceptance of alternative fuels and energy sources (such as bio-diesel).

My own car is a Chrysler PT Cruiser. Chrysler sells the PT Cruiser over in Europe, and offered (at least at one point) electric versions of the PT, as well as a CRD powered PT Cruiser. CRD is the acronym for COMMON RAIL DIESEL and it actually is a very viable diesel motor - with great performance and low emissions - not anything like the diesels we all may remember from the 80s…. Jeep even offers the CRD engine in their “Liberty” truck-ette in the US. But I digress from My original thought and point.

Reading that post (at Inovis) and My comment on same made Me think of how much better and easier (!) EDI could be if more hubs and suppliers - and even EDI providers - were to be more open and accepting to other ways of thinking.. How much more we could all get done.

As a hub (i.e. a retailer that starts the EDI process), I have great and tremendous power over My suppliers.. Geez, now “He-Man: Master of the Universe” is running around My brain with “by the power of Grayskull… I HAVE THE POWER!!!!” as he turns from meek and mild Prince “what’s-his-name” into He-Man - Master of the Universe.. and yes, I’m digressing again. But still, as the retailer, I do “have the power” to control the way that EDI works. I’m the one that specifies what information is important to Me and what information I’m going to send and how I’m going to send it and you can either accept it or not. But if not, then you’re probably going to be dropped off of our “active vendor” rolls.

But then it makes Me think - even more - about how that power can be used - or abused - depending on how willing I am (as the hub) to force the issues. We’ve all heard the horror stories of this hub or that supplier and how they make EDI painful..

In our product mix, we have some of the big-big heavy hitters and also some small little mom-n-pop kinds of suppliers.. If you read My other blog about “How Do You EDI” - I mention about a supplier that provides us with one product, but it’s the best damn version of that product on the market, you understand what I mean about mon-n-pop suppliers. But still.. I have to be considerate of all of My vendors and suppliers - of all of My trading partners. I have to be flexible in what I will and will not send, and in what I will and will not accept in a return document.

We buy a lot from one of the biggest names in Camping Goods that you can know - they do it all - from coolers to lanterns to sleeping bags to those folding chairs and then even more.. When we first implemented our EDI ASN, I was asked by their EDI mapper if they could send additional information in the ASN - information that our spec didn’t call for; hell it didn’t even mention it. Like the PID segment. The reason? because he sends that segment to other hubs/retailers and was looking to keep as few maps around as possible. This would be a classic example of the KISS philosophy I mentioned previously. And it’s something I’m quite OK with.

It’s the same thing that many of My trading partners have to deal with when they receive My 850 PO - in that I send along information that they may never use in their own system. For example, in the PO1 segment, I send along our SKU (important for the return ASN and for pre-ticketing), but I also send the product UPC, the vendor style number, a generic item description, case pack information, item sizes, etc.. Some of the vendors fill the order completely on the UPC. Others use their style number. Others use the size and the style.. So there are different needs out there.

But the point is - we only use one document map for our outbound PO and for the inbound ASN. And the same will hold true for our inbound 810 Invoice (once completed). As EDI trading partners, we’ve come to an agreement of what will work best and we’re working together and thinking together with a common goal - transmitting information back and forth without major headaches. We’ve both made changes on each side of the EDI equation to help out the other partner to implement the data. We’ve accepted alternatives to our own documents and changed what we needed to change in order to use those alternative documents. Much like we could (as a people and as a country) make changes to accommodate those alternative fuels..

There are, as I said, a couple of the big “heavy hitters” in the supply chain that hold to the credo of “my way or the highway” type of thinking. You - if you want to trade documents with them - must comply to their way of thinking. There is NO deviation. Resistance is futile. You will be assimilated. We are BORG.. oh, wait.. more nonsense.. But still. Many of you may have had to have dealt with these hubs and suppliers - the EDI “trading partners” that will not accept anything but total compliance with their specs. No deviation from their ways of doing business and doing EDI. You cannot mix styles on an order. You cannot send extra data. You must send via AS2. And on and on and on and ..

These heavy hitters are the stumbling blocks and the hurdles to making this all easy and painless. They’re the ones that don’t want to accept an alternative way of thinking. They don’t want to make accommodations to a different way of thinking. They’re the villains of this piece, much like some of the automakers and oil companies are the villains in the alternative energy ways of thinking. They only want what they know and they only want the way they do it and there will be no deviation. There will be no alternatives. It’s Pink Floyd and “The Wall“.. It’s “Us or Them“..

In the cavern of arcane and sometimes useless (and other times useful - like in a great game of Trivial Pursuit!), another thought is bouncing around off of the lobes and valleys and bumps of My brain - “Can’t we all just get along?”

Author: Craig Dunham - EDI Coordinator @ Big 5
Read more about Craig here: http://editalk.com/contributors/
25
Mar

EDI vs. XML - how readable is XML?

Over on the Inovis blog, Bill Chessman ponders about the human readability of XML vs. EDI.  A different take on an old debate. 

Ah, the old “EDI vs XML” debate rears it’s enormous jumbo head of dissent again…  *sigh…..

XML is simply a language for possibly trading information in a human readable format.  Much like HTML (the language of the Internet), you use “tags” that tell you what the next piece of information is.  So you can have a simple tag of <NAME> and then a person’s name and then the closing tag </NAME>….  You can continue to use these simple kinds of tags for the rest of the information you’re sending (sending maybe an address, a 2nd line of address, a city, a state, a zip and more) and the human eye can read it as

John Smith
123 Main Street
Suite 123
Anytown
ST
92345

In his post at the Inovis blog, however, Bill makes an excellent point - and one I’ve touted before in other comments - in that XML may be easier (in the layout of tags and direct information) to read then EDI formats, but it’s all dependent upon the DTD and the schema.  It’s easier because there is no rigid, solid standard to follow.  “Data A” can be ANYWHERE in the document, as long as it’s labeled as “Data A”.  The DTD and the schema are a lot like the translation specs we use in EDI - in that it tells you what tags will contain what data and what it all means.

But it’s that same lack of a standard that makes XML so much more complicated and so much less a solid answer.  There’s no specific spot for that “Data A” mentioned above.  It can be ANYWHERE… and it’s the job of the DTD or schema to tell you where it is and what it means.

Kay Dietz (of Inovis) offers a great course (through the training roadshow) on XML 101 - giving you the most basics of basics - kind of like a sample when you’re at the store…  “Here, try this cookie.  Isn’t it the best? Aisle 3B, 4.99 a dozen!“  XML is a great thing - offering a lot of possibilities for the transmission of data between partners.  And it’s supposed to be human-eyes readable.

But that’s where the problem comes in….  If (as Bill mentions) you don’t know what this tag is and means, or you don’t know what the abbreviation or code I’m using is, how can you interpret the data.  And sure, the schema or dtd can tell you what that is, but you have to read it and/or format the document to tell you what it means….

XML is, at its most basic, a language.  Just like Cobol and C++ and HTML and Chinese and French and English and…. Well, you get the point.  But let’s take that comparison even deeper….  XML could be very similar to Chinese or English - in that you will have different variations on the same language, all depending upon who is speaking.  There are many different dialects in both languages.  In the Chinese language, if you have two people speaking two different dialects, then there is a lot that they cannot communicate.  In the English language, at least if there are two people and two dialects, most of it can come across.  This isn’t a failing in the Chinese language at all.

XML can be a lot like English or a lot like Chinese.  It can be similar and yet different or it can be different and different.  Let’s say I’m sending you an order.  I can send it with the tag <ORDER> and then the number and the closing tag (don’t forget that closing tag!)…  But what if you use <PURCHASE> in your own system.  Sure, that schema or DTD will let you know that I’m sending you the purchase order number in that <ORDER> tag, but you will have to look at the schema for that meaning.

In EDI, since there is a standard (whether ANSI/X12 or TRADACOM or ________), you know that if I’m sending an order, it will be in the BEG segment at location BEG03.  Always.  If you’re fluent in the “language” of EDI - the standard you’re using - you know exactly what information is in what segment and where to look for it and what format it will be in and all of that.  Just as if you’re fluent in English, you will know that in the Southern Dialect, “y’all” generally means “all of you” in a more formalized version of the language.

In My example above (about the name, address, etc., tags), the same information is carried in the N1, N3 and N4 segments.  And it also gives you a bit more information by the element designator (ST = Ship To, BT = Bill To, etc.) so you can also have the same information - but in a different format:

N1*ST*John Smith~
N3*123 Main street*Suite 123~
N4*Anytown*ST*92345~

And there you have the same information.  Sure, there’s the added symbols of * as a element separator and the ~ as the segment terminator, but it’s still readable, IF YOU KNOW THE LANGUAGE.

One of the things that Bill mentions (in the posting) is that EDI was not really supposed to be “human readable” - as it is/was a way of getting data from a source machine or system to a destination machine or system.  It was transferring data from My systems to yours.  If you want “human readable”, you create a report.  It prints out and has all the “tags” set up as field names (name, address, address, city, state, zip) followed by the appropriate data.

Hmmm… that’s just like the XML format of the data above - in that it’s now suddenly human readable.  But instead of having to have the user (aka the human) try and figure out what they mean - the report tells them exactly what they mean, because the data was transmitted and then translated via the standard spec.

Look at it this way - suppose you’re a maker/seller of … gum…  Just looking at the pack of Trident White on My desk, there are 12 pieces of gum to a pack.  Now, let’s say that you put 12 packs in a box.  Then there are 12 boxes to a carton.  And 12 cartons to a pallet.  That’s a lot of twelves…

Now I send you an order…

XML - <QTY>144</QTY>

EDI - PO1*1*144*EA*UP*445600456729~

In the XML version, I order 144.  But 144 what?  Each? Boxes? Cartons?  Pallets?  In the EDI version I give you My UOM (unit of measurement) in the line item detail.  To get that information to you in the XML format, I’d have to add another set of tags - like <UOM>EACH</UOM> or similar or tell you what that quantity means in the DTD or schema.  As a matter of fact, each element in the EDI segment has to have its OWN SET of tags for EACH piece of information…..  So now I’m sending all of this information to you - think about any kilo-character limits or charges you may have - and that simplicity of XML - that “freedom” now is costing you extra.

The XML for just that simple EDI line would look something like this:

<LINE>1</LINE>
<QTY>144</QTY>
<UOM>EA</UOM>
<UPC>445600456729</UPC>

Each piece of information for the item being ordered has to have a set of tags to designate it.  And for EACH and EVERY order I send you, you’re getting that same set of tags and data over and over and over again.  For each line item (style) I’m ordering, you’re getting all of those characters that make up those tags - over and over and over and over and….  Whereas with EDI, you get - hey, look - a separator (*)….  So, let’s just do a quick character count of the EDI PO1 segment I’ve got up there…. 29.  29 characters…  The same for an XML version of that line…?  Let’s see .. 14 for the qty line .. um .. carry the one .. divide by .. add .. Where’s that damn calculator..?!?  It came to 64 characters, btw.

 And the more “detailed” I make My tags (use QUANTITY instead of QTY, UNIT OF MEASURE instead of UOM) and you can see how it can REALLY start to add up.  Oh, and then you’re also sending that DTD or schema with EACH and EVERY document.  Imagine if you had to send your translation spec with EVERY document you send..

So, yeah, XML has some benefits in the simplicity department.. and in the “human interface” area.  But with no standards to abide by, no rules to play by, that human readability goes right out the window with whatever dialect you want to speak.

Author: Craig Dunham - EDI Coordinator @ Big 5
Read more about Craig here: http://editalk.com/contributors/




Contribute to the Community

EDITalk.com is run by EDI guys for EDI guys. Want to write a article or blog post? Just let us know on the fourms and become a contributor today! All credits given to any article posted on the web site.

Categories

 

September 2008
S M T W T F S
« Aug    
 123456
78910111213
14151617181920
21222324252627
282930