Comments on: Load Excel files to ServiceNow using Portal https://servicenowguru.com/service-portal/load-excel-files-to-servicenow-using-portal/ ServiceNow Consulting Scripting Administration Development Fri, 31 May 2024 00:18:55 +0000 hourly 1 https://wordpress.org/?v=6.8.2 By: Thiago Pereira https://servicenowguru.com/service-portal/load-excel-files-to-servicenow-using-portal/#comment-10040 Fri, 31 May 2024 00:18:55 +0000 https://servicenowguru.com/?p=15379#comment-10040 In reply to Ashish.

As I said in the previous answer there are several ways to do it and reduced server load It’s something we should always keep in mind. As GlideExcelParser runs on the server, all necessary validation would be done there, which I don’t see as a good practice.

]]>
By: Thiago Pereira https://servicenowguru.com/service-portal/load-excel-files-to-servicenow-using-portal/#comment-10039 Fri, 31 May 2024 00:11:01 +0000 https://servicenowguru.com/?p=15379#comment-10039 In reply to Ankush.

Hi Ankush!
There are several ways to do it but we should consider the following:
Loading large files and attachments: One place where we commonly run into performance troubles is loading large files and attachments. In general, these may take a littlelonger to load. Além do fato de sobrecarregar a sys_attachment.
Reduced Server Load: Distributing some processing to the client side can reduce the load on the server, especially for applications with a large number of concurrent users.
Validation Feedback: Real-time validation and feedback to users can be implemented more effectively on the client side, providing a better user experience.

In the example in the article, the Excel file is very simple. But imagine if you need to upload a file with dozens of columns and a lot of validations to be done on the data?

]]>
By: Ashish https://servicenowguru.com/service-portal/load-excel-files-to-servicenow-using-portal/#comment-10036 Wed, 29 May 2024 16:49:36 +0000 https://servicenowguru.com/?p=15379#comment-10036 why not use the OOB excel parser and avoid all this?

]]>
By: Ankush https://servicenowguru.com/service-portal/load-excel-files-to-servicenow-using-portal/#comment-10035 Wed, 29 May 2024 14:20:37 +0000 https://servicenowguru.com/?p=15379#comment-10035 Why can’t we create a data source and via recordproducer let user upload file using OOB attachment option ?
Unless I am missing something

]]>