You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "Vince M. Clark" <vc...@globalera.com> on 2008/08/29 16:33:58 UTC

Re: POS sync ofbiz

Please read: 
http://docs.ofbiz.org/display/OFBIZ/Sync+Setup+Notes+and+Example 

----- Original Message ----- 
From: "Pal InfoCom Technologies" <of...@palinfocom.net> 
To: user@ofbiz.apache.org 
Sent: Friday, August 29, 2008 8:55:13 AM (GMT-0700) America/Denver 
Subject: POS sync ofbiz 


I am facing the problem in POS syncing with the MCS database. 
I am running POS in windown XP and run ofbiz on another linux PC with 
different database. 


How can we set the RMIIF variable. 
I am trying to make syncing directly from MCS to POS exclude PSS. 
I am not using PSS . 

serviceengine.xml 

<?xml version="1.0" encoding="UTF-8"?> 
<!-- 
Licensed to the Apache Software Foundation (ASF) under one 
or more contributor license agreements. See the NOTICE file 
distributed with this work for additional information 
regarding copyright ownership. The ASF licenses this file 
to you under the Apache License, Version 2.0 (the 
"License"); you may not use this file except in compliance 
with the License. You may obtain a copy of the License at 

http://www.apache.org/licenses/LICENSE-2.0 

Unless required by applicable law or agreed to in writing, 
software distributed under the License is distributed on an 
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 
KIND, either express or implied. See the License for the 
specific language governing permissions and limitations 
under the License. 
--> 

<service-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/service-config.xsd"> 

<service-engine name="default"> 
<!-- Name of the service to use for authorization --> 
<authorization service-name="userLogin"/> 

<!-- Thread pool configuration (max/min threads, uses to live and 
time to live) --> 
<thread-pool send-to-pool="pool" 
purge-job-days="4" 
failed-retry-min="3" 
ttl="18000000" 
wait-millis="750" 
jobs="10" 
min-threads="5" 
max-threads="15" 
poll-enabled="true" 
poll-db-millis="20000"> 
<run-from-pool name="pool"/> 
</thread-pool> 

<!-- Service Engine Configuration --> 
<engine name="bsh" 
class="org.ofbiz.service.engine.BeanShellEngine"/> 
<engine name="group" 
class="org.ofbiz.service.group.ServiceGroupEngine"/> 
<engine name="http" class="org.ofbiz.service.engine.HttpEngine"/> 
<engine name="interface" 
class="org.ofbiz.service.engine.InterfaceEngine"/> 
<engine name="jacl" class="org.ofbiz.service.engine.BSFEngine"/> 
<engine name="java" 
class="org.ofbiz.service.engine.StandardJavaEngine"/> 
<engine name="javascript" 
class="org.ofbiz.service.engine.BSFEngine"/> 
<engine name="jms" class="org.ofbiz.service.jms.JmsServiceEngine"/> 
<engine name="jpython" class="org.ofbiz.service.engine.BSFEngine"/> 
<engine name="route" class="org.ofbiz.service.engine.RouteEngine"/> 
<engine name="rmi" class="org.ofbiz.service.rmi.RmiServiceEngine"/> 
<engine name="simple" 
class="org.ofbiz.minilang.SimpleServiceEngine"/> 
<engine name="soap" 
class="org.ofbiz.service.engine.SOAPClientEngine"/> 
<engine name="ofbiz-workflow" 
class="org.ofbiz.workflow.WorkflowEngine"/> 
<engine name="workflow" 
class="org.ofbiz.shark.service.SharkServiceEngine"/> 

<service-location name="main-rmi" 
location="rmi://192.168.11.201:1099/RMIDispatcher"/> 
<service-location name="main-http" 
location="http://192.168.11.201:8080/webtools/control/httpService"/> 

<service-location name="entity-sync-rmi" 
location="rmi://192.168.11.201:1099/RMIDispatcher"/> 
<service-location name="entity-sync-http" 
location="http://192.168.11.201:8080/webtools/control/httpService"/> 

