OFBiz › OFBiz - User

POS Setup question

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

12 messages Options

Deyan Tsvetanov

POS Setup question

Hi all,

I am trying to setup POS terminal and I have some questions of which I
couldn't find the answers myself.

1) Where is the relation between the PosTerminal and the ProductStore
created ?

In PosTerminal there is a field: facilityId ( which should be a facility
of type RETAIL_STORE ).

In framework/base/config/pos-containers.xml
the facility needs to be specified one more time:

<property name="facility-id" value="MyRetailStore"/>

But productStoreId is never specified. How does the PosTerminal find out
which is his ProductStore ?

2) Another question about the entity sync services:
http://docs.ofbiz.org/display/OFBIZ/Sync+Setup+Notes+and+Example

Step by Step Instructions

6. Load EntitySync record for PULL on MCS instance (the OFBiz instance
which runs the MCS
7. Load XML on POS instance to trigger PULL sync
8. Load EntitySync PUSH on POS instance(s).
9. When pull is finished, load XML to trigger PUSH

What I couldn't understand is how to "Load EntitySync record for PULL" .
Also - how to "Load XML to trigger PUSH" ...

Any help would be greatly appreciated :)

Thanks in advance,
Deyan

Deyan Tsvetanov

Re: POS Setup question

Well,
I'll recall my 2nd question: seems like the needed parts of
PosSyncSettings.xml could be loaded in

WebTools -> Entity Engine Tools -> XML Data Import.

-- deyan

On Mon, 2009-06-08 at 18:07 +0300, Deyan Tsvetanov wrote:

> Hi all,
>
> I am trying to setup POS terminal and I have some questions of which I
> couldn't find the answers myself.
>
> 1) Where is the relation between the PosTerminal and the ProductStore
> created ?
>
> In PosTerminal there is a field: facilityId ( which should be a
> facility of type RETAIL_STORE ).
>
> In framework/base/config/pos-containers.xml
> the facility needs to be specified one more time:
>
> <property name="facility-id" value="MyRetailStore"/>
>
> But productStoreId is never specified. How does the PosTerminal find
> out which is his ProductStore ?
>
>
> 2) Another question about the entity sync services:
> http://docs.ofbiz.org/display/OFBIZ/Sync+Setup+Notes+and+Example
>
> Step by Step Instructions
>
> 6. Load EntitySync record for PULL on MCS instance (the OFBiz instance
> which runs the MCS
> 7. Load XML on POS instance to trigger PULL sync
> 8. Load EntitySync PUSH on POS instance(s).
> 9. When pull is finished, load XML to trigger PUSH
>
> What I couldn't understand is how to "Load EntitySync record for
> PULL" . Also - how to "Load XML to trigger PUSH" ...
>
>
> Any help would be greatly appreciated :)
>
> Thanks in advance,
> Deyan

Dan Dodd

Importing data: best tools with CSV, XML

I need to do a import from another system. I want to demo using existing
data.

I can get the data in XML and csv formats.
What are the tools to use?
Which is simpler?
I'll have Products (5500) and Customers (2500)

Thanks for some hints.

Dan Dodd

Vince Clark

Re: POS Setup question

In reply to this post by Deyan Tsvetanov

Correct. You load the xml thru web tools. XML examples are in the documentation link you referred to in your question.

Regarding PosTerminal and ProductStore, the relationship is made thru the Facility. If you look at the product store setup you will see that you must choose a facility.

Vince Clark
[hidden email]
(303) 493-6723

----- Original Message -----
From: "Deyan Tsvetanov" <[hidden email]>
To: [hidden email]
Sent: Monday, June 8, 2009 9:18:11 AM GMT -07:00 US/Canada Mountain
Subject: Re: POS Setup question

Well,
I'll recall my 2nd question: seems like the needed parts of
PosSyncSettings.xml could be loaded in

WebTools -> Entity Engine Tools -> XML Data Import.

-- deyan

On Mon, 2009-06-08 at 18:07 +0300, Deyan Tsvetanov wrote:

