Home Button  Buy Button 

Topic:   Updating Components that already exist in database

By: StephenPosted on: Jan 14 2017 at 03:35:19 PM
I have made progress with my trial and imported some parts and assemblies.

I now need to update some components, to add / change the data (e.g. category). I tried several times but was unsuccessful and the component data doesn’t change even after refresh etc.

Here’s what I did, Keeping in mind parts do pre-exist in the db…

I clicked Inventory Import CSV; selected file and columns to update; imported; reviewed the results - says all were ‘updated’.
Note: A pop-up window noted ... " Any rows that were successfully imported will not be imported again so it doesn't matter how many times you retry the import.". hmmm...

Return to All Components list , refresh , no change.

Can someone help? Obviously I am not understanding something. It's like the components are locked (I did try unlocking them in the window fwiw).

By: StephenPosted on: Jan 14 2017 at 04:26:21 PM
Support replied:
Once an item has been imported the only thing that can be 're-imported' is the Vendor data (price etc) and the OnHand quantity. Everything else, description, category etc is not re-imported.

With their help, I did the one category in the Component by Category list and it worked.

But this is a problem for us. Our data comes from many sources and we like to clean it up and change it from time to time, after it gets imported. We do that in Excel and then re-import it.
With miniMrp, we would have to export all the items and all the assemblies, clean the items up, reimport them. Sometimes, we just want to add data, like 'category' to items, or change the category to a new one.

In my mind, if you import a column of data then you are wanting to update the data in that column otherwise why select it? The option I see, if you want to maintain the current functionality, would be to have another Checkbox that asks, "Update existing components?".

I'm surprised no one ever mentioned this. Any other suggestions?

Not sure if this is a bug & fix, new feature or not currently planned.


By: Ken at DTSPosted on: Jan 17 2017 at 02:17:53 PM
For mass changes, such as adding categories to thousands of previously-imported components, we bought a copy of Microsoft Access to directly manipulate the database. This requires great care (and plenty of backups!) but can save time when many repetitive changes need to be made.

By: GuestPosted on: Jan 18 2017 at 03:53:56 PM
MiniMRP isn't based on MS Access and doesn't need a licence for MS Access. It just uses the same Microsoft standard data file format. The MiniMRP data file can, as Ken said, be opened and edited with MS Access.

But you really shouldn't poke about in the database unless you understand how relational databases work. The data is linked across numerous tables in the database that makes it fast and efficient for computers to read/write. But not very human readable.

By: HPPosted on: Jan 18 2017 at 04:00:31 PM
Editing some of the data with MS Access is actually quite easy. Cursoring down the list of inventory editing the categories of each item is quite simple.

But adding new items needs new records in more than one table (locations and vendor tables) which can be confusing.

I just asked Support which tables I needed to update. I told them what I wanted to do and they told me exactly which tables needed to be updated and even sent screenshots.

By: StephenPosted on: Jul 31 2017 at 03:29:48 PM
Has there been any updates to the program to accommodate this?

By: SupportPosted on: Aug 1 2017 at 12:17:44 PM
No. The way it is is the way it's always been.

But in the next version we do intend to improve the csv import capability. But you just know that no matter how much data we update/import from csv somebody will always want some more so this is a feature that will never satisfy all users all of the time.

By: StefanPosted on: Mar 5 2018 at 05:02:17 AM
I would also find CVS import very useful to ba able to clean and update component descriptions, Loc, Category and so.

You be very very helpful and save tons of time.

Let us know when you will implement this feature. Thanks

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Updating Components that already exist in database

Enter the numbers.

Your name here is optional