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 <blake1024@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" <blake1024@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
> > > >>
> > > >>
> > > >
> > >
> >
>
|