Need help adding a GL account

[Blake McBride]

Greetings,

Just started looking at ofbiz.  I created a blank system after a cleanAll
with:

./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin
-PuserLoginId=admin

I then went in and created my main company via Party / Main / Create New
Party Group.

I am now trying to add a GL account. I am going to Accounting / Global GL
Settings / Navigate Accounts. The label "Gl Account Id" has no
field/control next to it. If I fill out the remainder of the fields and
click "Add" it tells me missing parameter createGlAccount.glAccountId. I
can't figure out how to put an Id there since there is no control / entry
field.

Sure appreciate any help.

Blake McBride

[Jacques Le Roux]

Hi Blake,

For the accounting part in the mid term I'd recommend Sharan's book

https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books

Happy new year :)

Jacques


Le 30/12/2017 à 00:14, Blake McBride a écrit :

> Greetings,
>
> Just started looking at ofbiz.  I created a blank system after a cleanAll
> with:
>
> ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin
> -PuserLoginId=admin
>
> I then went in and created my main company via Party / Main / Create New
> Party Group.
>
> I am now trying to add a GL account. I am going to Accounting / Global GL
> Settings / Navigate Accounts. The label "Gl Account Id" has no
> field/control next to it. If I fill out the remainder of the fields and
> click "Add" it tells me missing parameter createGlAccount.glAccountId. I
> can't figure out how to put an Id there since there is no control / entry
> field.
>
> Sure appreciate any help.
>
> Blake McBride
>

[Blake McBride]

Thanks.  It was already on order.  Just hoped to get an answer before
1/12/18.

On Sat, Dec 30, 2017 at 4:09 AM, Jacques Le Roux <
[hidden email]> wrote:

> Hi Blake,
>
> For the accounting part in the mid term I'd recommend Sharan's book
>
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books
>
> Happy new year :)
>
> Jacques
>
>
>
> Le 30/12/2017 à 00:14, Blake McBride a écrit :
>
>> Greetings,
>>
>> Just started looking at ofbiz.  I created a blank system after a cleanAll
>> with:
>>
>> ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin
>> -PuserLoginId=admin
>>
>> I then went in and created my main company via Party / Main / Create New
>> Party Group.
>>
>> I am now trying to add a GL account. I am going to Accounting / Global GL
>> Settings / Navigate Accounts. The label "Gl Account Id" has no
>> field/control next to it. If I fill out the remainder of the fields and
>> click "Add" it tells me missing parameter createGlAccount.glAccountId. I
>> can't figure out how to put an Id there since there is no control / entry
>> field.
>>
>> Sure appreciate any help.
>>
>> Blake McBride
>>
>>
>

[taher]

Hi Blake,

So the screen is a bit confusing because it implies the ability to add an
account when in fact it can only edit an existing account by clicking on it
from the tree above the edit form. For now, you should create your account
using XML data definitions. But perhaps it would be useful to add the
ability to add new GL accounts from the user interface and fix the
ambiguity in the form (like the add button). Needs some investigation and
I'll look into it

On Dec 30, 2017 1:20 PM, "Blake McBride" <[hidden email]> wrote:

> Thanks.  It was already on order.  Just hoped to get an answer before
> 1/12/18.
>
> On Sat, Dec 30, 2017 at 4:09 AM, Jacques Le Roux <
> [hidden email]> wrote:
>
> > Hi Blake,
> >
> > For the accounting part in the mid term I'd recommend Sharan's book
> >
> > https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books
> >
> > Happy new year :)
> >
> > Jacques
> >
> >
> >
> > Le 30/12/2017 à 00:14, Blake McBride a écrit :
> >
> >> Greetings,
> >>
> >> Just started looking at ofbiz.  I created a blank system after a
> cleanAll
> >> with:
> >>
> >> ./gradlew "ofbiz --load-data readers=seed,seed-initial"
> loadAdminUserLogin
> >> -PuserLoginId=admin
> >>
> >> I then went in and created my main company via Party / Main / Create New
> >> Party Group.
> >>
> >> I am now trying to add a GL account. I am going to Accounting / Global
> GL
> >> Settings / Navigate Accounts. The label "Gl Account Id" has no
> >> field/control next to it. If I fill out the remainder of the fields and
> >> click "Add" it tells me missing parameter createGlAccount.glAccountId. I
> >> can't figure out how to put an Id there since there is no control /
> entry
> >> field.
> >>
> >> Sure appreciate any help.
> >>
> >> Blake McBride
> >>
> >>
> >
>

