dbaccess/source/ui/dlg/TextConnectionHelper.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*************************************************************************
   3  *
   4  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   5  *
   6  * Copyright 2000, 2010 Oracle and/or its affiliates.
   7  *
   8  * OpenOffice.org - a multi-platform office productivity suite
   9  *
  10  * This file is part of OpenOffice.org.
  11  *
  12  * OpenOffice.org is free software: you can redistribute it and/or modify
  13  * it under the terms of the GNU Lesser General Public License version 3
  14  * only, as published by the Free Software Foundation.
  15  *
  16  * OpenOffice.org is distributed in the hope that it will be useful,
  17  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  18  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  19  * GNU Lesser General Public License version 3 for more details
  20  * (a copy is included in the LICENSE file that accompanied this code).
  21  *
  22  * You should have received a copy of the GNU Lesser General Public License
  23  * version 3 along with OpenOffice.org.  If not, see
  24  * <http://www.openoffice.org/license.html>
  25  * for a copy of the LGPLv3 License.
  26  *
  27  ************************************************************************/
  28 #include "moduledbu.hxx"
  29
  30 #include "TextConnectionHelper.hxx"
  31
  32 #include "sqlmessage.hxx"
  33 #include "dbu_dlg.hrc"
  34 #include "dbu_resource.hrc"
  35 #include "AutoControls.hrc"
  36
  37 #include <svl/itemset.hxx>
  38 #include <svl/stritem.hxx>
  39 #include <svl/eitem.hxx>
  40 #include <svl/intitem.hxx>
  41 #include "dsitems.hxx"
  42 #include "dbfindex.hxx"
  43 #include "dbaccess_helpid.hrc"
  44 #include "localresaccess.hxx"
  45 #include <vcl/msgbox.hxx>
  46 #include <vcl/mnemonic.hxx>
  47 #include <svl/cjkoptions.hxx>
  48 #include <jvmaccess/virtualmachine.hxx>
  49 #include <connectivity/CommonTools.hxx>
  50 #include "DriverSettings.hxx"
  51 #include "dbadmin.hxx"
  52 #include <comphelper/string.hxx>
  53 #include <comphelper/types.hxx>
  54
  55 #include <com/sun/star/ui/dialogs/XFolderPicker.hpp>
  56 #include <com/sun/star/task/XInteractionHandler.hpp>
  57
  58 #include <svl/filenotation.hxx>
  59
  60 #include <unotools/localfilehelper.hxx>
  61 #include <unotools/ucbhelper.hxx>
  62 #include <ucbhelper/commandenvironment.hxx>
  63 #include "finteraction.hxx"
  64
  65 #include "DBSetupConnectionPages.hxx"
  66
  67 #include <unotools/pathoptions.hxx>
  68
  69 #include <svtools/roadmapwizard.hxx>
  70
  71
  72 namespace dbaui
  73 {
  74
  75     //========================================================================
  76     //= OTextConnectionPageSetup
  77     //========================================================================
  78 DBG_NAME(OTextConnectionHelper)
  79 //------------------------------------------------------------------------
  80     OTextConnectionHelper::OTextConnectionHelper( Window* pParent, const short _nAvailableSections )
  81         :Control( pParent, WB_DIALOGCONTROL )
  82         ,m_aFTExtensionHeader       (this, ModuleRes(FT_AUTOEXTENSIONHEADER))
  83         ,m_aRBAccessTextFiles       (this, ModuleRes(RB_AUTOACCESSCTEXTFILES))
  84         ,m_aRBAccessCSVFiles        (this, ModuleRes(RB_AUTOACCESSCCSVFILES))
  85         ,m_aRBAccessOtherFiles      (this, ModuleRes(RB_AUTOACCESSOTHERS))
  86         ,m_aETOwnExtension          (this, ModuleRes(ET_AUTOOWNEXTENSION))
  87         ,m_aFTExtensionExample      (this, ModuleRes(FT_AUTOOWNEXTENSIONAPPENDIX))
  88         ,m_aLineFormat              (this, ModuleRes(FL_AUTOSEPARATOR2))
  89         ,m_aFieldSeparatorLabel     (this, ModuleRes(FT_AUTOFIELDSEPARATOR))
  90         ,m_aFieldSeparator          (this, ModuleRes(CM_AUTOFIELDSEPARATOR))
  91         ,m_aTextSeparatorLabel      (this, ModuleRes(FT_AUTOTEXTSEPARATOR))
  92         ,m_aTextSeparator           (this, ModuleRes(CM_AUTOTEXTSEPARATOR))
  93         ,m_aDecimalSeparatorLabel   (this, ModuleRes(FT_AUTODECIMALSEPARATOR))
  94         ,m_aDecimalSeparator        (this, ModuleRes(CM_AUTODECIMALSEPARATOR))
  95         ,m_aThousandsSeparatorLabel (this, ModuleRes(FT_AUTOTHOUSANDSSEPARATOR))
  96         ,m_aThousandsSeparator      (this, ModuleRes(CM_AUTOTHOUSANDSSEPARATOR))
  97         ,m_aRowHeader               (this, ModuleRes(CB_AUTOHEADER))
  98         ,m_aCharSetHeader           (this, ModuleRes(FL_DATACONVERT))
  99         ,m_aCharSetLabel            (this, ModuleRes(FT_CHARSET))
 100         ,m_aCharSet                 (this, ModuleRes(LB_CHARSET))
 101         ,m_aFieldSeparatorList      (ModuleRes(STR_AUTOFIELDSEPARATORLIST))
 102         ,m_aTextSeparatorList       (ModuleRes(STR_AUTOTEXTSEPARATORLIST))
 103         ,m_aTextNone                (ModuleRes(STR_AUTOTEXT_FIELD_SEP_NONE))
 104         ,m_nAvailableSections( _nAvailableSections )
 105     {
 106         DBG_CTOR(OTextConnectionHelper,NULL);
 107
 108         xub_StrLen nCnt = comphelper::string::getTokenCount(m_aFieldSeparatorList, '\t');
 109         xub_StrLen i;
 110
 111         for( i = 0 ; i < nCnt ; i += 2 )
 112             m_aFieldSeparator.InsertEntry( m_aFieldSeparatorList.GetToken( i, '\t' ) );
 113
 114         nCnt = comphelper::string::getTokenCount(m_aTextSeparatorList, '\t');
 115         for( i=0 ; i<nCnt ; i+=2 )
 116             m_aTextSeparator.InsertEntry( m_aTextSeparatorList.GetToken( i, '\t' ) );
 117         m_aTextSeparator.InsertEntry(m_aTextNone);
 118
 119         // set the modify handlers
 120         m_aFieldSeparator.SetUpdateDataHdl(getControlModifiedLink());
 121         m_aFieldSeparator.SetSelectHdl(getControlModifiedLink());
 122         m_aTextSeparator.SetUpdateDataHdl(getControlModifiedLink());
 123         m_aTextSeparator.SetSelectHdl(getControlModifiedLink());
 124         m_aCharSet.SetSelectHdl(getControlModifiedLink());
 125
 126         m_aFieldSeparator.SetModifyHdl(getControlModifiedLink());
 127         m_aTextSeparator.SetModifyHdl(getControlModifiedLink());
 128         m_aDecimalSeparator.SetModifyHdl(getControlModifiedLink());
 129         m_aThousandsSeparator.SetModifyHdl(getControlModifiedLink());
 130         m_aETOwnExtension.SetModifyHdl(LINK(this, OTextConnectionHelper, OnEditModified));
 131            m_aRBAccessTextFiles.SetToggleHdl(LINK(this, OTextConnectionHelper, OnSetExtensionHdl));
 132            m_aRBAccessCSVFiles.SetToggleHdl(LINK(this, OTextConnectionHelper, OnSetExtensionHdl));
 133         m_aRBAccessOtherFiles.SetToggleHdl(LINK(this, OTextConnectionHelper, OnSetExtensionHdl));
 134         m_aRBAccessCSVFiles.Check(sal_True);
 135
 136         struct SectionDescriptor
 137         {
 138             short   nFlag;
 139             Window* pFirstControl;
 140         } aSections[] = {
 141             { TC_EXTENSION,     &m_aFTExtensionHeader },
 142             { TC_SEPARATORS,    &m_aLineFormat },
 143             { TC_HEADER,        &m_aRowHeader },
 144             { TC_CHARSET,       &m_aCharSetHeader },
 145             { 0, NULL }
 146         };
 147
 148         for ( size_t section=0; section < sizeof( aSections ) / sizeof( aSections[0] ) - 1; ++section )
 149         {
 150             if ( ( m_nAvailableSections & aSections[section].nFlag ) != 0 )
 151             {
 152                 // the section is visible, no need to do anything here
 153                 continue;
 154             }
 155
 156             Window* pThisSection = aSections[section].pFirstControl;
 157             Window* pNextSection = aSections[section+1].pFirstControl;
 158
 159             // hide all elements from this section
 160             Window* pControl = pThisSection;
 161             while ( ( pControl != pNextSection ) && pControl )
 162             {
 163                 Window* pRealWindow = pControl->GetWindow( WINDOW_CLIENT );
 164             #if OSL_DEBUG_LEVEL > 0
 165                 String sWindowText( pRealWindow->GetText() );
 166                 (void)sWindowText;
 167             #endif
 168                 pRealWindow->Hide();
 169                 pControl = pControl->GetWindow( WINDOW_NEXT );
 170             }
 171
 172             // move all controls in following sections up
 173             if ( !pNextSection )
 174                 continue;
 175             const long nThisSectionStart = pThisSection->GetPosPixel().Y();
 176             const long nNextSectionStart = pNextSection->GetPosPixel().Y();
 177             const long nMoveOffset( nThisSectionStart - nNextSectionStart );
 178             while ( pControl )
 179             {
 180                 Point aPos = pControl->GetPosPixel();
 181                 aPos.Move( 0, nMoveOffset );
 182                 pControl->SetPosPixel( aPos );
 183                 pControl = pControl->GetWindow( WINDOW_NEXT );
 184             }
 185         }
 186
 187         Rectangle aControlRectUnion;
 188         for (   Window* pControl = aSections[0].pFirstControl;
 189                 pControl != NULL;
 190                 pControl = pControl->GetWindow( WINDOW_NEXT )
 191             )
 192         {
 193             aControlRectUnion = aControlRectUnion.Union( Rectangle( pControl->GetPosPixel(), pControl->GetSizePixel() ) );
 194         }
 195
 196         // need some adjustments to the positions, since the resource-specified
 197         // positions for the control were relative to *our* parent, while by now
 198         // the controls have |this| as parent.
 199
 200         // first, move ourself to the upper left of the area occupied by all controls
 201         SetPosPixel( aControlRectUnion.TopLeft() );
 202
 203         // then, compensate in the control positions, by moving them the up/left
 204         for (   Window* pControl = aSections[0].pFirstControl;
 205                 pControl != NULL;
 206                 pControl = pControl->GetWindow( WINDOW_NEXT )
 207             )
 208         {
 209             Point aPos( pControl->GetPosPixel() );
 210             aPos.Move( -aControlRectUnion.Left(), -aControlRectUnion.Top() );
 211             pControl->SetPosPixel( aPos );
 212
 213             // while we are here ... the controls should not have an own background
 214             // (this would not be needed when our outer dialog were also the parent
 215             // of the controls)
 216             pControl->SetBackground();
 217         }
 218
 219         // now, change our own size so all controls fit
 220         SetSizePixel( aControlRectUnion.GetSize() );
 221
 222         SetBackground();
 223         Show();
 224     }
 225
 226     // -----------------------------------------------------------------------
 227     OTextConnectionHelper::~OTextConnectionHelper()
 228     {
 229
 230         DBG_DTOR(OTextConnectionHelper,NULL);
 231     }
 232
 233
 234     // -----------------------------------------------------------------------
 235     IMPL_LINK(OTextConnectionHelper, OnControlModified, Control*, /*EMPTYARG*/)
 236     {
 237         callModifiedHdl();
 238         return 0L;
 239     }
 240
 241     // -----------------------------------------------------------------------
 242     IMPL_LINK(OTextConnectionHelper, OnEditModified, Edit*, /*_pEdit*/)
 243     {
 244         m_aGetExtensionHandler.Call(this);
 245         return 0L;
 246     }
 247
 248
 249     IMPL_LINK(OTextConnectionHelper, OnSetExtensionHdl, RadioButton*, /*_pRadioButton*/)
 250     {
 251         sal_Bool bDoEnable = m_aRBAccessOtherFiles.IsChecked();
 252         m_aETOwnExtension.Enable(bDoEnable);
 253         m_aFTExtensionExample.Enable(bDoEnable);
 254         m_aGetExtensionHandler.Call(this);
 255         return 0L;
 256     }
 257
 258
 259     // -----------------------------------------------------------------------
 260     void OTextConnectionHelper::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
 261     {
 262         _rControlList.push_back(new OSaveValueWrapper<ComboBox>(&m_aFieldSeparator));
 263         _rControlList.push_back(new OSaveValueWrapper<ComboBox>(&m_aTextSeparator));
 264         _rControlList.push_back(new OSaveValueWrapper<ComboBox>(&m_aDecimalSeparator));
 265         _rControlList.push_back(new OSaveValueWrapper<ComboBox>(&m_aThousandsSeparator));
 266         _rControlList.push_back(new OSaveValueWrapper<CheckBox>(&m_aRowHeader));
 267         _rControlList.push_back(new OSaveValueWrapper<ListBox>(&m_aCharSet));
 268     }
 269     // -----------------------------------------------------------------------
 270     void OTextConnectionHelper::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
 271     {
 272         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFieldSeparatorLabel));
 273         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aTextSeparatorLabel));
 274         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aDecimalSeparatorLabel));
 275         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aThousandsSeparatorLabel));
 276         _rControlList.push_back(new ODisableWrapper<FixedLine>(&m_aCharSetHeader));
 277         _rControlList.push_back(new ODisableWrapper<FixedText>(&m_aCharSetLabel));
 278         _rControlList.push_back(new ODisableWrapper<ListBox>(&m_aCharSet));
 279     }
 280
 281     // -----------------------------------------------------------------------
 282     void OTextConnectionHelper::implInitControls(const SfxItemSet& _rSet, sal_Bool _bValid)
 283     {
 284         if ( !_bValid )
 285             return;
 286
 287         SFX_ITEMSET_GET( _rSet, pDelItem, SfxStringItem, DSID_FIELDDELIMITER, sal_True );
 288         SFX_ITEMSET_GET( _rSet, pStrItem, SfxStringItem, DSID_TEXTDELIMITER, sal_True );
 289         SFX_ITEMSET_GET( _rSet, pDecdelItem, SfxStringItem, DSID_DECIMALDELIMITER, sal_True );
 290         SFX_ITEMSET_GET( _rSet, pThodelItem, SfxStringItem, DSID_THOUSANDSDELIMITER, sal_True );
 291         SFX_ITEMSET_GET( _rSet, pExtensionItem, SfxStringItem, DSID_TEXTFILEEXTENSION, sal_True );
 292         SFX_ITEMSET_GET( _rSet, pCharsetItem, SfxStringItem, DSID_CHARSET, sal_True );
 293
 294         if ( ( m_nAvailableSections & TC_EXTENSION ) != 0 )
 295         {
 296             m_aOldExtension = pExtensionItem->GetValue();
 297             SetExtension( m_aOldExtension );
 298         }
 299
 300         if ( ( m_nAvailableSections & TC_HEADER ) != 0 )
 301         {
 302             SFX_ITEMSET_GET( _rSet, pHdrItem, SfxBoolItem, DSID_TEXTFILEHEADER, sal_True );
 303             m_aRowHeader.Check( pHdrItem->GetValue() );
 304         }
 305
 306         if ( ( m_nAvailableSections & TC_SEPARATORS ) != 0 )
 307         {
 308             SetSeparator( m_aFieldSeparator, m_aFieldSeparatorList, pDelItem->GetValue() );
 309             SetSeparator( m_aTextSeparator, m_aTextSeparatorList, pStrItem->GetValue() );
 310             m_aDecimalSeparator.SetText( pDecdelItem->GetValue() );
 311             m_aThousandsSeparator.SetText( pThodelItem->GetValue() );
 312         }
 313
 314         if ( ( m_nAvailableSections & TC_CHARSET ) != 0 )
 315         {
 316             m_aCharSet.SelectEntryByIanaName( pCharsetItem->GetValue() );
 317         }
 318     }
 319
 320
 321
 322     // -----------------------------------------------------------------------
 323     sal_Bool OTextConnectionHelper::prepareLeave()
 324     {
 325         LocalResourceAccess aStringResAccess(PAGE_TEXT, RSC_TABPAGE);
 326             // for accessing the strings which are local to our own resource block
 327         String sExtension = GetExtension();
 328         String aErrorText;
 329         Control* pErrorWin = NULL;
 330         String aDelText(m_aFieldSeparator.GetText());
 331         if(!aDelText.Len())
 332         {   // Kein FeldTrenner
 333             aErrorText = String(ModuleRes(STR_AUTODELIMITER_MISSING));
 334             aErrorText.SearchAndReplaceAscii("#1",m_aFieldSeparatorLabel.GetText());
 335             pErrorWin = &m_aFieldSeparator;
 336         }
 337         else if (!m_aDecimalSeparator.GetText().Len())
 338         {   // kein Decimaltrenner
 339             aErrorText = String(ModuleRes(STR_AUTODELIMITER_MISSING));
 340             aErrorText.SearchAndReplaceAscii("#1",m_aDecimalSeparatorLabel.GetText());
 341             pErrorWin = &m_aDecimalSeparator;
 342         }
 343         else if (m_aTextSeparator.GetText() == m_aFieldSeparator.GetText())
 344         {   // Feld und TextTrenner duerfen nicht gleich sein
 345             aErrorText = String(ModuleRes(STR_AUTODELIMITER_MUST_DIFFER));
 346             aErrorText.SearchAndReplaceAscii("#1",m_aTextSeparatorLabel.GetText());
 347             aErrorText.SearchAndReplaceAscii("#2",m_aFieldSeparatorLabel.GetText());
 348             pErrorWin = &m_aTextSeparator;
 349         }
 350         else if (m_aDecimalSeparator.GetText() == m_aThousandsSeparator.GetText())
 351         {   // Tausender und DecimalTrenner duerfen nicht gleich sein
 352             aErrorText = String(ModuleRes(STR_AUTODELIMITER_MUST_DIFFER));
 353             aErrorText.SearchAndReplaceAscii("#1",m_aDecimalSeparatorLabel.GetText());
 354             aErrorText.SearchAndReplaceAscii("#2",m_aThousandsSeparatorLabel.GetText());
 355             pErrorWin = &m_aDecimalSeparator;
 356         }
 357         else if (m_aFieldSeparator.GetText() == m_aThousandsSeparator.GetText())
 358         {   // Tausender und FeldTrenner duerfen nicht gleich sein
 359             aErrorText = String(ModuleRes(STR_AUTODELIMITER_MUST_DIFFER));
 360             aErrorText.SearchAndReplaceAscii("#1",m_aFieldSeparatorLabel.GetText());
 361             aErrorText.SearchAndReplaceAscii("#2",m_aThousandsSeparatorLabel.GetText());
 362             pErrorWin = &m_aFieldSeparator;
 363         }
 364         else if (m_aFieldSeparator.GetText() == m_aDecimalSeparator.GetText())
 365         {   // Zehner und FeldTrenner duerfen nicht gleich sein
 366             aErrorText = String(ModuleRes(STR_AUTODELIMITER_MUST_DIFFER));
 367             aErrorText.SearchAndReplaceAscii("#1",m_aFieldSeparatorLabel.GetText());
 368             aErrorText.SearchAndReplaceAscii("#2",m_aDecimalSeparatorLabel.GetText());
 369             pErrorWin = &m_aFieldSeparator;
 370         }
 371         else if (m_aTextSeparator.GetText() == m_aThousandsSeparator.GetText())
 372         {   // Tausender und TextTrenner duerfen nicht gleich sein
 373             aErrorText = String(ModuleRes(STR_AUTODELIMITER_MUST_DIFFER));
 374             aErrorText.SearchAndReplaceAscii("#1",m_aTextSeparatorLabel.GetText());
 375             aErrorText.SearchAndReplaceAscii("#2",m_aThousandsSeparatorLabel.GetText());
 376             pErrorWin = &m_aTextSeparator;
 377         }
 378         else if (m_aTextSeparator.GetText() == m_aDecimalSeparator.GetText())
 379         {   // Zehner und TextTrenner duerfen nicht gleich sein
 380             aErrorText = String(ModuleRes(STR_AUTODELIMITER_MUST_DIFFER));
 381             aErrorText.SearchAndReplaceAscii("#1",m_aTextSeparatorLabel.GetText());
 382             aErrorText.SearchAndReplaceAscii("#2",m_aDecimalSeparatorLabel.GetText());
 383             pErrorWin = &m_aTextSeparator;
 384         }
 385         else if ((sExtension.Search('*') != STRING_NOTFOUND) || (sExtension.Search('?') != STRING_NOTFOUND))
 386         {
 387             aErrorText = String(ModuleRes(STR_AUTONO_WILDCARDS));
 388             aErrorText.SearchAndReplaceAscii("#1",sExtension);
 389             pErrorWin = &m_aETOwnExtension;
 390         }
 391         else
 392             return sal_True;
 393         ErrorBox(NULL, WB_OK, MnemonicGenerator::EraseAllMnemonicChars( aErrorText)).Execute();
 394         pErrorWin->GrabFocus();
 395         return 0;
 396     }
 397
 398
 399     // -----------------------------------------------------------------------
 400     sal_Bool OTextConnectionHelper::FillItemSet( SfxItemSet& rSet, const sal_Bool _bChangedSomething )
 401     {
 402         sal_Bool bChangedSomething = _bChangedSomething;
 403
 404         if ( ( m_nAvailableSections & TC_EXTENSION ) != 0 )
 405         {
 406             String sExtension = GetExtension();
 407             if( !m_aOldExtension.Equals( sExtension ) )
 408             {
 409                 rSet.Put( SfxStringItem( DSID_TEXTFILEEXTENSION, sExtension ) );
 410                 bChangedSomething = sal_True;
 411             }
 412         }
 413
 414         if ( ( m_nAvailableSections & TC_HEADER ) != 0 )
 415         {
 416             if( (m_aRowHeader.GetState() != m_aRowHeader.GetSavedValue()) )
 417             {
 418                 rSet.Put(SfxBoolItem(DSID_TEXTFILEHEADER, m_aRowHeader.IsChecked()));
 419                 bChangedSomething = sal_True;
 420             }
 421         }
 422
 423         if ( ( m_nAvailableSections & TC_SEPARATORS ) != 0 )
 424         {
 425             if( m_aFieldSeparator.GetText() != m_aFieldSeparator.GetSavedValue() )
 426             {
 427                 rSet.Put( SfxStringItem(DSID_FIELDDELIMITER, GetSeparator( m_aFieldSeparator, m_aFieldSeparatorList) ) );
 428                 bChangedSomething = sal_True;
 429             }
 430             if( m_aTextSeparator.GetText() != m_aTextSeparator.GetSavedValue() )
 431             {
 432                 rSet.Put( SfxStringItem(DSID_TEXTDELIMITER, GetSeparator( m_aTextSeparator, m_aTextSeparatorList) ) );
 433                 bChangedSomething = sal_True;
 434             }
 435
 436             if( m_aDecimalSeparator.GetText() != m_aDecimalSeparator.GetSavedValue() )
 437             {
 438                 rSet.Put( SfxStringItem(DSID_DECIMALDELIMITER, m_aDecimalSeparator.GetText().Copy(0, 1) ) );
 439                 bChangedSomething = sal_True;
 440             }
 441             if( m_aThousandsSeparator.GetText() != m_aThousandsSeparator.GetSavedValue() )
 442             {
 443                 rSet.Put( SfxStringItem(DSID_THOUSANDSDELIMITER, m_aThousandsSeparator.GetText().Copy(0,1) ) );
 444                 bChangedSomething = sal_True;
 445             }
 446         }
 447
 448         if ( ( m_nAvailableSections & TC_CHARSET ) != 0 )
 449         {
 450             if ( m_aCharSet.StoreSelectedCharSet( rSet, DSID_CHARSET ) )
 451                 bChangedSomething = sal_True;
 452         }
 453
 454         return bChangedSomething;
 455     }
 456
 457
 458     void OTextConnectionHelper::SetExtension(const String& _rVal)
 459     {
 460         if (_rVal.EqualsAscii("txt"))
 461             m_aRBAccessTextFiles.Check(sal_True);
 462         else if (_rVal.EqualsAscii( "csv" ))
 463             m_aRBAccessCSVFiles.Check(sal_True);
 464         else
 465         {
 466             m_aRBAccessOtherFiles.Check(sal_True);
 467             m_aFTExtensionExample.SetText(_rVal);
 468         }
 469     }
 470
 471
 472     String OTextConnectionHelper::GetExtension()
 473     {
 474         String sExtension;
 475         if (m_aRBAccessTextFiles.IsChecked())
 476             sExtension = String::CreateFromAscii("txt");
 477         else if (m_aRBAccessCSVFiles.IsChecked())
 478             sExtension = String::CreateFromAscii("csv");
 479         else
 480         {
 481             sExtension = m_aETOwnExtension.GetText();
 482             if ( sExtension.GetToken(0,'.').Equals('*') )
 483                 sExtension.Erase(0,2);
 484         }
 485         return sExtension;
 486     }
 487
 488
 489     //------------------------------------------------------------------------
 490     String OTextConnectionHelper::GetSeparator( const ComboBox& rBox, const String& rList )
 491     {
 492         sal_Unicode nTok = '\t';
 493         xub_StrLen  nPos(rBox.GetEntryPos( rBox.GetText() ));
 494
 495         if( nPos == COMBOBOX_ENTRY_NOTFOUND )
 496             return rBox.GetText().Copy(0);
 497
 498         if ( !( &m_aTextSeparator == &rBox && nPos == (rBox.GetEntryCount()-1) ) )
 499             return String(
 500                 static_cast< sal_Unicode >(
 501                     rList.GetToken(((nPos*2)+1), nTok ).ToInt32()));
 502         // somewhat strange ... translates for instance an "32" into " "
 503         return String();
 504     }
 505
 506     //------------------------------------------------------------------------
 507     void OTextConnectionHelper::SetSeparator( ComboBox& rBox, const String& rList, const String& rVal )
 508     {
 509         char    nTok = '\t';
 510         xub_StrLen  nCnt(comphelper::string::getTokenCount(rList, nTok));
 511         xub_StrLen  i;
 512
 513         for( i=0 ; i<nCnt ; i+=2 )
 514         {
 515             String  sTVal(
 516                 static_cast< sal_Unicode >(
 517                     rList.GetToken( (i+1), nTok ).ToInt32()));
 518
 519             if( sTVal == rVal )
 520             {
 521                 rBox.SetText( rList.GetToken( i, nTok ) );
 522                 break;
 523             }
 524         }
 525
 526         if ( i >= nCnt )
 527         {
 528             if ( &m_aTextSeparator == &rBox && !rVal.Len() )
 529                 rBox.SetText(m_aTextNone);
 530             else
 531                 rBox.SetText( rVal.Copy(0, 1) );
 532         }
 533     }
 534
 535 //.........................................................................
 536 }   // namespace dbaui
 537 //.........................................................................
 538
 539 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */