1
/* This file is part of the KDE project
2
Copyright (C) 2005-2012 Jarosław Staniek <staniek@kde.org>
4
This program is free software; you can redistribute it and/or
5
modify it under the terms of the GNU Library General Public
6
License as published by the Free Software Foundation; either
7
version 2 of the License, or (at your option) any later version.
9
This program is distributed in the hope that it will be useful,
10
but WITHOUT ANY WARRANTY; without even the implied warranty of
11
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
12
Library General Public License for more details.
14
You should have received a copy of the GNU Library General Public License
15
along with this program; see the file COPYING. If not, write to
16
the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
17
* Boston, MA 02110-1301, USA.
20
#include "kexicsvimportoptionsdlg.h"
21
#include <widget/kexicharencodingcombobox.h>
22
#include <kexiutils/utils.h>
25
#include <KSharedConfig>
26
#include <KConfigGroup>
27
#include <KLocalizedString>
32
#include <QGridLayout>
33
#include <QDialogButtonBox>
34
#include <QPushButton>
35
#include <QVBoxLayout>
38
KexiCSVImportOptions::DateFormat dateFormatFromString(const QString& s)
40
QString str(s.toLower().trimmed());
42
return KexiCSVImportOptions::DMY;
44
return KexiCSVImportOptions::YMD;
46
return KexiCSVImportOptions::MDY;
47
return KexiCSVImportOptions::AutoDateFormat;
50
QString dateFormatToString(KexiCSVImportOptions::DateFormat format)
53
case KexiCSVImportOptions::DMY: return "DMY";
54
case KexiCSVImportOptions::YMD: return "YMD";
55
case KexiCSVImportOptions::MDY: return "MDY";
61
KexiCSVImportOptions::KexiCSVImportOptions()
63
KConfigGroup importExportGroup(KSharedConfig::openConfig()->group("ImportExport"));
64
encoding = importExportGroup.readEntry("DefaultEncodingForImportingCSVFiles");
65
if (encoding.isEmpty()) {
66
encoding = QString::fromLatin1(KexiUtils::encoding());
67
defaultEncodingExplicitySet = false;
69
defaultEncodingExplicitySet = true;
71
dateFormat = dateFormatFromString(importExportGroup.readEntry("DateFormatWhenImportingCSVFiles"));
73
trimmedInTextValuesChecked
74
= importExportGroup.readEntry("StripBlanksOffOfTextValuesWhenImportingCSVFiles", true);
75
nullsImportedAsEmptyTextChecked = importExportGroup.readEntry("ImportNULLsAsEmptyText", true);
78
KexiCSVImportOptions::~KexiCSVImportOptions()
82
bool KexiCSVImportOptions::operator== (const KexiCSVImportOptions & opt) const
84
return defaultEncodingExplicitySet == opt.defaultEncodingExplicitySet
85
&& trimmedInTextValuesChecked == opt.trimmedInTextValuesChecked
86
&& encoding == opt.encoding
87
&& dateFormat == opt.dateFormat
88
&& nullsImportedAsEmptyTextChecked == opt.nullsImportedAsEmptyTextChecked;
91
bool KexiCSVImportOptions::operator!= (const KexiCSVImportOptions & opt) const
93
return !(*this == opt);
96
//----------------------------------
98
KexiCSVImportOptionsDialog::KexiCSVImportOptionsDialog(
99
const KexiCSVImportOptions& options, QWidget* parent)
102
setObjectName("KexiCSVImportOptionsDialog");
103
setWindowTitle(xi18nc("@title:window", "CSV Import Options"));
106
QVBoxLayout *mainLayout = new QVBoxLayout;
107
setLayout(mainLayout);
108
QGridLayout *lyr = new QGridLayout;
109
mainLayout->addLayout(lyr);
111
QGroupBox* textEncodingGroupBox = new QGroupBox(xi18n("Text encoding"), this);
112
lyr->addWidget(textEncodingGroupBox, 0, 0, 1, 2);
113
QVBoxLayout* textEncodingGroupBoxLyr = new QVBoxLayout;
114
KexiUtils::setStandardMarginsAndSpacing(textEncodingGroupBoxLyr);
115
textEncodingGroupBox->setLayout(textEncodingGroupBoxLyr);
117
textEncodingGroupBoxLyr->addItem(new QSpacerItem(20, 15, QSizePolicy::Fixed, QSizePolicy::Fixed));
119
m_encodingComboBox = new KexiCharacterEncodingComboBox(textEncodingGroupBox, options.encoding);
120
textEncodingGroupBoxLyr->addWidget(m_encodingComboBox);
122
lyr->addItem(new QSpacerItem(20, KexiUtils::spacingHint(), QSizePolicy::Expanding, QSizePolicy::Minimum), 0, 2);
124
m_chkAlwaysUseThisEncoding = new QCheckBox(
125
xi18n("Always use this encoding when importing CSV data files"), textEncodingGroupBox);
126
textEncodingGroupBoxLyr->addWidget(m_chkAlwaysUseThisEncoding);
128
m_comboDateFormat = new QComboBox(this);
129
m_comboDateFormat->setObjectName("m_comboDateFormat");
130
m_comboDateFormat->addItem(xi18nc("Date format: Auto", "Auto"));
131
QString year(xi18n("year")), month(xi18n("month")), day(xi18n("day"));
132
KLocalizedString mask = kxi18nc("do not reorder placeholders, just translate e.g. and - to the "
133
"separator used by dates in your language",
134
"%1, %2, %3 (e.g. %4-%5-%6)");
135
m_comboDateFormat->addItem(
136
mask.subs(day).subs(month).subs(year).subs(30).subs(12).subs(2008).toString());
137
m_comboDateFormat->addItem(
138
mask.subs(year).subs(month).subs(day).subs(2008).subs(12).subs(30).toString());
139
m_comboDateFormat->addItem(
140
mask.subs(month).subs(day).subs(year).subs(12).subs(30).subs(2008).toString());
141
lyr->addWidget(m_comboDateFormat, 1, 1);
143
QLabel* lblDateFormat = new QLabel(xi18n("Date format:"), this);
144
lblDateFormat->setBuddy(m_comboDateFormat);
145
lyr->addWidget(lblDateFormat, 1, 0);
147
m_chkStripWhiteSpaceInTextValues = new QCheckBox(
148
xi18n("Strip leading and trailing blanks off of text values"), this);
149
lyr->addWidget(m_chkStripWhiteSpaceInTextValues, 2, 0, 1, 2);
151
m_chkImportNULLsAsEmptyText = new QCheckBox(
152
xi18n("Import missing text values as empty texts"), this);
153
lyr->addWidget(m_chkImportNULLsAsEmptyText, 3, 0, 1, 2);
154
lyr->addItem(new QSpacerItem(30, KexiUtils::spacingHint(), QSizePolicy::Minimum, QSizePolicy::Expanding), 4, 0);
156
m_encodingComboBox->setSelectedEncoding(options.encoding);
157
if (options.defaultEncodingExplicitySet) {
158
m_chkAlwaysUseThisEncoding->setChecked(true);
160
m_comboDateFormat->setCurrentIndex((int)options.dateFormat);
161
m_chkStripWhiteSpaceInTextValues->setChecked(options.trimmedInTextValuesChecked);
162
m_chkImportNULLsAsEmptyText->setChecked(options.nullsImportedAsEmptyTextChecked);
165
QDialogButtonBox *buttonBox = new QDialogButtonBox(QDialogButtonBox::Ok|QDialogButtonBox::Cancel);
166
QPushButton *okButton = buttonBox->button(QDialogButtonBox::Ok);
167
okButton->setDefault(true);
168
okButton->setShortcut(Qt::CTRL | Qt::Key_Return);
169
okButton->setDefault(true);
170
connect(buttonBox, SIGNAL(accepted()), this, SLOT(accept()));
171
connect(buttonBox, SIGNAL(rejected()), this, SLOT(reject()));
172
mainLayout->addWidget(buttonBox);
175
m_encodingComboBox->setFocus();
178
KexiCSVImportOptionsDialog::~KexiCSVImportOptionsDialog()
182
KexiCSVImportOptions KexiCSVImportOptionsDialog::options() const
184
KexiCSVImportOptions opt;
185
opt.encoding = m_encodingComboBox->selectedEncoding();
186
opt.trimmedInTextValuesChecked = m_chkStripWhiteSpaceInTextValues->isChecked();
187
opt.nullsImportedAsEmptyTextChecked = m_chkImportNULLsAsEmptyText->isChecked();
191
void KexiCSVImportOptionsDialog::accept()
193
KConfigGroup importExportGroup(KSharedConfig::openConfig()->group("ImportExport"));
194
if (m_chkAlwaysUseThisEncoding->isChecked())
195
importExportGroup.writeEntry("DefaultEncodingForImportingCSVFiles",
196
m_encodingComboBox->selectedEncoding());
198
importExportGroup.deleteEntry("DefaultEncodingForImportingCSVFiles");
200
const KexiCSVImportOptions::DateFormat dateFormat
201
= (KexiCSVImportOptions::DateFormat)m_comboDateFormat->currentIndex();
202
if (dateFormat == KexiCSVImportOptions::AutoDateFormat)
203
importExportGroup.deleteEntry("DateFormatWhenImportingCSVFiles");
205
importExportGroup.writeEntry("DateFormatWhenImportingCSVFiles", dateFormatToString(dateFormat));
207
importExportGroup.writeEntry("StripBlanksOffOfTextValuesWhenImportingCSVFiles",
208
m_chkStripWhiteSpaceInTextValues->isChecked());
209
importExportGroup.writeEntry("ImportNULLsAsEmptyText",
210
m_chkImportNULLsAsEmptyText->isChecked());