CloudExtend Excel Data Management for NetSuite Bust Mode was built to get your data from Excel to NetSuite really fast. If you need to submit large jobs that are prone to timeouts between Excel and NetSuite or you need to submit multiple jobs without waiting for them to complete try Burst Mode. One primary difference between Burst Mode and Standard Upload is that Netsuite may elect to defer the processing of the job once received therefore for small uploads we still recommend the standard upload process.

When to consider Burst Mode?

  • If you need to create transactions with more lines than NetSuite allows via the UI and via standard uploads (see transaction line limits).

  • If you have other Excel work to do while batches are processing or want to submit multiple batches.

  • If you are submitting large complex batches that NetSuite cannot process in the one to two minutes allocated per batch.

  • If you have large data sets (note the definition of 'large' is subjective depending on your own needs. For example, one user may be willing to wait for 500 Sales Orders to process in batches of 25 while another may prefer to submit it as one batch, do other work, and then come back to it when complete).

  • If your NetSuite account typically has concurrency issues.

A note on transaction line limits

NetSuite has restrictions on the number of lines allowed for standard (synchronous) uploads and burst mode (asynchronous) uploads.

  • Journal entries have a limit of 1,000 lines for standard uploads and 10,000 lines for burst mode uploads.

  • All other transactions have a limit of 5,000 lines

  • See this article from NetSuite for up to date info

How to use Burst Mode

Initiate Upsert

Check the box on the upsert screen where it says to use the new Burst Upload and then choose your Upsert option (all records or selected records). If picklists have already been resolved it should only take a few seconds for the job to be submitted.

Once your job has been submitted you will be notified of the progress. At this point, you can safely submit other jobs (load them on other tabs in the workbook). You can even close Excel if desired (save your workbook first). After NetSuite completes the job the results are sent to the CloudExtend server and available for you to download.

Download Results

When you have been notified that your job is completed go ahead and click the download icon and your results will fetch from the CloudExtend server.  If there are any errors or warnings they will be displayed in the Reserved Column (Column A).

Checking on your job in NetSuite

Once your job has been submitted we periodically ping NetSuite for updates. If you or your Admin wants to check the status in NetSuite this can be done by going to Setup->Integration->SOAP Web Services Process Status.

Once there you will see a list of all the jobs in your queue. 

Removing a stuck burst mode job that appears incomplete

If a job has been fully completed but you're still receiving an indication that the job is in progress you can turn off this notification by navigating to the job status window and clicking the trash icon to stop being notified.

Known Limitations

Burst Mode upload is not supported if your template/fields contain any of the following:

  1. Custom transaction records

  2. Custom segments

  3. Multi-select fields

  4. Custom field of type Phone

Are there any drawbacks to using the Burst Mode Upload?

While Burst Mode gets your data to NetSuite very quickly, NetSuite may not process your requests immediately. If your NetSuite account is reasonably busy with other work such as requests coming in from other apps or users, NetSuite may not pick up upload job immediately. Therefore the entire job may, in some cases, seem to take longer than regular uploads for smaller sets of records.

Did this answer your question?