Skip to main content

Notifications

Announcements

Announcing Our 2025 Season 1 Super Users!
Announcing Forum Attachment Improvements!
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / exporting extra database
Small and medium business | Business Central, N...
Answered

exporting extra database

(2) ShareShare
ReportReport
Posted on by CU15011641-0 59
Hi,
I am learning Business Central.
When i am exporting data (for example customer, table id 18) there are some extra no. of database records also inserted. please let me know how to fix that.
 
Thanks
Categories:
Dynamics 365 Business Central
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 77,147 Super User 2025 Season 1 on at
    exporting extra database
    It is recommended to delete them through Configuration Package.
     
    Thanks.
    ZHU
  • Suggested answer
    CU15011641-0 Profile Picture
    CU15011641-0 59 on at
    exporting extra database
    Thank you for your reply.
    my permissions looks good. its only the export process through configuration packages which exporting 50+ more extra no. of records/ database in my excel file. can you please help .
    Also, there are too many extra customers (all blank, just a number series associated with them) please let em know how to delete them in a bulk.
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 77,147 Super User 2025 Season 1 on at
    exporting extra database
    This should not happen. Unless your permission only allows you to see limited records.
    You can directly click on table 18 on the page to see how many records there are in total.
    Viewing table data:
     
    Thanks.
    ZHU
  • CU15011641-0 Profile Picture
    CU15011641-0 59 on at
    exporting extra database
    Hello,
    Thank you replying to the post.
    Yes, i am exporting customer data by using configuration packages and getting extra no. of records (for example when i am writing the table id 18, it says customer and no. of records are 22, when after exporting the no. of records goes up to 36, so 14-15 extra no. of records i am getting with every export)   please let me know how to fix them. i don't want extra no. of records to be exported with my data.
     
    Thank you.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,785 Super User 2025 Season 1 on at
    exporting extra database
    Can you provide more information? Are you exporting the data using configuration packages? When you mention 'extra database records,' do you mean there are more records than you need in the exported data, or are additional tables being exported? If you're using configuration packages and there are more records than you need, you can use filters in configuration packages to only export the data you need.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Our 2025 Season 1 Super Users!
Announcing Forum Attachment Improvements!

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans