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
 

Friday, March 5, 2010

Mobile POS for xTuple

I just uploaded a beta to the sourceforge website, the filename is MobilePointOfSalexTupleIntegration_Install.msi, what a name.

The file is at the end of the list
http://sourceforge.net/projects/sierramobilepos/files/

It is a beta, so I still need to import more data and see how all integrate and works with Mobile POS.

Next step will be to make the synchronization  both ways now is one way. But the end-user can modify and create data on the PDA. I think it is the first time, someone will see their xTuple data on a windows mobile standard phone. I will love to see that face.

Here are some pictures, main menu program


Main Menu





When you click Import from xTuple
Notice I am using the demo database, with user admin, password admin, port 5432. In your case this will point to your Postgress xTuple host ( not necessarily localhost, could be an IP address), with your login,password, and port number. This connection can even be secure (ssl) 



Here finished importing from xTuple. Customers, Accounts, Terms, Invoices, Sales Orders, Vendors, Quotes, Products, Class and on and on. All this data will be transfered to the Windows Mobile devices.

Any way, thanks, email me bugs.

Friday, February 26, 2010

CPropertySheet on Windows Mobile Standard

First things first, I am super surprised on the interest on the Windows Mobile Standard version, 30 downloads a day. Just published it last Monday, so I am adding some features that were lacking and the WinMob Professional already had.

I have been working on Adding CPropertySheet on the Windows Mobile Standard. I found a way. Here are the pictures


From the Customers List, Click Choices




Another Menu, now Click Details. This will take you to the Customer Details ( My own CPropertySheet)




More Choices



Now you have all the Customers-Jobs information like the WinMob Professional.




So now I will upload to sourceforge this new version. The same work will be applied to Items, and Invoices. Will allow to see/edit details.

I was working on the xTuple http://www.xtuple.com/  version when I read an article some people are interested on a Mobile xTuple. I am working on it a lot. You can read previous posts I had about it.If someone reads this and is interested in Beta testing pls, email me ASP. I have a read-only version ready.
This is the article http://www.mobileenterprisemag.com/ME2/dirmod.asp?sid=&nm=&type=MultiPublishing&mod=PublishingTitles&mid=B4771C6F22F34E4CA3FFFDA61E0EA2C5&tier=4&id=F04B02FD8A2C47B39A673C5DDFAA851A

On another not related topic. The Mobile Point Of Sale Server Installer has giving me a lot of grief. It has a .net component that was not registering to import/export to QB. Now it was added it to the installer, I found a tool call heat that does some magic stuff. Read the component and export on xml format all the registration code. It comes with Wix 3.5 http://wix.sourceforge.net/. The installer used for this project. I also added some log capabilities to the Web Sync to better see errors when exporting to QB.

Thanks.

Monday, February 15, 2010

Well, testing, testing

I got a problem with the Standard version of the software and I resubmitted to Microsoft Marketplace.

Here is a list of Microsoft phones. They do have a lot choices.

http://www.microsoft.com/windowsmobile/en-us/devices/devices.mspx?id=650&backUrl=http%3a%2f%2fwww.microsoft.com%2fwindowsmobile%2fen-us%2fdevices%2fsmartphones.mspx#detail=656

Here this looks very competetive

http://www.verizonwireless.com/b2c/store/controller?item=phoneFirst&action=viewPhoneDetail&selectedPhoneId=4848


Anyone who find a problem pls email me.

Thanks.

Friday, February 12, 2010

Well is out

I published the software on Microsoft WinMob Marketplace. I have noticed the traffic here. I just published also the Smartphone (Standard) part, lets see when they approve it. You are welcome to write me, and ask for information here. I am still testing and fine tuning the software.
The Desktop part, has given me a lot of pain. The history behind it. It was originally a Visual Basic 6.0 app, so I ported it to C#. With the port, I carried some bugs like writing to a log c:\DataProjectErrorlog.txt. Under Vista, with UAC, I cant write to the C:\ drive. So I have to move this log to the %TEMP% directory.
I also created some other logs files, I have to move it to MyDocuments folder. The database used to be located under C:\Program Files\SierraCode\MobilePointofSale1.0, moved to c:\ProgramData\SierraCode. Which is a directory the installer create when installing the app, I gave it full access rights, read-write-create-delete.
All these are basic, changes.I totally made the mistake of testing the app under 'Administrator'. Not all the machines this app will run, the user is an 'Administrator'. So this situation created all these chaos.

So the future.

I am working to make it work under Xtuple, 2-3 more months and I have a beta. Anyone out there who wants to help, who uses Xtuple. Send me an email to test the app.
I am also working simultanously to make it run on the BlackBerry. This will be my first Java app, BlackBerry app. So far I like it, under Blackberry Java 5.0 SDK Beta http://na.blackberry.com/eng/developers/devbetasoftware/javasdk5.jsp , they support SQLite, so I am starting with the database port. I am migrating from C++ MFC to Java. Under Windows, I use CppSqlite3 wrapper.
I experimented with the Iphone, the Android. But I choose Blackberry as my next target. They have a good customer base. Why not. Also having this code under Java will make an easy port to Android JVM. The Android, having python is just amazing.
With the database, I experimented with python (using their db-api2), lua-sqlite3, but the code is in C++. I also took a look at http://www.sqlalchemy.org/docs/ I like them a lot. All this because I want to write one database module and make it work under all scenarios ( Desktop and PDAs). Also thought about porting the GUI to extJS http://www.extjs.com/, to make it work under all these devices, mixing it with PhoneGap http://phonegap.com/, but the learning curve was steep. Writing native code has its advantages, just like wxWidgets does. I am not a Javascript guy, took a look at extJS, it doesnt look easy. I have seen criptic code, for crying outloud have done a lot of MFC but this extJS is out of my ballpark.


So guys enough for now.

Friday, January 22, 2010

It does run on SmartPhone too

Like Microsoft call it Windows Mobile Standard, here is just a picture. I am trying to add it to Microsoft AppStore, lets see how it goes.






Wednesday, January 13, 2010

Web Sync running inside my GUI




Well just a picture with the Web Sync up and running.

I am researching XTuple http://www.xtuple.com/, to add support for a mayor ERP, and still undecided how I will port this app to the iphone.

Here is a link to the download

https://sourceforge.net/projects/sierramobilepos/



Friday, January 1, 2010

The Server Web Sync

I already have the backend sync with the PDA using FTP.

Here is picture with the whole process.

Before



and After