Valence Developer Diaries 045 - Valence 6.4 Sneak Peak: Spreadsheet Uploads Made Easy скачать в хорошем качестве

Valence Developer Diaries 045 - Valence 6.4 Sneak Peak: Spreadsheet Uploads Made Easy

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. 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 03: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"