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
