csvimportdialog.cpp

Go to the documentation of this file.

/*
  This file is part of KAddressBook.
  Copyright (c) 2009 Tobias Koenig <tokoe@kde.org>

  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License along
  with this program; if not, write to the Free Software Foundation, Inc.,
  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*/

#include "csvimportdialog.h"

#include "dateparser.h"
#include "qcsvmodel.h"
#include "templateselectiondialog.h"

#include <KApplication>
#include <KComboBox>
#include <KDebug>
#include <KInputDialog>
#include <KLineEdit>
#include <KLocalizedString>
#include <KMessageBox>
#include <KProgressDialog>
#include <KStandardDirs>
#include <KUrlRequester>

#include <QtCore/QPointer>
#include <QtCore/QTextCodec>
#include <QtCore/QThread>
#include <QtCore/QUuid>
#include <QButtonGroup>
#include <QCheckBox>
#include <QGridLayout>
#include <QGroupBox>
#include <QHBoxLayout>
#include <QLabel>
#include <QPushButton>
#include <QRadioButton>
#include <QStyledItemDelegate>
#include <QTableView>
#include <QHeaderView>

enum {
    Local = 0,
    Latin1 = 1,
    Uni = 2,
    MSBug = 3,
    Codec = 4
};

class ContactFieldComboBox : public KComboBox
{
public:

    ContactFieldComboBox( QWidget *parent = 0 )
        : KComboBox( parent )
    {
        fillFieldMap();

        addItem( ContactFields::label( ContactFields::Undefined ), ContactFields::Undefined );

        QMapIterator<QString, ContactFields::Field> it( mFieldMap );
        while ( it.hasNext() ) {
            it.next();

            addItem( it.key(), QVariant( it.value() ) );
        }

        int maxLength = 0;
        for ( int i = 0; i < count(); ++i ) {
            maxLength = qMax( maxLength, itemText( i ).length() );
        }

        setMinimumContentsLength( maxLength );
        setSizeAdjustPolicy( AdjustToMinimumContentsLength );
        setFixedSize( sizeHint() );
    }

    void setCurrentField( ContactFields::Field field )
    {
        setCurrentIndex( findData( (uint)field ) );
    }

    ContactFields::Field currentField() const
    {
        return ( ContactFields::Field )itemData( currentIndex() ).toUInt();
    }

private:
    static void fillFieldMap()
    {
        if ( !mFieldMap.isEmpty() ) {
            return;
        }

        ContactFields::Fields fields = ContactFields::allFields();
        fields.remove( ContactFields::Undefined );

        for ( int i = 0; i < fields.count(); ++i ) {
            mFieldMap.insert( ContactFields::label( fields.at( i ) ), fields.at( i ) );
        }
    }

    static QMap<QString, ContactFields::Field> mFieldMap;
};

QMap<QString, ContactFields::Field> ContactFieldComboBox::mFieldMap;

class ContactFieldDelegate : public QStyledItemDelegate
{
public:
    ContactFieldDelegate( QObject *parent = 0 )
        : QStyledItemDelegate( parent )
    {
    }

    QString displayText( const QVariant &value, const QLocale & ) const
    {
        return ContactFields::label( ( ContactFields::Field )value.toUInt() );
    }

    QWidget *createEditor( QWidget *parent, const QStyleOptionViewItem &,
                           const QModelIndex & ) const
    {
        ContactFieldComboBox *editor = new ContactFieldComboBox( parent );

        return editor;
    }

    void setEditorData( QWidget *editor, const QModelIndex &index ) const
    {
        const unsigned int value = index.model()->data( index, Qt::EditRole ).toUInt();

        ContactFieldComboBox *fieldCombo = static_cast<ContactFieldComboBox*>( editor );
        fieldCombo->setCurrentField( ( ContactFields::Field )value );
    }

    void setModelData( QWidget *editor, QAbstractItemModel *model, const QModelIndex &index ) const
    {
        ContactFieldComboBox *fieldCombo = static_cast<ContactFieldComboBox*>( editor );

        model->setData( index, fieldCombo->currentField(), Qt::EditRole );
    }

    void updateEditorGeometry( QWidget *editor, const QStyleOptionViewItem &option,
                               const QModelIndex & ) const
    {
        editor->setGeometry( option.rect );
    }

    void paint( QPainter *painter, const QStyleOptionViewItem &option,
                const QModelIndex &index ) const
    {
        if ( index.row() == 0 ) {
            QStyleOptionViewItem headerOption( option );
            headerOption.font.setBold( true );

            QStyledItemDelegate::paint( painter, headerOption, index );
        } else {
            QStyledItemDelegate::paint( painter, option, index );
        }
    }
};

CSVImportDialog::CSVImportDialog( QWidget *parent )
    : KDialog( parent ), mDevice( 0 )
{
    setCaption( i18nc( "@title:window", "CSV Import Dialog" ) );
    setButtons( Ok | Cancel | User1 | User2 );
    setDefaultButton( Ok );
    setModal( true );
    showButtonSeparator( true );

    mModel = new QCsvModel( this );

    initGUI();

    reloadCodecs();

    connect( mUrlRequester, SIGNAL(returnPressed(QString)),
             this, SLOT(setFile(QString)) );
    connect( mUrlRequester, SIGNAL(urlSelected(KUrl)),
             this, SLOT(setFile(KUrl)) );
    connect( mUrlRequester->lineEdit(), SIGNAL(textChanged(QString)),
             this, SLOT(urlChanged(QString)) );
    connect( mDelimiterGroup, SIGNAL(buttonClicked(int)),
             this, SLOT(delimiterClicked(int)) );
    connect( mDelimiterEdit, SIGNAL(returnPressed()),
             this, SLOT(customDelimiterChanged()) );
    connect( mDelimiterEdit, SIGNAL(textChanged(QString)),
             this, SLOT(customDelimiterChanged(QString)) );
    connect( mComboQuote, SIGNAL(activated(QString)),
             this, SLOT(textQuoteChanged(QString)) );
    connect( mCodecCombo, SIGNAL(activated(QString)),
             this, SLOT(codecChanged()) );
    connect( mSkipFirstRow, SIGNAL(toggled(bool)),
             this, SLOT(skipFirstRowChanged(bool)) );

    connect( mModel, SIGNAL(finishedLoading()), this, SLOT(modelFinishedLoading()) );

    delimiterClicked( 0 );
    textQuoteChanged( QLatin1String("\"") );
    skipFirstRowChanged( false );
}

CSVImportDialog::~CSVImportDialog()
{
    delete mDevice;
}

KABC::AddresseeList CSVImportDialog::contacts() const
{
    KABC::AddresseeList contacts;
    DateParser dateParser( mDatePatternEdit->text() );

    KProgressDialog progressDialog( const_cast<CSVImportDialog*>( this )->mainWidget() );
    progressDialog.setAutoClose( true );
    progressDialog.progressBar()->setMaximum( mModel->rowCount() );
    progressDialog.setLabelText( i18nc( "@label", "Importing contacts" ) );
    progressDialog.show();

    kapp->processEvents();

    for ( int row = 1; row < mModel->rowCount(); ++row ) {
        KABC::Addressee contact;
        bool emptyRow = true;

        for ( int column = 0; column < mModel->columnCount(); ++column ) {
            QString value = mModel->data( mModel->index( row, column ), Qt::DisplayRole ).toString();

            if ( !value.isEmpty() ) {
                emptyRow = false;

                const ContactFields::Field field =
                        ( ContactFields::Field )mModel->data( mModel->index( 0, column ) ).toUInt();

                // convert the custom date format to ISO format
                if ( field == ContactFields::Birthday || field == ContactFields::Anniversary ) {
                    value = dateParser.parse( value ).toString( Qt::ISODate );
                }

                value.replace( QLatin1String("\\n"), QLatin1String("\n") );

                ContactFields::setValue( field, value, contact );
            }
        }

        kapp->processEvents();

        if ( progressDialog.wasCancelled() ) {
            return KABC::AddresseeList();
        }

        progressDialog.progressBar()->setValue( progressDialog.progressBar()->value() + 1 );

        if ( !emptyRow && !contact.isEmpty() ) {
            contacts.append( contact );
        }
    }

    return contacts;
}

void CSVImportDialog::initGUI()
{
    QWidget *page = new QWidget( this );
    setMainWidget( page );

    QGridLayout *layout = new QGridLayout( page );
    layout->setSpacing( spacingHint() );
    layout->setMargin( 0 );

    QHBoxLayout *hbox = new QHBoxLayout();
    hbox->setSpacing( spacingHint() );

    QLabel *label = new QLabel( i18nc( "@label", "File to import:" ), page );
    hbox->addWidget( label );

    mUrlRequester = new KUrlRequester( page );
    mUrlRequester->setFilter( QLatin1String("*.csv") );
    mUrlRequester->lineEdit()->setTrapReturnKey( true );
    mUrlRequester->setToolTip(
                i18nc( "@info:tooltip", "Select a csv file to import" ) );
    mUrlRequester->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Click this button to start a file chooser that will allow you to "
                       "select a csv file to import." ) );
    hbox->addWidget( mUrlRequester );

    layout->addLayout( hbox, 0, 0, 1, 5 );

    // Delimiter: comma, semicolon, tab, space, other
    QGroupBox *group = new QGroupBox( i18nc( "@title:group", "Delimiter" ), page );
    QGridLayout *delimiterLayout = new QGridLayout;
    delimiterLayout->setMargin( marginHint() );
    delimiterLayout->setSpacing( spacingHint() );
    group->setLayout( delimiterLayout );
    delimiterLayout->setAlignment( Qt::AlignTop );
    layout->addWidget( group, 1, 0, 4, 1 );

    mDelimiterGroup = new QButtonGroup( this );
    mDelimiterGroup->setExclusive( true );

    QRadioButton *button = new QRadioButton( i18nc( "@option:radio Field separator", "Comma" ) );
    button->setToolTip(
                i18nc( "@info:tooltip", "Set the field separator to a comma" ) );
    button->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Select this option if your csv file uses the comma as a field separator." ) );
    button->setChecked( true );
    mDelimiterGroup->addButton( button, 0 );
    delimiterLayout->addWidget( button, 0, 0 );

    button = new QRadioButton( i18nc( "@option:radio Field separator", "Semicolon" ) );
    button->setToolTip(
                i18nc( "@info:tooltip", "Set the field separator to a semicolon" ) );
    button->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Select this option if your csv file uses the semicolon as a field separator." ) );
    mDelimiterGroup->addButton( button, 1 );
    delimiterLayout->addWidget( button, 0, 1 );

    button = new QRadioButton( i18nc( "@option:radio Field separator", "Tabulator" ) );
    button->setToolTip(
                i18nc( "@info:tooltip", "Set the field separator to a tab character" ) );
    button->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Select this option if your csv file uses the tab character as a field separator." ) );
    mDelimiterGroup->addButton( button, 2 );
    delimiterLayout->addWidget( button, 1, 0 );

    button = new QRadioButton( i18nc( "@option:radio Field separator", "Space" ) );
    button->setToolTip(
                i18nc( "@info:tooltip", "Set the field separator to a space character" ) );
    button->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Select this option if your csv file uses the space character as a field separator." ) );
    mDelimiterGroup->addButton( button, 3 );
    delimiterLayout->addWidget( button, 1, 1 );

    button = new QRadioButton( i18nc( "@option:radio Custum field separator", "Other" ) );
    button->setToolTip(
                i18nc( "@info:tooltip", "Set the field separator to a custom character" ) );
    button->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Select this option if to use some other character as the field delimiter "
                       "for the data in your csv file." ) );
    mDelimiterGroup->addButton( button, 4 );
    delimiterLayout->addWidget( button, 0, 2 );

    mDelimiterEdit = new KLineEdit( group );
    mDelimiterEdit->setToolTip(
                i18nc( "@info:tooltip",
                       "Set the custom delimiter character" ) );
    mDelimiterEdit->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Enter a custom character to use as the delimiter character. "
                       "If you enter more than 1 character, only the first will be used and "
                       "the remaining characters will be ignored." ) );
    delimiterLayout->addWidget( mDelimiterEdit, 1, 2 );

    // text quote
    label = new QLabel( i18nc( "@label:listbox", "Text quote:" ), page );
    layout->addWidget( label, 1, 2 );

    mComboQuote = new KComboBox( page );
    mComboQuote->setToolTip(
                i18nc( "@info:tooltip", "Select the quote character" ) );
    mComboQuote->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Choose the character that your csv data uses to \"quote\" the field delimiter "
                       "if that character happens to occur within the data.  For example, if the "
                       "comma is the field delimiter, then any comma occurring with the data "
                       "will be \"quoted\" by the character specified here." ) );
    mComboQuote->setEditable( false );
    mComboQuote->addItem( i18nc( "@item:inlistbox Qoute character option", "\"" ), 0 );
    mComboQuote->addItem( i18nc( "@item:inlistbox Quote character option", "'" ), 1 );
    mComboQuote->addItem( i18nc( "@item:inlistbox Quote character option", "None" ), 2 );
    layout->addWidget( mComboQuote, 1, 3 );

    // date format
    label = new QLabel( i18nc( "@label:listbox", "Date format:" ), page );
    layout->addWidget( label, 2, 2 );

    mDatePatternEdit = new KLineEdit( page );
    mDatePatternEdit->setText( QLatin1String("Y-M-D") ); // ISO 8601 date format as default
    mDatePatternEdit->setToolTip(
                i18nc( "@info:tooltip",
                       "<para><list><item>y: year with 2 digits</item>"
                       "<item>Y: year with 4 digits</item>"
                       "<item>m: month with 1 or 2 digits</item>"
                       "<item>M: month with 2 digits</item>"
                       "<item>d: day with 1 or 2 digits</item>"
                       "<item>D: day with 2 digits</item>"
                       "<item>H: hours with 2 digits</item>"
                       "<item>I: minutes with 2 digits</item>"
                       "<item>S: seconds with 2 digits</item>"
                       "</list></para>" ) );
    mDatePatternEdit->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "<para>Specify a format to use for dates included in your csv data. "
                       "Use the following sequences to help you define the format:</para>"
                       "<para><list><item>y: year with 2 digits</item>"
                       "<item>Y: year with 4 digits</item>"
                       "<item>m: month with 1 or 2 digits</item>"
                       "<item>M: month with 2 digits</item>"
                       "<item>d: day with 1 or 2 digits</item>"
                       "<item>D: day with 2 digits</item>"
                       "<item>H: hours with 2 digits</item>"
                       "<item>I: minutes with 2 digits</item>"
                       "<item>S: seconds with 2 digits</item>"
                       "</list></para>"
                       "<para>Example: \"Y-M-D\" corresponds to a date like \"2012-01-04\"</para>" ) );
    layout->addWidget( mDatePatternEdit, 2, 3 );

    // text codec
    label = new QLabel( i18nc( "@label:listbox", "Text codec:" ), page );
    layout->addWidget( label, 3, 2 );

    mCodecCombo = new KComboBox( page );
    mCodecCombo->setToolTip(
                i18nc( "@info:tooltip", "Select the text codec" ) );
    mCodecCombo->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Choose the character encoding of the data in your csv file." ) );
    layout->addWidget( mCodecCombo, 3, 3 );

    // skip first line
    mSkipFirstRow = new QCheckBox( i18nc( "@option:check", "Skip first row of file" ), page );
    mSkipFirstRow->setToolTip(
                i18nc( "@info:tooltip", "Skip first row of csv file when importing" ) );
    mSkipFirstRow->setWhatsThis(
                i18nc( "@info:whatsthis",
                       "Check this box if you want the import to skip over the first row "
                       "of the csv data. In many cases, the first line of a csv file will be a "
                       "comment line describing the order of the data fields included in the file." ) );
    layout->addWidget( mSkipFirstRow, 4, 2, 1, 2 );

    // csv view
    mTable = new QTableView( page );
    mTable->setModel( mModel );
    mTable->setItemDelegateForRow( 0, new ContactFieldDelegate( this ) );
    mTable->horizontalHeader()->hide();
    mTable->verticalHeader()->hide();
    mTable->setEditTriggers( QAbstractItemView::CurrentChanged );
    mTable->setHorizontalScrollMode( QAbstractItemView::ScrollPerPixel );
    layout->addWidget( mTable, 5, 0, 1, 5 );

    setButtonText( User1, i18nc( "@action:button", "Apply Template..." ) );
    setButtonText( User2, i18nc( "@action:button", "Save Template..." ) );

    enableButton( Ok, false );
    enableButton( User1, false );
    enableButton( User2, false );

    resize( 500, 400 );
}

void CSVImportDialog::reloadCodecs()
{
    mCodecCombo->clear();

    mCodecs.clear();

    Q_FOREACH ( const QByteArray &name, QTextCodec::availableCodecs() ) {
        mCodecs.append( QTextCodec::codecForName( name ) );
    }

    mCodecCombo->addItem( i18nc( "@item:inlistbox Codec setting", "Local (%1)",
                                 QLatin1String( QTextCodec::codecForLocale()->name() ) ), Local );
    mCodecCombo->addItem( i18nc( "@item:inlistbox Codec setting", "Latin1" ), Latin1 );
    mCodecCombo->addItem( i18nc( "@item:inlistbox Codec setting", "Unicode" ), Uni );
    mCodecCombo->addItem( i18nc( "@item:inlistbox Codec setting", "Microsoft Unicode" ), MSBug );

    for ( int i = 0; i < mCodecs.count(); ++i ) {
        mCodecCombo->addItem( QLatin1String(mCodecs.at( i )->name()), Codec + i );
    }
}

void CSVImportDialog::customDelimiterChanged()
{
    if ( mDelimiterGroup->checkedId() == 4 ) {
        delimiterClicked( 4 );
    }
}

void CSVImportDialog::customDelimiterChanged( const QString &, bool reload )
{
    mDelimiterGroup->button( 4 )->setChecked ( true );
    delimiterClicked( 4, reload ); // other
}

void CSVImportDialog::delimiterClicked( int id, bool reload )
{
    switch ( id ) {
    case 0: // comma
        mModel->setDelimiter( QLatin1Char(',') );
        break;
    case 4: // other
        mDelimiterEdit->setFocus( Qt::OtherFocusReason );
        if ( !mDelimiterEdit->text().isEmpty() ) {
            mModel->setDelimiter( mDelimiterEdit->text().at( 0 ) );
        }
        break;
    case 2: // tab
        mModel->setDelimiter( QLatin1Char('\t') );
        break;
    case 3: // space
        mModel->setDelimiter( QLatin1Char(' ') );
        break;
    case 1: // semicolon
        mModel->setDelimiter( QLatin1Char(';') );
        break;
    }

    if ( mDevice && reload ) {
        mModel->load( mDevice );
    }
}

void CSVImportDialog::textQuoteChanged( const QString &mark, bool reload )
{
    if ( mComboQuote->currentIndex() == 2 ) {
        mModel->setTextQuote( QChar() );
    } else {
        mModel->setTextQuote( mark.at( 0 ) );
    }

    if ( mDevice && reload ) {
        mModel->load( mDevice );
    }
}

void CSVImportDialog::skipFirstRowChanged( bool checked, bool reload )
{
    mFieldSelection.clear();
    for ( int column = 0; column < mModel->columnCount(); ++column ) {
        mFieldSelection.append(
                    ( ContactFields::Field )mModel->data( mModel->index( 0, column ) ).toInt() );
    }

    if ( checked ) {
        mModel->setStartRow( 1 );
    } else {
        mModel->setStartRow( 0 );
    }

    if ( mDevice && reload ) {
        mModel->load( mDevice );
    }
}