BJ Freeman

Re: Importing data: best tools with CSV, XML

In reply to this post by Deyan Tsvetanov

simpler is subjective.:D
if the xml is in entity format then you can use the
webtool import screen. Either the file or copy and paste into the textarea.

for CSV i suggest having it tab delimited instead of comma. it only
matters when there is a lot of " in the file and it has not been
escaped, like in the description.

the Datafile is the best way to convert a CSV into entities.
I have one import file that took 12 table definitions to created the
entity files to import through the webtools.

Not all the data can be imported this way. things like images,
categories need to be done by code, using the table defs you created for
the datafile import.

the other option is to hook up your legacy db to ofbiz create the
entities thru the webtools then write some code to import into ofbiz.
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data

Dan Dodd sent the following on 6/8/2009 9:19 AM:

> I need to do a import from another system. I want to demo using existing
> data.
>
> I can get the data in XML and csv formats.
> What are the tools to use?
> Which is simpler?
> I'll have Products (5500) and Customers (2500)
>
> Thanks for some hints.
>
> Dan Dodd
>
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

Deyan Tsvetanov

Re: POS Setup question

In reply to this post by Vince Clark

Yes, it came through my mind that the Pos app might find the
ProductStore through the Facility. But what if there are 2 ProductStores
bound to the same facility ? The GUI lets you do that. Also there isn't
any database restriction that prevents that - so it seems to be normal
behavior.

So I guess when using a PosTerminal for a ProductStore there could be
some other setup requirements - like not to create more than one
ProductStore per Facility ?

Also what about the ProductStore property "One Inventory Facility -
Y/N" ( on the create new store screen ) ?

-- Deyan

On Mon, 2009-06-08 at 13:03 -0500, Vince Clark wrote:

> Correct. You load the xml thru web tools. XML examples are in the documentation link you referred to in your question.
>
> Regarding PosTerminal and ProductStore, the relationship is made thru the Facility. If you look at the product store setup you will see that you must choose a facility.
>
>
> Vince Clark
> [hidden email]
> (303) 493-6723
>
> ----- Original Message -----
> From: "Deyan Tsvetanov" <[hidden email]>
> To: [hidden email]
> Sent: Monday, June 8, 2009 9:18:11 AM GMT -07:00 US/Canada Mountain
> Subject: Re: POS Setup question
>
> Well,
> I'll recall my 2nd question: seems like the needed parts of
> PosSyncSettings.xml could be loaded in
>
> WebTools -> Entity Engine Tools -> XML Data Import.
>
> -- deyan
>
>
> On Mon, 2009-06-08 at 18:07 +0300, Deyan Tsvetanov wrote:
> > Hi all,
> >
> > I am trying to setup POS terminal and I have some questions of which I
> > couldn't find the answers myself.
> >
> > 1) Where is the relation between the PosTerminal and the ProductStore
> > created ?
> >
> > In PosTerminal there is a field: facilityId ( which should be a
> > facility of type RETAIL_STORE ).
> >
> > In framework/base/config/pos-containers.xml
> > the facility needs to be specified one more time:
> >
> > <property name="facility-id" value="MyRetailStore"/>
> >
> > But productStoreId is never specified. How does the PosTerminal find
> > out which is his ProductStore ?
> >
> >
> > 2) Another question about the entity sync services:
> > http://docs.ofbiz.org/display/OFBIZ/Sync+Setup+Notes+and+Example
> >
> > Step by Step Instructions
> >
> > 6. Load EntitySync record for PULL on MCS instance (the OFBiz instance
> > which runs the MCS
> > 7. Load XML on POS instance to trigger PULL sync
> > 8. Load EntitySync PUSH on POS instance(s).
> > 9. When pull is finished, load XML to trigger PUSH
> >
> > What I couldn't understand is how to "Load EntitySync record for
> > PULL" . Also - how to "Load XML to trigger PUSH" ...
> >
> >
> > Any help would be greatly appreciated :)
> >
> > Thanks in advance,
> > Deyan
>

