Re: WebPOS Setup

[stimits]

But...how do I add a retail store? I only see a way to edit an existing retail 
store. One company should have at least one retail store, possibly many (unless 
it does all sales online). If I can't add a store I will have none...if I have 
no stores, I can't open a WebPOS terminal because there are no terminals (there 
can't be terminals without retail stores).
 
- Original Message -From: Shi Jinghai To: 
user@ofbiz.apache.orgSent: Tue, 04 Apr 2017 02:15:30 - (UTC)Subject: Re: 
WebPOS Setup

I think current data structure is right, in China, a retail store has at least 
2 facilities, one for storage, one for shop space. You can add an area amount 
to the shop space facility, and then it's easy to get its sales per square 
meter from order statics by day, month or year, this data can help a retailer 
to improve his/her product visual.

-邮件原件-发件人: stim...@comcast.net [mailto:stim...@comcast.net] 发送时间: 
2017年4月4日 4:23收件人: user@ofbiz.apache.org主题: Re: WebPOS Setup

Hi, Under Asset Maintenance, Facility, I can change existing facilities, but 
cannot add a new one. Should there be a button for "Add New Facility"? Is a 
retail store not a facility in this context? I do see that under Asset 
Maintenance, Fixed Assets has a button for New Fixed Asset, but this does not 
seem correct for adding a retail store. Same for New Maintenance...Maintenance 
items just doesn't seem like they are intended for adding a retail store 
facility. Perhaps I'm just not used to how the app words things. Just for 
humor, a modified quote: My kingdom for an Add Facility button! Thanks! PS: I 
don't have a kingdom, YMMV. - Original Message -From: Pierre Smits 
To: user@ofbiz.apache.orgSent: Mon, 03 Apr 2017 
18:59:28 - (UTC)Subject: Re: WebPOS Setup

Hi Dan,

You can add new facilities, as well as existing ones, through theassetmaint 
appl.

Best regards,

Pierre Smits

ORRTIZ.COM OFBiz based solutions & services

OFBiz Extensions Marketplacehttp://oem.ofbizci.net/oci-2/

On Mon, Apr 3, 2017 at 8:35 PM,  wrote:

> Just to reply to my own post on what I've found is that with sample data> you 
> can search and find the facility with facilityId MyRetailStore, but the> 
> functionality to add more facilities from scratch (to create a new physical> 
> retail store facility) seems to be completely non-existent (you can edit> 
> facilities, but you cannot create them...MyRetailStore is not part of a> 
> facility group, it is a facility it seems). I hope I'm wrong...can anyone> 
> verify if this is correct or not since I have so little experience with> this 
> app?>> It would make sense if adding a WebPOS terminal were part of the 
> retail> store edit since terminals would be associated that retail store. 
> When> editing the information for the existing sample data retail store there 
> is> (unfortunately) no link or clue as to how to edit any WebPOS terminals> 
> associated with that store.>> - Original Message -From: 
> stimits@comcast.netTo:> user@ofbiz.apache.orgSent: Mon, 03 Apr 2017 02:20:27 
> - (UTC)Subject:> Re: WebPOS Setup>> Hi, I'm sure you are correct on this, 
> I need to add facilityId> MyRetailStore...I have facilityId Company with a 
> retail store type, but> this is not the same (and editing facilityId from 
> MyRetailStore to Company> does not help). I used the setup app originally on 
> the seeded (but not data> demo added) instance to add Company, but I'm having 
> a hard time figuring> out where a new facility other than the original 
> Company is> added...apparently this is not from the facility function of the 
> setup> application (I can edit "Company" ID, but I can't add more 
> facilities). Is> this a case of my needing to think about adding ID 
> MyRetailStore as> something other than a facility in the setup application? 
> E.G., some> sub-menu of Company setup? Thanks! - Original Message 
> -From: Pierre> Smits To: 
> user@ofbiz.apache.orgSent: Sun, 02 Apr> 2017 07:02:50 - (UTC)Subject: Re: 
> WebPOS Setup>> HI Dan,>> Please ensure that there also is a: facilityId="MyRetailStore" />> uploaded prior to uploading thedata regarding 
> terminals,>> Best regards,>> Pierre Smits>> ORRTIZ.COM 
> OFBiz based solutions & services>> OFBiz Extensions 
> Marketplacehttp://oem.ofbizci.net/oci-2/>> On Sun, Apr 2, 2017 at 1:54 AM, 
>  wrote:>> > Just an apology for prior email formatting. 
> It was nicely formatted and>> readable, but comcast web mail strips the 
> formatting and throws away my>> work sometimes.>

