Hi,
I got squirrel sql running and able to connect to PostgreSQL. However, I'm a
bit confused about Derby connections...either I need a network address with
port ("Apache Derby Client" driver), or else it seems perhaps a direct file
access ("Apache Derby Embedded" driver). I didn't see any sep
Hi,
There are 861 tables in the ofbiz Derby database under ofbiz-16.11.02 for demo
data. I'm trying to learn to load this data manually using SQL queries, and
thus making a dependency list of tables with foreign key requirements (or even
references to other tables which are allowed to be null)
e.orgSent: Thu, 08 Jun 2017 07:31:52 - (UTC)Subject: Re:
Mapping Derby Sample Data Foreign Keys
Hi stimits,
I agree with Taher about the most productive way to solve your problem.
For an overall understanding of the data model,
seehttps://cwiki.apache.org/confluence/display/OFBIZ/Data+Model
first goal...I can't do that from within
the existing interfaces (due to WebPOS requirements).
Thanks!
- Original Message -From: Mike To: user
Sent: Fri, 09 Jun 2017 15:56:07 - (UTC)Subject: Re:
Mapping Derby Sample Data Foreign Keys
Hey stimits. Are you finding that the
There is a SQL table which is easier to see than XML. If you have direct access
to the OfBiz SQL tables look at table GL_ACCOUNTS (loaded from this file and
other GL_ tables).
- Original Message -From: Yash Sharma
To: user@ofbiz.apache.orgSent: Sat, 10 Jun 2017
09:00:19 - (UTC)Sub
Hi,
I will probably be interested in this. I have just switched from trying to do
this under Derby to doing this under PostgreSQL after looking at pgadmin3. It
looks like this tool provides more information than SQuirrel-sqL (possibly
because of Derby, not necessarily because of the tool) and
Don't know if this will help, but I have to change VISUAL_THEME to a
non-default because of a different failure. I like BLUELIGHT. Go here:
framework/common/config/general.properties
Edit the VISUAL_THEME line to be BLUELIGHT instead of TOMAHAWK, see if this
helps:
#VISUAL_THEME=TOMAHAWKVISUAL_
Is there a login name/pass for demo?
- Original Message -From: Shi Jinghai To:
user@ofbiz.apache.orgSent: Tue, 13 Jun 2017 05:36:36 - (UTC)Subject: Re:
Cash Register App?
Hi Jacques,
Updating the status of our new webpos development, we have just released the
new webpos implement
+1
Probably the same topic worded differently:
https://issues.apache.org/jira/browse/OFBIZ-9330
- Original Message -From: Jacques Le Roux
To: user@ofbiz.apache.orgSent: Fri, 25 Aug 2017
08:56:20 - (UTC)Subject: Re: creating new facility in Ofbiz
+1
Jacques
Le 25/08/2017 à 10:36
This is probably a naive question, but on 16.11.04 I am searching for the
actual code which runs for the "loadDefault" part of:
./gradlew loadDefault
I'm looking for what I might edit to create my own version of loadDefault after
observing what the existing loadDefault actually executes. I see
Hi,
I guess what I should do is rephrase...if I wanted to run this under a debugger
and get a stack frame (which I'm not actually set up to do), where would I find
the source code which specifically understands which XML files to read and load
for loadDefault? The build.gradle is more of a dec
I am interested in how the list of files is chosen, along with the rules for
order of choosing. I am thinking of custom loading for my own testing, but
mostly I just feel I need to better understand what the "All" of "loadAll" is.
- Original Message -From: Jacques Le Roux
To: user@ofbi
The trouble with that is I'm interested in dumping the logic of how the load
order is determined specifically with the loadDefault. If there were a command
such as "./gradlew --explain loadDefault", where it verbosely named which file
is chosen, what kind of sorting is used, and what it was doin
Hi,
Thanks, I think this is what I need. I wrote an application which diagrams
PostgreSQL databases and creates SVG maps of table pk and fk dependencies...it
graphically shows what needs to be modified in which order versus
primary/foreign key dependencies. I'm thinking of ways to extend it to
riginal Message -From: Paul Foxworthy To:
user@ofbiz.apache.orgSent: Sun, 28 Jan 2018 02:24:33 - (UTC)Subject: Re:
loadDefault Source Code
Hi stimits,
Can you contribute the results of your research?
There are data model diagrams
athttps://cwiki.apache.org/confluence/display/OFBIZ/Data
Hi
It was quite some time back (well, a year...that's like 7 dog years or 14
programmer years) it was announced that hot-deploy was being deprecated:
https://blogs.apache.org/ofbiz/entry/apache-ofbiz-news-march-2017
The directory still exists in 16.11.04. Would it be correct to assume that eve
In order to be closer to how release 17 will be, would it be advisable to
completely avoid the hot-deploy directory for now (this is limited to custom
data loading)?
- Original Message -From: Taher Alkhateeb
To: user@ofbiz.apache.orgSent: Wed, 31 Jan 2018
23:25:37 - (UTC)Subject:
Hi,
I'm just trying to evaluate ofbiz for some simple POS needs (which is of course
not really simple). I see there is a lot of ofbiz development activity, and
thus a lot of documents which are actually out of date. Sometimes for example
the instructions use "ant" directly and do not know of t
Hi,
...logged in to psql as user postgres...
psql (9.4.9)Type "help" for help. postgres=# \du
List of roles Role name | Attributes |
Member of
---++--- ofbiz
|
Hi,
I had been using this as reference:
https://blogs.oracle.com/robertlor/entry/ofbiz_and_postgresql
Your check made me realize the db was name "ofbizdb" and not "ofbiz". Once that
was fixed it worked. I still need to see if I can make it work for a simple
store cash register function (with
Hi,
Browsing through some of the setup for the demo data, I'm wondering if there is
a specific app which would demonstrate what a salesman at a cash register might
use for a retail customer in the store buying something? There seems to be a
lot of ability to add and set up the store and variou
Hi,
While figuring out how ofbiz is configured via the sample data I've been slowly
editing things to look like a real store (the store which would potentially use
ofbiz to replace its existing POS software). One thing I'm kind of stumped
on...it's easy to create catalogs...but how do I delete
Hi,
Attached is an ofbiz screenshot taken from firefox.
I'm wondering why some menus are visible but not accessible. In the upper left
corner there is a hierarchical list of where the user is currently at. In the
attached screenshot this is "Applications > Order Manager", and the mouse is
ho
go further into whichever
application. The bug or issue is that I can't move the mouse down to any of
those items...as soon as the mouse isn't hovering over the main part of that
menu the hover-over menu goes away.
- Original Message -From: stimits@comcast.netTo:
user@ofbiz.apache.
yone here is aware of the problem or
has a comment on how to proceed.
Thanks!
- Original Message -From: stimits@comcast.netTo:
user@ofbiz.apache.orgSent: Fri, 17 Mar 2017 19:22:48 - (UTC)Subject: Re:
Mouse Hover-Over Menus
Sorry, it looks like the email list strips attachments. A
...
- don't use gradle to start up, but use java - jar ofbiz.jar - set
'check-on-start' to false - set 'add-missing-on-start' to false - set
'check-inidices-on-start' to false
...
I am curious if gradle and the others are just start up time issues...I am
assuming these have no effect after sta
Hi,
I'm looking at the sample data, and it appears that the app is designed to
enter a customer name before an order. However, in a retail store at the cash
register, many people use cash and do not want to create accounts. What would
be the correct way to handle anonymous in-person cash trans
Hi,
The tutorial here:
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide
...is not current for 16.11.01. Is there an equivalent to this somewhere for
16.11 (gradlew seems to be the change)?
Thanks!
Hi,
I'm wondering about what individual steps are equivalent to loading the sample
data?
Some steps I've tried (perhaps I used seeds I didn't need...however, I
configured for PostgreSQL so I assume "ext" for that):
...build, load default demo data, browse...
./gradlew cleanAll
./gradlew "ofbi
Hi,
I'm just learning the lingo, but this is just for one company, so I think that
is single tenant. I'm wanting to put together the steps for manually bringing
up a small sample for a single company with a single retail store and no remote
warehouse. Presumably with in store POS and online sa
Hi,
I was wanting to break down the steps equivalent to cleanAll and
loadDefault...if I want to manually load my own data, and not demo data
(instead of expiring demo products and catalogs I'd like to start with nothing
and create my own catalog, company, admin user, and products):
How do I c
...
> 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
Hi,
I'm just experimenting with trying to add some real customers to a new ofbiz
install without sample data. I'm wondering about "First Customer" making "First
name" and "Last name" mandatory when the customer is another business (first
and last name don't apply). How to handle this if not mo
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#ApacheOFBiz
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 termina
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 si
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 defin
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=13919
Hi,
I had hoped I could export the POS data and get a more or less empty XML dump
which I could edit, but unfortunately empty tables do not export. I guess the
next step is to put sample data back in, export, and edit the sample data XML
files, drop sample data, re-seed, and then import the ed
Just an update on an attempt to work around missing terminals. If I import the
sample data and then export it to XML I get this:
If I then clean the database and seed (no sample data), followed by webtools
import of the XML, the WebPOS still has no terminals. There may be some other
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.
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 add
-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
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 st
fortunately) 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,
Hi,
Thought I'd summarize with some specific steps since I've made progress, but
still fail (writing down to explain to others might help me catch my own
mistakes too).
Problem: I need WebPOS to work on a brand new install using my own hand-entered
data for a real retail store (versus demo d
Hi,
I did try readers of both seed and seed-initial, this does not seem to have
changed anything.
So...how was the retail store in the sample data added? Was the building itself
added by XML file edit/import (I don't see how asset management can be used to
do this...loosely speaking one could
Hi,
Yes, this is how the problem started, and the end goal, to add a terminal so
WebPOS can be logged in to.
However, this also exposed a chain of issues with no ability to enter data
through a standard mechanism while trying to create a retail store via "Catalog
Manager->Stores, click New P
Hi,
Before I file the JIRA bug report, I want to check one more time about any
ideas anyone might have on the particular blocker in the chain of requirements
resulting in "Inventory Facility Id Required". This is currently at the root of
the chain of details blocking WebPOS. In summary, I have
Hi,
I think I receive messages from the list, but sometimes I get a copy of what
I'm forwarding below...my email has never stopped working (that I know of), so
I'm wondering if anyone knows what causes this? The title of the email is
always "Warning from user@ofbiz.apache.org".
I did get a
Hi,
Not long ago I was trying to figure out how to get WebPOS to work with an
actual retail store...lots of emails here. Just letting people know I finally
added the JIRA report here:
https://issues.apache.org/jira/browse/OFBIZ-9330
I did find out that some of my email from this list has been
Hi,
I'm wondering how often stable releases occur? I see on the downloads page it
doesn't seem to be very often, perhaps a year or more between releases. Would
it be safe to assume I won't be seeing any fixes for WebPOS for at least
another year if I wait (this would be terrible news)? I haven
Hi,
I'm still trying to find a way to load Web POS data for non-sample/real world,
and it seems the actual SQL tables are not too complicated for this purpose (at
least under PostgreSQL). I had been going through load logs when loading sample
data and then trying to recreate by manually loadin
53 matches
Mail list logo