Need help on sending grouped records to File Transfer

Answered

Swapnil Kshirsagar

• July 22, 2022 06:42

Hi Experts,

I have a use case where I am exporting NetSuite Saved Search data for Sales orders information. And since an order can have multiple items in it, saved search is returning multiple rows for an order having multiple items associated with it.

I want to create one CSV file per order with item rows repeating inside of it.

What I have tried so far -

1. Used Group Rows option on NS export and enabled one to Many on CSV file import.
But I think it doesnt work.

2. Removed Group Rows option on NS export, added pre save page script hook after the export to group it manually. But it is also not helping.
What could be alternatives here ?
Can I used Group Rows and somehow with script make array elements as separate records, that way I dont have to select one To many on CSV file transfer. But still would be able to create one file per order ?

0

• 

  Scott Henderson CTO

  • July 27, 2022 22:40

  

  

  

  This is an easy one. :)

  1. On NetSuite export, set 'Group rows' to true.
  2. On NetSuite export, set 'Page size' to 1 (pic below).
  3. On import, set 'Skip aggregation' to true (pic below).
  4. On import, set 'One to many' to false.

  Cheers!

  

  

   

  0

Please sign in to leave a comment.