如何将Quickbooks桌面应用程序与PHP(网络应用程序)集成? [英] How to integrate Quickbooks desktop Application with a PHP(web app)?

问题描述

在我的应用程序中，我想使用php通过PHP集成QuickBooks.因此，从Web服务器(使用PHP)中，我想调用QuickBooks Desktop版本的App来推送数据和检索数据.

In my application, i want to use php to integrate QuickBooks by PHP. So From a web server(with PHP), I want to call QuickBooks Desktop version App to push data and retrieve data.

我被困在这里.我不知道从哪里开始?有人要求我从webconnector开始.我想知道像其他Web服务一样具有URL，我们需要将数据推送到该URL，其余的将由它们完成.一样吗还是我需要遵循的其他任何流程?

I am stuck here. I do not know where to start? Someone asked me to start with webconnector. I wonder like other webservices have a URL, we need to push the data to that url and they will do the rest. Is this the same? Or any other process I need to follw?

所以，请那里的任何人可以帮助我吗?我想知道完整的过程，以及是否有任何示例代码可用于php中的相同代码.

So Please please can any one there to help me out? I want to to know the full process and if any sample code available for the same in php.

要求: 1.我的应用程序在Filemaker中. 2. FIlemaker将数据发送到PHP文件. 2.然后，PHP文件将以QBXML格式将数据发送到Quickbooks Desktop Application.

Requirement: 1. My app is in Filemaker. 2. FIlemaker send the data to PHP file. 2. Then PHP file will send the data(in QBXML format) to Quickbooks Desktop Application.

请帮助我

谢谢

推荐答案

这是一个 PHP QuickBooks库正是您想要做的.

Here is a PHP QuickBooks Library which does exactly what you want to do.

您应遵循 QuickBooks PHP Web连接器快速入门指南开始.您将需要设计您的应用程序，以便您的PHP脚本可以接收数据，将其临时存储在数据库(MySQL等)中，然后Web连接器可以从那里获取发往QuickBooks的数据.

You should follow the QuickBooks PHP Web Connector quick-start guide to get started. You'll want to architect your application so that your PHP script can receive the data, store it temporarily in a database (MySQL, etc.) and then the Web Connector can pick up the data destined for QuickBooks from there.

Web连接器与标准Web服务有点不同，它以一种向后的方式工作-Web连接器将调出您的PHP Web服务，而您调出的是它.

The Web Connector is a little different than a standard web service in that it works in a sort of backwards manner - the Web Connector will call out to your PHP web service vs. you calling out to it.

有关Web连接器如何在此处工作的概述.

您应该参考此脚本(如上面的快速入门指南所述):

You should refer to this script (as the quick-start guide does above):

• https://github.com/consolibyte/quickbooks-php/tree/master/docs/example_app_web_connector

您最终将编写函数来生成看起来像这样的qbXML请求:

You'll end up writing functions to generate qbXML requests that look something like this:

<?php

/**
 * Example Web Connector application
 * 
 * This is a very simple application that allows someone to enter a customer 
 * name into a web form, and then adds the customer to QuickBooks.
 * 
 * @author Keith Palmer <[e-mail]>
 * 
 * @package QuickBooks
 * @subpackage Documentation
 */

/**
 * Generate a qbXML response to add a particular customer to QuickBooks
 */
function _quickbooks_customer_add_request($requestID, $user, $action, $ID, $extra, &$err, $last_action_time, $last_actionident_time, $version, $locale)
{
        // Grab the data from our MySQL database
        $arr = mysql_fetch_assoc(mysql_query("SELECT * FROM my_customer_table WHERE id = " . (int) $ID));

        $xml = '<?xml version="1.0" encoding="utf-8"?>
                <?qbxml version="2.0"?>
                <QBXML>
                        <QBXMLMsgsRq onError="stopOnError">
                                <CustomerAddRq requestID="' . $requestID . '">
                                        <CustomerAdd>
                                                <Name>' . $arr['name'] . '</Name>
                                                <CompanyName>' . $arr['name'] . '</CompanyName>
                                                <FirstName>' . $arr['fname'] . '</FirstName>
                                                <LastName>' . $arr['lname'] . '</LastName>
                                        </CustomerAdd>
                                </CustomerAddRq>
                        </QBXMLMsgsRq>
                </QBXML>';

        return $xml;
}

这篇关于如何将Quickbooks桌面应用程序与PHP(网络应用程序)集成?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！