Welcome to MSDN Blogs Sign in | Join | Help

Records Management Feature(s) – Barcode and Labeling Policies

Before moving on to our next topic of record declaration & classification (which I know that many of you are anxiously waiting to hear about), this week’s posting discusses the last two features in the Information Management Policy framework of the 2007 release of the Office system – labels & barcodes.

Both of these features target a problem of particular interest to records managers – namely, how to manage physical records or documents in a manner consistent with their electronic counterparts? This is of course, requirement #1 for using a Records Management Application to handle physical records – while the application stores a digital object that represents the record, containing metadata about the record (like where the physical record is being stored), the appropriate disposition schedule for the record, etc., users need a barcode or labeling system to identify which physical records correspond to which digital objects.

So in the 2007 release of the Office system, we’ve included features for labeling & barcodes to automatically assign identifiers to content.

What do you mean by labeling & barcodes?

When we talked to customers about how they assigned identifiers to objects, we heard two main approaches:

  • Metadata-based labels: Some preferred to use an identification scheme that communicated metadata about the objects in the identifiers themselves. For example, some of our legal customers assigned identifiers to records that were based on the number of the client account, the jurisdiction of the matter in question, the year the matter was initiated, and the number of the folder that contained the record, like: Northwind—Massachusets—2006—001 .
  • Machine-readable barcodes: Other customers preferred to use machine-readable identifiers like barcodes. While these didn’t communicate any information about the record directly, they could be read by scanner devices to automatically look up the record information from the application.

So in the 2007 release, we’ve provided features that can use either approach.

Label Policies:

Label policies are the mechanism for assigning metadata-based identifiers. Label policies specify how to assemble the metadata about an item or document into an identifier, and the label is automatically filled in as the metadata is entered. And the label can of course be searched for to locate items on the server.

Here is a screenshot of the settings page for configuring a Label policy:

 

Barcode policies:

Barcode policies (as you may expect) are the mechanism for assigning machine-readable identifiers. Once a barcode policy is applied to a Content Type, barcodes will automatically be assigned to items as they are created or uploaded to the system, and items can be searched for using their barcode value.

Here is a screenshot of an item that has been assigned a barcode via a policy:

 

The barcode format is totally configurable – Office SharePoint Server 2007 includes a component for generating barcodes that conform to the “Code 39” barcode symbology (formally known as ANSI/AIM BC1-1995), but components that provide barcodes in other formats can be plugged in as well.

Barcodes and labels in the Office 2007 client applications

And while everything mentioned above applies to managing any type of item or document in Office SharePoint Server, label & barcode policies have some additional capabilities when  applied to Word, Excel, and PowerPoint documents.

Policies on these types of documents can specify that the label/barcode should be included in print-outs of these documents, and the Office 2007 applications will then provide users with an opportunity to add the label or barcode automatically when they print those documents out.

Here's a screenshot of a user printing out a document with a barcode policy:

In this way, document print-outs can be made to include the appropriate labels & barcodes to ensure that they can be easily correlated with the digital documents in Office SharePoint Server.

Thanks for reading!
- Ethan Gur-esh, Program Manager.

Published Thursday, August 10, 2006 6:54 AM by recman

Comments

# Records management - barcoding documents as policy

in 2007 we are adding records management to SharePoint.  I came across this great post on barcoding...
Thursday, August 10, 2006 5:00 AM by Office Rocker!

# re: Records Management Feature(s) – Barcode and Labeling Policies

Well, Code 39 or 3of 9 is widely used, but it doesn't have checksumming which can cause false positive reads - one old system I worked with used Code 128 codes with checksums, and provided a far more reliable label.  

I'd also want to look at ways of guaranteeing uniqueness of generated numbers to the organization, as in government we have this tendency to transfer functions and the attached records between agencies, which results in a lot of duplicate labelling over time.  I've often wondered if using the equivalent of a key generator would be much more effective than sequential schemes, which by nature will overlap.  Any thoughts on this?

The policy attachment idea is very good.  I can see a number of other applications in areas dealing with health/safety/child protection/security etc, anywhere confirmation or approval before release of information is critical.  The question is of course, how to get this accepted in organizations with considerable cultural 'stickiness'?

