Ofbiz JSON / XML Data Import - Leads

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Ofbiz JSON / XML Data Import - Leads

Sebastian Naumann
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
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz JSON / XML Data Import - Leads

deepak nigam-2
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
>
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz JSON / XML Data Import - Leads

Sebastian Naumann
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
> >
>