Find Jobs
Hire Freelancers

C# Extract Act 2005 Data to CSV

$100-300 USD

Abgesagt
Veröffentlicht vor etwa 18 Jahren

$100-300 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 51722

Über das Projekt

7 Vorschläge
Remote Projekt
Aktiv vor 18 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
7 Freelancer bieten im Durchschnitt $261 USD für diesen Auftrag
Avatar des Nutzers
I can do it but please explain it in more details
$300 USD in 10 Tagen
5,0 (72 Bewertungen)
6,0
6,0
Avatar des Nutzers
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 Tagen
5,0 (9 Bewertungen)
4,6
4,6
Avatar des Nutzers
Will be happy to help you. Will wait for additional info.
$300 USD in 14 Tagen
4,6 (2 Bewertungen)
4,3
4,3
Avatar des Nutzers
OK. According the explanation we can do it.
$230 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I can do this with best qualities.
$300 USD in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
Dallas, United States
5,0
2
Mitglied seit März 27, 2006

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.