Nice work, there seems to be some really switched on architecture in this.
Thursday, August 10, 2006 8:44 AM by Hef

# re: Records Management Feature(s) – Barcode and Labeling Policies

Great info! :)
Thursday, August 10, 2006 3:35 PM by mkruger

# re: Records Management Feature(s) – Barcode and Labeling Policies

This is great info!
Friday, August 11, 2006 4:51 PM by gannotti

# re: Records Management Feature(s) – Barcode and Labeling Policies

Great stuff thanks!
Friday, August 11, 2006 4:54 PM by gannotti

# 2007 MOSS Resource Links (Microsoft Office SharePoint Server)

Here is an assortment of various 2007 Microsoft Office SharePoint Server Documentation / Reference Materials...
Monday, August 14, 2006 5:55 PM by The Boiler Room - Mark Kruger, SharePoint MVP

# re: Records Management Feature(s) – Barcode and Labeling Policies

@ Hef:

You're absolutely right that Code 39 isn't necessarily the right barcode format for all customers in all situations. We didn't mean to imply that Code 39 is "better" in any way because it's the default format we chose to include in the product. Rather, we knew that we needed to include one format "in the box" (so that customers could use the feature without needing to install additional components), and we chose Code 39 because it is widely used and there weren't any onerous licensing or royalty requirements. But the motivation for allowing components for providing barcodes in other formats was so that customers could plug-in and use whichever formats are appropriate for their organizations.

As for your question about uniqueness: the problem of duplication in labeling systems is very real. At many of the customers we've talked to, we've seen one of two two modes of labeling: "sequential" (where subsequent documents are assigned incrementing IDs) or "random" (where the IDs generated for items are not assigned in a predictable sequence).

"Sequential" systems often introduce the risk of duplication (for example, because different departments/groups inadvertently start assigning the same IDs), but they have the advantage of sometimes conveying meaningful information (e.g. because companies use IDs starting at 100000 for "sales" documents, 200000 for "finance" documents, etc.)

Random systems (which I believe you called "key generator" systems) have the benefit of being far less likely to introduce duplication, but with the trade-off that the IDs aren't inherently meaningful.

I don't have an answer as to which approach is correct or better -- it really is up to each organization to decide how they want to make those trade-offs. The good news is that the labeling and barcoding features in the 2007 Office System can support either approach. The Code 39 barcode component we provide in the box takes the "random" approach, and label policies can be configured to include item metadata for sequential systems, reducing the likelihood of duplication.

Finally, thanks for the warm feedback on the features. It's always nice for our team to hear. :)

- Ethan Gur-esh, Program Manager.
Wednesday, August 16, 2006 9:53 PM by Ethan Gur-esh

# re: Records Management Feature(s) – Barcode and Labeling Policies

I don't think so, that random systems is the same the "key generator". I think that the "key generator" is @the one place" where you can get the bar-code value wit.h special rules( like you mention "sales" 200000).
In our case, we have one office with different locations, so we have to be sure that the bar code is not dublicated. As well we need the feature to get the barcode from electronic document when we put it in one database
Thursday, August 17, 2006 4:40 AM by igor

# re: Records Management Feature(s) – Barcode and Labeling Policies

@ Igor:
Thanks for the correction. In that case what’s described as “key generator” is more like the “sequential” model I mentioned in my earlier comment. Hence the requirement to ensure that the identifier is not duplicated.

I’m not sure I followed your last requirement about “getting the barcode from electronic document when we put it in one database”. Can you clarify?

Thanks,
- Ethan Gur-esh.
Wednesday, August 23, 2006 12:57 PM by recman

# Sharepoint 2007: Document/Records Management resource list V0.1

Planning Plan document management Chapter overview: Plan document management What is document management?
Thursday, August 31, 2006 4:27 AM by Arno Nel 2.0

# Records Center Q&A

Thanks to everyone who posted questions about the Records Center or sent them in via the “contact” form....
Tuesday, September 19, 2006 4:54 PM by Microsoft Records Management Team Blog

# Physical Records Management in the 2007 Office system

So far in this blog, we’ve talked directly about electronic records – the files created in document authoring

Thursday, October 05, 2006 4:00 AM by Microsoft Records Management Team Blog

# re: Records Management Feature(s) – Barcode and Labeling Policies