[Blake McBride]

Thanks!

On Sat, Dec 30, 2017 at 4:40 AM, Taher Alkhateeb <[hidden email]
> wrote:

> Hi Blake,
>
> So the screen is a bit confusing because it implies the ability to add an
> account when in fact it can only edit an existing account by clicking on it
> from the tree above the edit form. For now, you should create your account
> using XML data definitions. But perhaps it would be useful to add the
> ability to add new GL accounts from the user interface and fix the
> ambiguity in the form (like the add button). Needs some investigation and
> I'll look into it
>
> On Dec 30, 2017 1:20 PM, "Blake McBride" <[hidden email]> wrote:
>
> > Thanks.  It was already on order.  Just hoped to get an answer before
> > 1/12/18.
> >
> > On Sat, Dec 30, 2017 at 4:09 AM, Jacques Le Roux <
> > [hidden email]> wrote:
> >
> > > Hi Blake,
> > >
> > > For the accounting part in the mid term I'd recommend Sharan's book
> > >
> > > https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books
> > >
> > > Happy new year :)
> > >
> > > Jacques
> > >
> > >
> > >
> > > Le 30/12/2017 à 00:14, Blake McBride a écrit :
> > >
> > >> Greetings,
> > >>
> > >> Just started looking at ofbiz.  I created a blank system after a
> > cleanAll
> > >> with:
> > >>
> > >> ./gradlew "ofbiz --load-data readers=seed,seed-initial"
> > loadAdminUserLogin
> > >> -PuserLoginId=admin
> > >>
> > >> I then went in and created my main company via Party / Main / Create
> New
> > >> Party Group.
> > >>
> > >> I am now trying to add a GL account. I am going to Accounting / Global
> > GL
> > >> Settings / Navigate Accounts. The label "Gl Account Id" has no
> > >> field/control next to it. If I fill out the remainder of the fields
> and
> > >> click "Add" it tells me missing parameter
> createGlAccount.glAccountId. I
> > >> can't figure out how to put an Id there since there is no control /
> > entry
> > >> field.
> > >>
> > >> Sure appreciate any help.
> > >>
> > >> Blake McBride
> > >>
> > >>
> > >
> >
>

[Mike Z]

The secret to "seeding" is the demo data.  You MUST create custom seed
files(s) that matches your requirements, up to and including the general
ledger.

Only after you have properly seeded your company can you think about adding
an ecommerce store.  The only practical way to do this is to create XML
files that contains the data YOU need, because you WILL be loading it over
and over again until you get it right.

Forget about using the UI at this point...!! Just tweak the seed data until
you get it right.  How do you do this? Create a "hot-deploy" directory that
contains your SEED data, which is loaded AFTER seed initial.

Here is a clue:  Clear the logs, and load the full demo.  This is the order
the demo data is loaded:

/opt/apache-ofbiz-16.11.01/framework/security/data/PasswordSecurityDemoData.xml
/opt/apache-ofbiz-16.11.01/framework/security/data/SecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/framework/security/data/SecurityTypeDemoData.xml
/opt/apache-ofbiz-16.11.01/framework/common/data/CommonSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/framework/service/data/ServiceSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/framework/service/data/ServiceDemoData.xml
/opt/apache-ofbiz-16.11.01/framework/entityext/data/EntityExtSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/framework/webtools/data/WebtoolsSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/party/data/PartySecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/party/data/PartyDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/securityext/data/UserDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/content/data/ContentSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/content/data/UsersDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogPubPtData.xml
/opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogUsersData.xml
/opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogEntryData.xml
/opt/apache-ofbiz-16.11.01/applications/content/data/WebSitePublishPointData.xml
/opt/apache-ofbiz-16.11.01/applications/content/data/CompDocData.xml
/opt/apache-ofbiz-16.11.01/applications/content/data/ForumDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/workeffort/data/WorkEffortSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/workeffort/data/WorkEffortDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/product/data/ProductSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/product/data/FacilitySecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/product/data/ProductDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/manufacturing/data/ManufacturingSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/manufacturing/data/ManufacturingExampleData.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/AccountingSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoGeneralChartOfAccounts.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoOrganizationData.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoGlSetupData.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoFinAccountData.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoTaxAuthority.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAcctgTransactionData.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoPaymentsInvoices.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAccountingUserData.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAssetMaintData.xml
/opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoBudgetData.xml
/opt/apache-ofbiz-16.11.01/applications/humanres/data/HumanResSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/humanres/data/HumanResDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/order/data/OrderSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/order/data/OrderDemoUser.xml
/opt/apache-ofbiz-16.11.01/applications/order/data/OrderDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/order/data/OrderQuoteDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/marketing/data/MarketingSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/marketing/data/SfaSystemPropertyData.xml
/opt/apache-ofbiz-16.11.01/applications/marketing/data/sfaDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/commonext/data/CommonExtSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/applications/commonext/data/OfbizSetupSecurityGroupDemoData.xml
[end of core company]
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProduct.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoSurvey.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoRentalShipping.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoShipping.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoWebSitePublishPointData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTemplateData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoContent.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTopic.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTree.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoFactoids.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoRelatedData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoConfigurator.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoRentalProduct.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProductImages.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTaxAuthority.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoOrderPeopleData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoOrderTestData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoMarketing.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoPurchasing.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoStandardCosting.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoStoreGiftCertificateSettings.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoFinAccount.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProductI18nData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProductCategoriesI18nData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTreeContent.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTestSurveyData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProductAdditionalViewData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoPopularCategoriesData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoContentAltUrl.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/hhfacility/data/HhFacilitySecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/assetmaint/data/AssetMaintSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/cmssite/data/CmsMultiSiteDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/cmssite/data/CmsSiteDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/projectmgr/data/ProjectMgrSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/projectmgr/data/ProjectMgrDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/projectmgr/data/ProjectMgrDemoPasswordData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/scrum/data/scrumSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/scrum/data/scrumDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ebay/data/EbaySecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/ebay/data/DemoEbayData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/myportal/data/MyPortalSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/myportal/data/MyPortalPageDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/myportal/data/MyPortalDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/webpos/data/WebPosSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/webpos/data/DemoRetail.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/webpos/data/DemoPosData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/webpos/data/PosSyncSettings.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/bi/data/BiSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/example/data/ExampleSecurityGroupDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/example/data/ExampleDemoData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/passport/data/OAuth2LinkedInSeedData.xml
/opt/apache-ofbiz-16.11.01/specialpurpose/passport/data/OAuth2GitHubSeedData.xml

The order is critical.  Everything prior to "ecommerce" is core company
stuff.  You don't need 90% of it.  You need to go through each demo file
and either edit the file, eliminate it, or create a single file out of the
whole lot.  After you tweak it, you must do a complete reload to test the
data.  As you can see, there are a lot of prerequisites until you get to
load general ledger stuff.

Do NOT directly edit the above Demo files!!!  Create a new folder structure
in "hot-deploy" that may look like this...

hot-deploy
hot-deploy/mydata
hot-deploy/mydata/data

Details:

DIR: hot-deploy

FILE (in hot-deploy): "component-load.xml" which looks like:

<?xml version="1.0" encoding="UTF-8"?>
<component-loader xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="
http://ofbiz.apache.org/dtds/component-loader.xsd">
    <load-component component-location="mydata"/>
</component-loader>

DIR: hot-deploy/mydata
FILE (in mydata): "component-load.xml" which looks like:

<?xml version="1.0" encoding="UTF-8"?>
<ofbiz-component name="mydata"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="
http://ofbiz.apache.org/dtds/ofbiz-component.xsd">
    <!-- define resource loaders; most common is to use the component
resource loader -->
    <resource-loader name="main" type="component"/>
    <entity-resource type="data" reader-name="mydata" loader="main"
location="data/01000_security_PasswordSecurityData.xml"/>
    <entity-resource type="data" reader-name="mydata" loader="main"
location="data/01010_security_SecurityGroupData.xml"/>
    <entity-resource type="data" reader-name="mydata" loader="main"
location="data/01020_security_SecurityTypeData.xml"/>
    <entity-resource type="data" reader-name="mydata" loader="main"
location="data/02000_common_CommonSecurityGroupData.xml"/>
    <entity-resource type="data" reader-name="mydata" loader="main"
location="data/03000_service_ServiceSecurityGroupData.xml"/>
    <entity-resource type="data" reader-name="mydata" loader="main"
