#045 - Valence 6.4 Sneak Peak: Spreadsheet Uploads Made Easy

[Iwona]

SUMMARY: In this month’s Valence Developer Diaries, the CNX Dev team unveiled a brand-new NAB feature to be included in Valence 6.4, which could also be enabled in Valence 6.3 as a Beta feature for those feeling adventurous. The demo showed how users could upload a standard spreadsheet directly into a local data grid, validate the data, and then pump it into an appropriate back-end file. This greatly simplified the process of importing spreadsheet data from users.??

URL: https://youtu.be/GnOV5zaSecQ?si=eLIqU--54oqGJ-8J

Screenshot 2025-09-25 at 2.54.21 PM.png

TIMESTAMPS AND FEATURES COVERED:


00:20 - New Edit Grid Feature - uploading an Excel File
01:30 - New Upload Excel File feature only available if in Edit Grid using local data, with no paging used.
02:00 - Attaching Upload feature into the Edit Grid
02:30 - Enabling the new Excel Upload feature in Valence Portal Admin - Settings - Enable Beta Features
3:10 - Setting up import in Edit Grid
03:35 - Excel Import options explained: Clear Grid Before Import
04:25 - Excel Import options explained: Track Removed Rows on Clear
05:12 - Excel Import options explained: Has Header Row
06:20 - Excel Import options explained: Number of Header Rows, Maximum Row, Sheet Name, Import Button Text, Import Example
07:10 - Mapping columns from your Excel File
09:00 - Testing "Import Products" button in the NAB application
09:50 - Reviewing the RPG program attached to the "Import Products" button
13:15 - Explaining the procedure "RowAdded"?