def test_user_import_from_excel_file(self):
setRoles(self.portal, TEST_USER_ID, ('Manager',))
# create a folder for covalent-members:
members = helpers.create_memberfolder(self.portal)
# extract members from file:
excel_file_path = helpers.absolute_dir("assets/covalent_batch.xls")
excel_file = open(excel_file_path, "r+b")
filedata = mmap.mmap(excel_file.fileno(), 0)
user_infos = member_import.extract_memberdata(filedata)
filedata.close()
excel_file.close()
# add covalent-members:
utilities.add_members(members, user_infos)
# inspect our covalent-members:
for properties in user_infos:
memberId = properties['id']
self.assertIn(memberId, members)
member = members[memberId]
self.assertEqual(member.title, properties['title'])
self.assertEqual(member.emailAddress, properties['emailAddress'])
def test_user_import_from_excel_file_acceptance(self):
driver = self.driver
# create a folder for covalent-members:
pat.setRoles(self.portal, pat.TEST_USER_ID, ('Manager',))
members = helpers.create_memberfolder(self.portal)
# log in as a manager:
login(driver, self.portal, username=testing.MANAGER,
password=testing.PASSWORD)
open(driver, members.absolute_url() + "/import")
fileUpload = driver.find_element_by_name("form.widgets.file")
filename = helpers.absolute_dir("assets/covalent_batch.xls")
fileUpload.send_keys(filename)
driver.find_element_by_id("form-buttons-save").click()
# TODO: assert
driver.find_element_by_name("confirm").click()