Home Button  Buy Button 

Topic:   Import (csv)

By: GuestPosted on: May 3 2012 at 09:32:00 PM
Hello,
I am a trial user and I am trying to import a cvs file which I created from an xls file...but minimrp does not recognize the greek fonts. Is there any specific font to use?

By: SupportPosted on: Jun 23 2012 at 08:27:41 AM
Are you able to send us the csv?

support at minimrp.com

.

By: GuestPosted on: Jun 23 2012 at 09:24:18 AM
Guy's

I have sent the CSV file by mail

Stu

By: SupportPosted on: Oct 23 2012 at 07:06:13 AM
Latest update now allows importing of CSV files that contain Cyrillic, Greek and a few other non-English alphabets.

By: GuestPosted on: Dec 9 2012 at 05:42:38 PM
I am a trial user. I want to import a CSV file that contains part Desciptions with commas. How can I do this?

By: SupportPosted on: Dec 9 2012 at 10:06:30 PM
You need to know how your CSV file is formatted. Normally each column of data is separated by a comma but this will be a problem if your data contains commas. For example if you were in a country where your numbers had a comma as a decimal point.

In such cases it is common for columns to be separated by a semicolon. MiniMrp allows you to select semicolon in the import window.

But MS Excel often separates columns with quotes as well as commas. Mini!rp will handle that eventuality automatically.

If you are stuck then you can email your csv to us and we'll be happy to advise.

Send to

support an minimrp.com

.

By: GuestPosted on: Dec 10 2012 at 02:19:59 AM
I have no semi-colon in the data. I can use the semicolon delimeter. Thanks for the speedy answer.

By: GuestPosted on: Dec 19 2012 at 08:17:55 PM
When I import a CSV the "price" column is assigned to the "sell at" field, not the the "cost price". Can you fix this?

By: SupportPosted on: Dec 20 2012 at 09:42:49 AM
The problem with the 'cost' price is that it's always related to a vendor. MiniMrp allows each item in the inventory to have an unlimited number of vendors each with their own cost prices and units of measure. This flexibility means that, at the moment, we can't import vendor/price information.

It is something we intend to look at once we finish some other, more important, updates.

By: GuestPosted on: Feb 2 2013 at 06:53:40 PM
On initial use, importing a csv and assigning my columns to your defaults is fine - but how do I include more of my own columns in the import - I cant see how to include extra columns.

By: GuestPosted on: Feb 2 2013 at 08:31:17 PM
You can only import the default columns.

By: Rob FPosted on: Feb 22 2013 at 03:08:50 PM
The ability to only import the default functions is a big limitation to using this package quickly. My excel spreadsheet has information about the supplier, manufacturers part number, suppliers part number - plus other important information. With several hundred parts, this is an aweful lot of work to add manually when transferring. I see the custom fields as imperative to allow the database to hold my parts usefully. Is this going to be a permanent limitation?

By: SupportPosted on: Feb 23 2013 at 11:18:02 AM
We keep talking about improving the import capability but just don't have enough people asking for it to make it worthwhile.

Having said that I really think we need to improve this although this isn't likely to happen within the next few months. We're all tied up with other more important updates.

By: David SPosted on: Mar 21 2013 at 03:27:53 PM
I am in the import CSV area but can only see 7 Column headings on right hand side when I have 15 columns. To import the test files that we need we have to have all the columns or import manually which we take too long. Is this what you would expect?

By: GuestPosted on: Mar 21 2013 at 03:33:00 PM
So this issue is not really about the columns although that would solve the problem, it is the ease that changes can be made in excel compared to the difficulty in Mini MRP. We are only working with 350 parts but still having to enter each cell individually is far too time consuming. If we could designate all columns we could be done in 10 minutes

By: David SPosted on: Mar 21 2013 at 03:47:12 PM
The attraction of Mini MRP is simple and basic as MRP systems go so at this level EXCEL is the current surrogate that we use. So a good import capability with mapping that would import all the data would be a very easy sell to management. However we cant do that because of this apparent limitation of seven columns. The transition cost changes from the cost of the software to pull our existing data to the cost of the labor to enter it because we cannot import our data from existing EXCEL. The software cost is insignificant in the second case. I hope that I am misunderstanding the because this is such an easy program to use.

By: SupportPosted on: Mar 21 2013 at 04:56:01 PM
David, as per your request (in a different thread) we sent the DB password allowing you to import manually.

Just out of interest though - what do your 15 columns contain ?

By: GuestJBPosted on: Apr 8 2014 at 04:38:26 PM
Hi, Is there a way to import Assemblies and Units? The CSV export headings are not the same as the import ones and it currently means I have to go back and edit every PART to change them to ASSY once imported.....very time consuming as opposed to part of the quick import?

