Hi everyone,
Hopefully you are all having a great Friday. I have a question for data imports from Json or XML. My situation: I have a PHP Laravel Web app that is hosted on a third party server, while I am using Ofbiz 18.12 locally to manage my company. The PHP app has a contact form so people can send me inquiries. Since I do not want to store the same data in two separate places, I thought the smartest thing to do is, in the PHP app, to create some sort of Json / XML file that I can then import into ofbiz. Particularly I want to create Parties that are People with the RoleTypeId of Lead. I tried to do this in the demo for the trunk that's online :) PartyId = DemoLeadTester & ImportPerson1 I touched the Party, PartyRole PartyAndPerson Tables. Just wanted to see if there is anything that I am missing here and what your thoughts are on my import workflow / method. Thanks so much for all the help, and sorry for the perhaps simple questions, but I am a complete newby :). Enjoy your weekend. Sincerely, Sebastian Dill |
Hi Sebastian,
If I understood your points correctly, one important table you are missing is the 'Person' table. Apart from that, if you also have contact details related to the parties, you are missing tables like ContactMech, PartyContactMech etc. Thanks -- Deepak Nigam On Fri, Aug 16, 2019, 8:41 PM Sebastian Naumann <[hidden email]> wrote: > Hi everyone, > > Hopefully you are all having a great Friday. > > I have a question for data imports from Json or XML. > > My situation: I have a PHP Laravel Web app that is hosted on a third party > server, while I am using Ofbiz 18.12 locally to manage my company. > > The PHP app has a contact form so people can send me inquiries. > > Since I do not want to store the same data in two separate places, I > thought the smartest thing to do is, in the PHP app, to create some sort of > Json / XML file that I can then import into ofbiz. Particularly I want to > create Parties that are People with the RoleTypeId of Lead. > > I tried to do this in the demo for the trunk that's online :) PartyId = > DemoLeadTester & ImportPerson1 > > I touched the Party, PartyRole PartyAndPerson Tables. > > Just wanted to see if there is anything that I am missing here and what > your thoughts are on my import workflow / method. > > Thanks so much for all the help, and sorry for the perhaps simple > questions, but I am a complete newby :). > > Enjoy your weekend. > > Sincerely, > > Sebastian Dill > |
Hi Deepak,
Thanks for the super quick response. I had actually touched the Person Table, sorry forgot to mention it. And yeah, there will be an email address supplied etc. Just wanted to see If I am on the right track. Have a great weekend. Sincerely, Sebastian On Fri, Aug 16, 2019, 11:21 Deepak Nigam <[hidden email]> wrote: > Hi Sebastian, > > If I understood your points correctly, one important table you are missing > is the 'Person' table. Apart from that, if you also have contact details > related to the parties, you are missing tables like ContactMech, > PartyContactMech etc. > > Thanks > -- > Deepak Nigam > > On Fri, Aug 16, 2019, 8:41 PM Sebastian Naumann < > [hidden email]> > wrote: > > > Hi everyone, > > > > Hopefully you are all having a great Friday. > > > > I have a question for data imports from Json or XML. > > > > My situation: I have a PHP Laravel Web app that is hosted on a third > party > > server, while I am using Ofbiz 18.12 locally to manage my company. > > > > The PHP app has a contact form so people can send me inquiries. > > > > Since I do not want to store the same data in two separate places, I > > thought the smartest thing to do is, in the PHP app, to create some sort > of > > Json / XML file that I can then import into ofbiz. Particularly I want to > > create Parties that are People with the RoleTypeId of Lead. > > > > I tried to do this in the demo for the trunk that's online :) PartyId = > > DemoLeadTester & ImportPerson1 > > > > I touched the Party, PartyRole PartyAndPerson Tables. > > > > Just wanted to see if there is anything that I am missing here and what > > your thoughts are on my import workflow / method. > > > > Thanks so much for all the help, and sorry for the perhaps simple > > questions, but I am a complete newby :). > > > > Enjoy your weekend. > > > > Sincerely, > > > > Sebastian Dill > > > |
Free forum by Nabble | Edit this page |