Re: WebPOS Setup

[Shi Jinghai]

I think current data structure is right, in China, a retail store has at least 
2 facilities, one for storage, one for shop space. You can add an area amount 
to the shop space facility, and then it's easy to get its sales per square 
meter from order statics by day, month or year, this data can help a retailer 
to improve his/her product visual.


-邮件原件-
发件人: stim...@comcast.net [mailto:stim...@comcast.net] 
发送时间: 2017年4月4日 4:23
收件人: user@ofbiz.apache.org
主题: Re: WebPOS Setup

Hi,
 
Under Asset Maintenance, Facility, I can change existing facilities, but cannot 
add a new one. Should there be a button for "Add New Facility"? Is a retail 
store not a facility in this context?
 
I do see that under Asset Maintenance, Fixed Assets has a button for New Fixed 
Asset, but this does not seem correct for adding a retail store. Same for New 
Maintenance...Maintenance items just doesn't seem like they are intended for 
adding a retail store facility. Perhaps I'm just not used to how the app words 
things.
 
Just for humor, a modified quote: My kingdom for an Add Facility button!
 
Thanks!
 
PS: I don't have a kingdom, YMMV.
 
- Original Message -From: Pierre Smits To: 
user@ofbiz.apache.orgSent: Mon, 03 Apr 2017 18:59:28 - (UTC)Subject: Re: 
WebPOS Setup

Hi Dan,

You can add new facilities, as well as existing ones, through theassetmaint 
appl.

Best regards,

Pierre Smits

ORRTIZ.COM OFBiz based solutions & services

OFBiz Extensions Marketplacehttp://oem.ofbizci.net/oci-2/

On Mon, Apr 3, 2017 at 8:35 PM,  wrote:

> Just to reply to my own post on what I've found is that with sample data> you 
> can search and find the facility with facilityId MyRetailStore, but the> 
> functionality to add more facilities from scratch (to create a new physical> 
> retail store facility) seems to be completely non-existent (you can edit> 
> facilities, but you cannot create them...MyRetailStore is not part of a> 
> facility group, it is a facility it seems). I hope I'm wrong...can anyone> 
> verify if this is correct or not since I have so little experience with> this 
> app?>> It would make sense if adding a WebPOS terminal were part of the 
> retail> store edit since terminals would be associated that retail store. 
> When> editing the information for the existing sample data retail store there 
> is> (unfortunately) no link or clue as to how to edit any WebPOS terminals> 
> associated with that store.>> - Original Message -From: 
> stimits@comcast.netTo:> user@ofbiz.apache.orgSent: Mon, 03 Apr 2017 02:20:27 
> - (UTC)Subject:> Re: WebPOS Setup>> Hi, I'm sure you are correct on this, 
> I need to add facilityId> MyRetailStore...I have facilityId Company with a 
> retail store type, but> this is not the same (and editing facilityId from 
> MyRetailStore to Company> does not help). I used the setup app originally on 
> the seeded (but not data> demo added) instance to add Company, but I'm having 
> a hard time figuring> out where a new facility other than the original 
> Company is> added...apparently this is not from the facility function of the 
> setup> application (I can edit "Company" ID, but I can't add more 
> facilities). Is> this a case of my needing to think about adding ID 
> MyRetailStore as> something other than a facility in the setup application? 
> E.G., some> sub-menu of Company setup? Thanks! - Original Message 
> -From: Pierre> Smits To: 
> user@ofbiz.apache.orgSent: Sun, 02 Apr> 2017 07:02:50 - (UTC)Subject: Re: 
> WebPOS Setup>> HI Dan,>> Please ensure that there also is a: facilityId="MyRetailStore" />> uploaded prior to uploading thedata regarding 
> terminals,>> Best regards,>> Pierre Smits>> ORRTIZ.COM 
> OFBiz based solutions & services>> OFBiz Extensions 
> Marketplacehttp://oem.ofbizci.net/oci-2/>> On Sun, Apr 2, 2017 at 1:54 AM, 
>  wrote:>> > Just an apology for prior email formatting. 
> It was nicely formatted and>> readable, but comcast web mail strips the 
> formatting and throws away my>> work sometimes.>