By: SupportPosted on: Apr 8 2014 at 08:44:49 PM
I think we got this from you by email ? The 'TYPE' column is currently not imported. All parts are initially imported as components and then you manually change the type.

But I agree that this could get tedious if you had 100's of assemblies. We will add the 'Type' column to the import in a couple of days. In the meantime - do you have a column in your CSV that contains the word 'Assy'. It must contain that exact word otherwise it will be assumed to be a 'Part'/Component ?


By: GuestJAFPosted on: Jun 28 2015 at 06:16:45 PM
I attempting to import parts from an Access database that have individual entries for a part, along with duplicate MFR part#'s with unique supplier part numbers and prices.
Is there a way to link the supplier part numbers with a primary manufacturer part number during import?
I can export to csv file and manipulate that. I have roughly 500 unique parts to import and around 100 alternate supplier entries. I would be most appreciative if I don't have to hand enter these.
Thanks.

By: SupportPosted on: Jun 28 2015 at 09:45:10 PM
You can import parts with Your Part Number, Supplier's Part Number, Supplier's Price

Unfortunately you can't import 'alternate' supplier's part number, manufacturer etc.

By: GuestJAFPosted on: Jun 30 2015 at 08:06:32 PM
On another export/import note, when you export from the component library, you don't export the supplier name, but you do export the supplier part number. WHY?
Also, is there any way to free-form update the description field without opening each component? I was attempting to export the components, make changes in Excel then re-import. That does not seem to work well when the supplier name is missing. :-( Unless you would be willing to provide a password to the jet database so that i can use access to update directly.

By: SupportPosted on: Jun 30 2015 at 08:25:02 PM
I'm nor sure why it doesnt export the supplier name. I'll need to have that checked.

It's your data so of course you can have the password.

Email us

support at minimrp. Com

By: GuestPosted on: Aug 27 2015 at 04:55:53 PM
What does it mean when the Import Y/N column says "Updated"? These items are not being imported into the database.

By: GuestPosted on: Aug 27 2015 at 05:54:12 PM
If you import new inventory items the "Imported Y/N" column indicates whether a specific item was imported. If it says "Imported" then it means that the item was successfully imported.

If the item already exists in your inventory then it will not be imported again. But if you had selected options to update the quantity or include new supplier data then the Y/N column says "Updated".

I have noticed that even when the supplier or Qty options were not selected it still says "Updated" even though nothing was actually changed at all.

By: JessePosted on: Sep 21 2015 at 09:33:41 PM
Hi,
I'm having a difficult time when creating New Assemblies, type ASSY. For some reason when I import "Read Partslist/BOM from CSV" to a New Assembly, the Built Cost doesn't update, stays at zero. I have done previous assemblies and didn't have this issue before. I checked every component to make sure they all have a cost, I checked quantities on components, I ran a test for a new assembly with different components getting the same results. I checked everything I could possibly check and can't resolved the issue...

Any advise on what I might be missing, doing wrong or what else I can check, will be appreciated.

Thank you,

By: GuestPosted on: Sep 23 2015 at 04:25:40 PM
Not sure why the cost isn't updating.

Go to the tools back/restore window and run the check/compact/resync process.

Does the cost appear now?

By: GuestPosted on: Dec 3 2015 at 01:59:37 PM
I am trying to importing my inventory using the 'Inventory Import CSV' feature. I have four columns in my CSV file part number, description, quantity on hand, and cost. I enable the 'include supplier data' information, and chose the cost column for the 'supplier cost' field. When I click import, it shows me the data it is going to import and everything looks great. However, when it finishes importing and I click on the 'All Components' button, the supplier cost is $0.00 for all the parts. What am I doing wrong?

By: SupportPosted on: Dec 3 2015 at 09:06:08 PM
You sent the same question by email which we answered but I'll still answer it here in case anyone else has the same problem.

In your case it's the dollar symbol. The cost column needs to be just the numbers. No currency symbol.

By: GuestPosted on: Mar 10 2020 at 11:39:09 AM
The program I am using now I import daily:
Inventory on Hand
Purchase Orders for raw material
Manufacturing Plan

I export material requirements (it puts in the order we need going out several months)

Can this program do this?

By: Guest JasonPosted on: Mar 11 2020 at 05:44:17 AM
MiniMRP can import inventory from CSV. Not purchase orders or manufacturing plans. It creates its own purchase orders and its own work orders.

But can I ask, where is this data coming from? It sounds like you have some other program (programs?) doing your inventory, purchase orders and manufacturing.

Why can't that 'other' program do what you want? Having separate programs and transferring data every day to keep them in sync really is not ideal.

Take a long look at MiniMRP. It may be that it does everything or most of what you need and then you can stop transferring data between multiple programs - or at least minimize it somewhat.

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:- Import (csv)


Enter the numbers.

Your name here is optional