Where could I find the component for generating barcode ?

I have to add an unique number to every document that will be added to my MOSS 2007 portal. One way of doing it is maybe to use the label or barcode feature. At this moment I don't now which is the most appropriated...

Any help or advice are welcome !

Tuesday, October 10, 2006 5:38 AM by ayk

# re: Records Management Feature(s) – Barcode and Labeling Policies

@ayk:

Using the barcode feature is the more straightforward approach for your scenario, since much of the additional benefit of the labels feature is to incorporate additional metadata into a document identifier.

If you’re looking for the steps to try out the barcode feature (including the component for generating barcodes that we provide “in the box”), the steps are included in the posting about information management policies (http://blogs.msdn.com/recman/archive/2006/06/16/633393.aspx) .

If you want to find out how to plug in your own barcode component (e.g. because your organization has particular requirements around how values are assigned, etc.), there’s a code sample showing how to author & deploy new barcode components in the “Enterprise Content Management Starter Kit” SDK which can be found @ http://blogs.msdn.com/ecm/archive/2006/10/10/ECM-Starter-Kit-for-B2TR.aspx .

Hope this helps,

- Ethan Gur-esh, Program Manager.

Monday, October 16, 2006 1:56 PM by recman

# re: Records Management Feature(s) – Barcode and Labeling Policies

@recman:

Thank you for the link, I'll try that !

My number has to be unique so I'll probably have to code my own barcodes generator...

Thursday, October 19, 2006 4:21 AM by ayk

# Barcode's NOT unique

SharePoint's barcode feature does not guarantee that barcodes are generated every time a document is added to a document library.

This has the consequence that two different documents can have the same barcode.

Any workarounds?

Monday, January 29, 2007 8:48 AM by marquard

# re: Records Management Feature(s) – Barcode and Labeling Policies

Recently I tried the barcode sample code from the ECM starter kit. (http://blogs.msdn.com/ecm/archive/2006/10/10/ECM-Starter-Kit-for-B2TR.aspx )

According to this example, adding a custom barcode seems to be not a big deal. I compiled the assembly and added to the GAC. I added the manifest with the small console application which is also in the sample package. That worked well! But now comes tha question. After adding the plug in, how can I use my custom barcode within sharepoint.

If I create a new policy I do not see where I can select my custom barcode?

I'm wondering if anybody has tried the ECM example?

Monday, March 12, 2007 10:51 AM by dottimar

# Barcode « Calvin998’s Space

Tuesday, August 07, 2007 8:18 PM by Barcode « Calvin998’s Space

# re: Records Management Feature(s) – Barcode and Labeling Policies

Hi,

Is it possible to use the barcode and labeling feature in collaborative spaces?

thx,

Bela Pesics

Monday, August 27, 2007 1:53 PM by pc2

# Sharepoint 2007 Document and Records Management resource List (update)

Document and Records Management Definition Document Management According to Wikipedia : "A document

Wednesday, October 03, 2007 11:20 AM by Mirrored Blogs

# re: Records Management Feature(s) – Barcode and Labeling Policies

We have customer who is thinking about sharepoint portal server, but ask us the following question:

1. Using Record management or infopath form service (Infopath form) with textbox control pulling accountnumber from database, then generate barcode automatically, Is it possible to alter meta data and tie Unique id to read from database, in this case AccountNumber, then generate barcode accordingly when new form is created.

2. Currently they print out blank form, then print out barcode using third party tool, then put the barcode on the form.

Tuesday, October 23, 2007 4:58 PM by dz0001

# 2007 MOSS Resource Links (Microsoft Office SharePoint Server)

2007 MOSS Resource Links (Microsoft Office SharePoint Server) Here is an assortment of various 2007 Microsoft

Monday, November 12, 2007 3:47 PM by The Boiler Room - Mark Kruger, Microsoft SharePoint MVP

# Barcode « All About SharePoint

Wednesday, December 12, 2007 6:53 PM by Barcode « All About SharePoint

# re: Records Management Feature(s) – Barcode and Labeling Policies

IDAutomation offers several integration options for SharePoint Designer: http://idautomation.com/sharepoint/

Wednesday, March 05, 2008 10:34 AM by banders
Anonymous comments are disabled
 
Page view tracker