def importVCardFile(self, vcardfilename, currentSheet):
self.componentDict = {}
self.componentList = []
writer = KCells.writer()
if not writer.setSheet(currentSheet):
raise 'Invalid sheet "%s" defined.' % currentSheet
writer.next() # hack
writer.next() # hack
f = open(vcardfilename, "r")
lines = []
for line in f:
if not line.strip() == "":
lines.append(line)
continue
if len(lines) > 0:
self.importVCardLines(writer, lines)
lines = []
if len(lines) > 0:
self.importVCardLines(writer, lines)
if writer.setSheet(currentSheet):
writer.next() # hack
writer.setValues(self.componentList)
def doImport(self):
currentSheet = self.sheetslistview.sheet()
if not currentSheet:
raise "No current sheet."
writer = KCells.writer()
if not writer.setSheet(currentSheet):
raise "Invalid sheet \"%s\" defined." % currentSheet
cell = self.sheetslistview.editor()
if not writer.setCell(cell):
raise "Invalid cell \"%s\" defined." % cell
csvfilename = self.openwidget.selectedFile()
if not os.path.isfile(csvfilename):
raise "File '%s' not found." % csvfilename
#writer.connect("valueChanged()",writer.next)
csv.register_dialect("custom", self.getCustomDialect())
csvfile = open(csvfilename,'r')
try:
csvreader = csv.reader(csvfile, dialect="custom")
try:
while True:
record = csvreader.next()
if not writer.setValues(record):
print "Failed to set all of '%s' to cell '%s'" % (record,writer.cell())
#writer.insertValues(record)
writer.next()
except StopIteration:
pass
finally:
csvfile.close()
def importVCardFile(self, vcardfilename, currentSheet):
self.componentDict = {}
self.componentList = []
writer = KCells.writer()
if not writer.setSheet(currentSheet):
raise "Invalid sheet \"%s\" defined." % currentSheet
writer.next() #hack
writer.next() #hack
f = open(vcardfilename, 'r')
lines = []
for line in f:
if not line.strip() == "":
lines.append(line)
continue
if len(lines) > 0:
self.importVCardLines(writer, lines)
lines = []
if len(lines) > 0:
self.importVCardLines(writer, lines)
if writer.setSheet(currentSheet):
writer.next() #hack
writer.setValues(self.componentList)
def start(self):
writer = KCells.writer()
connection = self.showImportDialog(writer)
if not connection:
return
try:
print "databaseNames = %s" % connection.databaseNames()
print "tableNames = %s" % connection.tableNames()
print "queryNames = %s" % connection.queryNames()
queryschema = self.showTableDialog(connection)
if not queryschema:
return
print "queryschema.name() = %s" % queryschema.name()
print "queryschema.caption() = %s" % queryschema.caption()
print "queryschema.description() = %s" % queryschema.description()
cursor = connection.executeQuerySchema(queryschema)
if not cursor:
raise "Failed to create cursor."
if not cursor.moveFirst():
raise "The cursor has no records to read from."
while not cursor.eof():
record = []
for i in range( cursor.fieldCount() ):
record.append( cursor.value(i) )
if writer.setValues(record):
writer.next()
else:
print "Failed to set all of '%s' to cell '%s'" % (record,writer.cell())
cursor.moveNext()
finally:
connection.disconnect()
def doImport(self):
currentSheet = self.sheetslistview.sheet()
if not currentSheet:
raise "No current sheet."
writer = KCells.writer()
if not writer.setSheet(currentSheet):
raise "Invalid sheet \"%s\" defined." % currentSheet
cell = self.sheetslistview.editor()
if not writer.setCell(cell):
raise "Invalid cell \"%s\" defined." % cell
csvfilename = self.openwidget.selectedFile()
if not os.path.isfile(csvfilename):
raise "File '%s' not found." % csvfilename
#writer.connect("valueChanged()",writer.next)
csv.register_dialect("custom", self.getCustomDialect())
csvfile = open(csvfilename, 'r')
try:
csvreader = csv.reader(csvfile, dialect="custom")
try:
while True:
record = csvreader.next()
if not writer.setValues(record):
print "Failed to set all of '%s' to cell '%s'" % (
record, writer.cell())
#writer.insertValues(record)
writer.next()
except StopIteration:
pass
finally:
csvfile.close()
