Program to parse a text report (csv) and convert into a usable flat file

Closed

Description

We have a point of sale system that stores transactional information very poorly. I think it actually writes it to a string then stores it in a file.

Anyway, the data can be manually exported to what they call a "csv". I've attached a sample of the data.

We'd like the following:

A program to run nightly (we can use Windows Scheduled Tasks)

Searches a directory for new reports

parse the report for the core data

append said data to a database program such as access

We would need our table to have the following columns:

Transaction ID

Date

Item Number (Item number and description are in the same cell - they need to be separate columns)

Description

Quantity

Unit Price

Extended Price

Customer Code

Customer Name

Clerk

RxNumber (*item # 01 is a "prescription". the line below it "Reference:" has 4 "columns". we need the data from the 2nd column here. data from the 4th column goes to "customer code")

The sales data is found within the groups that say "Type: Sales"

Skills: Database Administration, Excel, PHP, Software Architecture

See more: parse reports program, text to string, file clerk, parse a string, flat price, flat line, convert access reports, call a, php flat file csv, convert reports database, point sale software code, transaction report, php csv sample, parse table, extended customer, php table csv, sales report access, flat file access, convert database program, parse csv string, convert text file report, csv convert, php parse string, access file convert program file, prescription data

Project ID: #5063489

Awarded to:

weng0000

Good day! I can help you provide the application using vb.net. I am ready to start. Thanks and regards, Weng

$194 USD in 3 days
(749 Reviews)
6.9

15 freelancers are bidding on average $179 for this job

rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$309 USD in 1 day
(446 Reviews)
7.2
cheapexcell

Hello, I have done a similar job before. Ready to start. You can count on me for high quality work. Thanks, Alex

$175 USD in 3 days
(150 Reviews)
6.4
gangabass

Hi, I'm talking about Windows tool (you can place it in Windows Scheduler) which will parse your log files and save info into Access database (or Excel file if you want). I have completed many desktop automation pr More

$55 USD in 2 days
(144 Reviews)
6.0
ZeusMan

Looking forward to working with you...Ready to start as soon as you are...Thank you for the opportunity...

$69 USD in 3 days
(67 Reviews)
5.9
unbre4kab1esl

Hi, I'm ready to help you on this starting right now and finish ASAP. firstly the CSV file is not valid so I should fix it. then parse data and store it in database ! thanks.

$160 USD in 2 days
(57 Reviews)
5.2
elboukharimu

Aucune proposition n'a encore été fournie.

$231 USD in 7 days
(12 Reviews)
4.4
AccuPro

Hello, I can help you. The data in the csv is not straightforward. It will have to be carefully extracted with a lot of intricacies. Best regards, AccuPro.

$200 USD in 3 days
(6 Reviews)
3.8
gallyn

Good day sir! I'm very interested in this project and ready to discuss further for details. I'm looking forward to get your reply. Thanks and regards

$250 USD in 7 days
(1 Review)
2.8
RAJCDAC

We are Sql database experts.We can take up your project.More details can be discussed in PMB. You can expect time bound results

$257 USD in 3 days
(2 Reviews)
1.6
carivera

5+ Years of experience working with Excel/Access VBA (connecting to databases to transfer data), for automated reports. Very enthusiastic professional, detailed-oriented and very hard-working. Have spent the last 5 More

$155 USD in 0 days
(1 Review)
1.4
mmp3396

Hello! I can do this job for you. I have great experience programming Excel, Word and Access. Your program can be done in Access or in Excel, and you can run it nightly. As I see it, it'll be better to place results in More

$55 USD in 10 days
(0 Reviews)
0.0
swamis71

Possibility in perl or php. Deliverable can be in mysql or mdb ( access ) As of now the CSV that you have posted looks like a normal text file.. it is not exportable to xls as csv file should..

$250 USD in 3 days
(0 Reviews)
0.0
HeadGr

Have some questions and idea for you not export to csv at all. But it needs to be discussed. PM me if interested.

$166 USD in 7 days
(0 Reviews)
0.0
nhk5375

I'll put a property in configuration which will contain the date & time of last execution. When you execute the application, it will read the last execution date and select only those reports which are created/modified More

$155 USD in 7 days
(0 Reviews)
0.0