Forum Discussion
- Gary1Qrew Cadet
I would need a lot more info on the make up of the Excel document to be helpful, but in general if you have a well-maintained spreadsheet or database, you should be able to import parent records and their children. Are you using pipelines or scripting this, or something else?
------------------------------
gary
------------------------------- ChrisBaker2Qrew Member
I am not using any scripts or pipelines currently, just manually add the parent and then importing the children from an excel file that is taken from a source outside of my reach, I just get sent the final file.
In terms of the make up, the parent table has an invoice date and due date field, and I added a uniqueId field. For the child records the file is just this structure when I import.
Transaction Date Description Category Total UniqueId 04/13/2022 description 1 Merchandise $25.00 fromparent 04/13/2022 description 2 Merchandise $51.72 fromparent 04/13/2022 description 3 Merchandise $81.55 fromparent 04/14/2022 description 4 Merchandise $4.00 fromparent 04/14/2022 description 5 Other Services $149.77 fromparent 04/14/2022 description 6 Dining $23.49 fromparent
------------------------------
Chris Baker
------------------------------- ChayceDuncanQrew Captain
If it's easy enough you could manually create the parent like you are and enter the invoice and due date, and then load a CSV with the children then save. Have a pipeline handle the loading of the children into records, this way you can skip the manual import part.
------------------------------
Chayce Duncan
------------------------------
- ChayceDuncanQrew Captain
Depending on the makeup of your parent record you could approach this with Pipelines. If you can load the file as CSV to Box or somewhere that Pipelines can access you can create the parent record and then load the actual file as the children using the prior step. The assumption there is that you have sufficient info to make the parent
------------------------------
Chayce Duncan
------------------------------- AdamKrzyzanekQrew Captain
I remember I saw it on one from Empower video but not sure which (2021, 2022 or 2023).
Over there was described how to build Excel file to load 1 set of data to "Staging" table and later pipeline was distributing it to Parent and Child table.Here links to recordings but not sure which🤔
Empower-2021
Empower-2022
Empower 2023
------------------------------
Adam Krzyzanek
------------------------------