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.
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.