Integrate OB POS

Hello all,

We have a sponsor interested in making an integration between the OpenBravo POS and ADempiere.
The scope of the project is defined here:
http://www.adempiere.com/wiki/index.php/Sponsored_Development:_OB_POS_Integration

We estimate a cost of $2800USD  for the integration, and have sponsors for $1500USD.  If we can get some more sponsorship, we would love to proceed.

If you'd like to participate in the project, you can contact me directly, or send your contribution to contribute-at-idalica-dot-com.  Make sure to let us know whether you want to be credited.

Regards,

Joel S

Dear ADempierians, 

I see a potential in integration of OB POS with ADempiere, so I would like to participate in pushing forward this feature. Actually I can participate only in sponsorship, at this moment.

From this discusion I can see you had already gone long way.
I don't want to say which option is better, this I totally trust you, to pick up the best one, in short and long term. Just I would suggest to consider the possibility to use developed features in another integration projects ( for example Magento or another OSS  … )

Can you pls. let me know amount needed ? And navigate me what to do next ?

Best Ragards
Zilincar Michal

www.zitec.sk

Quick Question . OB POS is better than Posterita?

according to Colin Rooney last nite in the chatroom it is pretty good:

0308am
]
croo

ok - some issues but mostly about integeration with some technical thing that is not really anything to do with us

0308am
]
croo

but because it's part of the technical solution

0308am
]
croo

we get tarred with the same brush

0308am
]
croo

but we have OB POS in maybe 30-40 stores and pentaho to load the sales

0308am
]
croo

working on the movements now

0309am
]
red1

about OB POS.. is it better choice?

0309am
]
croo

the standard inventory moev has no doc for some reason and I have added that

0309am
]
red1

can it handle promotions and multiple payments?

0309am
]
croo

I plan to suggest it go in standard

0309am
]
croo

yeah the OB POS is actually very very nice

0309am
]
croo

doesnt handle promotions though

0309am
]
red1

u know how to integrate Pentaho?

0309am
]
croo

but does lots

0310am
]
red1

so ok i can propose u to do this for Thailand

0310am
]
croo

yes I am a -pentaho data-integeration guru now

0310am
]
red1

huraah

0310am
]
red1

karma is working i hope that way

0310am
]
croo

not really .. but I did find a bug in pentaho!

0310am
]
red1

u made to slog but its really payback later

0310am
]
croo

alas someone else found just before me so I didn't get my name in to log it

0311am
]
croo

I hope so

0311am
]
red1

can it handle multiple payments

0311am
]
red1

?

0312am
]
croo

yes

0312am
]
croo

and can pause a sale,

0312am
]
red1

great

0312am
]
croo

but really nice

0312am
]
red1

ah same like Java POS

0312am
]
red1

can jump to new sales

0312am
]
croo

is it can handle a restaurant

0312am
]
red1

same like Java POS

0312am
]
croo

with a floor plan 

0312am
]
red1

now thats sumtin!

0312am
]
croo

maybe it is the same

0313am
]
croo

this was called TinaPOS befoire OB took it on

0313am
]
croo

perhaps it had other names too

0313am
]
red1

so is the integration done in trunk somewhere?

0313am
]
red1

yeah we know it as TinaPOS

0313am
]
croo

not in trunk no … we did it via pentaho & sppon

0313am
]
croo

spoon

0313am
]
croo

the hope/plan was …

0314am
]
red1

u mean the code is not committed yet?

0314am
]
red1

i saw a wiki page on it

0314am
]
croo

either 1) help with the webservice issue to allow integration directly

0314am
]
croo

or 2)

0314am
]
croo

pentaho "transformations"  (think scripts) can be called from java

0314am
]
red1

u mean TinaPOS has to work via Pentaho?

0315am
]
croo

so use that to call the transformation

0315am
]
croo

no tinaPOS is standaline

0315am
]
croo

no tinaPOS is standalone

0315am
]
croo

we then use pentaho to sync at the close

0315am
]
croo

so it's not java code

0315am
]
croo

but pentaho "transformation"

0316am
]
croo

we load them as Import Orders

0316am
]
croo

then process them so

0316am
]
croo

and we use warehouse orders … so it completes the order/shipment & invoice in adempiere

0316am
]
red1

how long u think u take to teach a team to do it?

0317am
]
croo

in parallel we import all the payments and auto allocate them to the invoice from previous step

0317am
]
croo

