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
 

Thursday, April 22, 2010

Mobile POS for Openbravo POS

I am working on a beta for putting some of the data from Openbravo POS http://www.openbravo.com/product/pos/ in Mobile POS.
Wait 2 more weeks, I have a beta.



It will be easy because OpenBravo POS has its own database, with like 34 tables, they resemble my datamodel. Originally it will be for people using Postgres as the backend. Later I will see what else they use, Apache Derby ?

The one I did for xTuple http://www.xtuple.com/ is still there in sourceforge, but I dont see it becoming popular, it was just a beta.

Ok, Ok I finally have an Alpha, is not complete, I would say is like 85%.
I am uploading it now to sourceforge http://sourceforge.net/projects/sierramobilepos/files/
MobilePointOfSaleOpenbravoPOSIntegration_Beta_Install.msi

Ahhh 5-05-10, I found a bug I was missing a file on the install
C:\Program Files (x86)\SierraCode\MobilePointofSale 1.0 OpenbravoPOS Integration\python\library.zip
I just uploaded the fix to sourceforge.

Sunday, April 18, 2010

A Bug on the QuickBooks version

I had a bug on the Mobile POS the QuickBooks version. It was importing the current opened company file but at the time of syncing with the PDA on the cradle it was only sending one company file. Usually the dummy database I have set up,  C:\ProgramData\SierraCode\Sample Consulting Business.db3.

Please anyone with an old version, download the install version 2.0.1166 remove the previous one, re-install this one.

I know how it goes. Unfortunately this software is not mature 100%. I still find bugs, and end-users tell me of issues. Just have some patience and bear with me all this pain. Until it becomes rock solid, we are getting there one bug at a time. -:)

Like I keep mentioning, email me if you find any issue. I can only test so much.

Thanks

Sunday, April 11, 2010

Windows 7 --- 64 Bit

Well I got a new laptop. I think I was the last one to get it

 http://www.tigerdirect.com/applications/SearchTools/item-details.asp?EdpNo=5646037&CatId=4948

It was similar to this one, Turion II Ultra 2.4, and the HD is 500G 7200, 4G RAM
If you see the laptop I was using to develop before you think I am crazy. It was super slow, some Dual Pentium Windows Vista Toshiba Satellite. It was like 3.6 years old. The Windows Mobile build would take like 3 min, on the new one like 1 min.

So, now I can test under 64 Bit. And....and I found bugs. I compiled the app now the .net part for Any CPU if not I have issues reading from the registry under 64 Bit..

The xTuple http://www.xtuple.com/ Desktop GUI Integration was crashing. I have to fix that too.
The Bold text seems to fix the problem.
lResult = RegOpenKeyEx(HKEY_LOCAL_MACHINE,

KeyToReadOriginal, 0, KEY_READ | KEY_WOW64_64KEY,&hSoftKey);


So, I know some people are downloading the app, but if it is crashing they are not emailing me. Soon, I will change that. Now to run the app you will have to email me first some unique keys that I use. So, I can have more control who, why, when, what is using this.

Addendum 4-23-2010
One more bug, registering qbfc8.dll the COM dll to talk (import/export) with QuickBooks
Under 64 bit, I have to register this dll under $(env.PROGRAMFILES) (x86).
More changes, I included now the QBFC8_0Installer.exe and run it after installing the software. This QBFC8... will install qbfc8.dll for me. Now the install went from 17M to 27M.


Thanks

Wednesday, March 31, 2010

The downloads on the ver 2.2 WM Professional

...has been great.
Anyone, with any question please email me.

  I am inviting, people with any business idea to write me too. I am open to any suggestion, even if someone wants to use the source code for other platforms or backends ( email me), xTuple ? OpenERP ? OpenBravo POS ?
 We can always work something out.



Thanks

Wednesday, March 17, 2010

240x400 480x800 WVGA

480x800 is called Wide VGA example --> HTC phone http://www.microsoft.com/windowsmobile/en-us/devices/devices.mspx?id=900 from ATT

The Windows Mobile Professional works under these two screen resolutions. I will have to update the software under Microsoft marketplace. Mobile POS 2.1 doesn't have that https://marketplace.windowsphone.com/categories.aspx?categoryId=50090&pid=50065 the one under sourceforge http://sourceforge.net/projects/sierramobilepos/files/ does. I updated the one on MS to 2.1 but 2.2 is ready with these new screen sizes.

  I found out when submitted for certification, I did not check these resolutions. So if someone is accessing MS marketplace from an HTC phone 480x800 wont see the software as it was not certified for these resolutions.  Ok Ok my mistake.

  I will give it a couple of weeks, to certify 2.2 with 480x800 and 240x400.

 Any way, any msg, idea, if someone knows when will stop raining in Atlanta pls email me.

Thanks.

Thursday, March 11, 2010

Mobile POS and Credit Card Transaction on the field

I am testing now to allow Credit Card Transactions on the field. I will use http://www.payjunction.com/  for the CC processing, I can also use http://www.firstdata.com/

All these APIs to do credit card transactions on the field use some form of ssl (secure socket layer) to interact with their https servers. Just the same way an end user login to his bank and do online payments. I can write extensively about the subject using openssl but believe me it is very complex.
http://www.openssl.org/

Ok is in sourceforge, the last release with CC txns.




The Windows Mobile Standard







The Windows Mobile Professional

Like I mentioned I am using http://www.payjunction.com/ for the CC txns.

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.