Home Button  Buy Button 

Topic:   Importing data from other software

By: GuestPosted on: Apr 3 2022 at 02:05:45 PM
I have data from another mrp software that used SQL Server 2012 Express. My computer failed. I have backup copies of the database. The mrp software is no longer available and is not supported. I found a converter online that enables me to create .csv files from the old database file. Can I somehow import this data into miniMRP?

By: SupportPosted on: Apr 4 2022 at 05:45:12 AM
If you had a CSV file that lists the part number, description, onhand quantity etc of each inventory item then you should be able to import that.

Same thing with suppliers. Name, address, phone number, etc. in a single CSV. That should be importable too.

Do you have product parts lists BOMs as CSV files? These might be importable but we'd need to see what they look like - what the layout is. If you have that you could maybe email it and we'll take a look?

By: GuestPosted on: Apr 4 2022 at 06:29:00 AM
I have part numbers, descriptions, etc and supplier data. I can easily re-create the few BOMs. It sounds like I'm good. Thanks!

By: EricPosted on: Apr 11 2022 at 04:50:06 PM
what is the process for importing an inventory list and BOMs from excel files? thanks

By: SupportPosted on: Apr 12 2022 at 02:31:56 AM
Importing your inventory.

In excel load up the sheet containing your inventory then, in excel, select the option to 'Save As' and save as CSV.

Then in MiniMRP look at the menu on the left of the program window. See the "Components" menu. Open that and you see the button for "Inventory Import CSV".

Same thing for importing suppliers, customers.

By: GuestPosted on: Nov 5 2023 at 04:39:48 PM
Picking up on this older thread, the "MRP" package I've been using for a few years was abandoned once the owner/developer died a few years back (not P&V but a product called VMP). It still works but is severely lacking.

I can export the inventory, BOMs, suppliers, etc in CSV files, view the existing database with DB_Browser, etc. but want to migrate over to MiniMRP. I'm assuming that the CSV file being imported by MiniMRP needs to be structured in a specific fashion, but can't find anything here that defines this order. At present the "Parts" CSV data is organized by Item number, Part Number, Description, Stock, Cost, . . . What does MiniMRP expect to see during an import? This applies to the other files (BOMs, Suppliers, etc.).


By: GuestPosted on: Nov 6 2023 at 10:18:18 AM
When you import inventory from CSV you first select your CSV. MiniMRP reads in the first few lines and displays them. with the columns numbered 1 to ?

You then have the option to tell MiniMRP which column should be imported for Part Number and which column as Description and which column is cost etc etc.

So it doesn't matter what format your CSV is it because you can select the columns and MiniMRP imports it.

By: GuestPosted on: Nov 8 2023 at 10:57:29 AM
Thank you very much! That's what I was hoping for, I'll try that later today.

By: GuestPosted on: Nov 11 2023 at 04:15:09 PM
Unfortunately the Parts.CSV file as exported by the older MRP uses a semicolon as the column delimiter, commas are allowed inside each column and I made use of them to separate the text as below:

Item P/N Description
433 760222-499 Resistor, 49.9k Ohms, 1/4W, 1%
434 760222-501 Resistor, 50.1k Ohms, 1/4W, 1%

The same issue occurs in the BOMs when exported, commas were used between reference designators, . . probably in other files as well.

Is there a way to tell the MiniMRP CSV Import utility to use a character other than a comma when importing various files? I looked but could have missed it.


By: GuestPosted on: Nov 12 2023 at 04:47:36 PM
Got it basically working now with a bit of editing of the CSV files, please ignore the previous post.

By: SupportPosted on: Nov 13 2023 at 06:30:07 AM
When you pop open the window to select your CSV file take a look in the bottom right corner just above the Open/Cancel buttons.

You see a drop down list where you can select the delimiter. Comma, SemiColon or Tab

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:- Importing data from other software

Enter the numbers.

Your name here is optional