location="data/03010_service_ServiceData.xml"/>
    <entity-resource type="data" reader-name="mydata" loader="main"
location="data/04000_entityext_EntityExtSecurityGroupData.xml"/>
...etc...etc...etc... ORDER is critical
</ofbiz-component>

The numeric prefixes allow you to quickly show order.

DIR: hot-deploy/mydata/data
FILE(S), based on demo data, which you can edit, delete, comment out, etc.
-rw-r--r-- 1 root root   1628 Apr  6  2017
01000_security_PasswordSecurityData.xml
-rw-r--r-- 1 root root   2568 Apr  6  2017
01010_security_SecurityGroupData.xml
-rw-r--r-- 1 root root   1892 Apr  6  2017
01020_security_SecurityTypeData.xml
-rw-r--r-- 1 root root   2164 Apr  6  2017
02000_common_CommonSecurityGroupData.xml
-rw-r--r-- 1 root root   1049 Apr  6  2017
03000_service_ServiceSecurityGroupData.xml
-rw-r--r-- 1 root root   9141 Apr  6  2017 03010_service_ServiceData.xml
-rw-r--r-- 1 root root   1050 Apr  6  2017
04000_entityext_EntityExtSecurityGroupData.xml
-rw-r--r-- 1 root root   4610 Apr  6  2017
05000_webtools_WebtoolsSecurityGroupData.xml
-rw-r--r-- 1 root root   3757 Apr  6  2017
06000_party_PartySecurityGroupData.xml
-rw-r--r-- 1 root root   4351 Apr  6  2017 06010_party_PartyData.xml
-rw-r--r-- 1 root root   4757 Apr  6  2017 07000_securityext_UserData.xml
-rw-r--r-- 1 root root   2352 Apr  6  2017
08000_content_ContentSecurityGroupData.xml
-rw-r--r-- 1 root root   4480 Apr  6  2017 08010_content_UsersData.xml

NOTE:  You can, optionally, create ONE GIGANTIC XML FILE that contains ALL
of your seed data.  It's up to you!!!

After you have edited, tweaked, eliminated, concatenated as required  to
match your requirements, "try" to load it (over and over again) via:

./ant load-readers "-Ddata-readers=mydata"

The above "ant" has a gradlew version, which I don't know (don't use it),
but that is the gist of it.

Steps:
1) clean-all, load seed, seed-initial
2) load "mydata", UNTIL it works (i.e. your accounting looks proper)

For me, #1 and #2 took about 50x for me.  So, as I said earlier, forget
about using the UI.

After you get this working, then DO THE SAME for the ecommerce store,
adding it to your "mydata" directory structure, or (better) create another
sub-directory under hot-deploy for your ecommerce data.

Hope this helps.

On Sat, Dec 30, 2017 at 4:57 AM, Blake McBride <[hidden email]> wrote:

> Thanks!
>
> On Sat, Dec 30, 2017 at 4:40 AM, Taher Alkhateeb <
> [hidden email]
> > wrote:
>
> > Hi Blake,
> >
> > So the screen is a bit confusing because it implies the ability to add an
> > account when in fact it can only edit an existing account by clicking on
> it
> > from the tree above the edit form. For now, you should create your
> account
> > using XML data definitions. But perhaps it would be useful to add the
> > ability to add new GL accounts from the user interface and fix the
> > ambiguity in the form (like the add button). Needs some investigation and
> > I'll look into it
> >
> > On Dec 30, 2017 1:20 PM, "Blake McBride" <[hidden email]> wrote:
> >
> > > Thanks.  It was already on order.  Just hoped to get an answer before
> > > 1/12/18.
> > >
> > > On Sat, Dec 30, 2017 at 4:09 AM, Jacques Le Roux <
> > > [hidden email]> wrote:
> > >
> > > > Hi Blake,
> > > >
> > > > For the accounting part in the mid term I'd recommend Sharan's book
> > > >
> > > > https://cwiki.apache.org/confluence/display/OFBIZ/
> OFBiz+Related+Books
> > > >
> > > > Happy new year :)
> > > >
> > > > Jacques
> > > >
> > > >
> > > >
> > > > Le 30/12/2017 à 00:14, Blake McBride a écrit :
> > > >
> > > >> Greetings,
> > > >>
> > > >> Just started looking at ofbiz.  I created a blank system after a
> > > cleanAll
> > > >> with:
> > > >>
> > > >> ./gradlew "ofbiz --load-data readers=seed,seed-initial"
> > > loadAdminUserLogin
> > > >> -PuserLoginId=admin
> > > >>
> > > >> I then went in and created my main company via Party / Main / Create
> > New
> > > >> Party Group.
> > > >>
> > > >> I am now trying to add a GL account. I am going to Accounting /
> Global
> > > GL
> > > >> Settings / Navigate Accounts. The label "Gl Account Id" has no
> > > >> field/control next to it. If I fill out the remainder of the fields
> > and
> > > >> click "Add" it tells me missing parameter
> > createGlAccount.glAccountId. I
> > > >> can't figure out how to put an Id there since there is no control /
> > > entry
> > > >> field.
> > > >>
> > > >> Sure appreciate any help.
> > > >>
> > > >> Blake McBride
> > > >>
> > > >>
> > > >
> > >
> >
>

