Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
 Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Alpha 5 to Quickbooks 2004 preimerSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Installation Support Forum

 New Topic 
 
 Post Reply 
[1]  
 Alpha 5 to Quickbooks 2004 preimer 
 Author   Message 
  David 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-05-08 
 Profile
 Posted : 2006-05-08 14:54:37

I downloaded the trial version of qodbc several months ago, didn't get to try very much. I tried downloading again and now my time has expired.

Can I get a trial copy again?

What I want to evaluate is to create Sales Orders in Alpha 5, and them import Invoices into Quickbooks.

Is this a complicated task? Will the qodbc talk directly to QB? or, Will I have to do this through SDK?

Thank you,

David

 

 

 
Win XP Pro
Quickbooks 2007 Preimer
Alpha 5 ver 8 Enterprise
ODBC Ver 8 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-05-08 15:24:40
You need to contact your local sales office directly for an evaluation extension.

Alpha Five is a preferred partner of FLEXquarters.com LLC, and the Alpha Five software is an excellent choice for end users to develop web and desktop applications based on the QODBC Driver for QuickBooks. We believe you will be impressed by it's ease of use and flexibility in creating applications without complicated coding.

Setup QODBC to work with Alpha Five Web

Alpha Five can offer smooth running attractive web documents containing live QuickBooks data when using the QODBC Driver. Install Alpha Five on your web server, along with QuickBooks and the QODBC Driver. Click to download a free trial of Alpha Five Web Edition.

Start and minimize QuickBooks. Make sure you have already followed the instructions on How do I connect to QuickBooks for the first time?  to setup data security settings and How can I see QuickBooks data in a Internet Explorer Browser using Windows XP?

Start Alpha Five and create a new database, it could be called QuickBooks.adb - it is a holder for the entire application. Make sure the web server component has a green light on the top, indicating that it is running. Click the Web Projects button, Click New and choose Alpha Five Web Component, then OK.

Choose the Component Type as Grid. Under the Grid Builder, we will be filling in each of the tree tabs on the left to complete the project. First click on Data Source, choose ADO/ODBC/Access.

Click Query ADO tab. Change connection type to ADO Connection String. Change Use Named Connection String to Specify Connection String. Click the Build button. The Data Link Properties will pop-up with the Connection tab selected. Use the Data Source Name QuickBooks Data, then click the Test Connection button. Do a small celebration dance when it works.

Click OK twice then click the Connect button, which will ask the QODBC Driver for the list of tables available from QuickBooks. This list will vary depending on which version of QuickBooks you are running.

When the choice appears, choose the table from QuickBooks you wish to use in the view, such as Customer.

Click the Fields tab on the tree, and then choose which fields from those available you would like to show in the grid/list of records by clicking the arrow buttons.

Click the Save button and name the web component, something like "cust". Click the Save Page button, click Save Page, name it "cust". At this point you should be ready to test your web application. Click the Live Preview tab on the bottom and you should see the data from QuickBooks in a grid.

Click the top menu option for Preview / Live Prevue in Browser.

You now have your first working web application with Alpha Five using live QuickBooks data via the QODBC Driver. Now add your own touches and launch it on the web, the possibilities are endless and the ease of use is unmatched.

Get More Details on Alpha Five Web Edition - Download a Free Evaluation Version

Alpha Five has made importing QuickBooks® data into a database a breeze, even if you’re a novice to database design.  With Alpha Five and QODBC installed, just open QuickBooks and open the company file.

 

Select File/Import/ODBC Import Genie

 

The Import Genie walks you right through the process.

 

Select ODBC Data Source as the type to convert and then select the QuickBooks DSN as the source to use and voila, all the tables available through QODBC are listed. Click on  the >> button to convert all tables or select the ones you opt for by clicking ->.

 

Select the "SQL Dialect - No [ ] around table names" option if asked.

 

Click on the finish button and let the genie do its work!

 

Once the tables have been imported Alpha Five lists all the tables that you selected for import.

 

By highlighting a table name and clicking on the view button, Alpha Five gives you 2 separate views of the data both of which can be customized to fit your needs. It’s as easy as that!

Form view

 

Grid View

See also: What is the difference between the Server Edition of the QODBC driver and the Desktop Edition? 

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to