POS sync ofbiz

[Pal Infocom Technologies-2]

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"?>


<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">
       
        <authorization service-name="userLogin"/>

       
        <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>

       
        <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"/>

       
       
       
       

       
       
    </service-engine>
</service-config>
 


The PosSyncSetting.xml



  
 <EntityGroup entityGroupId="5501" entityGroupName="POS: Per Store Server
 to POS Terminal"/> 
  
<EntityGroupEntry entityGroupId="5501"
 entityOrPackage="org.ofbiz.entity.group" applEnumId="ESIA_INCLUDE"/> 
  
 <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"/> 
  
 <EntityGroupEntry entityGroupId="5501"
entityOrPackage="org.ofbiz.product.category" applEnumId="ESIA_INCLUDE"/> 
  
 <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"/> 
 
  
 <EntityGroup entityGroupId="5506" entityGroupName="POS: Per Store Server
 to Central Server"/> 
  
 <EntityGroupEntry entityGroupId="5506"
 entityOrPackage="org.ofbiz.party.party" applEnumId="ESIA_INCLUDE"/> 
 <EntityGroupEntry entityGroupId="5506"
 entityOrPackage="org.ofbiz.party.contact" applEnumId="ESIA_INCLUDE"/> 
  
 <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"/> 
  
 <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"/> 
  
 <EntityGroupEntry entityGroupId="5506"
 entityOrPackage="org.ofbiz.pos.PosTerminalInternTx"
 applEnumId="ESIA_INCLUDE"/> 
 
 
  
  
 <EntitySync entitySyncId="POSPUSH" runStatusId="ESR_NOT_STARTED"
 syncSplitMillis="600000" targetServiceName="remoteStoreEntitySyncDataRmi"
 keepRemoveInfoHours="24" forPushOnly="Y"/> 
 <EntitySyncIncludeGroup entitySyncId="POSPUSH" entityGroupId="5506"/> 
 
  
  
 <EntitySync entitySyncId="<POS Terminal ID>" runStatusId="ESR_NOT_STARTED"
 syncSplitMillis="600000"
 keepRemoveInfoHours="24" forPullOnly="Y"/>
 <EntitySyncIncludeGroup entitySyncId="<POS Terminal ID>"
 entityGroupId="5501"/>
 
  
 
 
  
 <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

[Vince Clark]

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

----- Original Message -----
From: "Pal InfoCom Technologies" <[hidden email]>
To: [hidden email]
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">[hidden email]</notify>
<notify type="to">[hidden email]</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.