Question & Answer > View Question

import csv to a form that has a form grid in it

Confluence User - 30 Mar, 2021

Hello,

Newbie to joget here. I have a form Customer that has a form grid for Address because my db has customers with multiple addresses.

Can't figure out how I should import csv that has addresses and customer data.

Also, on a separate note, couldn't figure out how to import related data to different tables, like customer and addresses.I can create an id column for customers, and use it in the address, but I wasn't sure how i connect those at the joget backend.

Thank you for your help!

forms;database;csv;importing

2

Confluence User •

31 Mar, 2021 •

confluenceUser •

•

confluenceUser •

Perform two separate import menus, the first import for the main records and the second import for the form grid records, ensuring you include the matching foreign key column/value in the second import so there is a relationship between the parent form and the form grid form.

Confluence User •

31 Mar, 2021 •

confluenceUser •

•

confluenceUser •

Thank you for your response. I am a little confused on how to set the foreign keys. I see that there is an id section for each form, should the foreign key column be named as 'Form Name + ID' ? in my case customerID ?

Thank you in advance.

1

CSV | Excel | XML | PDF

Your answer

Print

import csv to a form that has a form grid in it

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-6de63342-4545-4956-8af5-534f60aca08a{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-67984c6a-f27b-4640-a1a8-750a7364114c{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer