Answered

Need help on sending grouped records to File Transfer

Avatar
Swapnil Kshirsagar
Engaged
Celigo University Level 4: Legendary

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

Comments

1 comment
Date Votes
  • Avatar
    Scott Henderson
    CTO
    Celigo University Level 1: Skilled
    Answer Pro
    Top Contributor

    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.

 

Didn't find what you were looking for?

New post