CakePHP 4 - CSV Import / Export with MySQL Workbench and CsvView Plugin
In this video come along as I do a round trip of importing a CSV file using MySQL Workbench, then run migrations to rename and modify the resulting table and columns. Then using the FriendsOfCake/CsvView Plugin to format and download CSV files.
Code: https://github.com/toggenation/cakeph...
00:00 Importing a CSV using MySQL Workbench
02:00 Table rename migration
03:46 Column rename migration
05:00 Adding an id column to an existing table
09:27 Bake all 1st try
11:00 Change column type migration
16:30 Bake all 2nd try
19:22 Install CsvView plugin
20:10 Add Bootstrap CSS and download button
23:36 Add CsvView download action code
25:46 Format column headings with Inflector::humanize
28:20 Formatting output using CsvView
33:20 Selecting the columns for CsvView to output
Watch video CakePHP 4 - CSV Import / Export with MySQL Workbench and CsvView Plugin online without registration, duration hours minute second in high quality. This video was added by user James McDonald 16 August 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 536 once and liked it 10 people.