BJ Freeman

Re: POS Setup question

In reply to this post by Vince Clark

you usually have one or more POS hooked to a back office
when working pOS mode it is not working in Server mode, normally
https://demo904.ofbiz.org/catalog/control/EditProductStore?productStoreId=9100
is the product store

Deyan Tsvetanov sent the following on 6/8/2009 12:28 PM:

> Yes, it came through my mind that the Pos app might find the
> ProductStore through the Facility. But what if there are 2 ProductStores
> bound to the same facility ? The GUI lets you do that. Also there isn't
> any database restriction that prevents that - so it seems to be normal
> behavior.
>
> So I guess when using a PosTerminal for a ProductStore there could be
> some other setup requirements - like not to create more than one
> ProductStore per Facility ?
>
> Also what about the ProductStore property "One Inventory Facility -
> Y/N" ( on the create new store screen ) ?
>
>
> -- Deyan
>
>
>
> On Mon, 2009-06-08 at 13:03 -0500, Vince Clark wrote:
>> Correct. You load the xml thru web tools. XML examples are in the documentation link you referred to in your question.
>>
>> Regarding PosTerminal and ProductStore, the relationship is made thru the Facility. If you look at the product store setup you will see that you must choose a facility.
>>
>>
>> Vince Clark
>> [hidden email]
>> (303) 493-6723
>>
>> ----- Original Message -----
>> From: "Deyan Tsvetanov" <[hidden email]>
>> To: [hidden email]
>> Sent: Monday, June 8, 2009 9:18:11 AM GMT -07:00 US/Canada Mountain
>> Subject: Re: POS Setup question
>>
>> Well,
>> I'll recall my 2nd question: seems like the needed parts of
>> PosSyncSettings.xml could be loaded in
>>
>> WebTools -> Entity Engine Tools -> XML Data Import.
>>
>> -- deyan
>>
>>
>> On Mon, 2009-06-08 at 18:07 +0300, Deyan Tsvetanov wrote:
>>> Hi all,
>>>
>>> I am trying to setup POS terminal and I have some questions of which I
>>> couldn't find the answers myself.
>>>
>>> 1) Where is the relation between the PosTerminal and the ProductStore
>>> created ?
>>>
>>> In PosTerminal there is a field: facilityId ( which should be a
>>> facility of type RETAIL_STORE ).
>>>
>>> In framework/base/config/pos-containers.xml
>>> the facility needs to be specified one more time:
>>>
>>> <property name="facility-id" value="MyRetailStore"/>
>>>
>>> But productStoreId is never specified. How does the PosTerminal find
>>> out which is his ProductStore ?
>>>
>>>
>>> 2) Another question about the entity sync services:
>>> http://docs.ofbiz.org/display/OFBIZ/Sync+Setup+Notes+and+Example
>>>
>>> Step by Step Instructions
>>>
>>> 6. Load EntitySync record for PULL on MCS instance (the OFBiz instance
>>> which runs the MCS
>>> 7. Load XML on POS instance to trigger PULL sync
>>> 8. Load EntitySync PUSH on POS instance(s).
>>> 9. When pull is finished, load XML to trigger PUSH
>>>
>>> What I couldn't understand is how to "Load EntitySync record for
>>> PULL" . Also - how to "Load XML to trigger PUSH" ...
>>>
>>>
>>> Any help would be greatly appreciated :)
>>>
>>> Thanks in advance,
>>> Deyan
>
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

Dan Dodd

RE: Importing data: best tools with CSV, XML

In reply to this post by BJ Freeman

BJ, thanks for the reply. I did a tab delimited import with a few fields
and it worked. I can expand that to include all the fields.

My XML file is output from the existing system and not in entity format.
What is the tool of choice to convert it to an entity format, if any?

Dan Dodd

-----Original Message-----
From: BJ Freeman [mailto:[hidden email]]
Sent: Monday, June 08, 2009 1:32 PM
To: [hidden email]
Subject: Re: Importing data: best tools with CSV, XML

