Save Error files to sftp server
Hi,
Is there a way to save the error files while doing an export of csv files from a sftp server?
We are exporting the csv files from the server and importing to NetSuite. I need the errored files saved to a folder in the server, Is that possible in the custom flow?
-
Might i suggest taking the Celigo University courses?
0 -
Are you importing raw CSV files into NetSuite, or are you parsing the CSV files and then importing records into NetSuite?
0 -
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 -
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 -
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 -
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.
Comments
6 comments