Re: WebPOS Setup
Le 01/04/2017 à 00:53, stim...@comcast.net a écrit : Additional question: Is this URL current? It doesn't look anything like the WebPOS sample data, perhaps it is from the older POS instead of WebPOS: https://cwiki.apache.org/confluence/download/attachments/6553725/OFBiz%20POS%20User%20Manual%20-%20version%209.11.pdf?version=2&modificationDate=1391944202000&api=v2 Yes it applies only to the POS not the WebPos. It's from 2009, last time the POS was updated The reference to that URL came from here: https://cwiki.apache.org/confluence/display/OFBIZ/POS+System#POSSystem-OFBiz-POS(PointOfSales) I am assuming the whole page is out of date since it uses ant. No it's up to date, but only if using the POS. Jacques
Re: Special char
It honestly shouldn't be hard to change the structure through phpmyadmin. On Mar 31, 2017 6:09 PM, "Mike" wrote: > 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=true&characterEncoding=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 > > >
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=true&characterEncoding=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 >
Re: WebPOS Setup
Additional question: Is this URL current? It doesn't look anything like the WebPOS sample data, perhaps it is from the older POS instead of WebPOS: https://cwiki.apache.org/confluence/download/attachments/6553725/OFBiz%20POS%20User%20Manual%20-%20version%209.11.pdf?version=2&modificationDate=1391944202000&api=v2 The reference to that URL came from here: https://cwiki.apache.org/confluence/display/OFBIZ/POS+System#POSSystem-OFBiz-POS(PointOfSales) I am assuming the whole page is out of date since it uses ant.
Re: WebPOS Setup
Since WebPOS replaced any previous POS this is what I'm interested in bringing up. My observation is that when ofbiz starts and has the demo data that there are three POS terminals listed when logging in to the WebPOS. There was no special command to start any standalone POS, so either the defined terminals (WebPOS concept, not computer terminal) are entirely defined by data, or else the data is responsible for causing launch of WebPOS terminals based on that data. Somehow someone created demo data and defined three POS terminals. How was this done? I know it isn't via the WebPOS login itself, as you cannot log in to WebPOS unless terminals already exist. I did not see any other admin type interface to add a POS to the WebPOS. I am wondering if the only way to do this is to directly manipulate the data? If old data from a prior version was imported for part of the current 16.11.01 demo data, then perhaps the interface was completely lost and nobody noticed because the demo data hid the missing method for creating a POS. Does anyone know if the demo data POS definitions were imported from a prior version of demo data? Thanks! - Original Message -From: Jacques Le Roux To: user@ofbiz.apache.orgSent: Fri, 31 Mar 2017 04:48:17 - (UTC)Subject: Re: WebPOS Setup Le 30/03/2017 à 23:34, stim...@comcast.net a écrit :> Hi,> > Thanks for the update, links now work.> > I still see older docs which don't seem to be correct for gradlew. In particular I'm thinking the command for starting a standalone POS might help as this would maybe create a terminal...and the current WebPOS can't be logged in to without a terminal. The command listed here does not exist in 16.11.01 (gradlew) ofbiz:> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=65866466#ApacheOFBizTechnicalProductionSetupGuide-POSSetupProcess> > That command (with jar file location being corrected) is:> java -jar ./build/libs/ofbiz.jar --posActually the POS has been pushed to Attic just before creating the R16 branch, where Gradle was 1st put in. That's why the doc also stop with Ant. The WebPos is not concerned and is something different.> Does anyone here know if WebPOS terminals are not actually something added as data and instead reflect actually running POS terminals?Yes something like that indeed, but it's the notion of POS terminal, not Linux Terminal. A POS terminal is where the client pay. I can't say more about this, and it's maybe wrong.> If so, how does one start a terminal under gradlew?I guess you need to have an OFBiz instance running where the client pay. I hope someone will confirm, I was the POS maintainer, but don't know well the WebPos. Jacques> If not, how does one add a terminal to the database since the POS app cannot be logged into without a pre-existing terminal (a bit of a proverbial "catch-22").> > Thanks!> > - Original Message -From: Jacques Le Roux To: user@ofbiz.apache.orgSent: Thu, 30 Mar 2017 19:36:07 - (UTC)Subject: Re: WebPOS Setup>> Le 29/03/2017 à 22:29, stim...@comcast.net a écrit :> Hi,> > I was looking at this document regarding the POS setup:> https://cwiki.apache.org/confluence/display/OFBIZ/POS+System> > This in turn mentions another document here, described as "POS Setup Process":> http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-POSSetupProcess> > Unfortunately that document is an invalid link. Does anyone know if this was moved somewhere and is still available?Yes, while changing the content of the https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide page it to reflect the Gradle move from Ant, I put a link to the previous version in the top of the page. So it was easy to change the faulty link. It's now done, HTH Basically, when starting with seed and no demo data, I'm looking for a way to log in to the WebPOS (I've already added the admin user and some other details). The problem is that WebPOS can't log in without picking a terminal ("Choose Terminal" is empty), but there are no terminals to choose, so I was hoping the above document would mention how to add a terminal. If that document is not available, perhaps someone could mention which menu or web page to use for adding terminals when there are none to start with.> > Thanks!>I don't know well the webPOS, I hope someone else will be able to help you> Jacques>>
Re: Special char
Consider the possibility that this is a font issue, and not an encoding issue. Every font used to display a character has an index, but not every index in a given font has a graphical glyph to render it. I would try to convert the characters to hex first and see if something in the viewing is simply not rendering a character that is there...a basic string length test. If the character really is UTF-8 then it is always a single byte and the database should not care...treating that character as a particular font is when things go bad. I had some similar strange issues in DocBook. Changing default fonts solved them. The case was that illustrating a directory tree used some box drawing symbols which showed up fine in my terminal, and copy and paste into the editor also showed up well...but the generated PDF and HTML output was missing the character (it was substituted with a "missing character" symbol). The problem was that those indices into my terminal font had a different glyph than Times-Roman and Helvetica, which the PDF and HTML output used...Times-Roman and Helvetica do not have the box drawing characters (the index exists, the glyph does not). Switching to DejaVu and DejaVu Sans caused the character to show up again. During the entire set of events of transferring and viewing those characters, including things like mouse copy and paste, what font is used in cases where font is relevant? - Original Message -From: Ingo Wolfmayr To: 'user@ofbiz.apache.org' Sent: Fri, 31 Mar 2017 09:39:22 - (UTC)Subject: Special char Hi everybody, I have a question regarding special chars: Environment: Ofbiz trunk, Mysql 5.6Entity Engine: collate="utf8_unicode_ci", jdbc-uri="jdbc:mysql://localhost/ofbiz_test?autoReconnect=true&characterEncoding=UTF-8" I have the following strings:1) Käse2) 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
Re: Special char
Im pretty sure mysql databases have a structure. although i am a little disconnected with the ofbiz implementation in mysql, it does have a database and that database will always have a structure and if varchar or text is the defined structure of a column there is futher a collation of that column. this collation has many different enunciations of utf8 for the various languages that utilize utf8 to its fullest. it could be that your specific character that is missing from that collation. again this is merely off the cuff speculation but you may want to look into it. On Fri, Mar 31, 2017 at 12:27 PM, Christian Geisert < christian.geis...@isu-gmbh.de> wrote: > Hi, > > I do not remember the details (which MySQL version, maybe it was even > MariaDB) but this did work for us: > > ?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 > > Christian > > Am 31.03.2017 11:39, schrieb Ingo Wolfmayr: > > 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=true&characterEncoding=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 > > > >
Re: Special char
Hi, I do not remember the details (which MySQL version, maybe it was even MariaDB) but this did work for us: ?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 Christian Am 31.03.2017 11:39, schrieb Ingo Wolfmayr: > 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=true&characterEncoding=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 >
Re: Permissions Profiling
Hi Ryan, Maybe just a simple find + grep would do the trick. On Mar 31, 2017 2:24 AM, "Ryan Moriarty" wrote: I've been asked to do a review of user permissions in our OFBiz installation. Is there any good method (besides searching through the code base one-by-one) of determining what services and screens a user has access to, given a certain SecurityPermission? Perhaps XPath queries against service definitions and implementations? If anyone else has done this and has ideas, I would appreciate the input.
Re: Permissions Profiling
Heck, I'd appreciate a table to that effect within the wiki. Just saying. On 17-03-30 04:23 PM, Ryan Moriarty wrote: I've been asked to do a review of user permissions in our OFBiz installation. Is there any good method (besides searching through the code base one-by-one) of determining what services and screens a user has access to, given a certain SecurityPermission? Perhaps XPath queries against service definitions and implementations? If anyone else has done this and has ideas, I would appreciate the input.
Special char
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=true&characterEncoding=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