Re: entitydef XIncludes

[Taher Alkhateeb]

In that case perhaps one solution is to define as many files as you want
and then include them all in ofbiz-component.xml as entity resources of
type model .. I think this might achieve what you are looking for. Just
make sure to load them in the proper sequence.

On Mon, Apr 3, 2017 at 11:20 PM, Max Peak  wrote:

> Taher,
>
> Thanks for your reply. I am planning a collection of BI data collection
> services that may require a large set of tables in OLAP. My thought was to
> put related defs in separate files for a logical organization and just
> include them in the master def files. It's not a big deal to put all in one
> file, it just seemed more organized.
>
> Thanks again,
> Max
>
> -Original Message-
> From: Taher Alkhateeb [mailto:slidingfilame...@gmail.com]
> Sent: Monday, April 03, 2017 12:01 PM
> To: user@ofbiz.apache.org
> Subject: Re: entitydef XIncludes
>
> Hi Max,
>
> You can't (violates the XML schemas) but why would you anyway? Why not
> define the new entities directly in the XML file? Or why not create a new
> file for that purpose? Seems strange that you want to compose files.
>
>
> On Apr 3, 2017 8:38 PM, "Max Peak"  wrote:
>
> Greetings user list,
>
>
>
> In order to add DB tables to the Business Intelligence app, I used
> XIncludes to import xml fragments into entitygroup.xml and entitymodel.xml.
>
> On restart, entities were not added, and the err.log reports:
>
>
>
> Invalid content was found starting with element 'xi:include'. One of
> '{copyright, author, version, default-resource-name, entity, view-entity,
> extend-entity}' is expected
>
>
>
> Is there a way to structure the entitydefs with includes?
>
>
>
> Max Peak
>
>

Re: Equivalent Steps for Creating Sample Data

[Taher Alkhateeb]

Hello, inline...

On Mar 26, 2017 11:59 PM,  wrote:

...
> cleanAll deletes everything as long as you are using an embedded
database> (default) otherwise you have to clean itup yourself.
...

This is the reason why I'm trying to better understand if loadDefault and
cleanAll have a series of smaller commands which are equivalent...I am not
using the embedded database, and those commands leave a non-working ofbiz
while not clearing out or resetting data in PostgreSQL. The README.md does
not say much about PostgreSQL.


You are right. Maybe we should mention in README.md that the cleanAll task
wipes out only the embedded database.


When configured to use PostgreSQL running "gradlew cleanAll loadDefault"
leaves ofbiz in a non-working state. Clearing out the ofbiz install,
running it with Derby and the default data makes ofbiz work again;
reconfiguring to once again use PostgreSQL succeeds, but the previous
experimental data changes are there, not the fresh demo data. This is
expected since gradlew commands have no concept of the XML database
configuration...only commands going through ofbiz itself would have any way
of talking to the database as configured in entityengine.xml. If I know
exactly what sub-steps cleanAll and loadDefault take I might be able to
clean out my PostgreSQL tables and load default sample data in PostgreSQL
with a standard mechanism which is repeatable. Manually dropping and
recreating a database or wiping out my install and starting from scratch
(but pointing back at the original PostgreSQL database) does not give me
confidence that I understand enough about the process to put this in place
in a real store depending on the software (hard drives die, machines die,
networks change, various software versions migrate to newer versions, so
on). I'd like to understand what goes on under cleanAll and loadDefault and
equivalents if working through ofbiz instead of gradlew.


