def __init__(self, scriptaction): self.scriptaction = scriptaction self.currentpath = self.scriptaction.currentPath() self.forms = Kross.module("forms") self.dialog = self.forms.createDialog(T.i18n("CSV Export")) self.dialog.setButtons("Ok|Cancel") self.dialog.setFaceType("List") #Auto Plain List Tree Tabbed savepage = self.dialog.addPage(T.i18nc("Options page name", "Save"),T.i18n("Export to CSV File"),"document-save") self.savewidget = self.forms.createFileWidget(savepage, "kfiledialog:///kspreadcsvexportsave") self.savewidget.setMode("Saving") self.savewidget.setFilter("*.csv *.txt|%(1)s\n*|%(2)s" % { '1' : T.i18n("Comma-Separated-Value Files"), '2' : T.i18n("All Files") } ) datapage = self.dialog.addPage(T.i18nc("Options page name", "Export"),T.i18n("Export Sheets and ranges"),"document-export") self.sheetslistview = KSpread.createSheetsListView(datapage) self.sheetslistview.setSelectionType("MultiSelect") self.sheetslistview.setEditorType("Range") optionspage = self.dialog.addPage(T.i18n("Options"),T.i18n("Comma Separated Value Options"),"configure") self.optionswidget = self.forms.createWidgetFromUIFile(optionspage, os.path.join(self.currentpath, "csvoptions.ui")) if self.dialog.exec_loop(): try: self.doExport() except: self.forms.showMessageBox("Error", T.i18n("Error"), "%s" % "".join( traceback.format_exception(sys.exc_info()[0],sys.exc_info()[1],sys.exc_info()[2]) ))
def __init__(self, action, config): self.action = action self.config = config forms = Kross.module("forms") dialog = forms.createDialog(T.i18n("Import vCard")) #dialog.minimumWidth = 400 #dialog.minimumHeight = 300 dialog.setButtons("Ok|Cancel") dialog.setFaceType("List") #Auto Plain List Tree Tabbed filepage = dialog.addPage(T.i18n("Open"), T.i18n("vCard File"), "document-open") #deffile = "/home/kde4/vcardtest/addressbook.vcf" #"kfiledialog:///kspreadvcardimport" deffile = "kfiledialog:///kspreadvcardimport" self.openwidget = forms.createFileWidget(filepage, deffile) self.openwidget.setMode("Opening") self.openwidget.setFilter("*.vcf|%(1)s\n*|%(2)s" % { '1' : T.i18n("vCard Files"), '2' : T.i18n("All Files") } ) datapage = dialog.addPage(T.i18n("Import"),T.i18n("Import to sheet beginning at cell"),"document-import") self.sheetslistview = KSpread.createSheetsListView(datapage) self.sheetslistview.setEditorType("Cell") if not dialog.exec_loop(): return vcardfilename = self.openwidget.selectedFile() if not os.path.isfile(vcardfilename): raise Exception, T.i18n("File '%1' not found.", [vcardfilename]) currentSheet = self.sheetslistview.sheet() if not currentSheet: raise Exception, T.i18n("No current sheet.") self.importVCardFile(vcardfilename, currentSheet)
def showExportDialog(self, reader): dialog = self.forms.createDialog(T.i18n("Kexi Export")) dialog.setButtons("Ok|Cancel") dialog.setFaceType("List") #Auto Plain List Tree Tabbed savepage = dialog.addPage(T.i18nc("Options page name", "Save"), T.i18n("Export to Kexi Project File"), "document-save") savewidget = self.forms.createFileWidget( savepage, "kfiledialog:///kspreadkexidbexport") savewidget.setMode("Saving") savewidget.setFilter("*.kexi *.kexis *kexic|%(1)s\n*|%(2)s" % { '1': T.i18n("Kexi Project Files"), '2': T.i18n("All Files") }) datapage = dialog.addPage(T.i18nc("Options page name", "Export"), T.i18n("Export sheets and ranges"), "document-export") sheetslistview = KSpread.createSheetsListView(datapage) sheetslistview.setSelectionType("MultiSelect") sheetslistview.setEditorType("Range") if dialog.exec_loop(): projectfile = savewidget.selectedFile() if not os.path.isfile(projectfile): raise Exception, T.i18n("File '%1' not found.", [projectfile]) reader.setSheets(sheetslistview.sheets()) connection = self.createConnection(projectfile) return connection return None
def showDataSelectionDialog(self, writer, Plan ): tabledialog = self.forms.createDialog("Property List") tabledialog.setButtons("Ok|Cancel") tabledialog.setFaceType("List") #Auto Plain List Tree Tabbed datapage = tabledialog.addPage(T.i18n("Destination"),T.i18n("Import to sheet beginning at cell")) sheetslistview = KSpread.createSheetsListView(datapage) sheetslistview.setEditorType("Cell") schedulepage = tabledialog.addPage(T.i18n("Schedules"),T.i18n("Select schedule")) schedulewidget = Plan.createScheduleListView(schedulepage) sourcepage = tabledialog.addPage(T.i18n("Data"),T.i18n("Select data")) sourcewidget = Plan.createDataQueryView(sourcepage) if tabledialog.exec_loop(): currentSheet = sheetslistview.sheet() if not currentSheet: raise Exception, T.i18n("No current sheet.") if not writer.setSheet(currentSheet): raise Exception, T.i18n("Invalid sheet '%1' defined.", [currentSheet]) cell = sheetslistview.editor() if not writer.setCell(cell): raise Exception, T.i18n("Invalid cell '%1' defined.", [cell]) schedule = schedulewidget.currentSchedule() #print "schedule: ", schedule props = sourcewidget.selectedProperties() #print "props: ", props ot = sourcewidget.objectType() #print "objectType: ", ot return [ot, schedule, props, sourcewidget.includeHeaders() ] return None
def showDataSelectionDialog(self, writer, KPlato ): tabledialog = self.forms.createDialog("Property List") tabledialog.setButtons("Ok|Cancel") tabledialog.setFaceType("List") #Auto Plain List Tree Tabbed datapage = tabledialog.addPage(i18n("Destination"),i18n("Import to sheet beginning at cell")) sheetslistview = KSpread.createSheetsListView(datapage) sheetslistview.setEditorType("Cell") schedulepage = tabledialog.addPage(i18n("Schedules"),i18n("Select schedule")) schedulewidget = KPlato.createScheduleListView(schedulepage) sourcepage = tabledialog.addPage(i18n("Data"),i18n("Select data")) sourcewidget = KPlato.createDataQueryView(sourcepage) if tabledialog.exec_loop(): currentSheet = sheetslistview.sheet() if not currentSheet: raise Exception, i18n("No current sheet.") if not writer.setSheet(currentSheet): raise Exception, i18n("Invalid sheet '%1' defined.", [currentSheet]) cell = sheetslistview.editor() if not writer.setCell(cell): raise Exception, i18n("Invalid cell '%1' defined.", [cell]) schedule = schedulewidget.currentSchedule() #print "schedule: ", schedule props = sourcewidget.selectedProperties() #print "props: ", props ot = sourcewidget.objectType() #print "objectType: ", ot return [ot, schedule, props, sourcewidget.includeHeaders() ] return None
def showImportDialog(self, writer): dialog = self.forms.createDialog(T.i18n("Kexi Import")) dialog.setButtons("Ok|Cancel") dialog.setFaceType("List") #Auto Plain List Tree Tabbed openpage = dialog.addPage(T.i18n("Open"),T.i18n("Import from Kexi Project File"),"document-open") openwidget = self.forms.createFileWidget(openpage, "kfiledialog:///kspreadkexidbimportopen") openwidget.setMode("Opening") openwidget.setFilter("*.kexi *.kexis *kexic|%(1)s\n*|%(2)s" % { '1' : T.i18n("Kexi Project Files"), '2' : T.i18n("All Files") } ) datapage = dialog.addPage(T.i18n("Import"),T.i18n("Import to sheet beginning at cell"),"document-import") sheetslistview = KSpread.createSheetsListView(datapage) sheetslistview.setEditorType("Cell") if dialog.exec_loop(): projectfile = openwidget.selectedFile() if not os.path.isfile(projectfile): raise Exception, T.i18n("File '%1' not found.", [projectfile]) currentSheet = sheetslistview.sheet() if not currentSheet: raise Exception, T.i18n("No current sheet.") if not writer.setSheet(currentSheet): raise Exception, T.i18n("Invalid sheet \"%1\" defined." [currentSheet]) cell = sheetslistview.editor() if not writer.setCell(cell): raise Exception, T.i18n("Invalid cell \"%1\" defined.", [cell]) connection = self.createConnection(projectfile) return connection return None
def __init__(self, scriptaction): self.scriptaction = scriptaction self.currentpath = self.scriptaction.currentPath() self.forms = Kross.module("forms") self.dialog = self.forms.createDialog(T.i18n("CSV Import")) self.dialog.setButtons("Ok|Cancel") self.dialog.setFaceType("List") # Auto Plain List Tree Tabbed openpage = self.dialog.addPage(T.i18n("Open"), T.i18n("Import from CSV File"), "document-open") self.openwidget = self.forms.createFileWidget(openpage, "kfiledialog:///kspreadcsvimportopen") self.openwidget.setMode("Opening") self.openwidget.setFilter( "*.csv *.txt|%(1)s\n*|%(2)s" % {"1": T.i18n("Comma-Separated-Value Files"), "2": T.i18n("All Files")} ) datapage = self.dialog.addPage(T.i18n("Import"), T.i18n("Import to sheet beginning at cell"), "document-import") self.sheetslistview = KSpread.createSheetsListView(datapage) self.sheetslistview.setEditorType("Cell") optionspage = self.dialog.addPage(T.i18n("Options"), T.i18n("Comma Separated Value Options"), "configure") self.optionswidget = self.forms.createWidgetFromUIFile( optionspage, os.path.join(self.currentpath, "csvoptions.ui") ) if self.dialog.exec_loop(): try: self.doImport() except: self.forms.showMessageBox( "Error", T.i18n("Error"), "%s" % "".join(traceback.format_exception(sys.exc_info()[0], sys.exc_info()[1], sys.exc_info()[2])), )
def showImportDialog(self, writer): dialog = self.forms.createDialog(T.i18n("Kexi Import")) dialog.setButtons("Ok|Cancel") dialog.setFaceType("List") #Auto Plain List Tree Tabbed openpage = dialog.addPage(T.i18n("Open"), T.i18n("Import from Kexi Project File"), "document-open") openwidget = self.forms.createFileWidget( openpage, "kfiledialog:///kspreadkexidbimportopen") openwidget.setMode("Opening") openwidget.setFilter("*.kexi *.kexis *kexic|%(1)s\n*|%(2)s" % { '1': T.i18n("Kexi Project Files"), '2': T.i18n("All Files") }) datapage = dialog.addPage(T.i18n("Import"), T.i18n("Import to sheet beginning at cell"), "document-import") sheetslistview = KSpread.createSheetsListView(datapage) sheetslistview.setEditorType("Cell") if dialog.exec_loop(): projectfile = openwidget.selectedFile() if not os.path.isfile(projectfile): raise Exception, T.i18n("File '%1' not found.", [projectfile]) currentSheet = sheetslistview.sheet() if not currentSheet: raise Exception, T.i18n("No current sheet.") if not writer.setSheet(currentSheet): raise Exception, T.i18n( "Invalid sheet \"%1\" defined."[currentSheet]) cell = sheetslistview.editor() if not writer.setCell(cell): raise Exception, T.i18n("Invalid cell \"%1\" defined.", [cell]) connection = self.createConnection(projectfile) return connection return None
def __init__(self, action, config): self.action = action self.config = config forms = Kross.module("forms") dialog = forms.createDialog(T.i18n("Import vCard")) #dialog.minimumWidth = 400 #dialog.minimumHeight = 300 dialog.setButtons("Ok|Cancel") dialog.setFaceType("List") #Auto Plain List Tree Tabbed filepage = dialog.addPage(T.i18n("Open"), T.i18n("vCard File"), "document-open") #deffile = "/home/kde4/vcardtest/addressbook.vcf" #"kfiledialog:///kspreadvcardimport" deffile = "kfiledialog:///kspreadvcardimport" self.openwidget = forms.createFileWidget(filepage, deffile) self.openwidget.setMode("Opening") self.openwidget.setFilter("*.vcf|%(1)s\n*|%(2)s" % { '1': T.i18n("vCard Files"), '2': T.i18n("All Files") }) datapage = dialog.addPage(T.i18n("Import"), T.i18n("Import to sheet beginning at cell"), "document-import") self.sheetslistview = KSpread.createSheetsListView(datapage) self.sheetslistview.setEditorType("Cell") if not dialog.exec_loop(): return vcardfilename = self.openwidget.selectedFile() if not os.path.isfile(vcardfilename): raise Exception, T.i18n("File '%1' not found.", [vcardfilename]) currentSheet = self.sheetslistview.sheet() if not currentSheet: raise Exception, T.i18n("No current sheet.") self.importVCardFile(vcardfilename, currentSheet)
def showExportDialog(self, reader): dialog = self.forms.createDialog(T.i18n("Kexi Export")) dialog.setButtons("Ok|Cancel") dialog.setFaceType("List") #Auto Plain List Tree Tabbed savepage = dialog.addPage(T.i18nc("Options page name", "Save"), T.i18n("Export to Kexi Project File"),"document-save") savewidget = self.forms.createFileWidget(savepage, "kfiledialog:///kspreadkexidbexport") savewidget.setMode("Saving") savewidget.setFilter("*.kexi *.kexis *kexic|%(1)s\n*|%(2)s" % { '1' : T.i18n("Kexi Project Files"), '2' : T.i18n("All Files") } ) datapage = dialog.addPage(T.i18nc("Options page name", "Export"), T.i18n("Export sheets and ranges"),"document-export") sheetslistview = KSpread.createSheetsListView(datapage) sheetslistview.setSelectionType("MultiSelect") sheetslistview.setEditorType("Range") if dialog.exec_loop(): projectfile = savewidget.selectedFile() if not os.path.isfile(projectfile): raise Exception, T.i18n("File '%1' not found.", [projectfile]) reader.setSheets( sheetslistview.sheets() ) connection = self.createConnection(projectfile) return connection return None