Import From My Gun DB to NM Collector Software
I have been approached by several owners of My Gun DB
software to see if I could help them migrate their data to NM
Collector Software. After investigating this situation I discovered
that there is a way to do it using .csv (Excel) formatted files.
Please see the following instructions with screen captures for key
steps in the process.
- Items are ordered in the NM Collector Software treeview
according to the order in the spreadsheet. If you want a different
order it is best to change the order in the spreadsheet before you
- Serial numbers are blocked in the screen captures below to
protect the privacy of the owner of the data who gave me permission
to use his data as an example of how to do this.
Step By Step Procedure
- Start with a fresh copy of NM Collector Software. You can
download it for free and install it on your hard drive or a
removable flash drive. Make a backup so you can recover the default
database in case you need to start the import process over
- Since My Gun DB exports a few fields that NM Collector
Sofware does not have by default, we need to add the Bluing,
Barrel Length, Sights, and Manufactured fields from My Gun DB to
the Description tab in NM Collector Software. Really, you can use
any available field in any tab but the Description tab seems the
most logical for these fields.
- Next we will add the Accessories field to
the "Notes" section of the "More" tab of NM Collector Software.
Some people just add the Accessories from My Gun DB to the Notes of
NM Collector Software but that will only work during the import if
you combine your notes with your accessories in the spreadsheet
- Now that we have defined the additional fields from My Gun
DB that we need to import into NM Collector Software, we will
export the sample data from NM Collector Software to the JE
formatted .csv (Excel) file. This will give us something to work
with when reformatting the exported data into the NM Collector
Software expected format. The name of the exported file is JEFirearms.csv.
I made a copy of this file and named it JEFirearms1.csv
so that I would not lose my changes in case I had to re-export my
NM Collector Software data.
- Next, we will delete the sample data that comes with NM
Collector Software. Since you will be importing your real data from
My Gun DB you do not need the sample data.
- At this point, we turn our attention to the .csv
(Excel) files where we will actually copy and reformat the data
from My Gun DB (MyGunDBExport.csv)
to NM Collector Software (JEFirearms1.csv).
First, delete the sample data from JEFirearms1.csv.
Now that we have our headings in our exported .csv file we no
longer need the sample data.
- Then we copy data from the MyGunDBExport.csv
file to JEFirearms1.csv. You can select all of the
data in a column (do not include the header),
- Right click the selected cells and select
"Copy" from the drop down list,
- Click in the first cell in the appropriate column of
JEFirearms.csv (just below the heading) to select the cell, then
right click the cell and select "Paste" to paste
all of the copied My Gun DB data into the NM Collector Software
- Repeat this process for all of the data that you
want to import from My Gun DB into NM Collector
. Due to some apparent inconsistencies with the format My Gun DB
uses to export the data to .csv (Excel) some of the dates will have
to be reformatted to properly import into NM Collector Software.
Please see screen captures below for details.
- You are now ready for the final step to import your data
from My Gun DB to NM Collector. Go back to NM Collector, select
File > Import > From JE CSV
Then select the JEFirearms1.csv that you just
With a little more work, you can bring the pictures over. When you exported the sample data to get your csv format you might have noticed that there is a folder named Firearms1 in the same directory as your exported file. This folder contains the pictures for the item 1 in your csv file with the value of 1 in the NMCSWITEMID column.
I do not know how you will get your pictures from My Gun DB but I am assuming that they are exported somehow. So, this is how you can import those pictures into NM Collector. Please see screen captures below.
When you manipulate the csv file to import data into NM Collector, make sure you add unique (please, no duplicates!) sequential numbers in the NMCSWITEMID column. Then, add a folder containing pictures of each item in the same directory as your csv file. Name the folder according to the NMCSWITEMID in your csv file. So, if your gun with an item number of 3 has pictures, create a folder named Firearms3 and put your pictures for that item in that folder.
Here are the screen captures:
Sample data export directory contents:
Contents of csv file with sample NM Collector Data:
Adding pictures folders for firearms 2 and 3:
Your My Gun DB data is now imported