Hi Rishi / List members, My problem is eventually sorted out and of course there are multiple solutions and approaches. part of the solution is also the fact that I have become less fussy about some of the demo data that will stick around.
I 'settled' with loading the demo data but omitting few transactional data that were showing up in AR and AP and balance sheets. Even if some demo data sticks around i feel its harmless. (of course i will take steps to change the passwords , as described in docs) @Rishi , thanks for understanding and supporting the concern of no being able to start with seed,seed-initial. Also a big thanks to the everyone in community for being supportive to newbies. ( Gripe: I wish there were a slack channel for ofbiz , it would have been so much more fun ;-) ) regds mallah. On Fri, Aug 25, 2017 at 2:06 PM, Rishi Solanki <[email protected]> wrote: > Rajesh, > > You will need to list out all the data you want to override. And then start > copying the selective data for edition. > > Please see response inline. > > > Rishi Solanki > Sr Manager, Enterprise Software Development > HotWax Systems Pvt. Ltd. > Direct: +91-9893287847 > http://www.hotwaxsystems.com > www.hotwax.co > > On Thu, Aug 24, 2017 at 8:59 PM, Rajesh Mallah <[email protected]> > wrote: > > > Hi Rishi , > > > > > > Firstly , Thanks for the response. > > > > There in total 36 Demo Data files. > > If i delete records in some xml and there is a (fkey) reference to > > the deleted record in some other xml how does the system behave ? > > > > > I wanted to say, copy the files in your custom component, edit the data as > per your requirement and add new reader to load that data. While copying > the data you need to be selective on what data you want in your system. > > > > lets consider the id "DemoSupplier" which is present in > PartyDemoData.xml > > as well as DemoPaymentsInvoices.xml > > > > $ grep DemoSupplier `cat list` > > > > *./party/data/PartyDemoData.**xml: * <Party partyId="DemoSupplier" > > statusId="PARTY_ENABLED"/> > > *./accounting/data/**DemoPaymentsInvoices.xml: * <AcctgTransEntry > > acctgTransId="8005" acctgTransEntrySeqId="00002" > > acctgTransEntryTypeId="_NA_" partyId="DemoSupplier" > > roleTypeId="BILL_FROM_VENDOR" glAccountTypeId="ACCOUNTS_PAYABLE" > > glAccountId="210000" organizationPartyId="Company" amount="33.99" > > currencyUomId="USD" origAmount="33.99" origCurrencyUomId="USD" > > debitCreditFlag="C" reconcileStatusId="AES_NOT_RECONCILED"/> > > > > suppose i delete DemoSupplier from PartyData and forget to delete in > > DemoPaymentsInvoices , will it not > > be an issue ? > > > > > > References in other entity will effect for sure. All general db practices > applicable here as well. > > > > > > I still feel an enduser should be able/allowed to bring the instance to a > > usable form starting from seed,seed-initial ( > > which are maintained along with code) > > > > Big +1 for this, and it should work how you are expecting. I remember > Sharan Foga also faced similar issue in past. > > Community, I feel we should proceed to fix the behavior mentioned here. I > completely agree on seed and seed-initial data should be enough to bring > the instance usable. Please let me know if agree then will log jira ticket > for the same. Thanks! > > > > > > In my case certain functions of the software were failing in doing so > which > > is the reason i took the other route. > > > > Regds > > mallah. > > > > > > > > > > On Thu, Aug 24, 2017 at 7:51 PM, Rishi Solanki <[email protected]> > > wrote: > > > > > You just need to take care of either your copy or demo data will load. > Or > > > You can also change the PKs while editing. > > > > > > Rishi Solanki > > > Sr Manager, Enterprise Software Development > > > HotWax Systems Pvt. Ltd. > > > Direct: +91-9893287847 > > > http://www.hotwaxsystems.com > > > www.hotwax.co > > > > > > On Thu, Aug 24, 2017 at 7:49 PM, Rajesh Mallah < > [email protected]> > > > wrote: > > > > > > > Thanks Rishi , > > > > > > > > Is there no risk of introducing referential integrity issues if > > > > I edit the ( copy of ) demo data by hand and load it subsequently ? > > > > > > > > regds > > > > mallah. > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Thu, Aug 24, 2017 at 7:30 PM, Rishi Solanki < > > [email protected]> > > > > wrote: > > > > > > > > > Rajesh, > > > > > > > > > > I see your several conversation on setting up the instance for > > > > production. > > > > > I would suggest instead of changing or editing the data from > > > application > > > > UI > > > > > you should try to use existing demo data setup for facility, store > > etc. > > > > > copy them in separate xml file. > > > > > > > > > > Edit the data as per your requirement. Finally, remove the demo > > readers > > > > and > > > > > load the data for your application with separate custom reader. > > > > > > > > > > In this way you will have all history of changes you are doing for > > your > > > > > application. Also this practice should be follow for customization. > > > > > > > > > > HTH! > > > > > > > > > > > > > > > > > > > > Rishi Solanki > > > > > Sr Manager, Enterprise Software Development > > > > > HotWax Systems Pvt. Ltd. > > > > > Direct: +91-9893287847 > > > > > http://www.hotwaxsystems.com > > > > > www.hotwax.co > > > > > > > > > > On Wed, Aug 23, 2017 at 7:05 PM, Rajesh Mallah < > > > [email protected]> > > > > > wrote: > > > > > > > > > > > Pritam thanks for the hint :-) > > > > > > > > > > > > it is awkward but accessing /facility/control/EditFacility from > > > > > > the address bar did help me pass my current hurdle . > > > > > > > > > > > > I could create the new facility. > > > > > > > > > > > > regds > > > > > > mallah. > > > > > > > > > > > > > > > > > > On Wed, Aug 23, 2017 at 6:47 PM, Pritam Kute < > > > > > > [email protected]> > > > > > > wrote: > > > > > > > > > > > > > Hi Rajesh, > > > > > > > > > > > > > > There is an option available to add the new facility. Go to > > > > > > "Application" > > > > > > > > "Facility" and select any available facility. Click on Submit > > > button. > > > > > It > > > > > > > will open the detail screen of the facility. On this screen, > you > > > will > > > > > get > > > > > > > the button to "Create New Facility". > > > > > > > > > > > > > > Improvement can be done over here by adding the "Create New > > > Facility" > > > > > > > button on Facility Selection screen itself instead of overview > > > > screen. > > > > > > > > > > > > > > Regards > > > > > > > -- > > > > > > > Pritam Kute > > > > > > > > > > > > > > On Wed, Aug 23, 2017 at 6:21 PM, Rajesh Mallah < > > > > > [email protected]> > > > > > > > wrote: > > > > > > > > > > > > > > > Hi , > > > > > > > > > > > > > > > > I do not see any "Add Facility" in "Application" > > "Facility" > > > > > > > > is it not possible or required ? > > > > > > > > > > > > > > > > The original requirement is to Create an Employee which has > > > > > following > > > > > > > > dependencies . > > > > > > > > > > > > > > > > Employee requires a "Store" > > > > > > > > Store requires "Inventory Facility Id" > > > > > > > > > > > > > > > > regds > > > > > > > > mallah. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
