Đã Hủy

C# Extract Act 2005 Data to CSV

We need someone to write a console application written in C#.

The program is geared to a user of Act 2005 and Act 2006 with the objective of extracting the data

from an act zipped backup a user database and write them out to comma delimited ASCII file.

Act 2005 and Act 2006 allows you to extract the main table to a flat file but it does not support all the other other objects like history, notes and calls.

It should create one file for every view that can be created from the Act database structure.

Since Act 2005 uses SQL Server you need to devise a way to connect and login into the database using ADO.Net.

Console Application with the following command line parameter

string - Location of the zip file containing the backup SQL database.

string - Path where the CSV file will be extracted to

string - Name of Database Instance to use to reattach the database

string - password for the sa account since it is needed to reattach the backup database.

Console Application return a value of 0 if it failed or 1 if it worked.

Files needs to be written in a comma delimited format with the first line of the file containing the field name.

You can download a sample zip file at http://www.centrebase.netact.zip.

All Views will get written to the

path as defined in the command line parameter. One file per view with name of ViewName.csv.

Once all files are extracted a summary file shou ld be written showing the number of records written and the view name in a HTML table layout.

1. Assume the database server is on the machine where the console app will be running

2. Extracting of Backup file will be done from a zip file. Use GPL library at

[url removed, login to view]

3. Coding standard should follow

[url removed, login to view]

There are no config file allowed as all your inputs will need to be derived from the command line parameters.

As previously mentionned source code needs to be well documented with comments in the source code.

We own the source code.

Kỹ năng: .NET, Xử lí dữ liệu

Xem thêm: extract act database data using net, extract act 2005, www data processing, uses of data structure, use of data structure, to string, table data structure, string standard, string processing in c, string library in c, string library c, string in data structure, string data structure, standard string, standard library c, return path, out source coding, objective c com, need of data structure, login in aspx, login aspx, line coding, get string c, extract number from string, data structure with c

Về Bên Thuê:
( 2 nhận xét ) Dallas, United States

Mã Dự Án: #51722

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

MMaghawry

I can do it but please explain it in more details

$300 USD trong 10 ngày
(72 Đánh Giá)
6.0
indradj

I can get this done for you.. I have already done programme/sql-script which process zipped/rar-ed MSSQL backup's. So this is not a problem for me. The data conversion itself (to CSV file) is relatively easy.. as long Thêm

$180 USD trong 7 ngày
(9 Đánh Giá)
4.6
grshadow

Will be happy to help you. Will wait for additional info.

$300 USD trong 14 ngày
(2 Đánh Giá)
4.3
jesuarez

OK. According the explanation we can do it.

$230 USD trong 5 ngày
(0 Đánh Giá)
0.0
hgteam

I can do this with best qualities.

$300 USD trong 7 ngày
(0 Đánh Giá)
0.0
hiensys

Dear Sir Hiensys IT Consulting is an emerging global technology services company delivering business solutions to its clients. We deliver the full range of application outsourcing, business process outsourcing, con Thêm

$250 USD trong 20 ngày
(0 Đánh Giá)
0.0
unitedinformatic

United Informatics is a leading web designing firm. We deliver a full spectrum of innovative web solutions designed to help clients harness the power of the Internet to transform their business for the new century. Thêm

$270 USD trong 8 ngày
(0 Đánh Giá)
0.0