follow

#12 CSV exporter (implementation attached)

Reported anonymously 2009-09-08

I hacked together a CSV exporter, thought you might find it useful. I made it for version 0.4.11-3.1ubuntu2.

Attachments

Comments and changes

1. #1 Anonymous

   written 2009-09-08

   Ok, I cannot find the attach button...

   # Gergely Nagy <greg@gnome.hu>
   #
   import base
   from revelation import data, entry
   
   import time
   import csv
   from cStringIO import StringIO
   
   
   class CSV(base.DataHandler):
   	"Data handler for CSV files"
   
   	name		= "Comma Separated Values (CSV)"
   	importer	= False
   	exporter	= True
   	encryption	= False
   
   
   	def export_data(self, entrystore, password = None):
   		"Exports data to a CSV file"
   
   		# fetch and sort entries
   		entries = []
   		iter = entrystore.iter_nth_child(None, 0)
   
   		while iter is not None:
   			e = entrystore.get_entry(iter)
   
   			if type(e) != entry.FolderEntry:
   				entries.append(e)
   
   			iter = entrystore.iter_traverse_next(iter)
   
   		entries.sort(lambda x,y: cmp(x.name.lower(), y.name.lower()))
   
   		
   		stringwriter = StringIO()
   		csvwriter = csv.writer(stringwriter, dialect="excel")
   
   		keys = set()
   		for e in entries:
   			for f in e.fields:
   				keys.add(f.name)
   
   		# 'Email', 'Hostname', 'Password', 'URL', 'Username'
   		keys = sorted(keys)
   
   		csvwriter.writerow(['Name', 'Type', 'Description', 'Updated'] + keys)
   
   		for e in entries:
   
   			values = []
   			for key in keys:
   				value = ''
   				for field in e.fields:
   					if key == field.name:
   						value = field.value
   				values.append(value)
   
   			updated = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(e.updated))
   			csvwriter.writerow([e.name, e.typename, e.description, updated] + values)
   
   
   		return stringwriter.getvalue()
   
   
   
2. #2 Anonymous

   written 2009-10-07

   This is a good enhancement. Any chance this could be added to a new release?
3. #3 Anonymous

   written 2009-10-07

   Bump!
4. #4 Mikel Olasagasti Uranga

   written 2012-01-14

   • Changed status from new to resolved.

   Applied on master, will be on next release. Thanks Gergely!

Verification: Please write the text from the image in the box (letters only)

Is that you, Humanoid? Is this me?

• Cancel