Emma: Ever find yourself just staring at Business Central waiting for data to import, or maybe wrestling with those complicated Excel files?
Ryan: Yeah, it’s a common headache. We’ve all been there.
Emma: We really have. So today we’re diving into making that whole process work. Well, hopefully a lot easier and definitely faster.
Ryan: Exactly. We’ve been looking into this free tool from Insight Works. The Import Export power tool.
Emma: Right.
Ryan: And its whole mission really is just to make Data migration in B.C. smoother. Less fuss.
Emma: Okay, less fuss. Sounds good. So the headline number I saw was what, up to 30 times faster than RapidStart.
Ryan: That’s the benchmark they’re putting out there? Yeah, based on their tests. And it’s a pretty significant claim.
Emma: 30 times. I mean, think about that. A job that takes say four hours could potentially be done in like under 10 minutes.
Ryan: Something like that.
Emma: Potentially, yeah.
Ryan: It bypasses some of RapidStart’s complexities, especially with large data sets. That’s where the speed really comes in.
Emma: And it doesn’t force you into Excel. Right. I saw something about text files.
Ryan: Correct. You can use Excel if you want, but it also works great with just plain tab delimited text files. You can even edit them in something basic like Notepad F. Okay.
Emma: That’s flexible. And it tackles more than just the standard tables, doesn’t it? Our sources mentioned it can get into areas usually off limits.
Ryan: Uh huh. That’s a really key point. If you have the necessary permissions, and that’s crucial. You can actually work with tables like say, Atom ledger entries directly.
Emma: Wow. Okay. So direct access to ledger entries, that gives you a lot more control.
Ryan: It does. Which naturally brings up the question of who this is really built for.
Emma: Right. Sounds powerful. The info we saw definitely points towards, you know, developers, consultants, maybe power users. People comfortable under the hood of bc.
Ryan: Precisely. It’s not really for the casual user. It assumes you understand the data structures. It lets you export, import, update, and even delete data.
Emma: Ooh, delete. That sounds potentially risky.
Ryan: It absolutely can be. You need to be careful, use filters wisely, and again, have the right permissions assigned in Business Central. The tool respects BC security.
Emma: Good to know. So practically speaking, how does it work? Walk us through the basics.
Ryan: Sure. So first you grab it from AppSource.
Emma: Standard Install Microsoft’s App Store, basically.
Ryan: Yep. And then honestly, the very first thing you should do is configure the user permissions for the Tool itself. Don’t skip that. Right.
Emma: Permissions first, always.
Ryan: Then say you want to get data out. You can export whole configuration packages. You know those bundles of tables?
Emma: Yeah, the standard way.
Ryan: Or you could just pick individual tables and it spits out these clean tab delimited text files fast.
Emma: And those text files are easier to handle than the package file?
Ryan: Oh, much easier. You just open them in Notepad plus plus, Excel, whatever. Make your changes directly in the data. No need to mess with the configuration package structure itself.
Emma: I see. So edit the text. Then what?
Ryan: Then you just point the tool to that file to port it back into another PC environment. Sandbox, test production wherever.
Emma: And it’s not just for bulk migrations. You mention updates and deletes.
Ryan: Exactly. You can use filters to make very precise changes, update specific records, delete incorrect entries, maybe even trigger some logic if needed. Even in places where there isn’t like a regular page in B.C. to do it.
Emma: That sounds incredibly useful. Can you give some like real world examples where this would be a lifesaver?
Ryan: Oh, definitely. Think about quickly populating a sandbox with production data for testing, or fixing a batch of incorrect item ledger entries without needing a developer to write code.
Emma: Okay, that’s huge.
Ryan: Or importing serialized items and having it generate the lot numbers automatically. Even loading historical data without using slow drop general journals, stuff like that. Big time savers with all that power.
Emma: Especially the update and delete. How safe is it? You mentioned permissions, but anything else?
Ryan: Well, like I said, it fully respects your standard Business Central permission sets. That’s the main thing. But the tool also provides filters, so you only touch the data you intend to. Plus there are confirmation prompts you can enable and you have control down to the field level to help prevent accidental overwrites or deletions. It’s designed to give power, but controlled power.
Emma: Okay, so the big takeaway here seems to be it’s powerful, it’s flexible, and crucially, it’s free. No user limits, no hidden costs.
Ryan: That’s right, completely free. It seems really aimed at consultants, developers, integrators, anyone who’s frequently moving or manipulating data within Business Central.
Emma: So if you’re listening and you spend way too much time on data migration or data fixes in BC, yeah, this.
Ryan: Could genuinely change how you work.
Emma: Then the call to action is pretty simple. Go to app source, search for the Import Export power tool by Insight Works and give it a try.
Ryan: Absolutely. And maybe just, you know, think about how much time you get back on your next project, how much frustration you could avoid it seems well worth the zero cost of admission.
