grabo

multiple field conversion into portal lines

Discussion created by grabo on Jul 24, 2018
Latest reply on Jul 24, 2018 by grabo

I have an old database invoices. Invoice entries consist of multiple fields. I would like to convert the whole database by turning multiple fields into portal rows. I thought I should export all the records and then make sure that the invoice key is inserted into the fk_filling key of the invoice lines. I think it's a very delicate operation and I'm not sure I'll do it, but at least as an exercise it's worth trying. Other times I had to do intermediate steps to be able to export and import data. Does anyone have different ideas for doing this?
When I export a field with multiple rows I do not know how to present it for example in an excel file ... I do not know if in fact the multiple field is a complication to do what I think.

Outcomes