Tip 7 of 10 on Best Practices for Asset Tracking

Posted on March 11, 2010

Effectively Populate the Database. Once you are ready to begin your asset tracking work, you need to have decided how you are going to populate the asset information into the central database. Some customers have their assets in another software application, on a spreadsheet, or on sheets of paper. If you have the data in an electronic form, it is usually best to import that into CG4 and then polish the data from there. If you do not have any electronic data, then adding all the assets manually using the web screens or the handheld scanners will be a good idea for you. Some people think that the quality of their existing data is poor and that they would like to enter everything from scratch. If you are able to start with some data and improve it, at the end of your initial asset tracking effort, it will usually be less effort than if you added them all from scratch.

Comments are closed.

Competitive Genius 4
Your Assets


Experience web-based, enterprise-level, asset tracking software with a catch. At CG4, one-size fits every size. We scale with you.

Customers Say . . .


“We have used CG4 for our asset tracking for eight years now, and have never regretted it.” - Ruth Kline

“My company has saved over 20% on new purchases by keeping track of existing assets.” - Peter Rothman

“CG4’s customer service is absolutely wonderful.” - Grace Rasmussen

PHVsPjxsaT48c3Ryb25nPndvb19hZGRibG9nPC9zdHJvbmc+IC0gdHJ1ZTwvbGk+PGxpPjxzdHJvbmc+d29vX2Fkc19yb3RhdGU8L3N0cm9uZz4gLSBmYWxzZTwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2ltYWdlXzE8L3N0cm9uZz4gLSBodHRwOi8vd3d3Lndvb3RoZW1lcy5jb20vYWRzL3dvb3RoZW1lcy0xMjV4MTI1LTEuZ2lmPC9saT48bGk+PHN0cm9uZz53b29fYWRfaW1hZ2VfMjwvc3Ryb25nPiAtIGh0dHA6Ly93d3cud29vdGhlbWVzLmNvbS9hZHMvd29vdGhlbWVzLTEyNXgxMjUtMi5naWY8L2xpPjxsaT48c3Ryb25nPndvb19hZF9pbWFnZV8zPC9zdHJvbmc+IC0gaHR0cDovL3d3dy53b290aGVtZXMuY29tL2Fkcy93b290aGVtZXMtMTI1eDEyNS0zLmdpZjwvbGk+PGxpPjxzdHJvbmc+d29vX2FkX2ltYWdlXzQ8L3N0cm9uZz4gLSBodHRwOi8vd3d3Lndvb3RoZW1lcy5jb20vYWRzL3dvb3RoZW1lcy0xMjV4MTI1LTQuZ2lmPC9saT48bGk+PHN0cm9uZz53b29fYWRfdXJsXzE8L3N0cm9uZz4gLSAvbW9iaWxlLWZlYXR1cmVzPC9saT48bGk+PHN0cm9uZz53b29fYWRfdXJsXzI8L3N0cm9uZz4gLSAvbW9iaWxlLWZlYXR1cmVzPC9saT48bGk+PHN0cm9uZz53b29fYWRfdXJsXzM8L3N0cm9uZz4gLSAvbW9iaWxlLWZlYXR1cmVzPC9saT48bGk+PHN0cm9uZz53b29fYWRfdXJsXzQ8L3N0cm9uZz4gLSAvbW9iaWxlLWZlYXR1cmVzPC9saT48bGk+PHN0cm9uZz53b29fYWx0X3N0eWxlc2hlZXQ8L3N0cm9uZz4gLSBkZWZhdWx0LmNzczwvbGk+PGxpPjxzdHJvbmc+d29vX2F1dG9faW1nPC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19ibG9nY2F0PC9zdHJvbmc+IC0gL2Jsb2cvPC9saT48bGk+PHN0cm9uZz53b29fYmxvZ19jYXRfaWQ8L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19jYXRtZW51PC9zdHJvbmc+IC0gZmFsc2U8L2xpPjxsaT48c3Ryb25nPndvb19jdXN0b21fY3NzPC9zdHJvbmc+IC0gPC9saT48bGk+PHN0cm9uZz53b29fY3VzdG9tX2Zhdmljb248L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19leF9mZWF0cGFnZXM8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fZmVhdGhlaWdodDwvc3Ryb25nPiAtIDwvbGk+PGxpPjxzdHJvbmc+d29vX2ZlYXRwYWdlczwvc3Ryb25nPiAtIDIsMTczLDMsNDAwLDE3NSwxNzcsNDk2PC9saT48bGk+PHN0cm9uZz53b29fZmVlZGJ1cm5lcl91cmw8L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19nb29nbGVfYW5hbHl0aWNzPC9zdHJvbmc+IC0gPHNjcmlwdCB0eXBlPVwidGV4dC9qYXZhc2NyaXB0XCI+DQp2YXIgZ2FKc0hvc3QgPSAoKFwiaHR0cHM6XCIgPT0gZG9jdW1lbnQubG9jYXRpb24ucHJvdG9jb2wpID8gXCJodHRwczovL3NzbC5cIiA6IFwiaHR0cDovL3d3dy5cIik7DQpkb2N1bWVudC53cml0ZSh1bmVzY2FwZShcIiUzQ3NjcmlwdCBzcmM9XCdcIiArIGdhSnNIb3N0ICsgXCJnb29nbGUtYW5hbHl0aWNzLmNvbS9nYS5qc1wnIHR5cGU9XCd0ZXh0L2phdmFzY3JpcHRcJyUzRSUzQy9zY3JpcHQlM0VcIikpOw0KPC9zY3JpcHQ+DQo8c2NyaXB0IHR5cGU9XCJ0ZXh0L2phdmFzY3JpcHRcIj4NCnRyeSB7DQp2YXIgcGFnZVRyYWNrZXIgPSBfZ2F0Ll9nZXRUcmFja2VyKFwiVUEtNTA5ODg5MC0xXCIpOw0KcGFnZVRyYWNrZXIuX3RyYWNrUGFnZXZpZXcoKTsNCn0gY2F0Y2goZXJyKSB7fTwvc2NyaXB0PjwvbGk+PGxpPjxzdHJvbmc+d29vX2ltYWdlX2hlaWdodDwvc3Ryb25nPiAtIDI1MDwvbGk+PGxpPjxzdHJvbmc+d29vX2ltYWdlX3dpZHRoPC9zdHJvbmc+IC0gMzkwPC9saT48bGk+PHN0cm9uZz53b29faW50cm88L3N0cm9uZz4gLSA8Y2VudGVyPkV4cGVyaWVuY2UgRW50ZXJwcmlzZS1MZXZlbCwgV2ViLUJhc2VkLCBBc3NldCBUcmFja2luZyBTb2Z0d2FyZSBXaXRoIEEgQ2F0Y2guIDxiciAvPiBBdCBDRzQsIE9uZS1TaXplIEZpdHMgRXZlcnkgU2l6ZS4gV2UgU2NhbGUgV2l0aCBZb3UuIDwvY2VudGVyPjwvbGk+PGxpPjxzdHJvbmc+d29vX2xvZ288L3N0cm9uZz4gLSAvd3AtY29udGVudC93b29fdXBsb2Fkcy84LUNHNF9Mb2dvX2JsYWNrMTI1LnBuZzwvbGk+PGxpPjxzdHJvbmc+d29vX21hbnVhbDwvc3Ryb25nPiAtIGh0dHA6Ly93d3cud29vdGhlbWVzLmNvbS90aGVtZS1kb2N1bWVudGF0aW9uL292ZXItZWFzeS88L2xpPjxsaT48c3Ryb25nPndvb19tZW51cGFnZXM8L3N0cm9uZz4gLSA8L2xpPjxsaT48c3Ryb25nPndvb19yZXNpemU8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fc2hvcnRuYW1lPC9zdHJvbmc+IC0gd29vPC9saT48bGk+PHN0cm9uZz53b29fdGhlbWVuYW1lPC9zdHJvbmc+IC0gT3ZlciBFYXN5PC9saT48bGk+PHN0cm9uZz53b29fdGhlX2NvbnRlbnQ8L3N0cm9uZz4gLSB0cnVlPC9saT48bGk+PHN0cm9uZz53b29fdXBsb2Fkczwvc3Ryb25nPiAtIGE6Njp7aTowO3M6Nzg6Imh0dHA6Ly93d3cuY2c0YXNzZXR0cmFja2luZy5jb20vd3AtY29udGVudC93b29fdXBsb2Fkcy84LUNHNF9Mb2dvX2JsYWNrMTI1LnBuZyI7aToxO3M6Nzg6Imh0dHA6Ly93d3cuY2c0YXNzZXR0cmFja2luZy5jb20vd3AtY29udGVudC93b29fdXBsb2Fkcy83LUNHNF9Mb2dvX2JsYWNrMTIyLnBuZyI7aToyO3M6OTE6Imh0dHA6Ly93d3cuY2c0YXNzZXR0cmFja2luZy5jb20vd3AtY29udGVudC93b29fdXBsb2Fkcy82LUNHNF9Mb2dvX2JsYWNrLTEzMl93aGl0ZV9zcGFjZS5wbmciO2k6MztzOjEwMToiaHR0cDovL3d3dy5jZzRhc3NldHRyYWNraW5nLmNvbS93cC1jb250ZW50L3dvb191cGxvYWRzLzUtQ0c0X0xvZ29fYmxhY2tfbm9fZ29sZC05Mng3MF9XaGl0ZV9TcGFjZS5wbmciO2k6NDtzOjg5OiJodHRwOi8vd3d3LmNnNGFzc2V0dHJhY2tpbmcuY29tL3dwLWNvbnRlbnQvd29vX3VwbG9hZHMvNC1DRzRfTG9nb19ibGFja19ub19nb2xkLTkyeDcwLnBuZyI7aTo1O3M6NjU6Imh0dHA6Ly93d3cuY2c0YXNzZXR0cmFja2luZy5jb20vd3AtY29udGVudC93b29fdXBsb2Fkcy8zLWxvZ28uZ2lmIjt9PC9saT48L3VsPg==