You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Mike <mz...@gmail.com> on 2018/01/01 21:03:59 UTC
Re: Need help adding a GL account
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 <bl...@gmail.com> wrote:
> Thanks!
>
> On Sat, Dec 30, 2017 at 4:40 AM, Taher Alkhateeb <
> slidingfilaments@gmail.com
> > 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" <bl...@gmail.com> 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 <
> > > jacques.le.roux@les7arts.com> 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
> > > >>
> > > >>
> > > >
> > >
> >
>
Re: Need help adding a GL account
Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <bl...@gmail.com> wrote:
>
>> Thanks!
>>
>> On Sat, Dec 30, 2017 at 4:40 AM, Taher Alkhateeb <
>> slidingfilaments@gmail.com
>>> 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" <bl...@gmail.com> 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 <
>>>> jacques.le.roux@les7arts.com> 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
>>>>>>
>>>>>>