Home Button  Buy Button 

Topic:   Inventory DB access for quantity control

By: JimbostonPosted on: Jul 14 2007 at 12:45:28 AM
I`ve been looking around for BOM/Inventory software and miniMRP is really impressive. Everything else out there is more complicated than I need.. I was up and playing with the trial version in 5 minutes.

In any case, is there any way to expose an interface to the DB for the purpose of inventory quantity updates?

Currently we use an access based system, and a wireless barcode reader is used to pull from inventory in real time. Additionally, when adding items to inventory, it seems quite time consuming to do it via the conext menu quantity... if there was any way to expose either an ODBC connection to the DB to use SQL or some such, we could just roll our own modules for inventory management. Any ideas that might help me?

Thanks, and great job

Jim

By: GuestPosted on: Jul 14 2007 at 02:29:20 AM
Actually even a facility to import a comma delimited inventory "change" file would do the trick for us. Perhaps something as simple as

"(partnum|unique id), (rem|add), (quant)"

By: SupportPosted on: Jul 15 2007 at 02:11:21 PM
You have two possibilities.

First one - Take a look at the CSV import capability. As well as importing new inventory items you can also update the quantities of items which already exist.

Next option - You used the words SQL and ODBC etc in your post so I`m guessing you`ll like this one. miniMrp uses a 100% JET compatible database format. You can open, read and write to the database file (EMRP.AXI) using any JET compatible application such as MS Access or any JET/DAO/ADO application you might wish to write yourself. You can even include your own VBA routines, forms, queries etc into the database file if you wish.

You shouldn`t have any problem at all creating a small application which scans your barcode data right into the database.

Couple of things you need to be aware of. You`ll need at least MS Access 2000 or above if you want to open the database using MS Access and if you do open the database with MS Access you may see a prompt to convert the database. I`ve never had any problems if the database is converted to a true Access 2002, 2003 format but I`d suggest not doing that unless you really have to.

Once you`re in the database looking at tables etc you`ll see that tables have sensible names so you should be able to see where everything is. Altering data, such as changing the on-hand quantities etc shouldn`t be a problem but it might not be so obvious how to add new records. miniMrp makes great use of SQL Joins at run time so data might be scattered through different tables in the database and new records in one table often require matching records in other tables meaning it isn`t always obvious where to add new records to the database.

We don`t have an actual database layout/description document but if you get stuck let me know what you`re trying to do and I`ll explain how the relevent tables hang together.

By: JimbostonPosted on: Jul 16 2007 at 11:29:51 PM
I was hoping for a response like that! Thanks for getting the . This sounds like it`ll be easy! I`m going to give it a shot. If it works for us, consider that a sale...

Thanks,

Jim

By: Marvin E.Posted on: Feb 23 2013 at 03:06:28 AM
I'm doing the same...I'm impressed with your simple, straight forward application. And yes, after some successful ODBC driven tests, you can consider that a sale! Thanks!

By: SupportPosted on: Feb 23 2013 at 11:07:57 AM
I will add that this thread was started a few years ago and the database has changed quite a bit since then.

MininMrp v3 and below (3.7 etc) use a database file called EMRP.AXI

MiniMrp 4 uses a database file called MRP4DATA ( no filename extension)

This database file may be password protected but we're happy to give anyone the password if they ask.

MiniMrp 4.1 (release due Mid 2013 will use either the same db as v4 but can also migrate to SQL Server.

By: GuestPosted on: Feb 24 2013 at 03:33:24 AM
Thanks for response. I was going towards ODBC as I normally would. Would you direct me to how I could go about this? wouldn't I need a driver to setup a DSN in odbc admin? Thank you.

By: SupportPosted on: Feb 24 2013 at 12:57:51 PM
The EMRP.AXI and MRP4DATA files are simple JET database files so you can use the same methods that you would use if you were accessing an MS Access database file.

By: Guest Posted on: Feb 25 2013 at 06:01:43 AM
Dont' know what I was thinking..thanks again for quick response. I've created a connection to MRP4DATA, and it is asking for a password. Could you please email me one, marvine@............ Thanks very much.

By: DaveS Posted on: Mar 21 2013 at 04:03:30 PM
Could you email me the database password please
davi---ter@-----el.org

By: SupportPosted on: Mar 21 2013 at 04:50:08 PM
Sent to your email.

By: GuestPosted on: Jan 25 2017 at 08:25:23 PM
I have a unique inventory import of 10000 items and would like to get most of the fields in. Looks like I will need to write something to do that,which is OK. Can you provide the password to my email.

By: GuestPosted on: Jan 25 2017 at 10:48:01 PM
Not Sure how to provide you my email address for the above password request

By: GuestPosted on: Jan 26 2017 at 07:55:27 PM
You can send an email to
support at minimrp dot com

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:- Inventory DB access for quantity control


Enter the numbers.

Your name here is optional