Got it. Its just that "Webtools" can't be selected from the menu and so i did not find it. Import was a success as it seems.
On 6 February 2014 10:19, Adrian Stern <[email protected]> wrote: > The depedencies i mentioned above are quite troubeling. Right now nothing > works and getting it to work is very complicated because of the mentioned > dependencies. > > I tried to only Import DemoGeneralChartOfAccounts.xml by deleteng one by > one the other Files causing errors on ant load-demo. Problem is: Once the > accounting module stopped trhowing errors, the HR and E-Commerce module > started. > > My conclusion is that this demo data is way too US-Specific and too > extensive for adjusting it to this region and law. > I get that for the CoA to work i have to change the mappings in > DemoGlSetupData.xml. What i don't get is why all the Tax information, HR > stuff, Ecommerce and so on have to be present as well. > > What i'm trying to do now is building up from the minimal configuration i > get when using "ant load-extseed && ant create-admin-account...". > BUT: How / Where can i import the CoA i've created for demo data? ant > load-file wont let me do it. (does not exist in project "OFBiz Main Build") > > The Question is how do in Import a CoA in the same Format as the Demo one > but not with load-demo > > > On 5 February 2014 18:26, Anil Patel <[email protected]> wrote: > >> Adrian, >> This document is good resource, >> >> https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide >> >> There is lot of information on it. >> >> >> Thanks and Regards >> Anil Patel >> COO >> Hotwax Media Inc >> http://www.hotwaxmedia.com/ >> ApacheCon US 2013 Gold Sponsor >> http://na.apachecon.com/sponsors/ >> >> >> >> >> On Feb 5, 2014, at 12:17 PM, Adrian Stern <[email protected]> wrote: >> >> > I played around with ofbiz a little and i am able to import our accounts >> > together with the ones already present in demo data. When disposing of >> the >> > demo ones i get some import errors because there are references to >> accounts >> > no longer present. Also we had to switch from a CSV to a TSV because our >> > account names actually contain commas. >> > >> > This is just a status update. >> > >> > Dependencies to these files: >> > >> > DemoGlSetupData.xml >> > DemoFinAccountData.xml >> > DemoTaxAuthority.xml >> > DemoAcctgTransactionData.xml >> > DemoPaymentsInvoices.xml >> > DemoTaxAuthority.xml >> > DemoOrderPeopleData.xml >> > DemoOrderTestData.xml >> > DemoMarketing.xml >> > >> > Next we will try to switch the old account codes with our own new ones. >> > This will hopefully get us started. >> > As of now we are unsure if we just do it inside the files mentioned >> above >> > or with excessive trial end error with use-cases. >> > >> > Regards, Adrian >> > >> > On 5 February 2014 15:30, Adrian Stern <[email protected]> wrote: >> > >> >> Thanks Anil >> >> >> >> So i will try to build our needs within the GUI and inspect the output. >> >> As for the CSV, we included a english translation (google translate) so >> >> its easier for you to guess what a spesific account is used for. >> >> >> >> Furthermore i will ignore the GL Account Classes for the time beeing >> and >> >> try to set a GL Account Type on each account. >> >> >> >> >> >> On 5 February 2014 14:45, Anil K Patel <[email protected]> >> wrote: >> >> >> >>> It's recommended that all glAccounts have type. It's safe to say with >> >>> some level of confidence, that accounts with no glaccountType don't >> get >> >>> automatic posting. >> >>> >> >>> For now I say, ignore them :) >> >>> >> >>> Anil K Patel >> >>> Sent from my iPad >> >>> >> >>>> On Feb 5, 2014, at 7:46 AM, Adrian Stern <[email protected]> wrote: >> >>>> >> >>>> So. I discovered that there are many accounts in the CoA which do not >> >>>> specify a GL Account Type. Why is this? Which rules will help me >> >>> determine >> >>>> wheter to set a type or not and which type to set? >> >>>> >> >>>>> On 5 February 2014 10:55, Adrian Stern <[email protected]> wrote: >> >>>>> >> >>>>> Hi Anil >> >>>>> >> >>>>> Thanks for your response. Since English is not my mother tongue, it >> is >> >>>>> hard for me to read between the lines. So i have to come back to you >> >>> from >> >>>>> time to time with some questions about your statements. >> >>>>> >> >>>>> First: You say i can safely ignore GL Account Class. I assume this >> is >> >>>>> because it is not used for accounting but for reporting instead. >> True? >> >>>>> But do you also imply we will have to set GL Account Type properly? >> >>>>> >> >>>>> Secondly: In DemoGlSetupData.xml, do we also need to do all the >> Invoice >> >>>>> Item Types to Gl Account Ids mappings? I would have done it since >> >>>>> everything there uses the wrong codes. >> >>>>> >> >>>>> I think for now we should focus on Step 1 and 2. But out of >> Couriosity, >> >>>>> where would i configure Step 3? >> >>>>> >> >>>>> For our CoA we've created a Spreadsheet which we will exprot to a >> CSV >> >>> and >> >>>>> then generate the GL Xml from it. I can share the generation script >> >>> with >> >>>>> you if you'd like. You can find the Spreadsheet in the link below. >> >>>>> >> >>>>> We've mainly focused on the GL Account Classes... Too bad we have to >> >>> start >> >>>>> over on the Types. >> >>>>> >> >>>>> >> >>>>> >> >>> >> https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing >> >>>>> >> >>>>> Regards, Adrian >> >>>>> >> >>>>> >> >>>>>> On 5 February 2014 04:33, Anil Patel <[email protected]> >> >>> wrote: >> >>>>>> >> >>>>>> Adrian, >> >>>>>> >> >>>>>> Regarding questions in your first email. >> >>>>>> >> >>>>>> You can safely ignore GL Account Class for automatic posting of >> >>> business >> >>>>>> transactions to general ledger. >> >>>>>> >> >>>>>> I see you got basic steps figured >> >>>>>> >> >>>>>> Step 1) Define Chart of Account. For reference use >> >>>>>> DemoGeneralChartOfAccounts.xml >> >>>>>> Step 2) Associate GLAccounts to Organization. For reference use >> >>>>>> DemoGlSetupData.xml >> >>>>>> Step 3) Setup data for automatic GL posting of business >> transactions >> >>> e.g >> >>>>>> Invoice , Payment , Inventory issuances etc. >> >>>>>> >> >>>>>> Looks like you have figured first two steps. I can help you setup >> data >> >>>>>> for automatic posting. Data setup between line # 294 to line #315 >> is >> >>> good >> >>>>>> example. If you can read code, start with >> >>> "getGlAccountFromAccountType" at >> >>>>>> line #446 in GeneralLedgerServices.xml. >> >>>>>> >> >>>>>> I can give you specific help for real specific question, for e.g >> setup >> >>>>>> data for automatic posting of Sales Invoice to GL. I will need >> access >> >>> to >> >>>>>> your CoA as well. >> >>>>>> >> >>>>>> Thanks and Regards >> >>>>>> Anil Patel >> >>>>>> COO >> >>>>>> Hotwax Media Inc >> >>>>>> http://www.hotwaxmedia.com/ >> >>>>>> ApacheCon US 2013 Gold Sponsor >> >>>>>> http://na.apachecon.com/sponsors/ >> >>>>>> >> >>>>>>> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[email protected]> >> >>> wrote: >> >>>>>>> >> >>>>>>> For know im happy with the demo data. What i have been missing is >> an >> >>>>>> import >> >>>>>>> option for installing only my own CoA. Well i did not search that >> >>> deeply >> >>>>>>> since it is not important for know. (Maybe ant load-file) >> >>>>>>> >> >>>>>>> Would be happy for an answer to my previous email. >> >>>>>>> >> >>>>>>> >> >>>>>>>> On 4 February 2014 15:05, Pierre Smits <[email protected]> >> >>> wrote: >> >>>>>>>> >> >>>>>>>> Adrian, >> >>>>>>>> >> >>>>>>>> Other good point of reference are the books regarding the >> Universal >> >>>>>> Data >> >>>>>>>> Model by Len Silverston. >> >>>>>>>> >> >>>>>>>> Regards, >> >>>>>>>> >> >>>>>>>> Pierre Smits >> >>>>>>>> >> >>>>>>>> *ORRTIZ.COM <http://ORRTIZ.COM>* >> >>>>>>>> Services & Solutions for Cloud- >> >>>>>>>> Based Manufacturing, Professional >> >>>>>>>> Services and Retail & Trade >> >>>>>>>> http://www.orrtiz.com >> >>>>> >> >>> >> >> >> >> >> >> >
