def test_template(self):
xls = TempXLS()
title = u'\xc3\xb6\xc3\xa4$' * 10
directory = self.add_directory()
directory.title = title
directory.cat1 = u'One'
directory.cat2 = u'Two'
directory.cat3 = u'Three'
directory.cat4 = u'Four'
self.add_item(directory)
export_xls(directory, xls.file, 'de', True)
wb = xls.load()
ws = wb.sheet_by_index(0)
self.assertEqual(ws.nrows, 1)
self.assertTrue(ws.name in title)
self.assertEqual(ws.cell(0, 2).value, u'One')
self.assertEqual(ws.cell(0, 3).value, u'Two')
self.assertEqual(ws.cell(0, 4).value, u'Three')
self.assertEqual(ws.cell(0, 5).value, u'Four')
def test_template(self):
xls = TempXLS()
title = u'\xc3\xb6\xc3\xa4$' * 10
directory = self.add_directory()
directory.title = title
directory.cat1 = u'One'
directory.cat2 = u'Two'
directory.cat3 = u'Three'
directory.cat4 = u'Four'
self.add_item(directory)
export_xls(directory, xls.file, 'de', True)
wb = xls.load()
ws = wb.sheet_by_index(0)
self.assertEqual(ws.nrows, 1)
self.assertTrue(ws.name in title)
self.assertEqual(ws.cell(0, 2).value, u'One')
self.assertEqual(ws.cell(0, 3).value, u'Two')
self.assertEqual(ws.cell(0, 4).value, u'Three')
self.assertEqual(ws.cell(0, 5).value, u'Four')
def test_export(self):
xls = TempXLS()
directory = self.add_directory()
directory.title = u'test'
directory.cat1 = u'Testkategorie 1'
directory.cat2 = u'Testkategorie 2'
item = self.add_item(directory, 'item1')
item.title = u'item1'
item.description = u'description1'
item.cat1 = [u'Eins']
item.cat2 = [u'Zwei']
item = self.add_item(directory, 'item2')
item.cat1 = [u'One']
item.cat2 = [u'Two']
export_xls(directory, xls.file, 'de', False)
wb = xls.load()
ws = wb.sheet_by_index(0)
self.assertEqual(ws.nrows, 3)
self.assertEqual(ws.cell(1, 0).value, u'item1')
self.assertEqual(ws.cell(1, 1).value, u'description1')
self.assertEqual(ws.cell(1, 2).value, u'Eins')
self.assertEqual(ws.cell(1, 3).value, u'Zwei')
self.assertEqual(ws.cell(2, 0).value, u'')
self.assertEqual(ws.cell(2, 1).value, u'')
self.assertEqual(ws.cell(2, 2).value, u'One')
self.assertEqual(ws.cell(2, 3).value, u'Two')
def export(self, request):
fields = [
('title', _(u'Name')),
('address', _(u'Address')),
('zipcode', _(u'Zipcode')),
('location', _(u'Location')),
('email', _(u'Email')),
('cat1', _(u'Type')),
('cat2', _(u'Location (Daycare Center)')),
('correspondence_first_name', _(u'Correspondence first name')),
('correspondence_last_name', _(u'Correspondence last name')),
('correspondence_address', _(u'Correspondence address')),
('correspondence_zipcode', _(u'Correspondence zipcode')),
('correspondence_town', _(u'Correspondence town')),
]
fieldmap = FieldMap()
fieldmap.root = True
fieldmap.keyfields = ('title',)
fieldmap.typename = 'seantis.dir.facility.item'
fieldmap.add_fields(f[0] for f in fields)
for field, title in fields:
fieldmap.add_title(field, title)
add_category_binds(fieldmap)
xlsfile = StringIO()
export_xls(
directory=self.context,
filehandle=xlsfile,
language=get_current_language(self.context, request),
as_template=False,
fieldmap=fieldmap
)
return xls_response(request, 'kitas_export_versand.xls', xlsfile)
def export(self, request):
fields = [
('title', _(u'Name')),
('affix', _(u'Name affix')),
('notes', _(u'Description')),
('spots', _(u'Total number of places')),
('address', _(u'Address')),
('zipcode', _(u'Zipcode')),
('location', _(u'Location')),
('phone', _(u'Phone')),
('email', _(u'Email')),
('url', _(u'Homepage')),
('fax', _(u'Fax')),
('cat1', _(u'Type')),
('cat2', _(u'Location (Daycare Center)')),
('age', _(u'Age')),
('cat4', _(u'Language')),
('cat3', _(u'Subsidized')),
('holidays', _(u'Holidays')),
('opening_hours', _(u'Opening Hours')),
('contact_first_name', _(u'Contact first name')),
('contact_last_name', _(u'Contact last name')),
('contact_phone', _(u'Contact phone')),
('contact_email', _(u'Contact email')),
('correspondence_first_name', _(u'Correspondence first name')),
('correspondence_last_name', _(u'Correspondence last name')),
('correspondence_address', _(u'Correspondence address')),
('correspondence_zipcode', _(u'Correspondence zipcode')),
('correspondence_town', _(u'Correspondence town')),
('latitude', _(u'Latitude')),
('longitude', _(u'Longitude'))
]
fieldmap = FieldMap()
fieldmap.root = True
fieldmap.keyfields = ('title',)
fieldmap.typename = 'seantis.dir.facility.item'
fieldmap.add_fields(f[0] for f in fields)
for field, title in fields:
fieldmap.add_title(field, title)
add_category_binds(fieldmap)
to_str = lambda o: str(o) if o is not None else ''
fieldmap.bind_wrapper('spots', to_str)
fieldmap.bind_wrapper('latitude', to_str)
fieldmap.bind_wrapper('longitude', to_str)
fieldmap.bind_wrapper('notes', extract_text_from_html)
xlsfile = StringIO()
export_xls(
directory=self.context,
filehandle=xlsfile,
language=get_current_language(self.context, request),
as_template=False,
fieldmap=fieldmap
)
return xls_response(request, 'kitas_export.xls', xlsfile)
