Windows utility to import data from Excel, Openoffice or CSV format into SQL Server
£20-250 GBP
Terminado
Publicado hace más de 10 años
£20-250 GBP
Pagado a la entrega
IMPORTANT. This project needs to be completed this week before the end of the weekend. If you cannot guarantee this please do not bid as it is needed for a demonstration on Sunday evening.
Requirement is for a small utility which will load and parse files in either Microsoft Excel (newst formats), OpenOffice Calc, .TXT or .CSV file formats, allow limited manipulation, and then attempt to import them row by row into a Microsoft SQL database table.
There will be three options initially: Import, Replace and Update. The choice here will determine how the utility later actions the updates and which columns are required to be supplied.
There will be an option to type an input file into a box, or click 'browse' to select one using the standard windows file selection window. Once the opened the utility will present a grid containing the rows of data. In the case of .TXT files it may be necessary to have a field at the top to allow the user to define the delimiter in case this is not a comma.
The user will be able to modify data in the fields in the grid, sort the grid by any of the column headings and (most importantly) easily delete rows.
The grid's column headings will be named F1, F2 etc.
The user will specify what field in the data file represents which of the required columns. There will be only two columns required to be defined if 'update' is selected: VendorSKU and VendorCode. If 'Import' is selected, the required column names are: VendorSku, VendorCode, Description, List, Cost, Retail. This will be done by picking, for each potential column name (List given) which of F1, F2, F3 contains this information.
Once the user has designated the columns, they will click a button labelled either 'import' or 'update' depending on the option selected above.
The utility will then perform the procedure chosen.
1) Update: UPDATE rows with the filled information. This must include VendorSKU and VendorCode and can optionally include one, two or three of List, Cost, Retail. Any rows with the mandatory fields filled but none of List, Cost or Retail will be supressed/skipped by the utility.
2) Insert: INSERT rows into the table with rows taking information from the grid and filling the gaps with default values for any non-completed columns. Details of the schema will be supplied, but there are currently 48 columns in total, some are NOT NULL so default values need to be supplied - others can be passed NULL. There needs to be a method by which these defaults are stored, so that when the schema changes and more fields are added, I can simply update the 'template' so that the utlity knows how to handle the extra fields.
This needs to be completed line by line. The purpose here is that some of the data is poor quality, contains duplicates or invalid values etc. We need to separate out the rows that were not successfully imported.
If the row is inserted OK, keep a count, and move to the next one.
If the row is not inserted OK, we append it to a new file which is to be created in the same folder as the import file, and named the same but with a prefix of 'ERRORs' The first field should be the error returned when attempting to import the row, followed by the fields exactly as they were given in the grid.
Keep a count of the failed records too.
At the end of the process we have: Number of successful rows, number of failed rows, and a data file created with the failed data. The numbers of succesful/unsuccessful entries should be presented to the user at the bottom of the form, and a button should become visible to wipe the grid so they can start over on a new speadsheet.
I have a simple template for how the GUI should look which I will submit to the programmer as we wish to maintain a similar style as other tools we have written.
Hi there, hope all is well. I can get this done for you this week as requested - I have some open cycles today and tomorrow. If you can get me the info today then we should be able to complete this before the weekend. Thanks!
-Jared
£210 GBP en 3 días
5,0 (245 comentarios)
7,5
7,5
8 freelancers están ofertando un promedio de £222 GBP por este trabajo
I'm an expert database developer with experience developing data import application software for a variety of databases, including SQL Server.
I can develop a Windows application for you that will import the formats you mentioned, except OpenOffice Calc.
Can start work now and deliver in 48 hrs or less. High quality work, satisfaction guaranteed. I will also be available on the long term for other work / support / enhancements.
Please send the GUI sketch.
Thank you for considering my bid.
Bests,
Larry
Dear Team,
I am a Microsoft Certified Trainer, with over 7 years of experience as an SQL Expert. I have consulted over 200 clients related with different topics of SQL (DB: Mirroring, Replication, Back up/ Restore, Log Shipping) BI(SSIS, SSAS, SSRS, MDX queries and many more) as an ex-mckinsey consultant.
Well versed with below given tools: 1) SQL Server 2008/2008 R2 and 2012 (DB and BI) 2) Reporting (SSRS, Crystal Reports, PowerBuilder and Sharepoint)
Certifications related with SQL Server MCITP SQL Server 2008 DB, Developer and BI MCSE SQL Server 2012 Data Platform and BI One of the exam for Microsoft Certified Master is already completed awaiting for the lab exam.
I would more than glad to work on the opportunity.
Regards,
Rahul