<service-location name="rita-rmi" 
location="rmi://192.168.11.201:1099/RMIDispatcher"/> 
<service-location name="eedcc-test" 
location="http://192.168.11.201:8080/webtools/control/httpService"/> 

<!-- default notification group for all services loaded with 'main' 
loader 
- uncomment this to enable error notification for all services 
- (default.fail.main, default.success.main can also be defined 

<notification-group name="default.error.main"> 
<notification subject="Service Error ${model.serviceName}" 

screen="component://content/widget/EmailScreens.xml#ServiceNotification"/> 
<notify type="from">ofbiz@test.com</notify> 
<notify type="to">error@test.com</notify> 
</notification-group> 
--> 

<!-- Start-Up Services --> 
<!-- 
- runtime-data-id refers to the RuntimeData entity for 
in-parameters 
- runtime-delay is the milliseconds after startup this service 
should run 
- run-in-pool is the name of the pool to run the job in; defaults 
to the send-to-poll (above) 

<startup-service name="testScv" runtime-data-id="9900" 
runtime-delay="0" run-in-pool="pool"/> 
--> 

<!-- JMS Service Queue/Topic Configuration --> 
<!-- 
<jms-service name="serviceMessenger" send-mode="all"> 
<server jndi-server-name="default" 
jndi-name="jms/TopicConnectionFactory" 
topic-queue="jms/OFBTopic" 
type="topic" 
username="admin" 
password="admin" 
listen="true"/> 
</jms-service> 
--> 
</service-engine> 
</service-config> 



The PosSyncSetting.xml 



<!-- MCS->POS Per Store Server to POS Terminal 
This data is loaded on the Master Central Server --> 
<EntityGroup entityGroupId="5501" entityGroupName="POS: Per Store Server 
to POS Terminal"/> 
<!-- these are used to update sync settings on the POS terminals from the 
central server --> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.entity.group" applEnumId="ESIA_INCLUDE"/> 
<!-- this is the general product information needed for pricing, 
promotions, basic product info, etc --> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.product.product" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.product.price" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.product.promo" applEnumId="ESIA_INCLUDE"/> 
<!-- org.ofbiz.product.category is needed for certain promotions, probably 
won't be used much for category browsing in the POS --> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.product.category" applEnumId="ESIA_INCLUDE"/> 
<!-- org.ofbiz.party.party may be needed for certain promotions --> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.party.party" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.pos.PosTerminal" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.product.storage" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.product.store" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.accounting.tax" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.security.login" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.security.securitygroup" 
applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.party.contact" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5501" 
entityOrPackage="org.ofbiz.product.inventory" applEnumId="ESIA_INCLUDE"/> 

<!-- POS->MCS Per Store Server to Central Server --> 
<EntityGroup entityGroupId="5506" entityGroupName="POS: Per Store Server 
to Central Server"/> 
<!-- org.ofbiz.party.party may be needed for order related information, 
like party roles or contact info etc --> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.party.party" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.party.contact" applEnumId="ESIA_INCLUDE"/> 
<!-- all order and related information, including payment, etc info --> 
<EntityGroupEntry entityGroupId="5506" entityOrPackage="org.ofbiz.order" 
applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.accounting.invoice" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.accounting.payment" applEnumId="ESIA_INCLUDE"/> 
<!-- include inventory and issuance info --> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.shipment.issuance" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.product.inventory" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.pos.PosTerminalLog" applEnumId="ESIA_INCLUDE"/> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.pos.PosTerminalState" 
applEnumId="ESIA_INCLUDE"/> 
<!-- include POS transactions --> 
<EntityGroupEntry entityGroupId="5506" 
entityOrPackage="org.ofbiz.pos.PosTerminalInternTx" 
applEnumId="ESIA_INCLUDE"/> 


<!-- Some examples of EntitySync settings for pulling and pushing data 
around --> 
<!-- POS example meant to be used for pushing data from POS to MCS --> 
<EntitySync entitySyncId="POSPUSH" runStatusId="ESR_NOT_STARTED" 
syncSplitMillis="600000" targetServiceName="remoteStoreEntitySyncDataRmi" 
keepRemoveInfoHours="24" forPushOnly="Y"/> 
<EntitySyncIncludeGroup entitySyncId="POSPUSH" entityGroupId="5506"/> 

<!-- POS example meant to be used for pulling data from MCS to POS --> 
<!-- NOTE: for pulling setup the EntitySync record lives on the server the 
data is pulled from and should ONLY BE USED FOR ONE CLIENT! --> 
<EntitySync entitySyncId="<POS Terminal ID>" runStatusId="ESR_NOT_STARTED" 
syncSplitMillis="600000" 
keepRemoveInfoHours="24" forPullOnly="Y"/> 
<EntitySyncIncludeGroup entitySyncId="<POS Terminal ID>" 
entityGroupId="5501"/> 

<!-- POS Push Scheduled Service --> 
<!-- 
<RecurrenceRule recurrenceRuleId="POSPUSH" untilDateTime="" 
frequency="MINUTELY" intervalNumber="5" countNumber="-1"/> 
<RecurrenceInfo recurrenceInfoId="POSPUSH" startDateTime="2000-01-01 
00:00:00.000" recurrenceRuleId="POSPUSH" recurrenceCount="0"/> 
<RuntimeData runtimeDataId="POSPUSH"> 
<runtimeInfo><![CDATA[<?xml version="1.0" encoding="UTF-8"?> 
<ofbiz-ser> 
<map-HashMap> 
<map-Entry> 
<map-Key> 
<std-String value="entitySyncId"/> 
</map-Key> 
<map-Value> 
<std-String value="POSPUSH"/> 
</map-Value> 
</map-Entry> 
</map-HashMap> 
</ofbiz-ser> 
]]></runtimeInfo> 
</RuntimeData> 
<JobSandbox jobId="POSPUSH" jobName="Push POS Data" 
runtimeDataId="POSPUSH" runTime="2000-01-01 00:00:00.000" 
serviceName="runEntitySync" poolId="pool" runAsUser="system" 
recurrenceInfoId="POSPUSH"/> 
--> 

<!-- POSPULL Scheduled Service --> 
<RecurrenceRule recurrenceRuleId="POSPULL" untilDateTime="" 
frequency="HOURLY" intervalNumber="2" countNumber="-1"/> 
<RecurrenceInfo recurrenceInfoId="POSPULL" startDateTime="2000-01-01 
00:15:00.000" recurrenceRuleId="POSPULL" recurrenceCount="0"/> 
<RuntimeData runtimeDataId="POSPULL"> 
<runtimeInfo><![CDATA[<?xml version="1.0" encoding="UTF-8"?> 
<ofbiz-ser> 
<map-HashMap> 
<map-Entry> 
<map-Key> 
<std-String value="entitySyncId"/> 
</map-Key> 
<map-Value> 
<std-String value="<POS Terminal ID>"/> 
</map-Value> 
</map-Entry> 
<map-Entry> 
<map-Key> 
<std-String value="remotePullAndReportEntitySyncDataName"/> 
</map-Key> 
<map-Value> 
<std-String value="remotePullAndReportEntitySyncDataRmi"/> 
</map-Value> 
</map-Entry> 
</map-HashMap> 
</ofbiz-ser> 
]]></runtimeInfo> 
</RuntimeData> 
<JobSandbox jobId="POSPULL" jobName="Pull Data from MCS" 
runtimeDataId="POSPULL" runTime="2000-01-01 00:00:00.000" 
serviceName="runPullEntitySync" poolId="pool" runAsUser="system" 
recurrenceInfoId="POSPULL"/> 

</entity-engine-xml> 



Please provide us correct information if we are missing any step in store 
setup. 
How can we connect the POS store to the central server databse . I am 
difining it only in one file serviveengine.xml. 
How can we connect the databse of the store to the central server. 



Thanks, 
varun mittal 




-- 
View this message in context: http://www.nabble.com/POS-sync-ofbiz-tp19221474p19221474.html 
Sent from the OFBiz - User mailing list archive at Nabble.com.