[Jacques Le Roux]

Thanks a lot Mike,

This is indeed the most used way (disclaimer: I did not check all details, the ideas are right)

The UI is more to maintain things once properly set.

You can use a similar way with Gradle in R17 and trunk but then plugins replaces hot-deploy and

gradlew "ofbiz --load-data readers=mydata"

replaces

./ant load-readers "-Ddata-readers=mydata"

Refer to README.MD in OFBiz root for more Gradle information, also here
https://cwiki.apache.org/confluence/display/OFBIZ/From+Ant+to+Gradle+-+R16.11+version

HTH

Jacques

PS: and while at it, happy new year and best wishes to ALL :)


Le 01/01/2018 à 22:03, Mike a écrit :

> The secret to "seeding" is the demo data.  You MUST create custom seed
> files(s) that matches your requirements, up to and including the general
> ledger.
>
> Only after you have properly seeded your company can you think about adding
> an ecommerce store.  The only practical way to do this is to create XML
> files that contains the data YOU need, because you WILL be loading it over
> and over again until you get it right.
>
> Forget about using the UI at this point...!! Just tweak the seed data until
> you get it right.  How do you do this? Create a "hot-deploy" directory that
> contains your SEED data, which is loaded AFTER seed initial.
>
> Here is a clue:  Clear the logs, and load the full demo.  This is the order
> the demo data is loaded:
>
> /opt/apache-ofbiz-16.11.01/framework/security/data/PasswordSecurityDemoData.xml
> /opt/apache-ofbiz-16.11.01/framework/security/data/SecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/framework/security/data/SecurityTypeDemoData.xml
> /opt/apache-ofbiz-16.11.01/framework/common/data/CommonSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/framework/service/data/ServiceSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/framework/service/data/ServiceDemoData.xml
> /opt/apache-ofbiz-16.11.01/framework/entityext/data/EntityExtSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/framework/webtools/data/WebtoolsSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/party/data/PartySecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/party/data/PartyDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/securityext/data/UserDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/content/data/ContentSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/content/data/UsersDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogPubPtData.xml
> /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogUsersData.xml
> /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogEntryData.xml
> /opt/apache-ofbiz-16.11.01/applications/content/data/WebSitePublishPointData.xml
> /opt/apache-ofbiz-16.11.01/applications/content/data/CompDocData.xml
> /opt/apache-ofbiz-16.11.01/applications/content/data/ForumDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/workeffort/data/WorkEffortSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/workeffort/data/WorkEffortDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/product/data/ProductSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/product/data/FacilitySecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/product/data/ProductDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/manufacturing/data/ManufacturingSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/manufacturing/data/ManufacturingExampleData.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/AccountingSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoGeneralChartOfAccounts.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoOrganizationData.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoGlSetupData.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoFinAccountData.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoTaxAuthority.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAcctgTransactionData.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoPaymentsInvoices.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAccountingUserData.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAssetMaintData.xml
> /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoBudgetData.xml
> /opt/apache-ofbiz-16.11.01/applications/humanres/data/HumanResSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/humanres/data/HumanResDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/order/data/OrderSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/order/data/OrderDemoUser.xml
> /opt/apache-ofbiz-16.11.01/applications/order/data/OrderDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/order/data/OrderQuoteDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/marketing/data/MarketingSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/marketing/data/SfaSystemPropertyData.xml
> /opt/apache-ofbiz-16.11.01/applications/marketing/data/sfaDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/commonext/data/CommonExtSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/applications/commonext/data/OfbizSetupSecurityGroupDemoData.xml
> [end of core company]
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProduct.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoSurvey.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoRentalShipping.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoShipping.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoWebSitePublishPointData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTemplateData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoContent.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTopic.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTree.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoFactoids.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoRelatedData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoConfigurator.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoRentalProduct.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProductImages.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTaxAuthority.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoOrderPeopleData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoOrderTestData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoMarketing.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoPurchasing.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoStandardCosting.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoStoreGiftCertificateSettings.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoFinAccount.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProductI18nData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProductCategoriesI18nData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTreeContent.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoTestSurveyData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProductAdditionalViewData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoPopularCategoriesData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoContentAltUrl.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/hhfacility/data/HhFacilitySecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/assetmaint/data/AssetMaintSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/cmssite/data/CmsMultiSiteDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/cmssite/data/CmsSiteDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/projectmgr/data/ProjectMgrSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/projectmgr/data/ProjectMgrDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/projectmgr/data/ProjectMgrDemoPasswordData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/scrum/data/scrumSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/scrum/data/scrumDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ebay/data/EbaySecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/ebay/data/DemoEbayData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/myportal/data/MyPortalSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/myportal/data/MyPortalPageDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/myportal/data/MyPortalDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/webpos/data/WebPosSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/webpos/data/DemoRetail.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/webpos/data/DemoPosData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/webpos/data/PosSyncSettings.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/bi/data/BiSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/example/data/ExampleSecurityGroupDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/example/data/ExampleDemoData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/passport/data/OAuth2LinkedInSeedData.xml
> /opt/apache-ofbiz-16.11.01/specialpurpose/passport/data/OAuth2GitHubSeedData.xml
>
> The order is critical.  Everything prior to "ecommerce" is core company
> stuff.  You don't need 90% of it.  You need to go through each demo file
> and either edit the file, eliminate it, or create a single file out of the
> whole lot.  After you tweak it, you must do a complete reload to test the
> data.  As you can see, there are a lot of prerequisites until you get to
> load general ledger stuff.
>
> Do NOT directly edit the above Demo files!!!  Create a new folder structure
> in "hot-deploy" that may look like this...
>
> hot-deploy
> hot-deploy/mydata
> hot-deploy/mydata/data
>
> Details:
>
> DIR: hot-deploy
>
> FILE (in hot-deploy): "component-load.xml" which looks like:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <component-loader xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>          xsi:noNamespaceSchemaLocation="
> http://ofbiz.apache.org/dtds/component-loader.xsd">
>      <load-component component-location="mydata"/>
> </component-loader>
>
> DIR: hot-deploy/mydata
> FILE (in mydata): "component-load.xml" which looks like:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <ofbiz-component name="mydata"
>          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>          xsi:noNamespaceSchemaLocation="
> http://ofbiz.apache.org/dtds/ofbiz-component.xsd">
>      <!-- define resource loaders; most common is to use the component
> resource loader -->
>      <resource-loader name="main" type="component"/>
>      <entity-resource type="data" reader-name="mydata" loader="main"
> location="data/01000_security_PasswordSecurityData.xml"/>
>      <entity-resource type="data" reader-name="mydata" loader="main"
> location="data/01010_security_SecurityGroupData.xml"/>
>      <entity-resource type="data" reader-name="mydata" loader="main"
> location="data/01020_security_SecurityTypeData.xml"/>
>      <entity-resource type="data" reader-name="mydata" loader="main"
> location="data/02000_common_CommonSecurityGroupData.xml"/>
>      <entity-resource type="data" reader-name="mydata" loader="main"
> location="data/03000_service_ServiceSecurityGroupData.xml"/>
>      <entity-resource type="data" reader-name="mydata" loader="main"
> location="data/03010_service_ServiceData.xml"/>
>      <entity-resource type="data" reader-name="mydata" loader="main"
> location="data/04000_entityext_EntityExtSecurityGroupData.xml"/>
> ...etc...etc...etc... ORDER is critical
> </ofbiz-component>
>
> The numeric prefixes allow you to quickly show order.
>
> DIR: hot-deploy/mydata/data
> FILE(S), based on demo data, which you can edit, delete, comment out, etc.
> -rw-r--r-- 1 root root   1628 Apr  6  2017
> 01000_security_PasswordSecurityData.xml
> -rw-r--r-- 1 root root   2568 Apr  6  2017
> 01010_security_SecurityGroupData.xml
> -rw-r--r-- 1 root root   1892 Apr  6  2017
> 01020_security_SecurityTypeData.xml
> -rw-r--r-- 1 root root   2164 Apr  6  2017
> 02000_common_CommonSecurityGroupData.xml
> -rw-r--r-- 1 root root   1049 Apr  6  2017
> 03000_service_ServiceSecurityGroupData.xml
> -rw-r--r-- 1 root root   9141 Apr  6  2017 03010_service_ServiceData.xml
> -rw-r--r-- 1 root root   1050 Apr  6  2017
> 04000_entityext_EntityExtSecurityGroupData.xml
> -rw-r--r-- 1 root root   4610 Apr  6  2017
> 05000_webtools_WebtoolsSecurityGroupData.xml
> -rw-r--r-- 1 root root   3757 Apr  6  2017
> 06000_party_PartySecurityGroupData.xml
> -rw-r--r-- 1 root root   4351 Apr  6  2017 06010_party_PartyData.xml
> -rw-r--r-- 1 root root   4757 Apr  6  2017 07000_securityext_UserData.xml
> -rw-r--r-- 1 root root   2352 Apr  6  2017
> 08000_content_ContentSecurityGroupData.xml
> -rw-r--r-- 1 root root   4480 Apr  6  2017 08010_content_UsersData.xml
>
> NOTE:  You can, optionally, create ONE GIGANTIC XML FILE that contains ALL
> of your seed data.  It's up to you!!!
>
> After you have edited, tweaked, eliminated, concatenated as required  to
> match your requirements, "try" to load it (over and over again) via:
>
> ./ant load-readers "-Ddata-readers=mydata"
>
> The above "ant" has a gradlew version, which I don't know (don't use it),
> but that is the gist of it.
>
> Steps:
> 1) clean-all, load seed, seed-initial
> 2) load "mydata", UNTIL it works (i.e. your accounting looks proper)
>
> For me, #1 and #2 took about 50x for me.  So, as I said earlier, forget
> about using the UI.
>
> After you get this working, then DO THE SAME for the ecommerce store,
> adding it to your "mydata" directory structure, or (better) create another
> sub-directory under hot-deploy for your ecommerce data.
>
> Hope this helps.
>
> On Sat, Dec 30, 2017 at 4:57 AM, Blake McBride <[hidden email]> wrote:
>
>> Thanks!
>>
>> On Sat, Dec 30, 2017 at 4:40 AM, Taher Alkhateeb <
>> [hidden email]
>>> wrote:
>>> Hi Blake,
>>>
>>> So the screen is a bit confusing because it implies the ability to add an
>>> account when in fact it can only edit an existing account by clicking on
>> it
>>> from the tree above the edit form. For now, you should create your
>> account
>>> using XML data definitions. But perhaps it would be useful to add the
>>> ability to add new GL accounts from the user interface and fix the
>>> ambiguity in the form (like the add button). Needs some investigation and
>>> I'll look into it
>>>
>>> On Dec 30, 2017 1:20 PM, "Blake McBride" <[hidden email]> wrote:
>>>
>>>> Thanks.  It was already on order.  Just hoped to get an answer before
>>>> 1/12/18.
>>>>
>>>> On Sat, Dec 30, 2017 at 4:09 AM, Jacques Le Roux <
>>>> [hidden email]> wrote:
>>>>
>>>>> Hi Blake,
>>>>>
>>>>> For the accounting part in the mid term I'd recommend Sharan's book
>>>>>
>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/
>> OFBiz+Related+Books
>>>>> Happy new year :)
>>>>>
>>>>> Jacques
>>>>>
>>>>>
>>>>>
>>>>> Le 30/12/2017 à 00:14, Blake McBride a écrit :
>>>>>
>>>>>> Greetings,
>>>>>>
>>>>>> Just started looking at ofbiz.  I created a blank system after a
>>>> cleanAll
>>>>>> with:
>>>>>>
>>>>>> ./gradlew "ofbiz --load-data readers=seed,seed-initial"
>>>> loadAdminUserLogin
>>>>>> -PuserLoginId=admin
>>>>>>
>>>>>> I then went in and created my main company via Party / Main / Create
>>> New
>>>>>> Party Group.
>>>>>>
>>>>>> I am now trying to add a GL account. I am going to Accounting /
>> Global
>>>> GL
>>>>>> Settings / Navigate Accounts. The label "Gl Account Id" has no
>>>>>> field/control next to it. If I fill out the remainder of the fields
>>> and
>>>>>> click "Add" it tells me missing parameter
>>> createGlAccount.glAccountId. I
>>>>>> can't figure out how to put an Id there since there is no control /
>>>> entry
>>>>>> field.
>>>>>>
>>>>>> Sure appreciate any help.
>>>>>>
>>>>>> Blake McBride
>>>>>>
>>>>>>