void CSVImportDialog::slotButtonClicked( int button )
{
    if ( button == KDialog::Ok ) {
        bool assigned = false;

        for ( int column = 0; column < mModel->columnCount(); ++column ) {
            if ( mModel->data( mModel->index( 0, column ),
                               Qt::DisplayRole ).toUInt() != ContactFields::Undefined ) {
                assigned = true;
                break;
            }
        }

        if ( !assigned ) {
            KMessageBox::sorry(
                        this,
                        i18nc( "@info:status", "You must assign at least one column." ) );
        } else {
            accept();
        }
    } else if ( button == User1 ) {
        applyTemplate();
    } else if ( button == User2 ) {
        saveTemplate();
    } else if ( button == KDialog::Cancel ) {
        reject();
    }
}

void CSVImportDialog::applyTemplate()
{
    QPointer<TemplateSelectionDialog> dlg = new TemplateSelectionDialog( this );
    if ( !dlg->templatesAvailable() ) {
        KMessageBox::sorry(
                    this,
                    i18nc( "@label", "There are no templates available yet." ),
                    i18nc( "@title:window", "No templates available" ) );
        delete dlg;
        return;
    }

    if ( !dlg->exec() || !dlg ) {
        delete dlg;
        return;
    }

    const QString templateFileName = dlg->selectedTemplate();
    delete dlg;

    KConfig config( templateFileName, KConfig::SimpleConfig );

    const KConfigGroup generalGroup( &config, "General" );
    mDatePatternEdit->setText( generalGroup.readEntry( "DatePattern", "Y-M-D" ) );
    mDelimiterEdit->setText( generalGroup.readEntry( "DelimiterOther" ) );

    const int delimiterButton = generalGroup.readEntry( "DelimiterType", 0 );
    const int quoteType = generalGroup.readEntry( "QuoteType", 0 );
    const bool skipFirstRow = generalGroup.readEntry( "SkipFirstRow", false );

    mDelimiterGroup->button( delimiterButton )->setChecked( true );
    delimiterClicked( delimiterButton, false );

    mComboQuote->setCurrentIndex( quoteType );
    textQuoteChanged( mComboQuote->currentText(), false );

    // do block signals here, otherwise it will trigger a reload of the model and
    // the following skipFirstRowChanged call end up with an empty model
    mSkipFirstRow->blockSignals( true );
    mSkipFirstRow->setChecked( skipFirstRow );
    mSkipFirstRow->blockSignals( false );

    skipFirstRowChanged( skipFirstRow, false );

    if ( mDevice ) {
        mModel->load( mDevice );
    }

    setProperty( "TemplateFileName", templateFileName );
    connect( mModel, SIGNAL(finishedLoading()), this, SLOT(finalizeApplyTemplate()) );
}

void CSVImportDialog::finalizeApplyTemplate()
{
    const QString templateFileName = property( "TemplateFileName" ).toString();

    KConfig config( templateFileName, KConfig::SimpleConfig );

    const KConfigGroup generalGroup( &config, "General" );
    const uint columns = generalGroup.readEntry( "Columns", 0 );

    // create the column map
    const KConfigGroup columnMapGroup( &config, "csv column map" );

    for ( uint i = 0; i < columns; ++i ) {
        const uint assignedField = columnMapGroup.readEntry( QString::number( i ), 0 );
        mModel->setData( mModel->index( 0, i ), assignedField, Qt::EditRole );
    }
}

