Desktop QuickBooks US, xTuple, Openbravo POS Integration

Here is a link to the download https://sourceforge.net/projects/sierramobilepos/
 
Back to the Windows Mobile Marketplace link Click Here
 
Another useful link http://forge.openbravo.com/plugins/mwiki/index.php/MobilePOS
 

Tuesday, December 29, 2009

file socketmodule.c line 299 #ifdef HAVE_INET_PTON
under XP the pythonftpd server was not running complaning of missing function inside ws2_32.dll so I disable HAVE_INET_PTON and made a change in this source code.
On the python core itself
Using and extending embedded python on the Desktop and embedded lua-arm on the PDA

Well I need to add more documentation to post one, but it was enough.
Now I needed to send data from PDA to the desktop. I know how to embed lua but lua doesnt have a lua ftpserver, so I settle embedding python 2.5.2 on the Desktop and using embedded lua on the PDA just to use luasocket and use their ftp module.
Now sometimes the pythonftpd server bind itself using ipv6, luasocket on the PDA is not IPV6 ready so I have to find out how I can strictly tell the embedded python and pythonftpd to use ipv4.
Anyway embedding python on the desktop and extending it with function, so when it finish receiving a file (DataToHost.zip) I start a bunch of c/c++ functions to unzip and process that data to the local sqlite3 tables. It was something to see. I may later post some code to show what I did.

Friday, December 25, 2009

First Blog, documenting the code part I



Well, I started blogging to document my code changes.

I have tested the import/export from QB code
This code consist on ConsoleApplication1


ExportFromQuickBooksFormAsyncExport.cs
ImportFromQuickBooksFormAsyncImprt.cs

The main form is located under ImportFromQuickbooksForm.cs

The CS module ImportExportQB
References
QBFC8Lib
System
System.Core
System.Data
System.Data.SQlite
System.Drawing
System.Windows.Forms
System.XML

Export\
Items\
Items\ExportToQBCodeInventoryItemAdd.cs
Items\ExportToQBCodeInventoryItemMod.cs
Items\ExportToQBCodeNonInventoryItemAdd.cs
Items\ExportToQBCodeServiceItemAdd.cs

ExportToQBCode.cs
ExportToQBCodeCreditMemosAdd.cs
ExportToQBCodeCustomersJobs.cs
ExportToQBCodeEstimatesAdd.cs
ExportToQBCodeInvoices.cs
ExportToQBCodePurchaseOrders.cs
ExportToQBCodeSalesOrdersAdd.cs
ExportToQBCodeSalesReceiptAdd.cs
ExportToQBCodeVendorsAdd.cs

Here are more images of the ClientSetup/ActiveSync Sync exe


Image-1















Image-2










Here below is the main menu Windows Mobile App, done using MFC



Customer List