[Sharan Foga]

Hi Blake

I've only just seen this message.

You can create your chart of accounts with an blank OFBiz install and seed data.  Please see below for some documentation that myself and Craig Parker are working on that should help you.

Note that even though the screen says it is in 'Edit mode' it is actually in Add mode so will add new accounts.

I've included some instructions of how to setup the basic 5 main account types below:

Thanks
Sharan

-------------------------------------------------

So the first step we need to do is create a Chart of Account Master template in OFBIz.

-Select “Accounting” from the Applications drop down menu
-Select “Global GL Settings” from the Accounting Manager drop down menu

(Default screen should be a blank chart of accounts)

-Click the “Navigate Accounts” button

An 'Edit GL Account' window will be displayed and the default is Add Mode.

Create the main Assets account:
-Select “Not Applicable” for GL Account Type Id
-Select “Asset” for GL Account Class Id
-Select “Money” for GL Resource Type Id
-Enter “ASSETS” in GL Account Code (NOTE: You might want to give this a code. Using a code will help you structure the account hierarchy in the order you want it to be displayed. Using text defaults to alphabetical order)
-Enter “Assets” in Account Name
-Click “Add”

Create the Liabilities main account
Make sure you are still in Add mode or Click “Navigate Accounts” again (NOTE: If you do a change and you are in update mode, it will update the account that you were previously working on rather than create a new one!)

