Ok just too busy

I have not posted in a while.

1. I am still working on the Openbravo ERP --> Windows Mobile
2. I am also working on migrating the data to the web, now the data resides on the desktop and pda devices as sqlite3. It will continue like that but now I will add a new layer, from the desktop to the Web ( on MySQL) from there to the PDA.The PDA will consume this data as Rest services, sometimes they may be able to cache it locally.
3. I am working on an Android (uses Java has local database support aka sqlite3, it is Java code) version and a Windows Mobile 7 version (uses Silverlight, doesnt have local database support aka NO sqlite3, it is C# code).
4. All these will keep me busy for 2-3 months easy.
5. The Web app, will be Asp.net based, I really dont have strong opinion on it, it could have been J2EE or Python or PHP. This app wont be a GUI app, the GUI will still be native on the PDA. However, this web-app will just expose the data to be consumed as Rest services. The code will be using nHibernate 3.0, and Spring.NET. It is not that different from Java Hibernate or Java Spring.
6. I am doing all these by myself, just way way too much work. I will be willing to share the code and do this project open source but first I need to see commitment from the potentail people that may get involved.

Openbravo ERP 5/10

So it begun, I started working on the Mobile Openbravo ERP. The learning curve has been step. Based on my pgAdmin the latest OB database I have, has 473 Tables, 75 View, 382 Functions, just looking at it made me dizzy. I have to create an import/export engine between their database and what I have on the PDA. Took a look at their hibernate module. But I will use exactly the same technique, a python script using sqlalchemy and thats it.

Mobile POS for Openbravo POS 4/10

Ok, some updates, I migrated all the source code to web svn on openbravo forge. I changed the import/export OB POS code from using psycopg2 ( a python postgres driver) to use sqlalchemy. This allow me to use postgres, mysql, oracle or whatever the OB POS database is using. The first two my guess is 80%+ of the customers are using it. I did test using Postgres and MySQL.
Also, started to play with OB POS java code to have one full install with my GUI running inside OB POS. This means the end user will have one place to install the PDAs and manage the PDAs from the OB POS GUI itself. As now, they have two separate products with disparate GUIs and look and feel, one is java swing based, the other one is MFC GUI based. Here is a picture of how the integrated GUI will look, this is a very rough rough rough idea. From the Maintenance->Users I will add a Tab page just as the MFC GUI does with specific PDA Users Roles and PDA specific behavior.

 I wish I can start the Mobile POS----OB ERP sync but lets wait to see when this one will become stable.
Anyway, I am uploading a new version with all these changes.

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.

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.

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

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.