simpler is subjective.:D
if the xml is in entity format then you can use the
webtool import screen. Either the file or copy and paste into the
textarea.

for CSV i suggest having it tab delimited instead of comma. it only
matters when there is a lot of " in the file and it has not been
escaped, like in the description.

the Datafile is the best way to convert a CSV into entities.
I have one import file that took 12 table definitions to created the
entity files to import through the webtools.

Not all the data can be imported this way. things like images,
categories need to be done by code, using the table defs you created for
the datafile import.

the other option is to hook up your legacy db to ofbiz create the
entities thru the webtools then write some code to import into ofbiz.
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data

Dan Dodd sent the following on 6/8/2009 9:19 AM:
> I need to do a import from another system. I want to demo using
existing

> data.
>
> I can get the data in XML and csv formats.
> What are the tools to use?
> Which is simpler?
> I'll have Products (5500) and Customers (2500)
>
> Thanks for some hints.
>
> Dan Dodd
>
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&tr
k=tab_pro
Systems Integrator.

BJ Freeman

Re: Importing data: best tools with CSV, XML

In reply to this post by BJ Freeman

though I have not done it and I am not sure there is any real docs on it
you can use an xlst to translate the xml files.
you can make an ftl to do this then send it to the webtools through the
controller.
this is a manual system.

The other is to write a importer in java that read your xml, make a map,
then create the entity record.
you can look at the webtools import page to get to the code that is used.

Dan Dodd sent the following on 6/10/2009 9:30 AM:

> BJ, thanks for the reply. I did a tab delimited import with a few fields
> and it worked. I can expand that to include all the fields.
>
> My XML file is output from the existing system and not in entity format.
> What is the tool of choice to convert it to an entity format, if any?
>
> Dan Dodd
>
>
> -----Original Message-----
> From: BJ Freeman [mailto:[hidden email]]
> Sent: Monday, June 08, 2009 1:32 PM
> To: [hidden email]
> Subject: Re: Importing data: best tools with CSV, XML
>
> simpler is subjective.:D
> if the xml is in entity format then you can use the
> webtool import screen. Either the file or copy and paste into the
> textarea.
>
> for CSV i suggest having it tab delimited instead of comma. it only
> matters when there is a lot of " in the file and it has not been
> escaped, like in the description.
>
> the Datafile is the best way to convert a CSV into entities.
> I have one import file that took 12 table definitions to created the
> entity files to import through the webtools.
>
> Not all the data can be imported this way. things like images,
> categories need to be done by code, using the table defs you created for
> the datafile import.
>
> the other option is to hook up your legacy db to ofbiz create the
> entities thru the webtools then write some code to import into ofbiz.
> http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data
>
>
>
>
> Dan Dodd sent the following on 6/8/2009 9:19 AM:
>> I need to do a import from another system. I want to demo using
> existing
>> data.
>>
>> I can get the data in XML and csv formats.
>> What are the tools to use?
>> Which is simpler?
>> I'll have Products (5500) and Customers (2500)
>>
>> Thanks for some hints.
>>
>> Dan Dodd
>>
>>
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

Vince Clark

Re: Importing data: best tools with CSV, XML

In reply to this post by BJ Freeman

BJ - I have a question about the link you provided:
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data

Specifically the section about connecting to a legacy database. Do you need to define another delegator in entityengine.xml?

Vince Clark
[hidden email]
(303) 493-6723

----- Original Message -----
From: "BJ Freeman" <[hidden email]>
To: [hidden email]
Sent: Monday, June 8, 2009 12:31:58 PM GMT -07:00 US/Canada Mountain
Subject: Re: Importing data: best tools with CSV, XML

simpler is subjective.:D
if the xml is in entity format then you can use the
webtool import screen. Either the file or copy and paste into the textarea.

for CSV i suggest having it tab delimited instead of comma. it only
matters when there is a lot of " in the file and it has not been
escaped, like in the description.

the Datafile is the best way to convert a CSV into entities.
I have one import file that took 12 table definitions to created the
entity files to import through the webtools.