What you are talking about here is what is referred to as OFBiz server
commands (also mentioned in README.md) as opposed to regular gradle tasks.
OFBiz commands are limited to a few things (start ofbiz, stop ofbiz, load
data, and run tests). You can get help on those using the command ./gradlew
"ofbiz --help"


An alternate view of my question might read: Does "gradlew cleanAll
loadDefault" have an equivalent using ofbiz's interface which might work in
a uniform way regardless of which database is used? The information in
README.md is minimal with regard to the right way to modify procedures when
using a non-Derby DB.


cleanAll deletes a bunch of files. Since Derby is an embedded database
deleting it is just a matter of deleting its files. loadDefault is an alias
for "ofbiz --load-data" which by default loads all data.

OFBiz cannot (and should not) have an equivalent command to cleanup a
standalone production environment database like postgres or mysql. Derby is
just a convenience embedded databaae for quick testing and development and
that's why cleanAll deletes its files. Other databases are used in
production and should not be altered from the build system. You just
initialize them once and off you go. This is not different from the way
most other web software frameworks / applications work for example.


Thanks!

Re: WebPOS Setup

[stimits]

Just to reply to my own post on what I've found is that with sample data you 
can search and find the facility with facilityId MyRetailStore, but the 
functionality to add more facilities from scratch (to create a new physical 
retail store facility) seems to be completely non-existent (you can edit 
facilities, but you cannot create them...MyRetailStore is not part of a 
facility group, it is a facility it seems). I hope I'm wrong...can anyone 
verify if this is correct or not since I have so little experience with this 
app?
 
It would make sense if adding a WebPOS terminal were part of the retail store 
edit since terminals would be associated that retail store. When editing the 
information for the existing sample data retail store there is (unfortunately) 
no link or clue as to how to edit any WebPOS terminals associated with that 
store.
 
- Original Message -From: stimits@comcast.netTo: 
user@ofbiz.apache.orgSent: Mon, 03 Apr 2017 02:20:27 - (UTC)Subject: Re: 
WebPOS Setup

Hi, I'm sure you are correct on this, I need to add facilityId 
MyRetailStore...I have facilityId Company with a retail store type, but this is 
not the same (and editing facilityId from MyRetailStore to Company does not 
help). I used the setup app originally on the seeded (but not data demo added) 
instance to add Company, but I'm having a hard time figuring out where a new 
facility other than the original Company is added...apparently this is not from 
the facility function of the setup application (I can edit "Company" ID, but I 
can't add more facilities). Is this a case of my needing to think about adding 
ID MyRetailStore as something other than a facility in the setup application? 
E.G., some sub-menu of Company setup? Thanks! - Original Message -From: 
Pierre Smits To: user@ofbiz.apache.orgSent: Sun, 02 Apr 
2017 07:02:50 - (UTC)Subject: Re: WebPOS Setup

HI Dan,

Please ensure that there also is a: 
uploaded prior to uploading thedata regarding terminals,

Best regards,

Pierre Smits

ORRTIZ.COM OFBiz based solutions & services

OFBiz Extensions Marketplacehttp://oem.ofbizci.net/oci-2/

On Sun, Apr 2, 2017 at 1:54 AM,  wrote:

> Just an apology for prior email formatting. It was nicely formatted and> 
> readable, but comcast web mail strips the formatting and throws away my> work 
> sometimes.

entitydef XIncludes

[Max Peak]

Greetings user list,

 

In order to add DB tables to the Business Intelligence app, I used XIncludes
to import xml fragments into entitygroup.xml and entitymodel.xml.

On restart, entities were not added, and the err.log reports:

 

Invalid content was found starting with element 'xi:include'. One of
'{copyright, author, version, default-resource-name, entity, view-entity,
extend-entity}' is expected

 