void CSVImportDialog::saveTemplate()
{
    const QString name =
            KInputDialog::getText( i18nc( "@title:window", "Template Name" ),
                                   i18nc( "@info", "Please enter a name for the template:" ) );

    if ( name.isEmpty() ) {
        return;
    }

    const QString fileName =
            KStandardDirs::locateLocal( "data", QLatin1String( "kaddressbook/csv-templates/") +
                                        QUuid::createUuid().toString() +
                                        QLatin1String(".desktop" ));

    KConfig config( fileName );
    KConfigGroup generalGroup( &config, "General" );
    generalGroup.writeEntry( "DatePattern", mDatePatternEdit->text() );
    generalGroup.writeEntry( "Columns", mModel->columnCount() );
    generalGroup.writeEntry( "DelimiterType", mDelimiterGroup->checkedId() );
    generalGroup.writeEntry( "DelimiterOther", mDelimiterEdit->text() );
    generalGroup.writeEntry( "SkipFirstRow", mSkipFirstRow->isChecked() );
    generalGroup.writeEntry( "QuoteType", mComboQuote->currentIndex() );

    KConfigGroup miscGroup( &config, "Misc" );
    miscGroup.writeEntry( "Name", name );

    KConfigGroup columnMapGroup( &config, "csv column map" );
    for ( int column = 0; column < mModel->columnCount(); ++column ) {
        columnMapGroup.writeEntry( QString::number( column ),
                                   mModel->data( mModel->index( 0, column ),
                                                 Qt::DisplayRole ).toUInt() );
    }

    config.sync();
}

void CSVImportDialog::setFile( const KUrl &fileName )
{
    setFile( fileName.toLocalFile() );
}

void CSVImportDialog::setFile( const QString &fileName )
{
    if ( fileName.isEmpty() ) {
        return;
    }

    QFile *file = new QFile( fileName );
    if ( !file->open( QIODevice::ReadOnly ) ) {
        KMessageBox::sorry( this, i18nc( "@info:status", "Cannot open input file." ) );
        delete file;
        return;
    }

    delete mDevice;

    mDevice = file;

    mModel->load( mDevice );
}

void CSVImportDialog::urlChanged( const QString &file )
{
    bool state = !file.isEmpty();

    enableButton( Ok, state );
    enableButton( User1, state );
    enableButton( User2, state );
}

void CSVImportDialog::codecChanged( bool reload )
{
    const int code = mCodecCombo->currentIndex();

    if ( code == Local ) {
        mModel->setTextCodec( QTextCodec::codecForLocale() );
    } else if ( code >= Codec ) {
        mModel->setTextCodec( mCodecs.at( code - Codec ) );
    } else if ( code == Uni ) {
        mModel->setTextCodec( QTextCodec::codecForName( "UTF-16" ) );
    } else if ( code == MSBug ) {
        mModel->setTextCodec( QTextCodec::codecForName( "UTF-16LE" ) );
    } else if ( code == Latin1 ) {
        mModel->setTextCodec( QTextCodec::codecForName( "ISO 8859-1" ) );
    } else {
        mModel->setTextCodec( QTextCodec::codecForName( "UTF-8" ) );
    }

    if ( mDevice && reload ) {
        mModel->load( mDevice );
    }
}

void CSVImportDialog::modelFinishedLoading()
{
    ContactFieldComboBox *box = new ContactFieldComboBox();
    int preferredWidth = box->sizeHint().width();
    delete box;

    for ( int i = 0; i < mModel->columnCount(); ++i ) {
        mTable->setColumnWidth( i, preferredWidth );
    }

    for ( int column = 0; column < mFieldSelection.count(); ++column ) {
        mModel->setData( mModel->index( 0, column ), mFieldSelection.at( column ), Qt::EditRole );
    }
    mFieldSelection.clear();
}

#include <csvimportdialog.moc>