-Select “Not Applicable” for GL Account Type Id
-Select “Liability” for GL Account Class Id
-Select “Money” for GL Resource Type Id
-Enter “LIABILITIES” in GL Account Code
-Enter “Liabilities” in Account Name
-Click “Add”

Create the Owner Equities main account
Make sure you are still in Add Mode or Click “Navigate Accounts” again

-Select “Not Applicable” for GL Account Type Id
-Select “Equity” for GL Account Class Id
-Select “Money” for GL Resource Type Id
-Enter “OWNER EQUITIES” in GL Account Code
-Enter “Owner Equities” in Account Name
-Click “Add”

Create the Revenues main account
Make sure you are still in Add Mode or Click “Navigate Accounts” again

-Select “Not Applicable” for GL Account Type Id
-Select “Revenue” for GL Account Class Id
-Select “Money” for GL Resource Type Id
-Enter “REVENUES” in GL Account Code
-Enter “Revenues” in Account Name
-Click “Add”

Create the Administrative Expenses main account
Make sure you are still in Add Mode or Click “Navigate Accounts” again

-Select “Not Applicable” for GL Account Type Id
-Select “Selling, General or Administrative Expense” for GL Account Class Id
-Select “Money” for GL Resource Type Id
-Enter “ADMINISTRATIVE EXPENSES” in GL Account Code
-Enter “Administrative Expenses” in Account Name
-Click “Add”

On 2017-12-30 00:14, Blake McBride <[hidden email]> wrote:

> Greetings,
>
> Just started looking at ofbiz.  I created a blank system after a cleanAll
> with:
>
> ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin
> -PuserLoginId=admin
>
> I then went in and created my main company via Party / Main / Create New
> Party Group.
>
> I am now trying to add a GL account. I am going to Accounting / Global GL
> Settings / Navigate Accounts. The label "Gl Account Id" has no
> field/control next to it. If I fill out the remainder of the fields and
> click "Add" it tells me missing parameter createGlAccount.glAccountId. I
> can't figure out how to put an Id there since there is no control / entry
> field.
>
> Sure appreciate any help.
>
> Blake McBride
>