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 <[email protected]> wrote: > Thanks! > > On Sat, Dec 30, 2017 at 4:40 AM, Taher Alkhateeb < > [email protected] > > 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" <[email protected]> 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 < > > > [email protected]> 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 > > > >> > > > >> > > > > > > > > > >
