Annulleret

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.

Færdigheder: .NET, Databehandling

Se mere: extract act 2005, uses data structure, use data structure, to string, table data structure, string standard, string library, string data structure, standard string, return path, need data structure, login aspx, line coding, extract number string, data structure uses, data structure notes, data structure coding, data structure code, data 0, using data structure, library standard, get string, data structure library, aspx login, application data structure

Om arbejdsgiveren:
( 2 bedømmelser ) Dallas, United States

Projekt-ID: #51722

7 freelancere byder i gennemsnit $261 for dette job

MMaghawry

I can do it but please explain it in more details

$300 USD in 10 dage
(72 bedømmelser)
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 Mere

$180 USD in 7 dage
(9 bedømmelser)
4.6
grshadow

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

$300 USD in 14 dage
(2 bedømmelser)
4.3
jesuarez

OK. According the explanation we can do it.

$230 USD in 5 dage
(0 bedømmelser)
0.0
hgteam

I can do this with best qualities.

$300 USD in 7 dage
(0 bedømmelser)
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 Mere

$250 USD in 20 dage
(0 bedømmelser)
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. Mere

$270 USD in 8 dage
(0 bedømmelser)
0.0