not ideal in my opinion but we need a quick result

0317am
]
croo

better one of the 2 options abobe

0317am
]
croo

above

0318am
]
croo

the important piece is I know the POS db structure (and a lot of the code structure as we made some changes in it too - but that is mostly to do with this customer no really generic)

0318am
]
croo

so the hope is we can then use the knowledge to make a trunkable intregration

0319am
]
croo

I also created pentaho scripts to "push" the products/users/taxes. pricelists to the POS cash registers

0320am
]
croo

for now these are scripted to run daily via a mix of cron & pentaho (kitchen & pan)

0320am
]
red1

can u say 1 week is enough for u to guide a team?

0320am
]
croo

into what exactly? the db , the integration?

0321am
]
croo

it's a very technical topic

0321am
]
croo

although actually spoon is graphical in nature

0321am
]
red1

OB POS into ADempiere

0321am
]
croo

well as I said I did it a quick an dirty way …

0321am
]
croo

might be better to approach in a more trunkable fashion

0322am
]
croo

does you project require POS then?

0322am
]
croo

I thought being redbull it might be more manufacturing

0323am
]
red1

yes many retailers clients

0323am
]
red1

before Red Bull

0324am
]
red1

they be going for the smaller ones first
]
croo

aha - well I can explain my approach fairly quickly ok … and the approach is fairly simply you only must know a little about the POS db … then the rest is about storing in the Import Order table in adempiere

0325am
]
croo

ok

Hi,

just for information:
I already integrated Openbravo POS with AD - but it's a very special implementation.
We use Postgres as DB backend so I implemented a stored procedure in PL/pgSQL that updates the customers, products and so on and uploads all ticket data from Openbravo POS and writes them to the i_invoice table of AD.
Currently I have only one issue - when we have sales to unknown customers at the POS then these cannot be distinguished by the AD import routine (it always generates only once invoice from several sales). I'm still figuring out how to solve this.

PS: We use a dblink connection over VPN with Postgres to transfer the data between the two systems.

So do you have an implementation guide or wiki page available for this, so others can utilise your efforts?

With the loss of Posterita, we're interested in getting another POS working too.

Hello all,

From your wiki, the status is "Stagnated because of technical issues".

OpenBravo 2.3 was released quite sometime ago.

Just to let you guys know that I'm going to have a look at this issue from the OpenBravo POS side and at the same time would like to understand the technical issue with the integration requirement.

I am interested If there is sponsorship/bounty and if you guys need a developer.

Regards,
Haris

Haris,
Thanks for your post. It seems this task requires both of what you stated.

Hi ADempierians,
Why wee need another POS ???
Can we focus only on JavaPOS and Posterita?

regards.

aminlutfi    Posterita has gone closed source, and is no longer being developed in the open.   OpenBravo is a very good POS and worth persuing.

Hi everyone,

We are looking into a Openbravo POS to Adempiere integration, so we already reviewed the available articles and docs with pros-cons about the web service integration, technical issues and it  looks blocked  rigth ?

So I am wondering if any of you that have performed this integration with postgres tools directly can share your approach, tips …or any other info useful to replicate or perform a better approach

Do we have any other options to integrate them ?

We are interested to contribute on this area, but we want to be sure that we re-use the community efforts …

Regards,

Pedro Rozo

"With postures tools directly"..
We did it years ago when the pos was still tinapos and the erp still Compiere.
A Compiere process just pulled all the trx directly from the tinapos postgres Db and pushed all the price lists and products etc to the pos. Is that what you mean?
We had to do a lot of changes to the pos as well.

yes, having in mind thew web services issues we are thinking in postgres tools -- how was your experiences syncing b.partners, products ? any relevant suggestion for this process ?

Any summary of the process that you can share, for example database table mappings or something similar ?

BTW: thanks for your quick reply.

Pedro Rozo.

I am making a Release Early contribution on ActiveMQ integration for OB POS to AD ERP  http://red1.org/adempiere/viewtopic.php?f=29&t=1356&p=6646#p6646

3.52min guide for those who wants to integrate Openbravo POS to ADempiere using ActiveMQ - http://www.youtube.com/watch?v=TwXyK1KoO-M .. Or you can extend from the simple backward compatible but comprehensive effort  sponsored by Sysnova. This project is standing mainly on the technical shoulders of Carlos Ruiz and Ajit Kumar. It reference original works of Compiere and TinaPOS.