ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike <mz4whee...@gmail.com>
Subject Re: Need help adding a GL account
Date Mon, 01 Jan 2018 21:03:59 GMT
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
> > > >>
> > > >>
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message