You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Tom Running <ru...@gmail.com> on 2016/06/24 19:14:22 UTC
ofbiz configure with postgres database
Greetings everyone,
I have been trying to configure ofbiz version 13 or 14 to work with
Postgre database. No luck so far. I have been looking and had tryied out
multiple way through what I had found via google. But still running into
problem. Is there a details document some where that layout how to do this.
Especially, what to load for the initial database and ofbiz load??
I want a basic seed load with no test data.
What is the correct syntax and option to use?
Load the seed data with : ./ant run-install-extseed or recently ./ant
load-extseed
Any help or suggestion?
Thanks,
Toom
Re: ofbiz configure with postgres database
Posted by Jacques Le Roux <ja...@les7arts.com>.
The syntax is (still) the same than in trunk
./ant load-extseed
You might want to use
./ant load-exttest
If you provide your own test data
By and large
./ant -p
is your friend
./ant run-install-extseed is deprecated (still used in R12.04)
HTH
Jacques:
Le 24/06/2016 � 21:14, Tom Running a �crit :
> Greetings everyone,
>
>
> I have been trying to configure ofbiz version 13 or 14 to work with
> Postgre database. No luck so far. I have been looking and had tryied out
> multiple way through what I had found via google. But still running into
> problem. Is there a details document some where that layout how to do this.
>
> Especially, what to load for the initial database and ofbiz load??
> I want a basic seed load with no test data.
>
> What is the correct syntax and option to use?
>
> Load the seed data with : ./ant run-install-extseed or recently ./ant
> load-extseed
>
> Any help or suggestion?
>
> Thanks,
> Toom
>
Re: ofbiz configure with postgres database
Posted by Tom Running <ru...@gmail.com>.
Thanks Deepak. I will take a look.
Tom
On Fri, Jun 24, 2016 at 3:29 PM, Deepak Dixit <
deepak.dixit@hotwaxsystems.com> wrote:
> Hi Tom,
>
> Please refer:
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup
>
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
>
> On Sat, Jun 25, 2016 at 12:44 AM, Tom Running <ru...@gmail.com>
> wrote:
>
> > Greetings everyone,
> >
> >
> > I have been trying to configure ofbiz version 13 or 14 to work with
> > Postgre database. No luck so far. I have been looking and had tryied
> out
> > multiple way through what I had found via google. But still running into
> > problem. Is there a details document some where that layout how to do
> this.
> >
> > Especially, what to load for the initial database and ofbiz load??
> > I want a basic seed load with no test data.
> >
> > What is the correct syntax and option to use?
> >
> > Load the seed data with : ./ant run-install-extseed or recently ./ant
> > load-extseed
> >
> > Any help or suggestion?
> >
> > Thanks,
> > Toom
> >
>
Re: ofbiz configure with postgres database
Posted by Deepak Dixit <de...@hotwaxsystems.com>.
Hi Tom,
Please refer:
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup
Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
On Sat, Jun 25, 2016 at 12:44 AM, Tom Running <ru...@gmail.com> wrote:
> Greetings everyone,
>
>
> I have been trying to configure ofbiz version 13 or 14 to work with
> Postgre database. No luck so far. I have been looking and had tryied out
> multiple way through what I had found via google. But still running into
> problem. Is there a details document some where that layout how to do this.
>
> Especially, what to load for the initial database and ofbiz load??
> I want a basic seed load with no test data.
>
> What is the correct syntax and option to use?
>
> Load the seed data with : ./ant run-install-extseed or recently ./ant
> load-extseed
>
> Any help or suggestion?
>
> Thanks,
> Toom
>
Re: ofbiz configure with postgres database
Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Tom,
This question might not be as simple as you think it is. I was also
confused the first time I started working with data type. So let me explain
things first.
OFBiz has the following types of data (defined in ofbiz-component.xml for
each component):
- seed: OFBiz and External Seed Data - to be maintained along with source
and updated whenever a system deployment is updated
- seed-initial: OFBiz and External Seed Data - to be maintained along with
source like other seed data, but only loaded initially and not updated when
a system is updated except manually reviewing each line
- demo: OFBiz Only Demo Data (also used for testing OFBiz)
- ext: External General Data (custom or yours)
- ext-test: External Test Data (custom or yours)
- ext-demo: External Demo Data (custom or yours)
Now this is the tricky part, to get a clean new system in OFBiz you need
seed, seed-initial and an admin user login which you can create with the
load-admin-user-login ant target. However, this is not a workable system,
you don't have a chart of accounts for example, and many basic
parameters like stuff in order and accounting have to be inserted manually
(I think this is what you are referring to as problems right?)
So unfortunately the data loading stuff in OFBiz is a bit complicated at
the moment. Creating a Clean system currently is more difficult than
building OFBiz with demo data and then deleting unwanted stuff. So here is
what I suggest that you do:
- First understand what data do you want from the data types mentioned
above. Go to the components where you are having problems and check what
data are you missing when you do not use load-demo (check
ofbiz-component.xml for related data that your are missing)
- Get familiar with ant load-readers to load exactly what you want
- Alternatively just use the demo data and clean it / shape it to your
requirements.
I hope I didn't go in the wrong direction and I understood your question
correctly. Otherwise nevemind :)
Taher Alkhateeb
On Friday, 24 June 2016, Tom Running <ru...@gmail.com> wrote:
> Greetings everyone,
>
>
> I have been trying to configure ofbiz version 13 or 14 to work with
> Postgre database. No luck so far. I have been looking and had tryied out
> multiple way through what I had found via google. But still running into
> problem. Is there a details document some where that layout how to do this.
>
> Especially, what to load for the initial database and ofbiz load??
> I want a basic seed load with no test data.
>
> What is the correct syntax and option to use?
>
> Load the seed data with : ./ant run-install-extseed or recently ./ant
> load-extseed
>
> Any help or suggestion?
>
> Thanks,
> Toom
>
Re: ofbiz configure with postgres database
Posted by Paul Piper <pp...@ilscipio.com>.
We got a complete documentation over at Scipio ERP that could be of use to
you:
http://www.scipioerp.com/community/developer/installation-configuration/configuration/
It also covers the database configuration in a few easy steps. Let me know
what you think :)
--
View this message in context: http://ofbiz.135035.n4.nabble.com/ofbiz-configure-with-postgres-database-tp4686225p4686227.html
Sent from the OFBiz - User mailing list archive at Nabble.com.