This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

for those of you who use Netsuite SuiteQL Query Tool, is there a way to export more than 5000 results?

<https://blog.prolecto.com/2022/01/29/learn-how-to-update-netsuite-using-sql/>

I use <https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/|this one> by <@U856E2SEA> in conjunction with <https://chrome.google.com/webstore/detail/download-table-as-csv/jgeonblahchgiadgojdjilffklaihalj?hl=en|this> extension. It can handle an arbitrary amount of rows but if you have to much information on the page it will crash.

i downloaded the suitelet, and created a script record and deployment, but for some reason im getting an unexpected error.
how do i troubleshoot that?
_An unexpected error has occurred. Please click here to notify support and provide your contact information._

im not an admin, but im running the script as admin

That is the most annoying error. All I can recommend is to maybe try an earlier version of the tool. If all else fails maybe click "here" and notify support.

ok sounds good. Thanks for you help Alan
I really appreciate it

Now im getting another error when i use a different version. do you know what this is?

_:"error.SuiteScriptModuleLoaderError","name":"MODULE_DOES_NOT_EXIST","message":"Module does not exist: /SuiteScripts/New SuiteQL Tool.js","stack":[]}_

Try to delete all deployments and script records, download the tool, unzip it, upload it without out renaming it and recreate the records.

ok everthing seems to work now.
but its always returning 5000 rows max.
is there a way to return more?

well i just realized that i can enable pagination

Ah. I forgot about that. My version has syntax highlighting, vim and autoformatting.