Peter works at a hotel/resort in Florida and had a great question about importing data into SpendMap…
“When I import my items, it just keeps adding the new items to the items that are already in the system. Is there any way to start over and replace everything with the next list of imported items?”
Yes, by default all Master File imports in SpendMap will add to what is already in the Master File. This is true not only of brand new items, but also new or changed fields for a particular item. So, for example, you can import the same items over and over again, perhaps to update pricing or other details on an ongoing basis.
But if you’d like to start over, just enable the setting “Allow purging of master files when importing“, in the [Permissions] folder of the User Master File, and then you will see the following prompt the next time you run any of the Master File imports…
We’ve had a few requests for help with importing your items (item catalogs) into the free Purchase Order Software during initial system setup (saves time over keying in all the item details manually).
So to help you out, we put together a new video tutorial on importing items into the Item Master File.
The video actually covers many generic concepts about SpendMap’s built-in integration tools, not just importing items, so it will also be helpful for you when importing other Master Files (suppliers, account codes, assets, etc), as well as setting up transactional interfaces (e.g. exporting approved invoices to your Accounts Payable system, etc.).
TIP: As you’ll see at the end of the tutorial on importing items, we’ve added a sample import configuration to your Evaluation System, along with a sample spreadsheet containing a few sample items that you can use to test the import utility. If you recently downloaded the free version, you may need to select the menu Help > Check For Updates to get these files.
You can watch all 14 video tutorials to help implement your free Purchase Order Software on our YouTube channel.
Thanks, and please keep the feedback coming!
I recently helped a Free-Procurement customer with importing his items into the Item Master File in SpendMap and I thought a couple of the tips I gave him would be useful for you as well.
What I’m going to outline here applies to importing most of the system’s Master Files, not just items…