I’ve been working on ways to filter and automatically clear up some of the huge numbers of duplicate IDs in our primary ERP. We’ve got at least 1800 of them remaining (from a high-water mark of around 2800), and it takes me at least 15 minutes to clean up each one manually.
We’ll be on a more advanced system by July. By “more advanced,” I mean that the system will at the very least support referential integrity, preventing exactly one half of the problems I’m fixing now. The other half — people getting entered twice because they’ve changed their name or moved or whatever since the last time they transacted with us — will be unaffected, sadly, so creating a good system for data cleanup is going to have to be a priority for me.
A few people might not obtain any kind of erection problem. tadalafil free shipping Muira Puama: it is a potency wood found in cialis sale online canterburymewscooperative.com South America. On the other hand, the patients who didn’t take the one ounce pomegranate juice found that their atherosclerotic plaque increased by 9 percent. cialis online usa This is because the ovary surface cheap cialis ruptures and the cells which might be launched float close to the fallopian tube entrance.
(As a side note: doesn’t “the last time they transacted with us” sound insanely dirty?)
This entry was posted in Work and tagged database, ERP. Bookmark the
permalink. Both comments and trackbacks are currently closed.
Referential integrity, will you have my babies?
I’ve been working on ways to filter and automatically clear up some of the huge numbers of duplicate IDs in our primary ERP. We’ve got at least 1800 of them remaining (from a high-water mark of around 2800), and it takes me at least 15 minutes to clean up each one manually.
We’ll be on a more advanced system by July. By “more advanced,” I mean that the system will at the very least support referential integrity, preventing exactly one half of the problems I’m fixing now. The other half — people getting entered twice because they’ve changed their name or moved or whatever since the last time they transacted with us — will be unaffected, sadly, so creating a good system for data cleanup is going to have to be a priority for me.
A few people might not obtain any kind of erection problem. tadalafil free shipping Muira Puama: it is a potency wood found in cialis sale online canterburymewscooperative.com South America. On the other hand, the patients who didn’t take the one ounce pomegranate juice found that their atherosclerotic plaque increased by 9 percent. cialis online usa This is because the ovary surface cheap cialis ruptures and the cells which might be launched float close to the fallopian tube entrance.
(As a side note: doesn’t “the last time they transacted with us” sound insanely dirty?)
Share this on: