Re: Using Derby ij To Browse Demo Data

[Jacques Le Roux]

From the top of my head (I'll be off until Saturday morning)

Create an Alias:

Use "Apache Derby Embedded" driver

URL (eg) jdbc:derby:C:\projectsASF\ofbiz\runtime\data\derby\ofbiz;create=true (don't connect to a running OFBiz instance, but you can use one 
created by OFBiz)


Std Derby data source credential (cf entityengine.xml), ie ofbiz/ofbiz

Good luck (it's not the easiest tool but it's worth to be know ;))

Jacques

Le 23/05/2017 à 21:30, stim...@comcast.net a écrit :

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 separate JDBC driver for Derby like what PostgreSQL has.
  
Is there a network port open when ofbiz runs which I can access Derby with? If not, is there a particular file in the ofbiz install I can point at for the embedded driver?
  
Basically it seems the embedded URL would be a format like this:

jdbc:derby:file:///some/database:create=false
  
Or for the networked Derby client version the URL format might be something like this:

jdbc:derby://localhost:port_number/databaseName:create=false
  
Would anyone here be able to give an example of using either the embedded or the client driver for squirrel sql URL? And would anyone be able to confirm that I don't need to name a JDBC jar file with the Derby driver the way I had to with PostgreSQL?
  
Thanks!
  
- Original Message -From: Jacques Le Roux To: user@ofbiz.apache.orgSent: Tue, 23 May 2017 09:15:28 - (UTC)Subject: Re: Using Derby ij To Browse Demo Data


Hi Dan,

I'm not sure it can fill you purpose but the tool of choice when it comes to 
manipulate Derby data is SQuirreL SQL

http://db.apache.org/derby/integrate/SQuirreL_Derby.html

HTH

Jacques

Le 23/05/2017  01:05, stim...@comcast.net a crit :> 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 loading xml files under PostgreSQL, but have never been able to find a way to successfully load 
sample data this way (Web POS never works). I am thinking that if I can browse and query the Derby database, then perhaps 
I can manually export/edit data and then use SQL through psql to load a customized version of that data. To that extent I 
found application "ij" for browsing Derby in a similar way as psql.> > When using ij to browse a Derby 
database is there a particular file or other method where I could use ij for an ofbiz server loaded with demo data? I 
have the browse application, but I'm not sure about how to connect. Or perhaps there is a better way to dump a Derby 
database as SQL data and tables other than ij?> > Thanks!>

Re: Using Derby ij To Browse Demo Data

[stimits]

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 separate JDBC driver 
for Derby like what PostgreSQL has.
 
Is there a network port open when ofbiz runs which I can access Derby with? If 
not, is there a particular file in the ofbiz install I can point at for the 
embedded driver?
 
Basically it seems the embedded URL would be a format like this:
jdbc:derby:file:///some/database:create=false
 
Or for the networked Derby client version the URL format might be something 
like this:
jdbc:derby://localhost:port_number/databaseName:create=false
 
Would anyone here be able to give an example of using either the embedded or 
the client driver for squirrel sql URL? And would anyone be able to confirm 
that I don't need to name a JDBC jar file with the Derby driver the way I had 
to with PostgreSQL?
 
Thanks!
 
- Original Message -From: Jacques Le Roux 
To: user@ofbiz.apache.orgSent: Tue, 23 May 2017 
09:15:28 - (UTC)Subject: Re: Using Derby ij To Browse Demo Data

Hi Dan,

I'm not sure it can fill you purpose but the tool of choice when it comes to 
manipulate Derby data is SQuirreL SQL

http://db.apache.org/derby/integrate/SQuirreL_Derby.html

HTH

Jacques

Le 23/05/2017  01:05, stim...@comcast.net a crit :> 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 loading xml files under 
PostgreSQL, but have never been able to find a way to successfully load sample 
data this way (Web POS never works). I am thinking that if I can browse and 
query the Derby database, then perhaps I can manually export/edit data and then 
use SQL through psql to load a customized version of that data. To that extent 
I found application "ij" for browsing Derby in a similar way as psql.> > When 
using ij to browse a Derby database is there a particular file or other method 
where I could use ij for an ofbiz server loaded with demo data? I have the 
browse application, but I'm not sure about how to connect. Or perhaps there is 
a better way to dump a Derby database as SQL data and tables other than ij?> > 
Thanks!>

Re: Catalog- OEM Party ID

[Jacques Le Roux]

Thanks Pierre,

Right spot on

Jacques


Le 23/05/2017 à 11:36, Pierre Smits a écrit :

See this relating issue: https://issues.apache.org/jira/browse/OFBIZ-9368

Best regards,

Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Tue, May 23, 2017 at 11:14 AM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:


Hi James,

I can just confirm what you found. The manufacturerPartyId field is only
an editable field of the EditProduct form. It's not else used in OFBiz OOTB.

ProductOemPartyId is only a label used by the manufacturerPartyId field.

So if you have to handle an OEM suppliers it's where you start.

Jacques



Le 17/05/2017 à 22:49, ja...@productive1.com a écrit :


I am looking at the catalog and trying to figure out the difference
between Manufacturer and OEM Party ID.  OEM Party ID ties to a
legitimate party in the system and it seems Manufacturer is just a
editable field.  Are there other areas in OFBiz that utilize OEM Party
ID that makes this relevant being tied to a product in the catalog?

