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
 

Wednesday, May 26, 2010

Mobile POS for Openbravo POS 3/10

I just have way way too much pressure. I feel, I am going to collapse. The software is not ready yet, I have a list of like 7 critical bugs under the openbravo forge. I just finished testing the full sync through USB. I have not done or tested ftp sync, aka web sync. Keep receiving 2-3 request for keys a day.
 Fernando is doing his best http://forge.openbravo.com/my/personal.php?userid=2093, I have no idea when we will finish. These are the list of bugs http://forge.openbravo.com/plugins/mantis/view_all_bug_page.php I am just dead.

Sunday, May 23, 2010

Mobile POS for Openbravo POS 2/10

Well, I worked on starting to update Openbravo POS database from my PDA data, originally tickets and ticketlines. I will publish the results on the Openbravo Development wiki I created, so far so good. Will update sourceforge with the latest code. This means, an end user can create tickets (openbravo pos sales orders) and when sync happens, these tickets can be scrutinized from the Ob POS itself, and exported to the Ob ERP. These relationships on these tables can be very convoluted. I have not found good specs on it. I just basically using pgAdmin III write raw sql and test it inserting/selecting/modifying dummy data. Interpreting the errors, and going back to the drawing board. No wonder I have a beta, this by no means is stable code.
  I noticed also people downloading the soft but they are not registering it. I am sorry but no email, no key. If they think, they can hack the key, look be my guess.
http://forge.openbravo.com/plugins/mwiki/index.php/MobilePOS/Mobile_POS_Development

I am also keeping my eye on the Openbravo ERP so when I finish this one, you are next, and Magento
http://www.magentocommerce.com/support/magento_core_api I will describe Magento as an unbeilabele piece of code written, I mean the best never seen such a great web app.

Sunday, May 16, 2010

Mobile POS for Openbravo POS 1/10

  I guess will need 10 more posts, before I finish. Because actually I am downsizing ( this word is recession friendly) the Mobile POS from QuickBooks to make it works for Ob POS. I have to remove Timetracking, Estimates, Vendors, Bills, Checks and more modules that Ob POS doesn't use. So doing some tests I noticed a menu, with the Timetracking choice enable. This doesn't make sense as Ob POS doesn't have timetracking. I have to make sure I disable, obfuscate, hide all these extra menus, choices, modules because it could confuse an end user.
 Enough, download, remove, re-install, and test to see all data making sense, all menu choices making sense.

 Ob POS has something call tickets. I have to rename the labels to read 'Tickets'

 I know, I know is getting there. I wonder the Spanish translation what will be, and German ? Ob POS runs localized in all these languages, at some point Mobile POS will have to behave/display like his localized master. I will get there, but for now English.

 ...and and you know is coming Mobile POS for Openbravo ERP. I dont know how, when but it will be done. I promise you, you will see OB ERP data on your Windows Mobile phone. Let me finish with this one.

 Thanks

Sunday, May 9, 2010

Openbravo Mobile POS

Things are moving along, I added this weekend the posibilty to login to the PDA, with the same user name and password used by Ob POS.
Now, if someone download the app. to run it you need to register it and I will issue a unique key for end users to test it and interact with it. No email, no trial as simple as that.

Thanks.

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