What the best option for an external system to push a large CSV file into NetSuite?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The best option for an external system to push a large CSV file into NetSuite would be to use the SuiteSolutions CSV Integrator. This tool, which is now free, allows for the efficient import of large amounts of data. You can find more information about it in the [SuiteSolutions CSV Integrator documentation](https://www.netsuite.com/portal/assets/pdf/ds-suitesolutions-csv-integrator.pdf) and a thorough walk-through video [here](http://blog.prolecto.com/2019/08/18/learn-and-assess-the-value-of-netsuites-csv-integrator-add-on-bundle/). Another option is to import data into a custom record and then run a script that processes the data. This could be an alternative depending on the complexity of your data. If you're dealing with a very large number of records (like 3 million), you could create multiple JSON files, upload them to the file cabinet, and do your import with a Map Reduce Script. This approach could be more efficient than a CSV import, which has a limit of 25,000 records per file. Lastly, you could also consider using CloudExtend Excel, which allows you to import thousands of check records at a time. Remember, when dealing with large data imports, it's important to plan for potential errors and to consider the impact on system performance.

@darrenhillconsulting how many records do you plan on importing and what record types?

journal entries .. and LOTS. I think I can keep it under the 25,000 max though

@darrenhillconsulting is this a one off or is this something you need to regularly? If it's a one off CSV import is an option. If you need to do it often then using Celigo's integrator.io to automate the process is an option. Alternatively, you can use CloudExtend Excel to import the JE's into NetSuite. Youcan do this directly from the CSV file vi Excel.