cancel
Showing results for 
Search instead for 
Did you mean: 

Mass BP Purge

Former Member
0 Kudos

Our current BP database consists of roughly 16,000 records. Most of those were ported over when we first integrated SBO nearly 2 years ago.

Now that we are confortable with the SBO system, we would like to purge our BP database of all of the old dead, and inactive accounts.

Identifying the BPs we would like to remove isn't the issue. Finding a way to do the purge en masse is.

Of course we could step , one by one, and delete the BP through the front end, but we are looking for an easier, more efficient method. There are several thousand records that need to be purged.

None of the BPs to be purged have any transactional history. They are simply BP Master records with an occassional Alternate Address.

Any help would be greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

Please check this Blog

Answers (1)

Answers (1)

Former Member
0 Kudos

Geoff,

The only way to do this is through the SDK. The DTW cannot remove records from the database.

There is a tool I have seen on the SDN here before that can delete records through the DIAPI, but I don't believe it to be a for resale Add-On. I believe it's a developer's tool.

I'd search the forum for this, I cannot recall what it was called or who built it.