Đã hoàn thành

Import / Convert program: flatfiles to database

Our application produces 3 different flat files.

File1: summary file containing:

- voucher numbers with voucher totals

- Payment method of the voucher

- Totals of the payment methods

- A number of other totals

- File name contains date and ID

- File time should also be kept

File2: voucher data for payment method A, includes:

- Payment method

- Voucher detail lines

File3: voucher data for payment method B, includes:

- Voucher detail lines

File2 and File3:

* Are in a directory for the specific date.

* Are identical on voucher detail lines level, before voucher detail lines there are hundreds of lines with

irrelevant data. In the first 12 lines there is useful data, voucher detail lines are at the end of the file.

* File name contains the voucher number.

* File time should also be kept.

Importer or the converter will run scheduled on a Win2k3 server and:

- scan the relevant directory (WDIR).

- import all File1 files into a database (MS SQL2005 or MS-Access).

- scan the subdirectories (DDIR) in WDIR.

- import all File2 and file3 files into the database.

- Keep track in the database of which files have been read.

- After the first import the new data according to schedule.

The database will have three tables:

- Timport: filename, importdate, importtime

- Treport: repdate, repnumber, retime, repvouchernumber, repvoucheramount, reppaymethod, rept1, rept2, rept3, rept4, repopentab

- Tvoucher: vounumber, voudate, voutime, voutable, voupaymethod, voulinenumber, vouitem, vouitemprice, vouitemqty, vouitemclass, vouitemcategory, vouitemprinter, voucode1, voucode2, voucode3, voucode4

At present there are 300 File1 and 7500 File2&File3 present.

Programming language: any; source code required.

Program should produce error messages where needed and pass them through log files or e-mail.

The start directory, WDIR, must be adjustable.

Attached zip file contains samples of all three files and a MS-Access file containing the data of the sample files. Also included are a few images to clarify the mapping.

Kĩ năng: Khai thác dữ liệu, Microsoft Access, PHP, Shell Script

Xem nhiều hơn: where to start programming, source code program php, schedule source, programming in access database, programming access database, ms access programming, microsoft programming language, microsoft number, microsoft access programming, first programming language, e programming language, b programming language, file2, ms access 2010, language converter, time converter, php program language, import database, images to ms, data convert

Về Bên Thuê:
( 14 nhận xét ) Amsterdam, Netherlands

ID dự án: #830224

Được trao cho:


Hi, I do this project for 3 days. Please see PM. Thanks.

$80 USD trong 3 ngày
(22 Đánh Giá)

16 freelancer đang chào giá trung bình $140 cho công việc này


I would like to bid on this project. Donna

$100 USD trong 5 ngày
(32 Nhận xét)

I can do this job for you. See PM for details.

$100 USD trong 2 ngày
(112 Nhận xét)

hello sir, i would like to do it .thx

$200 USD trong 7 ngày
(20 Nhận xét)

Hello, please check PM

$100 USD trong 4 ngày
(18 Nhận xét)

Please check detail on PMB. regards

$245 USD trong 10 ngày
(2 Nhận xét)

Hello i am software engineer with 10 year working experience.

$89 USD trong 6 ngày
(11 Nhận xét)

Hello, i will deliver a solution in VB.Net or C# (whatever your choice) that will parse the input text files and output in the ms access database that you have attached. The program will be a console application, with Thêm

$150 USD trong 5 ngày
(4 Nhận xét)

Pls see PM

$90 USD trong 7 ngày
(7 Nhận xét)

Hi, Please refer PM. Regards, Sandeep

$100 USD trong 2 ngày
(3 Nhận xét)

we can start on your project straight away, we are new here, therefore no reviews

$200 USD trong 3 ngày
(0 Nhận xét)

Let's start, please check PMB

$200 USD trong 4 ngày
(0 Nhận xét)

Few Hours Work!! Lets Start

$120 USD trong 2 ngày
(0 Nhận xét)

I'm new here but I have 4 years of professional experience in applications development. I can do this.

$120 USD trong 6 ngày
(0 Nhận xét)

Hello, I finished this project for you, please check your PM!

$200 USD trong 0 ngày
(0 Nhận xét)

I can do it. In my opinion VBScript will be the best decision.

$140 USD trong 5 ngày
(0 Nhận xét)