Thanks,

James

ApacheCon Miami

[Sharan Foga]

Hi Everyone

I've finally got back home after being at ApacheCon in Miami last week. 
As usual ApacheCon is an amazing and intense event where you meet so 
many people in such a short space of time.


This ApacheCon was especially busy for me which is why I haven't been so 
active on our lists. As well as my presentation, I was invited to 
participate on a panel. Generally I help out with the Barcamp and the 
ASF booth and this time I also went around with my recorder doing some 
interviews for Feathercast. I still have a little jetlag but came back 
knowing even more people than before!


If you don't know about Feathercast then please take a look.

https://feathercast.apache.org/

All the slides from the ApacheCon presentations should be available from 
the Linux Foundation website.


http://events.linuxfoundation.org/events/apachecon-north-america/program/slides

I understand that all presentations were audio recorded and the keynotes 
and some selected presentations were video recorded. Details of all the 
video sessions can be found at the link below.


https://www.youtube.com/playlist?list=PLbzoR-pLrL6pLDCyPxByWQwYTL-JrF5Rp

BTW – my presentation was video recorded (and yes I was very nervous! 
;-)) so if you'd like to see it then it is on Youtube here..


https://www.youtube.com/watch?v=vT-kxmoLs5k

It would be great to see more of our community at these events so I hope 
that we can get our community together at a future ApacheCon or other 
meetup event.


I will be at the OpenExpo in Madrid next 
week, so if anyone is going to be there then please drop by the ASF 
booth to say Hi or Hola!


Thanks
Sharan

Re: Catalog- OEM Party ID

[Pierre Smits]

See this relating issue: https://issues.apache.org/jira/browse/OFBIZ-9368

Best regards,

Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Tue, May 23, 2017 at 11:14 AM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi James,
>
> I can just confirm what you found. The manufacturerPartyId field is only
> an editable field of the EditProduct form. It's not else used in OFBiz OOTB.
>
> ProductOemPartyId is only a label used by the manufacturerPartyId field.
>
> So if you have to handle an OEM suppliers it's where you start.
>
> Jacques
>
>
>
> Le 17/05/2017 à 22:49, ja...@productive1.com a écrit :
>
>> I am looking at the catalog and trying to figure out the difference
>> between Manufacturer and OEM Party ID.  OEM Party ID ties to a
>> legitimate party in the system and it seems Manufacturer is just a
>> editable field.  Are there other areas in OFBiz that utilize OEM Party
>> ID that makes this relevant being tied to a product in the catalog?
>>
>> Thanks,
>>
>> James
>>
>>

Re: Using Derby ij To Browse Demo Data

[Jacques Le Roux]

Hi Dan,

I'm not sure it can fill you purpose but the tool of choice when it comes to 
manipulate Derby data is SQuirreL SQL

http://db.apache.org/derby/integrate/SQuirreL_Derby.html

HTH

Jacques


Le 23/05/2017 à 01:05, stim...@comcast.net a écrit :

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 loading xml files under PostgreSQL, but have never been able to find a way to successfully load sample data this way (Web POS never works). I am thinking that if I can browse and query the Derby database, then perhaps I can manually export/edit data and then use SQL through psql to load a customized version of that data. To that extent I found application "ij" for browsing Derby in a similar way as psql.
  
When using ij to browse a Derby database is there a particular file or other method where I could use ij for an ofbiz server loaded with demo data? I have the browse application, but I'm not sure about how to connect. Or perhaps there is a better way to dump a Derby database as SQL data and tables other than ij?
  
Thanks!

Re: Catalog- OEM Party ID

[Jacques Le Roux]

Hi James,

I can just confirm what you found. The manufacturerPartyId field is only an 
editable field of the EditProduct form. It's not else used in OFBiz OOTB.

ProductOemPartyId is only a label used by the manufacturerPartyId field.

So if you have to handle an OEM suppliers it's where you start.

Jacques


Le 17/05/2017 à 22:49, ja...@productive1.com a écrit :

I am looking at the catalog and trying to figure out the difference
between Manufacturer and OEM Party ID.  OEM Party ID ties to a
legitimate party in the system and it seems Manufacturer is just a
editable field.  Are there other areas in OFBiz that utilize OEM Party
ID that makes this relevant being tied to a product in the catalog?

Thanks,

James

Re: Using Derby ij To Browse Demo Data

[Taher Alkhateeb]

Hello,

If the loading fails then OFBiz would give you an error message. Trace it
to debug what is missing. Just go to webtools, load the XML files and
observe the error message. It should tell you exactly what's wrong. Usually
it is foreign key violations which means missing data somewhere.

On Tue, May 23, 2017 at 2:05 AM,  wrote:

> 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 loading
> xml files under PostgreSQL, but have never been able to find a way to
> successfully load sample data this way (Web POS never works). I am thinking
> that if I can browse and query the Derby database, then perhaps I can
> manually export/edit data and then use SQL through psql to load a
> customized version of that data. To that extent I found application "ij"
> for browsing Derby in a similar way as psql.
>
> When using ij to browse a Derby database is there a particular file or
> other method where I could use ij for an ofbiz server loaded with demo
> data? I have the browse application, but I'm not sure about how to connect.
> Or perhaps there is a better way to dump a Derby database as SQL data and
> tables other than ij?
>
> Thanks!