Skip to main content

Save Error files to sftp server

Comments

6 comments

  • David Gollom Channel Partner
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Might i suggest taking the Celigo University courses?  

    0
  • Scott Henderson CTO
    Answer Pro
    Top Contributor

    Are you importing raw CSV files into NetSuite, or are you parsing the CSV files and then importing records into NetSuite?

    0
  • Aishwarya M J

    Hi Scott Henderson,

    Using the data int the csv files I am creating customers in NetSuite, no parsing is done. In my one csv file there are multiple rows with data of multiple customers, each row has to saved as a customer. If error occurs in any of the csv row, I need that errored rows to save to a separate directory in the server as csv file. Could you please suggest a solution?

    0
  • Scott Henderson CTO
    Answer Pro
    Top Contributor

    For anyone else reading this post, I want to clarify that you are parsing the CSV files to create records in NetSuite.

    To collect all the failed rows in a new CSV file, and then upload the new file to a separate directory, you should use a 'response mapping' on your NetSuite import to map the errors back into the source records, and then you need to make sure failed records proceed to the next bubble, and then finally you should create a new FTP + CSV import bubble at the end of your flow, and you should use an 'input filter' to only process the records with errors.  Please see pic below for context on the 3 things you need to configure to make this work.  Hope this helps!

     

    0
  • Aishwarya M J

    Hi Scott Henderson,

    Thank You so much for your reply. I have a doubt in mapping the errors in response mapping. could you please explain that with a sample?

    Thanks

    0
  • Scott Henderson CTO
    Answer Pro
    Top Contributor

    I would recommend contacting support to get additional guidance. It is difficult to describe in detail here. You might find some examples in the help center too if you search around.

    0

Please sign in to leave a comment.