<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://meta.trackabout.com/w/index.php?action=history&amp;feed=atom&amp;title=Serial_Number</id>
	<title>Serial Number - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://meta.trackabout.com/w/index.php?action=history&amp;feed=atom&amp;title=Serial_Number"/>
	<link rel="alternate" type="text/html" href="https://meta.trackabout.com/w/index.php?title=Serial_Number&amp;action=history"/>
	<updated>2026-06-13T08:49:09Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.35.7</generator>
	<entry>
		<id>https://meta.trackabout.com/w/index.php?title=Serial_Number&amp;diff=8563&amp;oldid=prev</id>
		<title>Sdigon: /* Scrubbing on the way in */</title>
		<link rel="alternate" type="text/html" href="https://meta.trackabout.com/w/index.php?title=Serial_Number&amp;diff=8563&amp;oldid=prev"/>
		<updated>2022-07-12T14:07:04Z</updated>

		<summary type="html">&lt;p&gt;&lt;span dir=&quot;auto&quot;&gt;&lt;span class=&quot;autocomment&quot;&gt;Scrubbing on the way in&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left diff-editfont-monospace&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 14:07, 12 July 2022&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l9&quot; &gt;Line 9:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 9:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;We made a design decision long, long ago to &amp;quot;scrub&amp;quot; serial numbers as they enter TrackAbout, to eliminate ambiguities. The rules are fairly simple:&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;We made a design decision long, long ago to &amp;quot;scrub&amp;quot; serial numbers as they enter TrackAbout, to eliminate ambiguities. The rules are fairly simple:&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* All letter &amp;quot;O&amp;quot;s are converted to zeroes.&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* All letter &amp;quot;O&amp;quot;s are converted to zeroes.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* We strip out all special characters, like &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;dashes &lt;/del&gt;and underscores. Anything that's not a number or letter gets stripped out. That's how the data gets stored in the database.&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* We strip out all special characters, like &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;dollar signs &lt;/ins&gt;and underscores. Anything that's not a number or letter gets stripped out. That's how the data gets stored in the database&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;.&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;** Please note that dashes are currently excluded from scrubbing - they will remain in the serial number&lt;/ins&gt;.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;When done reliably at every point where a serial number can enter the system, this practice solves some of the problems with human serial number data collection.&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;When done reliably at every point where a serial number can enter the system, this practice solves some of the problems with human serial number data collection.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;

