Reading CSV file and passing data to Jinja template in Python

Question

I'm trying to build out a configuration file using jinja2. I have a bunch of data in a csv that I want to use for the jinja2 template.

I can open and read the csv file but just not sure how to get jinja2 to read the data from the CSV and add it into the variables of the template. This is the start of my config:

import jinja2
import csv

with open('dhcpd.csv', 'rb') as csvfile:
    build = csv.reader(csvfile)

env =   jinja2.Environment(loader=jinja2.FileSystemLoader('/templates'))
template = env.get_template('dhcpd-build')

I know i'm a fair way off, but any help would be great

score 1 · Answer 1 · edited May 23 '17 at 10:32

1

The process here is

You load data in Python code - as you are already doing - Python import csv to list
You pass the data to Jinja 2 template in its render() method. http://jinja.pocoo.org/docs/dev/api/#jinja2.Template.render

Example:

data = list(data)
result = template.render(data=data)

Then you can iterate data in the template:

{% for row in data %}
    {{ row }}
{% endfor %}

Code not tested in the real life, I wrote out of my head.

edited May 23 '17 at 10:32

Community

1
1

answered Aug 03 '15 at 22:14

Mikko Ohtamaa

82,057
50
264
435

Thanks for the input, i've got a little closer now, but the variables from my csv file are not making it into the template. – McJim Aug 04 '15 at 13:27
1

Please edit the question and add output, your template and possible error messages. Do not add answers, you should be able to edit the questions. – Mikko Ohtamaa Aug 05 '15 at 15:33

score 0 · Answer 2 · answered Aug 04 '15 at 13:30

Code now looks like

import jinja2
import csv

with open('dhcpd.csv', 'rb') as infile:
  reader = csv.reader(infile)
  build = list(reader)


env = jinja2.Environment(loader=jinja2.FileSystemLoader('/Users/Luca/Git/ztp/templates'))
template = env.get_template('dhcpd-build')
for data in build:
  print template.render(data=build)

It renders the template but does not have any of the variables from my csv file

Reading CSV file and passing data to Jinja template in Python

2 Answers2