I just cannot find information on how to import data directly into a custom fields subform in Joomla 4.
Looking in the database, the subform data gets saved in JSON format.
Therefore I converted my data into JSON as well. Here is an example of the JSON data I want to import:
{"row0":{"field73":"Wohncontainer f\\u00fcr Arztreserve und Krankenschwestern f\\u00fcr ein hessisches Krankenhaus.","field71":"Wohncontainer f\\u00fcr Arztreserve und Krankenschwestern f\\u00fcr ein hessisches Krankenhaus.","field72":"Wohncontainer f\\u00fcr Arztreserve und Krankenschwestern f\\u00fcr ein hessisches Krankenhaus.","field66":"images\\/containerfotos\\/394\\/fensterfront-behelfsunterkuenfte-arzt.jpg"},"row1":{"field73":"Wohncontainer f\\u00fcr Arztreserve und Krankenschwestern f\\u00fcr ein hessisches Krankenhaus.","field71":"Wohncontainer f\\u00fcr Arztreserve und Krankenschwestern f\\u00fcr ein hessisches Krankenhaus.","field72":"Wohncontainer f\\u00fcr Arztreserve und Krankenschwestern f\\u00fcr ein hessisches Krankenhaus.","field66":"images\\/containerfotos\\/394\\/eingangsbereich-4x20fuss-5-2013.jpg"},"row2":{"field73":"Wohncontainer BV N\\u00fcrnberg","field71":"Wohncontainer BV N\\u00fcrnberg","field72":"Wohncontainer BV N\\u00fcrnberg","field66":"images\\/containerfotos\\/394\\/img0141.jpg"},"row3":{"field73":"Wohncontainer BV N\\u00fcrnberg","field71":"Wohncontainer BV N\\u00fcrnberg","field72":"Wohncontainer BV N\\u00fcrnberg","field66":"images\\/containerfotos\\/394\\/img0142.jpg"}}
The Excel Column containing this JSON data gets mapped to the custom fields subform field.
Running the import this data seems not to get imported into the database. What am I missing?
- Is my approach to import the data into a custom fields subform correct?
- If so, what am I missing that the JSON data won't get imported properly?
Thanks for help.
Kind regards,
Bernhard