Project Description

Bring data from Input file, edit information in fields and save back to Output file.

Have search option to call data from input file. Search value will be only use for to find from "ProductNo" column. So we will call the data using ProductNo.
Once we hit the search, system will bring all the information for that line, column headers are as field name and editable text boxes where the data from input brought. We will edit the information in text fields and then click on save and system will save the new information to next available row in "output" file in the same column header order in input file.

Why we need this?

We often change the information about products and we have to do it on this input excel file. It is very confusing and tiring to do it with scrolling up and down , right and left through rows. So we need this application where it will show all the information orginized in 1 page where we can edit the data from cells.

There are 90 column headers for each product, so for this application it will be hard for to make all column headers visible in 1 page. So lets make most important column headers data at the top side of the page.

Most common used fields / column headers data from input file;

-ProductNo
-Product
-SKU
-Oem
-Price
-Quantity
-Weight
-Brief
-Description
-Thumbnail
-Photo
-ExtText1
-ExtText2
-ExtText3
-ExtText4
-ExtText5
-ExtText6
-Active
-Mpn
-NaturalSearchKeywords
-NaturalSearchDescription
-Keywords
-Category

All the rest of column headers data less used so they can be bottom of the page.

Please remember, application will not make any changes on input file. It will only read data from input file. Adjusted data will be saved to next available row in output file.

Input file is CSV ( comma separated ) output file must be also same CSV format.

Sorry for my poor english. If you have any questions please feel free to ask.

Attachments are sample files. In real input file there are much more products but all column headers are always same.

**When you bid please explain how you want to do the application otherwise your bid will be disregarded.
**Full payment will be done only after final delivery.

Tags: application, column, comparing excel files data report code vb, convert excel file pdf ms access vb, convert excel file stand alone application, data, display excel file data javascript, excel file data entry, excel file data mysql table java, excel file database web application, file, headers, import excel file data grid aspnet, import excel file java web application, import excel invoice data database application, information, input