Not all the data can be imported this way. things like images,
categories need to be done by code, using the table defs you created for
the datafile import.

the other option is to hook up your legacy db to ofbiz create the
entities thru the webtools then write some code to import into ofbiz.
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data

Dan Dodd sent the following on 6/8/2009 9:19 AM:

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

Vivek Mishra-2

Re: Importing data: best tools with CSV, XML

Hello Vince,

Data file tool is very effective for fulfilling your requirement if you have a record which provides primary key as well.
On the other hand I couldn't find it suitable if you don't have primary key in your record, in this case custom code is needed to handle the situation.
Thanks !

Regards,
--
Vivek Mishra

Vince Clark wrote:

BJ - I have a question about the link you provided:
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data

Specifically the section about connecting to a legacy database. Do you need to define another delegator in entityengine.xml?

Vince Clark 
[hidden email] 
(303) 493-6723 

----- Original Message -----
From: "BJ Freeman" [hidden email]
To: [hidden email]
Sent: Monday, June 8, 2009 12:31:58 PM GMT -07:00 US/Canada Mountain
Subject: Re: Importing data: best tools with CSV, XML

simpler is subjective.:D
if the xml is in entity format then you can use the
webtool import screen. Either the file or copy and paste into the textarea.

for CSV i suggest having it tab delimited instead of comma. it only
matters when there is a lot of " in the file and it has not been
escaped, like in the description.

the Datafile is the best way to convert a CSV into entities.
I have one import file that took 12 table definitions to created the
entity files to import through the webtools.

Not all the data can be imported this way. things like images,
categories need to be done by code, using the table defs you created for
the datafile import.

the other option is to hook up your legacy db to ofbiz create the
entities thru the webtools then write some code to import into ofbiz.
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data




Dan Dodd sent the following on 6/8/2009 9:19 AM:

I need to do a import from another system. I want to demo using existing
data.

I can get the data in XML and csv formats. 
What are the tools to use?
Which is simpler?
I'll have Products (5500) and Customers (2500)

Thanks for some hints. 

Dan Dodd

smime.p7s (4K) Download Attachment

BJ Freeman

Re: Importing data: best tools with CSV, XML

In reply to this post by Vince Clark

yes copy a database source and name it something.
that is what you will use to export the entities.
in web tools.
then assign a delegator to it which will read the entities you created,
and you map then over to ofbiz entities and create new records.
you can do this in java or mini language.

Vince Clark wrote:
> BJ - I have a question about the link you provided:
> http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data
>
> Specifically the section about connecting to a legacy database. Do you
need to define another delegator in entityengine.xml?

>
> Vince Clark [hidden email] (303) 493-6723
> ----- Original Message -----
> From: "BJ Freeman" <[hidden email]>
> To: [hidden email]
> Sent: Monday, June 8, 2009 12:31:58 PM GMT -07:00 US/Canada Mountain
> Subject: Re: Importing data: best tools with CSV, XML
>
> simpler is subjective.:D
> if the xml is in entity format then you can use the
> webtool import screen. Either the file or copy and paste into the

textarea.

>
> for CSV i suggest having it tab delimited instead of comma. it only
> matters when there is a lot of " in the file and it has not been
> escaped, like in the description.
>
> the Datafile is the best way to convert a CSV into entities.
> I have one import file that took 12 table definitions to created the
> entity files to import through the webtools.
>
> Not all the data can be imported this way. things like images,
> categories need to be done by code, using the table defs you created for
> the datafile import.
>
> the other option is to hook up your legacy db to ofbiz create the
> entities thru the webtools then write some code to import into ofbiz.
> http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data
>
>
>
>
> Dan Dodd sent the following on 6/8/2009 9:19 AM:
>
>> I need to do a import from another system. I want to demo using existing
>> data.
>>
>> I can get the data in XML and csv formats. What are the tools to use?
>> Which is simpler?
>> I'll have Products (5500) and Customers (2500)
>>
>> Thanks for some hints.
>> Dan Dodd
>>
>>
>>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.