Find Jobs
Hire Freelancers

C# Extract Act 2005 Data to CSV

$100-300 USD

Cancelled
Posted about 18 years ago

$100-300 USD

Paid on delivery
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 [login to view URL] 3. Coding standard should follow [login to view URL] 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.
Project ID: 51722

About the project

7 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average $261 USD for this job
User Avatar
I can do it but please explain it in more details
$300 USD in 10 days
5.0 (72 reviews)
6.0
6.0
User Avatar
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 as the data is in the database, it can be retrieved!! Give me a chance to do this. Will finish it no more than a week (most likely less)...
$180 USD in 7 days
5.0 (9 reviews)
4.6
4.6
User Avatar
Will be happy to help you. Will wait for additional info.
$300 USD in 14 days
4.6 (2 reviews)
4.3
4.3
User Avatar
OK. According the explanation we can do it.
$230 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this with best qualities.
$300 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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, consulting & systems integration services. We have a good expertise in Web designing ,Custom Application Programming in VB.Net , ASP.Net , DOTNETNuke , SQL Server 2000 etc. Also we have experiance in handling BPO Projects. This is the proposed bid and duration. It will be finalised after getting complete requirment. Please visit our profile for more details. Thanks & Regards Hiensys IT Consulting.
$250 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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. United Informatics helps global companies and Internet ventures leverage their existing business strengths to develop profitable and sustainable digital businesses. Driven by client needs, we identify e-business opportunities and utilize our conceptual, technological and marketing expertise to build, distribute and manage custom digital solutions for our clients. We are available on a New Jersey (USA) telephone number for easy contact & consultation
$270 USD in 8 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Dallas, United States
5.0
2
Member since Mar 27, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.