Is there a way to structure the entitydefs with includes?

 

Max Peak

 

Re: Special char

[Mike]

> The demo is not backed by PostgreSQL but Apache Derby, same for OFBiz
when installed locally.

Thanks Jacques.  Good to know.  Maybe Derby is by default UTF8, but I
haven't been able to verify this.

On Sun, Apr 2, 2017 at 10:08 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Mike,
>
> Inline
>
> Le 02/04/2017 à 22:44, Mike a écrit :
>
>> Great  Incidentally, I have no idea why the default for mysql,
>> *STILL*,
>> for ofbiz, is not UTF8.
>>
> The MySQL specifications in entityengine.xml are old. They need to be
> updated. Please create a Jira for that, follow
> https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+
> Contributors+Best+Practices
>
>>   Any modern database should, by default, be UTF8
>> compliant. The reason why the ofbiz multi-language demo works be because
>> the backend is PostgreSQL. If the same demo data was hosted by mysql, the
>> demo wouldn't even work with the defaults in entity.properties.
>>
>> Committers:  Please justify this.
>>
> The demo is not backed by PostgreSQL but Apache Derby, same for OFBiz when
> installed locally.
>
>> Converting to postgresq?
>>
>> https://wiki.postgresql.org/wiki/Converting_from_other_Datab
>> ases_to_PostgreSQL
>>
> The OFBiz projects has not special recommendations about RDMS to use.
> Because it depends on your needs, etc. Apache Derby is not recommended for
> production though.
> I personally, and a number of other committers, recommend to use
> PostgreSQL, but once correctly configured MySQL and its avatars are also
> good choices.
>
> Jacques
>
>
>> On Sun, Apr 2, 2017 at 10:29 AM, Ingo Wolfmayr 
>> wrote:
>>
>> Thanks, that fixed it.
>>>
>>> I am working on moving to postgresql. Did you move an existing
>>> ofbiz-mysql
>>> database to postgresql? If yes, what was your way of doing it if I may
>>> ask?
>>>
>>> -Ursprüngliche Nachricht-
>>> Von: Mike [mailto:mz4whee...@gmail.com]
>>> Gesendet: Samstag, 1. April 2017 01:10
>>> An: user 
>>> Betreff: Re: Special char
>>>
>>> I had this exact same problem back when I was using mysql.  This is how I
>>> finally got mysql to properly render UTF8
>>>
>>> entity.properties
>>>  character-set="utf8"
>>>  collate="utf8_general_ci">
>>>  jdbc-uri="jdbc:mysql://
>>> 10.2.10.101/ofbiz?autoReconnect=true;characterEncoding=UTF-8"
>>>
>>> Also:
>>> my.cnf
>>> character-set-server=utf8
>>> default-collation=utf8_unicode_ci
>>>
>>> Then (I believe) you have to re-create the database to pick up the UTF8
>>> stuff and reload the UTF8 data.  There may be a way to convert an
>>> existing
>>> DB on the fly to UTF8... However:
>>>
>>> The data in the DB is not UTF8 so you are (most likely) screwed.  THIS is
>>> exactly why I ditched mysql and went with postgresql, where everything is
>>> UTF8 by default.
>>>
>>> On Fri, Mar 31, 2017 at 2:39 AM, Ingo Wolfmayr 
>>> wrote:
>>>
>>> Hi everybody,

 I have a question regarding special chars:

 Environment: Ofbiz trunk, Mysql 5.6
 Entity Engine: collate="utf8_unicode_ci", jdbc-uri="jdbc:mysql://
 localhost/ofbiz_test?autoReconnect=truecharacterEncoding=UTF-8"

 I have the following strings:
 1) Käse
 2) Akrapovič

 The first one is working. The second becomes Akrapovi?

 Both strings work in the online demo. Does anyone has an idea what I
 may do wrong?

 Best regards,
 Ingo


>

AW: Special char

[Ingo Wolfmayr]

