How to delete all database records (contacts for example) (not in a live System!)

(0) Share

Report

Posted on by T_Mauser

397 User Group Leader

Hey,

I want to clear all records in my contact database/list - how is that possible?

Tried it with the config-packages but that didn't worked out as I wished ...

Greetings,

T_Mauser

All responses (4)

Answers (1)

T_Mauser 397 User Group Leader on at

Like (1)

Report

RE: How to delete all database records (contacts for example) (not in a live System!)

I had do create a new package - now it works as it should.

Sometimes it's better to start at the beginning ;)
Verified answer

S.Kawamura 1,524 on at

Like (0)

Report

RE: How to delete all database records (contacts for example) (not in a live System!)

Hi,

Import one record with the "Delete Table Records Before Processing" checkbox turned ON. Then, delete the imported contact.

If there are zero records to be imported, the "Delete Table Records Before Processing" flag will not work.

I hope this is helpful to you.

S.Kawamura
Suggested answer

Inge M. Bruvik 1,029 Moderator on at

Like (0)

Report

RE: How to delete all database records (contacts for example) (not in a live System!)

The easiest way is to do it in code.

But if you can not do it in code. You can try to use the edit in Excel if that function is available for the table you want to delete data in. It should be available for contacts.

So you use edit in Excel, delete all the records in Excel and then update back to Business Central.
Suggested answer

MahGah 15,445 on at

Like (0)

Report

RE: How to delete all database records (contacts for example) (not in a live System!)

Hi

In configuration package if you download the package and delete all lines and leave only one line (it is important to leave one line) then select "Delete Table Records Before Processing" then it should delete all contact and leave you with one contact that you can delete manually.

What is your goal and why the above method did not work the way you wanted it?

The other method is to ask you partner to create a page that gives you access to entire contact table and then you can delete from that page.