Friday, November 30, 2012

PostgreSQL Full Join, import csv

Made another Web Manager vid. This one covers:

  • adding a column to a table, 
  • adding default values, 
  • importing a csv, 
  • field mapping
  • creating a Full Join with conditions, 
  • coalesce, string concatenation. 
I'm trying to create a 'storyline' here about Iama, a mythical Knowledge Worker that is determined to learn and is not into instant gratification. Her cohort (a developer), Bridget, occasionally busts Iama but respects her persistence.

 In this vid, Iama was trying to join 2 reasonably similar tables: a contact table with data pulled from a web contact form + a customer table with more/different columns. I toyed with doing a Union, but decided a Full Join would be a bit easier. Creating these vids and battling with Adobe Captivate 6 is a bit time consuming. This one took two, full days.


Wednesday, November 28, 2012

Web Manager: Contact form, Part 2

Here is the second part of the video, where Iama learns that she is clueless about Php and receives assistance from a developer. I'll be adding the audio transcripts to these blog posts pretty soon. We have about 3 more vids to get out this week. Been quite a process.


Added two more web manager system videos, as part of a two part series that show how to create a Contact form for a website.  Ends up covering the contact for, how to add a Captcha, onchange event, a couple of onclick events, a bit of JQuery, the php that runs the process.  Includes inserting the submitted data to a PostgreSQL table, sending an email, alerting the user, checking the captcha, plus a fair amount more.  Includes quite a bit of audio.

I'm finding that it takes ~ 1 hour to generate about 1 minute of video & audio.


Monday, November 26, 2012

TrustE Privacy Certification is official

We received our TrustE Privacy certification today for SpinBackup.com.

The seal will go up tomorrow.

YouTube Web Manager System Playlist

 All vids can be reached here:  Web Manager System videos  Still working on this page, but the vids are embedded and seem to work ok.

Added annotations (pause + continue to url) at YouTube to an image, which we are currently using as a centralized link system.


The Web Manager System: How to Add an external RSS Feed

Using the Web Manager to add an external RSS feed to your own site.


Using the Web Manager System - Add a Shopping Cart payment system

Set Up a Web Payment System, using the Web Manager.


ACL: Access Control List, Add a Role, Add a User, Assign to a Role with the Web Manager System

ACL, Access Control List, Create and assign Roles (RBAC).  PostgreSQL and the Web Manager.


Create a Website, Part 1

Using the Web Manager to Create a Website, Part 1


Web Manager: Upload an Image plus many options

Use the Web Manager to Upload an Image + much more


Iama says hello

Iama says hello.  Used as psrt of the prvious video.


Web Manager: A YouTube Video of How to embed a Youtube Video

A YouTube Video of how to Add and embed a YouTube video, using the Web Manager.


Basic Navigation for the Web Manager System

Basic Navigation for the Web Manager


Web Manager: Extend the Power of Google Apps

Extend the Power of Google Apps.  Import a Google Spreadsheet and create a PostgreSQL Table at the same time by using the Web Manager.


The Web Manager as a Software as a Service (SaaS) Aggregator

The Web Manager as a Software as a Service (SaaS) 
 Aggregator

 

Make a Website Theme (Part 2 of make a website)

Make a Website Theme (Part 2 of Create a Website) using the Web Manager.


Using the Web Manager: Build a PostgreSQL Table in 2 minutes

Use the Web Manager to create a PostgreSQL Table in 2 minutes.


Make a History Table, PostgreSQL Table Trigger and Trigger Function

Been busy creating Web Manager videos.  Made quite a few, with more to come.

Here's the beginning of the current list, along with a synopsis:
Make a History Table, PostgreSQL Table Trigger and Trigger Function
- Use the Web Manager to create a backup history table, a PGSQL Trigger function and Table Trigger.

http://www.youtube.com/watch?v=5PYbfk3i2ng