Session 23: External data L2
Preparation
- Please download this content here.
Description
This tutorial examines the use of Excel spreadsheets and myql databases.
Session specific objectives
This tutorial examines the use of xls files and mysql databases to populate templates: L2
Chapter 1: Populating a template from an .xls file
- Installing ruby
- Installing gems
- Command Sources
- Command Strings
Chapter 2: Creating and using a libs script
- General description and example
- Basic syntax
Chapter 3: Populating a template from a mysql database
- Installing mysql
- Adding the database to the project
- Database Sources for Inputs
Expected duration
30 minutes
User Level
All new users
Ruby Basics by Darrell James
To find where you can download Ruby, open the Ruby Basics guide here and follow the installation instructions.
MySql
You can download MySql from here with your ftp login credentials.
Navigate to Downloads > Software releases > Utilities > Windows > mysql-essential-5.1.47-winx64.msi
Please refer to the correct installation procedures for this utility.
Chapter 3 crib
msql commands
mysql -u root
create database trainingdatabase;
exit
mysql -u root trainingdatabase < trainingdatabase.sql
Session Project
If you want to review Justin Avery's instructor project at this point in the course, you can download the project zip here.
