If you didn't downloaded the source code, but the executable itself, all you have to do is open it. no install needed (I hate installers), yet you do need the following:

  • .net framework 3.5
  • windows xp or higher
  • 250 RAM (the more the fastest)
  • 268KB disk space
  • Pentium 4 or higher

please note, that I've only tested this project under windows XP, so PLEASE if you get the chance to test it into another OS give me some feedback!

 

ok here are the screenshots:

overview

The screenshot is divided into steps, I'm describing below:

Step 1:

Choose your bulk csv file, this file must contain the fields in the database, this fields must be in the order you want them inserted.

Example:

if your csv looks like this:

Code Part Sales
001 CQP200 $1,200
002 CQP201 $2,200

The database must contain this 3 fields, and this 3 data types.

Step 2

Press the gather button to load the csv file into the program memory, you will know it gathered successfully when you see the number of registries in the "FOUND" field below.

Step 3

Copy paste, or type in the connection string to your MSSQL database, this will be the connection string used to run the insert statements.

Step 4

Click on "get tables", this will retrieve the table names in your database, so you can select your target table.

Step 5

Select your target table in the drop down list.

Step 6

Click "get fields" to get the selected table fields. (clear fields is to reset the fields in the list below, if you want to reset fields also it's enough to choose another table and click get fields, and same thing if you want to reset tables, just change the connection string)

Step 7

This is a very important step, if you do it right or wrong determines the program functionality. 

you have to select the fields you want to insert, this fields order from top to bottom, should match your csv file order from left to right, and your csv should match your database table left to right order.

Example:

your field list is:

  • Code
  • FileUrl
  • Author
  • Rating

your csv fields must be

001 www.codeplex.com/file1.html RicardoE 5
002 www.codeplex.com/file2.html RicardoE 4
003 www.codeplex.com/file3.html RicardoE 3

Also this fields must match the fields on your database, if you choose less fields than the database fields it's ok, but you have to keep the order left to right!

Step 8

Go2when you mouse enter the green button the word "GO!" will show up, if you push the button the program will start doing its thing until done, or closed.

Step 9

Step back and see how the query's go

 

Error Report's

If you see on the bottom left part of the window, you will see a small button with a diskette, if you click on it you will see two options "save failed querys" and "save error log"

this will create one txt file each, one with the error log, and the other one with the failed queries if any.

Error Handling

The small label "ready" will let you what are the internal processes running, like "generating script..." "executing script..." "opening file..." and so on.

 

That would be pretty much it. 

IF YOU FIND ANY ERRORS, ISSUES, HAVE SUGGESTIONS ABOUT FEATURES, PLEASE! DO NOT HESITATE ON CONTACTING ME VIA CODEPLEX.

Last edited Dec 11, 2010 at 5:13 AM by RicardoE, version 3

Comments

destinydriven Feb 12, 2011 at 6:46 PM 
This is excellent. Saved me a lot of time on an import solution I was working on. Tested on Windows 7 Ultimate 64 bit and it works without issue. Thanks for sharing.