Photoshop – Data Driven Graphics

What is ‘Data Driven Graphics’?

Data-driven graphics make it possible to produce multiple versions of an image quickly and accurately for print or web projects. For example, you can produce 100 versions of a web banner with different text and images, all based on a template design.

In the following tutorial we are going to read data from a CSV file and automatically create a banner for every row contained in the below dataset.

Step 1

In our example, we have two layers named as ‘Christmas Tree’ and ‘Background’ acting together as a very simplistic postcard. Yes, it is very simple.


Step 2

If we open our sample dataset (the CSV Excel file), we can notice that our database is divided into four columns which are the “Name”, “Surname”, “Street” and “Country”. Do you agree that we need to link Photoshop with this database? Yes? Good. Let’s proceed to the next step.


Netduino 2 – Introduction to Netduino – Traffic lights

You might ask. What is a Netduino? Netduino is an electronics prototyping platform based on the .NET Micro Framework. Yes, you can use C# and Visual Studio to develop!


To understand how Netduino works we are going to build a traffic lights. I suggest that first you install the .NET Micro Framework on your PC from the following link:

For this project we need:

  • Netduino 2 (duh…)
  • Wires
  • Breadboard
  • 3 * 47 Ω (resistors)
  • 1 Red LED
  • 1 Green LED
  • 1 Amber LED

One bought the wires, breadboard, resistors and the LEDs from: The Netduino 2 from:

Ok let’s start…

A solderless breadboard is a construction base for prototyping of electronics and it does not require soldering thus making it reusable.  The following video explains better how breadboards work and how to attach resistors and LEDs:

Now that you have a better understanding of how to use a breadboard, we can start building our traffic lights. Finally!

Wire the external LEDs and the resistors as shown in the pictures below:

netduinoTrafficLightsPhoto1 netduinoTrafficLightsSetup

In the code below you will notice that one has defined three Output Ports. One port is for our green LED and is set for digital Pin 0. The second port is our amber LED and  is set for digital Pin 1. The third port is our red LED and is set for digital Pin 3. One is also using the Interrupt Port which is the button on the Netduino. When the button is pressed, the traffic light will change it’s state like in the diagram below.


The Output port supports a method named ‘Write’ which accepts a Boolean value. When a ‘true’ value is passed our concerned LED will light up and vice versa. The ‘Thread.Sleep’ command is used to pause the traffic light from changing it’s state quickly.

Here is the final result: