Skip to content

On demand · Product video

Set up Import Export PowerTool

For administrators who have just installed the app and want to control who can import, update, and delete data.

Recorded September 8, 2022 · 5 minutes

Import Export PowerTool setup video thumbnail

Summary

This video walks through the first setup of Import Export PowerTool after it is installed. This is a completely free app from Insight Works for Business Central. It starts with the two permission sets that come with the app: a manager set that can change the setup and a user set that can only use what the administrator sets up. It then opens the app for the first time, runs the setup, and explains the access options for updating and deleting data, enhanced confirmation, disabling the change log, and protected tables such as item ledger entries and warehouse entries. Once the setup is done, the app opens with its import, export, delete, and update actions.

Key topics

  • Assign the manager and user permission sets
  • Allow update and delete access with enhanced confirmation
  • Decide whether users can disable the change log
  • Restrict access to protected tables such as ledger entries
Read the transcript

Hey everyone, I’m going to take you through a little bit of the setup of the Import Export PowerTool from Insight Works. After you install the PowerTool, the first thing you need to do is assign the permission sets to the appropriate people. Of course, if you’re a super user doing initial system setup, you probably won’t need to assign them, but on an ongoing basis you’ll want to make sure you assign the appropriate permissions to the appropriate people.

So I’ll just show you the permission sets that come with the system. We’ve got two: the manager and the user. The manager gives you the ability to modify the setup, and the setup allows you to restrict access to specific capabilities within the PowerTool. The user doesn’t have the ability to modify or even see the setup; they can just use whatever’s been set up by the system administrator. So for people who aren’t allowed to do certain things, you’d set them up as a user. For people who are allowed to modify the setup, you’d set them up as a manager. And again, if you’re a super user, it doesn’t really matter.

After you’ve done that, you’re going to find the Insight Works Import Export PowerTool. I’ve gone in and bookmarked it here. When you open it up for the first time, it’s going to prompt you and say you haven’t run the setup yet, please go check that out. So let’s do that. I’ll go through these fields very quickly and then we’ll see what they actually do. The PowerTool has the ability to update data and delete data, as well as importing and exporting data, but we give some access control over that, so we can prevent people from updating or deleting data.

I’m going to allow people to update data, but I’m also going to use this enhanced confirmation, which prevents people from accidentally just clicking through a confirmation box. It forces them to think about what they’re doing a little bit. So I’m going to provide update and delete access for any user that’s using it. Of course, their other permissions still come into play, so if I try to delete data from a table I’m not allowed to delete from, it will yell at me and prevent that.

Disable change log allows us to let users disable the change log when they’re making changes. When you’re doing massive imports, you may want to disable it to prevent a lot of additional records from being created. I’m going to leave that as no access, so people can’t disable the change log when they’re doing something in the system.

Finally, protected tables are things like item ledger entries, warehouse entries, or posted sales invoices. The PowerTool is a tool for power users, and it does give you the ability to import, export, delete, and modify things like item ledger entries. I think G/L entries are actually excluded, but a number of the tables that are protected by the system can be changed. Where you might find that useful is, for example, if you’re converting a location to use bins, you might want to import warehouse entries. Or if you accidentally forgot to put an address on a posted shipment, you could update that after the fact. There are lots of reasons why you might want to do that, but by default I would leave that as no access, which means we can’t access those protected tables.

All right, so once we’ve got the setup done, it opens up our PowerTool and gives us our options. I always pin the action bar here so that it’s always visible. We’ve got import, export, delete, and update, all the database activities you might want to perform. And that’s basically how we set it up: you check the permission sets, then you do the setup and indicate what you want, and you can start importing and exporting data.

Questions about this webcast?

Send your question and the Insight Works team will reply by email. Ready to plan a project? Contact your Microsoft Partner.

Ask a question

Webcast Questions