Closed

CSV to Text File Conversion

This project is about converting a CSV file which contains sales transaction into another CSV file with predefined fields. So basically you will need to parse columns from the source CSV file and insert them into the destination CSV file. The desired .NET application will parse a directory containing several source CSV files each belong to a unique store in the premises, all source CSV files will have the same structure. The desired app needs to convert each of the source CSV files into a separate new destination CSV file. The destination CSV file has a predefined template. You will insert into this template the parsed columns and insert them into the destination CSV template and save it as a new file and so on.

There will be a list of well defined business rules to take into consideration while converting files. Business rules will be share later on during low level design. Source files can be Excel files too, but will all be consistent, i.e. share the same column structure.

The app will need to provide extensive logging to reflect success, failure, duplicate sales records, inconsistent source file name, etc. It is preferable that logging be inserted into a simple SQL Database and provide a simple web interface to query it based on store name, ID, date, etc.

This has been done before so I have a very good idea about what needs to be done. please PM any questions you may have and I will answer you at the earliest convenience.

Skills: .NET, Excel, SQL, Visual Basic

See more: web logging template design, template source file, simple file database, application template excel, file conversion, csv file business directory, convert columns text files, simple net excel application, business directory database design, text based interface, excel csv database template, csv convert, excel sql query, save file directory, excel project idea, csv excel text, directory convert application, sql insert net, excel file conversion, excel sql interface, column text, csv text file, excel convert app, excel query csv file, database query failure

About the Employer:
( 0 reviews ) Cairo, Egypt

Project ID: #5327323

55 freelancers are bidding on average $146 for this job

samitXI

Hi Sir, I am ready to work for you.I have 9 years of experience in C/C++/C#, .NET , php, android and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality More

$60 USD in 2 days
(36 Reviews)
6.6
ITservice

Hi, I have 5+ years of experience. Developed various projects in .Net with MsSql database. Infact, 90% of the projects done so far are in ASP, which includes simple dynamic page to complex ecommerce related websites. More

$206 USD in 3 days
(41 Reviews)
6.5
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop software/macro/bot/ More

$100 USD in 2 days
(122 Reviews)
6.4
ehsankayani

HI, I have developed many parsing tools and my scripts always contain a complete log of whats going on. I can easily develop this for you . Kindly explain the rules you mentioned in the description. Thank you

$147 USD in 3 days
(51 Reviews)
6.3
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: http://sigma-dns.sigmavirtual.com/PDemo1/Am More

$206 USD in 5 days
(35 Reviews)
6.1
vano101

A proposal has not yet been provided

$48 USD in 2 days
(222 Reviews)
6.0
mhmhz

Hi I am ready to provide a desktop application in C#, that will do the conversion Waiting for your sample. Thanks

$210 USD in 3 days
(66 Reviews)
5.9
deepbluetech

A proposal has not yet been provided

$155 USD in 3 days
(130 Reviews)
5.8
usamacpp

We are a team of professional engineers in C/C++/C# for windows Objective-C for MAC and iOS and Java for Android, with 14 years experience in programming field. We have made many windows desktop applications using C More

$123 USD in 7 days
(28 Reviews)
5.8
djain01

Hi, I have a very good knowledge with visual basic with .Net. I have completed many projects based on the CSV and Excel file data conversion. Please also check my reviews to know more about my work. Thanks Dh More

$155 USD in 5 days
(74 Reviews)
5.7
zExcel

Hi, I can do the code in VBA if that is ok with you --------------------------------------------------------------------------------------------------------------------

$100 USD in 1 day
(43 Reviews)
5.7
wsh2

For your convenience, we can fulfill your complete requirement using (only) MsExcel. Greetings from the USA.. [smile] Highly experienced (20+ years) MsExcel Business programming and database expert with Guru / Me More

$236 USD in 7 days
(32 Reviews)
5.6
diegogarcia0531

I can develop the application to do the job, and can provide the sql logging but not a web application Regards Diego

$150 USD in 3 days
(30 Reviews)
5.4
feninsoftech

Hi, I done similar thing in my current project. Client has various input CSV files and want to import in a defined SQL table. For this to achieve i have designed a mapping screen where user can map input CSV column More

$222 USD in 10 days
(17 Reviews)
5.3
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$194 USD in 5 days
(32 Reviews)
5.2
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche More

$88 USD in 3 days
(43 Reviews)
5.1
sinharavi

Hi, I read your requirements, i am ready to the work. I am having 6+ year of experience in ASP.NET, MVC, C#.NET, VB.NET, MS SQL Server 2008 R2/2005, WCF Service, WCF REST Service, Javascript, JQuery, CSS. Please let me More

$242 USD in 7 days
(22 Reviews)
5.0
piyushdpatel

I have 8 yrs of Exp in VBA,VB6,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start Can You send me your Sample file / Project details if you want i will also send demo More

$111 USD in 3 days
(15 Reviews)
4.9
elboukharimu

Hi, I'm very interested helping you creating your application, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my port More

$210 USD in 7 days
(17 Reviews)
4.7
digidreamstech

Dear Wazab, Its Ram from Digital Dreams Technology, India. I have gone through your project requirements for .NET based software development for CSV to predefined CSV templates. I have already did similar task befor More

$183 USD in 7 days
(7 Reviews)
4.6