Wednesday, September 9, 2009

Import data into nopCommerce

skiltz.nopImport
Current Version - Alpha 0.1 *****NOT for Production Systems******

What does skiltz.nopImport do?

skiltz.nopImport will import data from a data source into the nopCommerce database.

What assumptions are made?- Each product has 1 product variant and zero attributes.
- Only products with SKU's that don't exist in nopCommerce will be imported.
- That you have a ProductTypeID that = 1
- That you have a TemplateID that = 4
- That your product images are stored in the database(nop Default) not on the file system.
- That you can remotely connect to your nopCommerce database.
- That your product images are on the file system.
- .net 3.5 framework is installed on PC

What data sources can I Import from?
Currently you can import from Excel or Microsoft Sql Server.

Where can I get help?
Please post all bugs on the nopCommerce forums or email mskilton@gmail.com

Install guide.

Where can I download the installation from?
It can be downloaded from http://skiltzonnet.blogspot.com


Double click on the install file and follow the prompts.


To open the program go to "Program Files"/skiltz/skiltz.nopimport

Steps to complete a import.
Step 1:
Right Mouse Click on NopSqlConnection and click "Update Connection String"
• Type in your server name i.e /home/sqlexpress
• Choose if using Windows Authentication or username and password
• Type in your database name
• Click test connection
• If successful then click ok

Step 2:
Right Mouse Click on Database (under External Data Sources) and click "Add Connection"
• Click "change" on right and choose your data source type (Excel or Sql Server)
• Type in your server name i.e /home/sqlexpress
• Choose if using Windows Authentication or username and password
• Type in your database name
• Click test connection
• If successful then click ok
• Type name of connection
• Click Save

Step 3:
Right mouse click on the connection you made and click "Database Mapping"
• Choose the table you want to import from
• Choose the column that contains your SKU code.
• Match your columns with the columns in nop using the dropdown boxes.
• click save to save you database mapping.

Step 4:
Right mouse click on the connection you made and click "Analyze data" this should some details about the file you are importing and information about nopCommerce.

Step 5:
Right mouse click on the connection you made and click "Import New Products". This should import products. Go to your website and see if it worked.


File can be downloaded from
http://www.agentx.info/setup.msi

10 comments:

WaltDjr said...

Have you had any one help you start testing yet? I just downloaded it and will probably try it out later tonight or maybe tomorrow. I'll let you know if I have any problems.

Is this based on the 1.30 version of NOP?

Thanks,
WaltD

Skiltz said...

Nope not a single person. Would be good to get someone else testing as would like to get this to a point where we can use it to update pricelists etc every night or hour etc....

Skiltz said...

opps...Yes based on NOP 1.30

Anonymous said...

I tested it with a Dell T105 Amd 64bit Server with Windows Server 2008 R2 x64. Seems to work fine, although it crashes every so often when you're changing from excel to sqlserver and vise versa.

Lainelaudur said...

I downloaded nopImport today to try it out and test it. I ran into problems when trying to add a connection. The test is successful, but I get an error when clicking OK. Let me know where you want me to send the error.

Lainelaudur said...

I got around the error in my last comment by running the program as administrator. BTW, I am using it right now on Windows Vista Ultimate 64-bit. I can also test on Windows Server 2003 32-bit.

Unknown said...

Installer is not working for me. Running Vista 32 bit. Gets to the "skilt.nopimport is being installed". Shows "Please wait", but the progress bar shows no progress. Just sits there.. Any ideas? I would glad do some testing and contribute to the code if I can get it running. I'm interested to see your progress before startig from scratch.

Skiltz said...

Make sure you are running as admin. Right mouse click on setup and click run as admin

Unknown said...

It runs on my machine. Does all mapped fields need to have a value from the excel file? I have mapped some of it but not all. It does not import anything from my tests. Should all items in the drop down box have a corresponding value from the excel file?

Skiltz said...

Its been a while since I used this! I pretty sure you only need to fill in the fields you need. But there are a couple of gotchas like

- That you have a ProductTypeID that = 1
- That you have a TemplateID that = 4