Login Form
Lost Password?
No account yet? Register
Freelancer Jobs arrow Freelancer Jobs - Archive 2007
JobId: #1400087

C# app to automate data push to QuickBooks
Categories: Microsoft Windows,Requirements,Operating Systems / Platforms,C#,Software Related (Includes Websites)
Posted By: Luxury Retreats  (5 ratings)
Source: Rent-a-coder
Job viewed: 318 times
Bids Placed: 6
Start Date: 2010-04-29 14:47:04
End Date: 2010-05-13 14:11:40
Time Remaining:
Deadline: Please estimate in your bid
Current Phase: All funds have been escrowed. Waiting for work to be completed by worker.
Max Accepted Bid: Bidding is closed
Project Type:
Bid Type: Open Auction
Brief Summary:

A C# console app to push data returned by SQL 2005 stored procedures into QuickBooks using QBFC. This app should also send out an emailto a distribution list irrespective of whether the process ran successfully or failed.



Requirements Interview Answers:
To help you bid more accurately, the buyer was interviewed about the requirements for this bid request. Below are their answers. Untitled Page
Bid request Type: What kind of work do you need done?
Software related (Includes desktop applications and internet websites)
Bid request Parts: What do you want the worker to do on this bid request?
Requirements: The worker will analyze the problem and propose a software-based solution to the problem.
Programming: The worker will take the requirements and translate them into the language of the computer (and test it).
User installation: The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.
Req. Doc. Type: What kind of documentation do you want for this bid request?
Informal documentation - As the buyer talks back and forth about the bid request with the worker, those conversations become the requirements.Remember to communicate ALL of the details of your bid request on the Rent A Coder site. If you don't, and there is a dispute, then important details of the contract will not be documented and cannot be taken into account in arbitration. If you feel you MUST go offsite (for example, using the phone or IM) then afterwards post everything onsite and get the other party to post that they agree to those contractual terms.
Program Type: What kind of software should the worker create (and/or install)?
  • A desktop or server program: This software runs on a user's own PC/workstation, or on a server.
Desktop / server program info
Size of application: How many screens/forms need to be created/edited in this application?
Exactly 0.
Programming Language: What programming language(s) do you want your application written in?
I do know the language(s).
Languages(s):
  • C#
Operating system(s) What operating systems(s) do you want your application to work on?
I do know the operating system(s):
  • Microsoft Windows -- version(s): Win XP and Win 2k3
    		•
    Database: Will this bid request include a database?
    No, it does not include a database.
    Installation Program: Does the worker need to create an installation program?
    Yes AND the program will be installed on only a single computer.
    Legal: 1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
    2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
    2a) If there are any server-side deliverables (intended to only exist in one place in the Buyer's environment) then they must be installed by the Worker in ready-to-run condition (unless specified elsewhere by the Buyer).
    2b) All other software (including but not limited to any desktop software or software the buyer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request (unless specified elsewhere by the Buyer).
    3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased.
    3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement.
    Other Requirements:

    I currently perform this process manually through an excel filethat fetches data to be pushed from a SQL 2005 database (through storedprocedures) and then imports all this information into QuickBooks using the QB API.All this is done through VBA code (in the excel file) and so basically thisfunctionality needs to be ported. Following data is pushed into QuickBooks 

    • Customers
    • Vendors
    • Customer Invoices
    • Vendor Bills

    I've attached a copy of this file (along with the specs of this project) with this post.

    I will eventually schedule this console app to run nightly so the application should not require QuickBooks or the QuickBooks file to beopen before this process runs and should send an email to a distribution groupif there are any errors while pushing  data into QuickBooks.

    I will/can provide

    • The necessary tables and stored procedures that fetch data from our CRM database
    • Sample Company QuickBooks file where the data is pushed.
    • Name of the distribution list 

    • All deliverables must be uploaded to Rent A Coder before the deadline(s) for this bid request...with no exceptions. If this contract makes it impossible for a competent person to do this, then do not start this bid request...but instead alert Rent A Coder of an un-arbitratable, illegal bid request.
    • Remember that contacting the other party outside of the site (by email, phone, etc.) on all business bid requests <$500 (before the buyer's money is escrowed) is a violation of both the software buyer and worker agreements. Rent A Coder monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
    Categories:
    (Note: Like everything else on this page, these categories are part of the original contract for this bid request.)
    Microsoft Windows, Languages, Requirements, Operating systems / platforms, C#, Other (Technology), Software related (includes websites)

    Additional Files:
    This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
    50.87 kb