&lt;!-- diff cache key supportmediawiki:diff::1.12:old-6942:rev-8563 --&gt;
&lt;/table&gt;</summary>
		<author><name>Sdigon</name></author>
	</entry>
	<entry>
		<id>https://meta.trackabout.com/w/index.php?title=Serial_Number&amp;diff=6942&amp;oldid=prev</id>
		<title>Lsilverman at 20:58, 26 September 2017</title>
		<link rel="alternate" type="text/html" href="https://meta.trackabout.com/w/index.php?title=Serial_Number&amp;diff=6942&amp;oldid=prev"/>
		<updated>2017-09-26T20:58:22Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left diff-editfont-monospace&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 20:58, 26 September 2017&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l1&quot; &gt;Line 1:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 1:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;TrackAbout has &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;several features which help &lt;/del&gt;to &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;ensure that &lt;/del&gt;serial numbers &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;are entered correctly&lt;/del&gt;, &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;but also to determine for which types of assets &lt;/del&gt;serial&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;-number collection is required&lt;/del&gt;.&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;==Serial Numbers Aren't Unique==&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;Serial numbers across an asset fleet cannot be guaranteed to be unique. Fleets contain assets from different manufacturers, and there's no guarantee there won't be overlap. This makes serial numbers a terrible choice on which to build an asset tracking system. &lt;/ins&gt;TrackAbout has &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;seen accounts where up &lt;/ins&gt;to &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;5% of the asset fleet had duplicate &lt;/ins&gt;serial numbers&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;. For this reason&lt;/ins&gt;, &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;TrackAbout relies on guaranteed-unique tag numbers and not &lt;/ins&gt;serial &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;numbers&lt;/ins&gt;.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;* Ensuring that serial &lt;/del&gt;numbers &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;are entered correctly&lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;Serial &lt;/ins&gt;numbers in TrackAbout &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;have always been considered &lt;/ins&gt;a &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;cross reference number&lt;/ins&gt;. &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;They &lt;/ins&gt;can be &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;useful &lt;/ins&gt;to &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;identify an asset if &lt;/ins&gt;the &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;asset tag is lost or damaged&lt;/ins&gt;. &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;But they shouldn&lt;/ins&gt;'&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;t be relied upon heavily&lt;/ins&gt;.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;** Serial number scrubbing allows for a cleanup of common mistakes &lt;/del&gt;in &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;serial numbers. For example, &lt;/del&gt;TrackAbout &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;changes all &amp;quot;O&amp;quot;s to &amp;quot;0&amp;quot;s so that if one user enters it as an &amp;quot;O&amp;quot; and another user enters it as &lt;/del&gt;a &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;&amp;quot;0,&amp;quot; a new asset will not get created&lt;/del&gt;.&lt;/div&gt;&lt;/td&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;** Incorrect serial number formats &lt;/del&gt;can be &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;set. These stop users from entering serial numbers that are know &lt;/del&gt;to &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;be a different number on &lt;/del&gt;the &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;tank shoulder&lt;/del&gt;. &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;For example, do not accept serial numbers that start with &amp;quot;DOT&amp;quot; as this the cylinder&lt;/del&gt;'&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;s DOT classification and not the serial number&lt;/del&gt;.  &lt;/div&gt;&lt;/td&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;* Determining for which types &lt;/del&gt;of &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;assets is &lt;/del&gt;serial&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;-&lt;/del&gt;number &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;collection is required&lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;TrackAbout has always assumed serial numbers would NOT be accurately recorded by humans adding assets to the system. Ask two people to Add New the same asset, and they'll type in different serial numbers because &lt;/ins&gt;of &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;this. Is it a letter O or number 0? A dash or an underline? Depending on the &lt;/ins&gt;serial number&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;'s font, size and condition, the characters can be ambiguous and lead to bad data.&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;** &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;Serial-&lt;/del&gt;number collection &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;is &lt;/del&gt;not &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;technically required, but absolutely recommended&lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt; &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;** &lt;/del&gt;Serial number can be &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;made optional&lt;/del&gt;. &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;Most &lt;/del&gt;assets &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;require &lt;/del&gt;a &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;serial &lt;/del&gt;number&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;, but &lt;/del&gt;for some classes of inexpensive assets it &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;is preferable &lt;/del&gt;to &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;not &lt;/del&gt;collect a serial number&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;. Therefore&lt;/del&gt;, &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;rules can be set to determine which types of assets require Serial Number&lt;/del&gt;.&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;==Scrubbing on the way in==&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;We made a design decision long, long ago to &amp;quot;scrub&amp;quot; serial numbers as they enter TrackAbout, to eliminate ambiguities. The rules are fairly simple:&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;All letter &amp;quot;O&amp;quot;s are converted to zeroes.&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;We strip out all special characters, like dashes and underscores. Anything that's not a number or letter gets stripped out. That's how the data gets stored in the database.&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt; &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;When done reliably at every point where a serial number can enter the system, this practice solves some of the problems with human serial &lt;/ins&gt;number &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;data &lt;/ins&gt;collection&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;.&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt; &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;==Validation Patterns==&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;Patterns can be configured in TrackAbout to prevent entering invalid serial numbers. Sometimes there are many numbers on an asset, and the user types in the wrong one. For example, a rule can be configured to reject serial numbers that start with &amp;quot;DOT&amp;quot;, as this will be an asset's DOT classification and &lt;/ins&gt;not &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;the serial number.&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt; &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;==Only Collect Serial Numbers Based on Asset Type==&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;Serial number &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;collection rules &lt;/ins&gt;can be &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;configured so users are prompted to enter the S/N only for specific asset types or product codes&lt;/ins&gt;.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt; &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt; &lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;For most &lt;/ins&gt;assets&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;, the serial number should be collected if available. It's &lt;/ins&gt;a &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;valuable cross reference &lt;/ins&gt;number &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;if the tag is damaged. But &lt;/ins&gt;for some classes of inexpensive assets&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;, &lt;/ins&gt;it &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;may not be worth the time &lt;/ins&gt;to collect a serial number, &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;or one might not exist&lt;/ins&gt;.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;

&lt;!-- diff cache key supportmediawiki:diff::1.12:old-5967:rev-6942 --&gt;
&lt;/table&gt;</summary>
		<author><name>Lsilverman</name></author>
	</entry>
	<entry>
		<id>https://meta.trackabout.com/w/index.php?title=Serial_Number&amp;diff=5967&amp;oldid=prev</id>
		<title>Lpickett: Created page with &quot;TrackAbout has several features which help to ensure that serial numbers are entered correctly, but also to determine for which types of assets serial-number collection is req...&quot;</title>
		<link rel="alternate" type="text/html" href="https://meta.trackabout.com/w/index.php?title=Serial_Number&amp;diff=5967&amp;oldid=prev"/>
		<updated>2017-06-28T17:56:08Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;TrackAbout has several features which help to ensure that serial numbers are entered correctly, but also to determine for which types of assets serial-number collection is req...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;TrackAbout has several features which help to ensure that serial numbers are entered correctly, but also to determine for which types of assets serial-number collection is required.&lt;br /&gt;
&lt;br /&gt;
* Ensuring that serial numbers are entered correctly&lt;br /&gt;
** Serial number scrubbing allows for a cleanup of common mistakes in serial numbers. For example, TrackAbout changes all &amp;quot;O&amp;quot;s to &amp;quot;0&amp;quot;s so that if one user enters it as an &amp;quot;O&amp;quot; and another user enters it as a &amp;quot;0,&amp;quot; a new asset will not get created.&lt;br /&gt;
** Incorrect serial number formats can be set. These stop users from entering serial numbers that are know to be a different number on the tank shoulder. For example, do not accept serial numbers that start with &amp;quot;DOT&amp;quot; as this the cylinder's DOT classification and not the serial number. &lt;br /&gt;
&lt;br /&gt;
* Determining for which types of assets is serial-number collection is required&lt;br /&gt;
** Serial-number collection is not technically required, but absolutely recommended&lt;br /&gt;
** Serial number can be made optional. Most assets require a serial number, but for some classes of inexpensive assets it is preferable to not collect a serial number. Therefore, rules can be set to determine which types of assets require Serial Number.&lt;/div&gt;</summary>
		<author><name>Lpickett</name></author>
	</entry>
</feed>