Hi,

maybe it would be a good idea to adopt the Mysql Wiki:

https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OFBiz+from+Derby+to+MySQL+database

entity.properties:
change character-set="latin1" to character-set="utf8"
change collate="latin1_general_cs" to "utf8_general_ci"
change jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true" to 
jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true 
;characterEncoding=UTF-8"

mysql.conf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

Mysql Version: > 5.6.4 (supports datetime milliseconds)

Best regards,
Ingo

-Ursprüngliche Nachricht-
Von: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
Gesendet: Montag, 3. April 2017 07:08
An: user@ofbiz.apache.org
Betreff: Re: Special char

Hi Mike,

Inline

Le 02/04/2017 à 22:44, Mike a écrit :
> Great  Incidentally, I have no idea why the default for mysql, 
> *STILL*, for ofbiz, is not UTF8.
The MySQL specifications in entityengine.xml are old. They need to be updated. 
Please create a Jira for that, follow 
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices
>   Any modern database should, by default, be UTF8 compliant. The 
> reason why the ofbiz multi-language demo works be because the backend 
> is PostgreSQL. If the same demo data was hosted by mysql, the demo 
> wouldn't even work with the defaults in entity.properties.
>
> Committers:  Please justify this.
The demo is not backed by PostgreSQL but Apache Derby, same for OFBiz when 
installed locally.
> Converting to postgresq?
>
> https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_Po
> stgreSQL
The OFBiz projects has not special recommendations about RDMS to use. Because 
it depends on your needs, etc. Apache Derby is not recommended for production 
though.
I personally, and a number of other committers, recommend to use PostgreSQL, 
but once correctly configured MySQL and its avatars are also good choices.

Jacques
>
> On Sun, Apr 2, 2017 at 10:29 AM, Ingo Wolfmayr 
> 
> wrote:
>
>> Thanks, that fixed it.
>>
>> I am working on moving to postgresql. Did you move an existing 
>> ofbiz-mysql database to postgresql? If yes, what was your way of doing it if 
>> I may ask?
>>
>> -Ursprüngliche Nachricht-
>> Von: Mike [mailto:mz4whee...@gmail.com]
>> Gesendet: Samstag, 1. April 2017 01:10
>> An: user 
>> Betreff: Re: Special char
>>
>> I had this exact same problem back when I was using mysql.  This is 
>> how I finally got mysql to properly render UTF8
>>
>> entity.properties
>>  character-set="utf8"
>>  collate="utf8_general_ci">
>>  jdbc-uri="jdbc:mysql://
>> 10.2.10.101/ofbiz?autoReconnect=true;characterEncoding=UTF-8"
>>
>> Also:
>> my.cnf
>> character-set-server=utf8
>> default-collation=utf8_unicode_ci
>>
>> Then (I believe) you have to re-create the database to pick up the 
>> UTF8 stuff and reload the UTF8 data.  There may be a way to convert 
>> an existing DB on the fly to UTF8... However:
>>
>> The data in the DB is not UTF8 so you are (most likely) screwed.  
>> THIS is exactly why I ditched mysql and went with postgresql, where 
>> everything is
>> UTF8 by default.
>>
>> On Fri, Mar 31, 2017 at 2:39 AM, Ingo Wolfmayr 
>> 
>> wrote:
>>
>>> Hi everybody,
>>>
>>> I have a question regarding special chars:
>>>
>>> Environment: Ofbiz trunk, Mysql 5.6
>>> Entity Engine: collate="utf8_unicode_ci", jdbc-uri="jdbc:mysql:// 
>>> localhost/ofbiz_test?autoReconnect=truecharacterEncoding=UTF-8"
>>>
>>> I have the following strings:
>>> 1) Käse
>>> 2) Akrapovič
>>>
>>> The first one is working. The second becomes Akrapovi?
>>>
>>> Both strings work in the online demo. Does anyone has an idea what I 
>>> may do wrong?
>>>
>>> Best regards,
>>> Ingo
>>>