<?xml version="1.0" encoding="utf-8"?>
<FormatImport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <oKind>TransactionCurrent</oKind>
  <stName>Format csv Boursorama</stName>
  <stExtension>csv</stExtension>
  <oDateOrder>DMY</oDateOrder>
  <stDateDelimiter>/</stDateDelimiter>
  <bYear4Digits>true</bYear4Digits>
  <oFormatMonth>Numerical</oFormatMonth>
  <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>TCOther</FormatColumn>
    <FormatColumn>TCAmount</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</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.+~$1/$2/20$3</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^CARTE\s\d{2}/\d{2}/\d{2}\s\d{0,2}(.+)CB.\d{4}~$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.+~$1/$2/20$3</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>
  </strListOfRules>
</FormatImport>