Automating generation of import files for doctypes with child tables

Has anyone had any luck with this? I can generate files for single-table doctypes (eg Item or Supplier) but due to how import files are structured for child tables (eg Purchase Order) I’m having difficulty thinking how this would be done.

At the moment I’m trying to export full rows to a csv then somehow blank out the duplicate parent table lines but the only way I know how to do that is VBA in Excel.

1 Like

My only experience is LibreOffice macros not Python…

Apparently this is acclaimed Interface-oriented programming in OpenOffice / LibreOffice : automate your office tasks with Python Macros

I’ve managed to build something through Pentaho Data Integration which I should be able to use as a template for all the integrations we’ll need. It basically relies on adding a column that identifies duplicates in the parent table fields, and then using those markers to replace that data with blanks.

1 Like