<?xml version="1.0" encoding="utf-8"?>
<Source xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <stSourceName>Boursorama csv TC</stSourceName>
  <oSourceImportedData>CurrentTransaction</oSourceImportedData>
  <oSourceReference>Code</oSourceReference>
  <bCodeMultiple>false</bCodeMultiple>
  <stCodeSeparator />
  <iCodeNbMax>0</iCodeNbMax>
  <iEncodingCharset>65001</iEncodingCharset>
  <iTimeZoneInfo>-1</iTimeZoneInfo>
  <stMainURL>#</stMainURL>
  <stParametersString />
  <oSourceMethod>MethodNAV</oSourceMethod>
  <bAuthorizePopup>false</bAuthorizePopup>
  <bEnableScript>true</bEnableScript>
  <oSourceContentType>Formatted</oSourceContentType>
  <strFormatImport>
    <oKind>TransactionCurrent</oKind>
    <stName>Format csv Boursorama</stName>
    <stExtension>csv</stExtension>
    <oDateOrder>YMD</oDateOrder>
    <stDateDelimiter>-</stDateDelimiter>
    <bYear4Digits>true</bYear4Digits>
    <oFieldSeparator>PointVirgule</oFieldSeparator>
    <stDecimalSeparator>,</stDecimalSeparator>
    <stTimeSeparator>:</stTimeSeparator>
    <stTextSeparator>"</stTextSeparator>
    <bStartRow>true</bStartRow>
    <oListOfColumns>
      <FormatColumn>TCDateReal</FormatColumn>
      <FormatColumn>TCDateValue</FormatColumn>
      <FormatColumn>TCThirdParty</FormatColumn>
      <FormatColumn>TCOther</FormatColumn>
      <FormatColumn>TCOther</FormatColumn>
      <FormatColumn>TCAmount</FormatColumn>
      <FormatColumn>TCOther</FormatColumn>
      <FormatColumn>TCOther</FormatColumn>
      <FormatColumn>TCLink</FormatColumn>
      <FormatColumn>TCOther</FormatColumn>
      <FormatColumn>TCOther</FormatColumn>
    </oListOfColumns>
    <strListOfRules>
      <FormatRule>
        <stDescription>Création d'un FITID pour les opérations du jour</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCIdImport</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCDateReal</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCIdImport</oFieldSource>
            <oAction>FieldConcatRight</oAction>
            <oResultColumn>TCAmount</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCIdImport</oFieldSource>
            <oAction>FieldConcatRight</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type CARTE</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>CARTE.+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCKind</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>Carte Bancaire</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCCB</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>{10}</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCDateReal</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCDateReal</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^CARTE\s(\d{2})/(\d{2})/(\d{2})\s.+~20$3-$2-$1</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^CARTE\s\d{2}/\d{2}/\d{2}\s(.+)~$1</stResultText>
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type RETRAIT DAB</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^RETRAIT\sDAB.+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCKind</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>Retrait Espèce par carte</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCCB</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>{10}</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCDateReal</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCDateReal</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^RETRAIT\sDAB\s(\d{2})/(\d{2})/(\d{2})\s.+~20$3-$2-$1</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^RETRAIT\sDAB\s\d{2}/\d{2}/\d{2}\s(.+)~$1</stResultText>
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type PRLV SEPA</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^PRLV\sSEPA.+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^PRLV\sSEPA\s(.+)~$1</stResultText>
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type CHQ. N.</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^CHQ\.\sN\..+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCKind</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>Chèque émis</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCCheque</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCCheque</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^CHQ\.\sN\.(.+)~$1</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>FieldDelete</oAction>
            <oResultColumn />
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type VIR SEPA</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^VIR\sSEPA.+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^VIR\sSEPA\s(.+)~$1</stResultText>
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type VIR</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^VIR.+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^VIR\s(.+)~$1</stResultText>
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type REM CHQ N.</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^REM\sCHQ\sN\..+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCKind</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>Chèque reçu</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCCheque</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCCheque</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^REM\sCHQ\sN\.(.+)~$1</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>FieldDelete</oAction>
            <oResultColumn />
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type AVOIR</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^AVOIR.+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCKind</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>Crédit par carte</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCCB</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>{9}</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCDateReal</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCDateReal</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^AVOIR\s(\d{2})(\d{2})(\d{2})\s.+~$1/$2/20$3</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>^AVOIR\s\d{6}\s(.+)~$1</stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCNote</oFieldSource>
            <oAction>StringReplace</oAction>
            <oResultColumn />
            <stResultText>Avoir</stResultText>
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type ECH PRET</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^ECH\sPRET.+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCNote</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>FieldDelete</oAction>
            <oResultColumn />
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type SOUSC.</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^SOUSC\..+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCNote</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>FieldDelete</oAction>
            <oResultColumn />
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Type FCPR</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCThirdParty</oFieldReference>
            <oOperator>RegexIsTrue</oOperator>
            <oValueColumn />
            <stValueText>^FCPR.+</stValueText>
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCNote</oFieldSource>
            <oAction>FieldReplace</oAction>
            <oResultColumn>TCThirdParty</oResultColumn>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>FieldDelete</oAction>
            <oResultColumn />
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Mise au format des tiers</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>ToUpperFirstChar</oAction>
            <oResultColumn />
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>ApplyRegex</oAction>
            <oResultColumn />
            <stResultText>\s+~ </stResultText>
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCThirdParty</oFieldSource>
            <oAction>Trim</oAction>
            <oResultColumn />
            <stResultText> </stResultText>
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Filtrage des opérations pour le compte concerné via le champ "Lien Pièce jointe"</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfConditions>
          <FormatItemCondition>
            <oFieldReference>TCLink</oFieldReference>
            <oOperator>Different</oOperator>
            <oValueColumn />
            <stValueText>{0}</stValueText>
          </FormatItemCondition>
          <FormatItemCondition>
            <oFieldReference>TCLink</oFieldReference>
            <oOperator>Different</oOperator>
            <oValueColumn />
          </FormatItemCondition>
        </strListOfConditions>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCDateReal</oFieldSource>
            <oAction>FieldDelete</oAction>
            <oResultColumn />
          </FormatRuleAction>
          <FormatRuleAction>
            <oFieldSource>TCDateValue</oFieldSource>
            <oAction>FieldDelete</oAction>
            <oResultColumn />
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
      <FormatRule>
        <stDescription>Purge de "Lien Pièce jointe" contenant le n° de compte utilisé pour le filtrage</stDescription>
        <bFromServer>true</bFromServer>
        <strListOfActions>
          <FormatRuleAction>
            <oFieldSource>TCLink</oFieldSource>
            <oAction>FieldDelete</oAction>
            <oResultColumn />
          </FormatRuleAction>
        </strListOfActions>
      </FormatRule>
    </strListOfRules>
  </strFormatImport>
  <iDataNbMax>0</iDataNbMax>
  <bDataInZip>false</bDataInZip>
  <oSourceIdentification>YesByLogin</oSourceIdentification>
  <stIdentificationURL>https://clients.boursorama.com/connexion/</stIdentificationURL>
  <stIdentificationParameters>form_login={8};marypopin-mask=byvirtualkeyboard|{9};form=submit</stIdentificationParameters>
  <iIdentificationSleepBefore>200</iIdentificationSleepBefore>
  <iIdentificationSleepAfter>2000</iIdentificationSleepAfter>
  <bIdentificationStop>false</bIdentificationStop>
  <oIdentificationVirKB>Bourso</oIdentificationVirKB>
  <stDeconnectionURL />
  <stDeconnectionParameters>[deconnexion]=click</stDeconnectionParameters>
  <iDeconnectionSleepAfter>2000</iDeconnectionSleepAfter>
  <oSourceWebBrowser>Gecko</oSourceWebBrowser>
  <dDateVersion>2019-10-19T00:00:00</dDateVersion>
  <stNotes>** ORIGINE **&lt;br /&gt;&lt;br /&gt;Site internet de la banque Boursorama : https://www.boursorama.com/&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;** PERIMETRE DES DONNEES **&lt;br /&gt;&lt;br /&gt;Opérations courantes au format csv.&lt;br /&gt;Cette source est aussi capable de récupérer les opérations des comptes externes à Boursorama qui ont été importés dans l'espace client du site Boursorama.&lt;br /&gt;&lt;br /&gt;Cette source nécessite une licence GesFine Premium.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;** CONFIGURATION **&lt;br /&gt;&lt;br /&gt;- Dans les propriétés de la source, onglet "Configuration", renseigner pour chaque item, la colonne "Valeur de 'votre titulaire'" du tableau "Variables du titulaire" ci-contre.&lt;br /&gt;Le nom de la carte bancaire doit être celui configuré dans les propriétés du compte pour lequel les opérations sont importées. Si la carte bancaire n'est pas configurée dans les propriétés du compte, elle sera automatiquement créée.&lt;br /&gt;&lt;br /&gt;- Dans les propriétés du compte, item "Importation", rubrique "Téléchargement des opérations courantes" :&lt;br /&gt; &gt; Affecter la source et saisir le code de téléchargement.&lt;br /&gt;&lt;br /&gt;Pour une importation SANS acceptation/validation des données importées :&lt;br /&gt; &gt; Ne pas cocher l'option pour la validation des opérations&lt;br /&gt; &gt; Cocher l'option pour la gestion des doublons&lt;br /&gt; &gt; Sélectionner l'importation depuis "La dernière opération"&lt;br /&gt;&lt;br /&gt;Pour une importation AVEC acceptation/validation des données importées :&lt;br /&gt; &gt; Cocher l'option pour la validation des opérations&lt;br /&gt; &gt; Ne pas cocher l'option pour la gestion des doublons&lt;br /&gt; &gt; Sélectionner l'importation depuis "La dernière opération validée"&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;** CODE DE TELECHARGEMENT **&lt;br /&gt;&lt;br /&gt;Le code de téléchargement est l'association de :&lt;br /&gt;- votre numéro de compte chez Boursorama &lt;br /&gt;- du code que l'on trouve dans l'url de consultation des mouvements pour le compte.&lt;br /&gt;Exemple : https://clients.boursorama.com/compte/cav/XXX/mouvements.&lt;br /&gt;Le 2ieme code correspond au "XXX" :&lt;br /&gt;&lt;br /&gt;Les 2 codes doivent être associés dans l'ordre par le caractère ~&lt;br /&gt;Exemple : 1354698244~2a18d3c21338d9a422512841e69a6fui</stNotes>
  <strListOfVariables>
    <SourceVariable>
      <stName>Identifiant</stName>
    </SourceVariable>
    <SourceVariable>
      <stName>Mot de passe</stName>
    </SourceVariable>
    <SourceVariable>
      <stName>Nom de la carte bancaire</stName>
    </SourceVariable>
  </strListOfVariables>
  <strListOfParameters>
    <SourceParameter>
      <oParameter>Reference</oParameter>
    </SourceParameter>
    <SourceParameter>
      <oParameter>Reference</oParameter>
    </SourceParameter>
    <SourceParameter>
      <oParameter>DayBegin</oParameter>
    </SourceParameter>
    <SourceParameter>
      <oParameter>MonthBegin</oParameter>
    </SourceParameter>
    <SourceParameter>
      <oParameter>YearBegin</oParameter>
    </SourceParameter>
    <SourceParameter>
      <oParameter>DayEnd</oParameter>
    </SourceParameter>
    <SourceParameter>
      <oParameter>MonthEnd</oParameter>
    </SourceParameter>
    <SourceParameter>
      <oParameter>YearEnd</oParameter>
    </SourceParameter>
  </strListOfParameters>
  <strListOfNavigations>
    <SourceNavigation>
      <oNavigation>GetLinkByAttribut</oNavigation>
      <stValue>mouvements-a-venir</stValue>
    </SourceNavigation>
    <SourceNavigation>
      <oNavigation>SetAttribut</oNavigation>
      <stValue>href=https://clients.boursorama.com/budget/exporter-mouvements?movementSearch%5BfromDate%5D={2}%2F{3}%2F{4}&amp;movementSearch%5BtoDate%5D={5}%2F{6}%2F{7}&amp;movementSearch%5Badvanced%5D=1&amp;accountsWithCardsKeys={1}&amp;format=csv</stValue>
    </SourceNavigation>
    <SourceNavigation>
      <oNavigation>EventOnElement</oNavigation>
      <stValue>clicksave</stValue>
    </SourceNavigation>
  </strListOfNavigations>
</Source>