.Net 2.0 Program to extract Act 2005 Database to Comma Delimited Files
$30-5000 USD
Kapalı
İlan edilme: yaklaşık 18 yıl önce
$30-5000 USD
Teslimde ödenir
We need someone to write a consoile 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 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.
The console application will require the following parameters to be passed into the application via command line:
string PathToDatabase
string ActVersion (Should be Act2005 or Act2006)
string PathToExtract
It should create one file for every table that can be created from the Act database structure.
There should a file for each of the object type
Contact
Company
Group
Note
History
Activities
Opportunities
Secondary Contacts
Documents with file content MIME64 encoded
User Fields
eMail with email content MIME64 encoded
Once the program has conmpleted its execution ith should generate a text file showing the result of the extraction.
Since Act 2005 uses SQL Server you need to devise a way to connect and login into the database using ADO.Net.
## Deliverables
Complete source code of the application.
User documentation on how to use the utility
Fully commented source code with all proper standard naming convention and header information.
Feedback type:Request Broadcast Message from Buyer to all Bidders
More information about the task.
We managed to look at the database structure in SQL Server and would feel that extracting all the views as individual CSV file will be the better approach than to try to figure out the internal structure of the database.
So the file name for each file associated to the view will be called
ViewName.csv.
Also since the database is running under its own SQL server instance the user needs to be able to point to the Act zip backup file, open it and restore it into another SQL server 2005 instance which will be identified to the console by a command line parameters. This will be needed in order to give sa right to the extractor program.
* * *This broadcast message was sent to all bidders on Thursday Mar 23, 2006 1:56:44 PM:
More information about the task.
We managed to look at the database structure in SQL Server and would feel that extracting all the views as individual CSV file will be the better approach than to try to figure out the internal structure of the database.
So the file name for each file associated to the view will be called
ViewName.csv.
Also since the database is running under its own SQL server instance the user needs to be able to point to the Act zip backup file, open it and restore it into another SQL server 2005 instance which will be identified to the console by a command line parameters. This will be needed in order to give sa right to the extractor program.
* * *This broadcast message was sent to all bidders on Friday Mar 24, 2006 10:43:24 AM:
This may be repetitive but I want to make sure everyone understand what I expect from the job.
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 [login to view URL]\act.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.
## Platform
.Net Framerwork 2.0
C#