Answers.Body: <p>I faced the same problem and double-checked date settings in Civi. All well.</p>
  <p>My solution was to delete the &quot;head&quot; and &quot;footer&quot; rows from the csv file, marked yellow in this screenshot:
  <a href="https://i.sstatic.net/dEZfn.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/dEZfn.jpg" alt="screenshot csv" /></a></p>
  <p>The result is a clean csv spreadsheet with 1 row for header and a rows for every transaction. This file was imported as expected to CiviBanking.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-30T11:33:22.373Z
Answers.LastActivityDate: 2022-02-02T17:52:55.210Z
Answers.LastEditDate: 2022-02-02T17:52:55.210Z
Answers.UserDisplayName: wintermoor
Answers.Body: <p>I encountered the same problem with very similar data and searched for the mistake longer then I would like to admit.</p>
  <p>To my big disappointment it was not caused by a wrong configuration per se, but by stupid copy-and-paste without thinking.
  Into the config-part on the web interface you should only copy the config-part of the json and not the 'name,description,weight,...'-part , i.e</p>
  <pre><code>{
   &quot;delimiter&quot;: &quot;;&quot;,
   &quot;encoding&quot;: &quot;iso-8859-1&quot;,
   &quot;skip&quot;: 11,
   &quot;header&quot;: 13,
   &quot;title&quot;: &quot;Test&quot;,
   &quot;defaults&quot;: [],
   &quot;rules&quot;: [
     {
       &quot;from&quot;: &quot;Buchungstag&quot;,
       &quot;to&quot;: &quot;booking_date&quot;,
       &quot;type&quot;: &quot;strtotime:d.m.Y&quot;
     },
     {
       &quot;from&quot;: &quot;Valuta&quot;,
       &quot;to&quot;: &quot;value_date&quot;,
       &quot;type&quot;: &quot;strtotime:d.m.Y&quot;
     },
     {
       &quot;from&quot;: &quot;Auftraggeber/Zahlungsempfänger&quot;,
       &quot;to&quot;: &quot;name&quot;,
       &quot;type&quot;: &quot;set&quot;
     }
   ]
  }
  </code></pre>
  <p>I also found out that the 'skip' parameter denotes numbers of line to skip which is less important than the 'header' parameter which denotes the line number of the header in the csv. Setting the right 'header' and not setting the 'skip' parameter still worked for my case as civiBanking did not find the right information in those lines and skiped them automatically.</p>
  <p>Hope that helped. This is my first entry on any StackOverflow site.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-05T11:40:25.020Z
Answers.Text: Great, thanx @kolblass ! In my GLS Bank case the solution was:
    "skip": 15,
    "header": 16,
Answers.UserDisplayName: wintermoor
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-02T13:56:25.013Z
Answers.LastActivityDate: 2022-02-02T13:56:25.013Z
Answers.UserDisplayName: kolblass
Body: <p>Unfortunately, even after several attempts, we have not managed to configure the CiviBanking plugin so that the csv file can be imported. We use a file from &quot;Deutsche Skatbank&quot; but the importer is not reading our configuration as expected.</p>
  <p><strong>Previous procedure</strong></p>
  <p>At first, we followed the examples from <a href="https://github.com/Project60/org.project60.banking/tree/master/configuration_database/Importer/CSV" rel="nofollow noreferrer">Project60</a>.
  But no matter what we do, we always get the message <code>No valid booking date detected. Not imported!</code> for all rows.</p>
  <p>Since we did not find any detailed documentation on the individual parameters, we looked directly at the code and tried to understand what was happening. According to our understanding, the <code>skip</code> specification should skip a number of lines during import, so that the code that gives the above mentioned error is not called for these lines at all. However, since the message appears for all lines and does not change even when the <code>skip</code> parameter is changed, we assume that there is a profound problem in the interpretation of the file.</p>
  <p><strong>Technical data</strong></p>
  <p>We have read the encoding of the file and set it to <code>iso-8859-1</code>. The line breaks in the file are set to <code>CRLF, LF</code>. But even if we write the contents of the file into a new one, with uniform line breaks and different coding, the error remains the same.</p>
  <p>We are currently using CiviCRM 5.36.xx on Drupal with, among others, CiviBanking and CiviSEPA.</p>
  <p>We saw a <a href="https://civicrm.stackexchange.com/questions/22748/civibanking-no-valid-booking-date-detected-not-imported">related StackExchange post</a> but it seems like that was a different issue.</p>
  <p><strong>The csv file</strong></p>
  <pre><code>&quot;VR-Bank Altenburger Land eG / Deutsche Skatbank&quot;
  
  &quot;Umsatzanzeige&quot;
  
  &quot;BLZ:&quot;;&quot;12345678&quot;;;&quot;Datum:&quot;;&quot;12.02.2021&quot;
  &quot;Konto:&quot;;&quot;1234567&quot;;;&quot;Uhrzeit:&quot;;&quot;15:48:21&quot;
  &quot;Abfrage von:&quot;;&quot;Anne Anne&quot;;;&quot;Kontoinhaber:&quot;;&quot;Otto Otto&quot;
  
  &quot;Zeitraum:&quot;;;&quot;von:&quot;;&quot;05.02.2021&quot;;&quot;bis:&quot;;
  &quot;Betrag in EUR:&quot;;;&quot;von:&quot;;&quot; &quot;;&quot;bis:&quot;;&quot; &quot;
  &quot;Sortiert nach:&quot;;&quot;Buchungstag&quot;;&quot;absteigend&quot;
  
  &quot;Buchungstag&quot;;&quot;Valuta&quot;;&quot;Auftraggeber/Zahlungsempfänger&quot;;&quot;Empfänger/Zahlungspflichtiger&quot;;&quot;Konto-Nr.&quot;;&quot;IBAN&quot;;&quot;BLZ&quot;;&quot;BIC&quot;;&quot;Vorgang/Verwendungszweck&quot;;&quot;Kundenreferenz&quot;;&quot;Währung&quot;;&quot;Umsatz&quot;;&quot; &quot;
  &quot;09.02.2021&quot;;&quot;09.02.2021&quot;;&quot;Otto Otto&quot;;&quot;Berta Berta&quot;;;&quot;DE12345678901234567890&quot;;;&quot;GENODEXXXXX&quot;;&quot;Blabla&quot;;;&quot;EUR&quot;;&quot;1,00&quot;;&quot;H&quot;
  &quot;08.02.2021&quot;;&quot;08.02.2021&quot;;&quot;Otto Otto&quot;;&quot;Chris Chris&quot;;;&quot;DE12345678901234567890&quot;;;&quot;GENODEXXXXX&quot;;&quot;Blabla&quot;;;&quot;EUR&quot;;&quot;1,00&quot;;&quot;H&quot;
  &quot;05.02.2021&quot;;&quot;05.02.2021&quot;;&quot;Otto Otto&quot;;&quot;Dora Dora&quot;;;&quot;DE12345678901234567890&quot;;;&quot;GENODEXXXXX&quot;;&quot;Blabla&quot;;;&quot;EUR&quot;;&quot;1,00&quot;;&quot;H&quot;
  &quot;05.02.2021&quot;;&quot;05.02.2021&quot;;&quot;Otto Otto&quot;;&quot;Emil Emil&quot;;;&quot;DE12345678901234567890&quot;;;&quot;GENODEXXXXX&quot;;&quot;Blabla&quot;;;&quot;EUR&quot;;&quot;1,00&quot;;&quot;H&quot;
  
  &quot;05.02.2021&quot;;;;;;;;;;&quot;Anfangssaldo&quot;;&quot;EUR&quot;;&quot;100,00&quot;;&quot;H&quot;
  &quot;09.02.2021&quot;;;;;;;;;;&quot;Endsaldo&quot;;&quot;EUR&quot;;&quot;104,00&quot;;&quot;H&quot;
  </code></pre>
  <p><strong>Configuration JSON</strong></p>
  <p>Some fields are not yet configured, this is simply because we did not get that far, as there were already these problems at the beginning.</p>
  <pre><code>{
    &quot;plugin_type_name&quot;: &quot;import&quot;,
    &quot;plugin_class_name&quot;: &quot;importer_csv&quot;,
    &quot;name&quot;: &quot;CSV Kontoauszug&quot;,
    &quot;description&quot;: &quot;Importiert CSV Kontoauszüge&quot;,
    &quot;weight&quot;: &quot;1000&quot;,
    &quot;config&quot;: {
      &quot;delimiter&quot;: &quot;;&quot;,
      &quot;encoding&quot;: &quot;iso-8859-1&quot;,
      &quot;skip&quot;: 11,
      &quot;header&quot;: 13,
      &quot;title&quot;: &quot;Test&quot;,
      &quot;defaults&quot;: [],
      &quot;rules&quot;: [
        {
          &quot;from&quot;: &quot;Buchungstag&quot;,
          &quot;to&quot;: &quot;booking_date&quot;,
          &quot;type&quot;: &quot;strtotime:d.m.Y&quot;
        },
        {
          &quot;from&quot;: &quot;Valuta&quot;,
          &quot;to&quot;: &quot;value_date&quot;,
          &quot;type&quot;: &quot;strtotime:d.m.Y&quot;
        },
        {
          &quot;from&quot;: &quot;Auftraggeber/Zahlungsempfänger&quot;,
          &quot;to&quot;: &quot;name&quot;,
          &quot;type&quot;: &quot;set&quot;
        }
      ]
    },
    &quot;state&quot;: []
  }
  </code></pre>
  <p>It would be really great if someone could help us with the appropriate plugin configuration or tips on the error message.</p>
  
Tags: <drupal><csv><civibanking>
Title: CiviBanking: CSV importer not reading the config as expected
ThreadText: # CiviBanking: CSV importer not reading the config as expected
  
  (Asked by: username_0 on 2021-04-24)
  
  Unfortunately, even after several attempts, we have not managed to configure the CiviBanking plugin so that the csv file can be imported. We use a file from "Deutsche Skatbank" but the importer is not reading our configuration as expected.
  Previous procedure
  At first, we followed the examples from Project60.
  But no matter what we do, we always get the message No valid booking date detected. Not imported! for all rows.
  Since we did not find any detailed documentation on the individual parameters, we looked directly at the code and tried to understand what was happening. According to our understanding, the skip specification should skip a number of lines during import, so that the code that gives the above mentioned error is not called for these lines at all. However, since the message appears for all lines and does not change even when the skip parameter is changed, we assume that there is a profound problem in the interpretation of the file.
  Technical data
  We have read the encoding of the file and set it to iso-8859-1. The line breaks in the file are set to CRLF, LF. But even if we write the contents of the file into a new one, with uniform line breaks and different coding, the error remains the same.
  We are currently using CiviCRM 5.36.xx on Drupal with, among others, CiviBanking and CiviSEPA.
  We saw a related StackExchange post but it seems like that was a different issue.
  The csv file
  "VR-Bank Altenburger Land eG / Deutsche Skatbank"
  
  "Umsatzanzeige"
  
  "BLZ:";"12345678";;"Datum:";"12.02.2021"
  "Konto:";"1234567";;"Uhrzeit:";"15:48:21"
  "Abfrage von:";"Anne Anne";;"Kontoinhaber:";"Otto Otto"
  
  "Zeitraum:";;"von:";"05.02.2021";"bis:";
  "Betrag in EUR:";;"von:";" ";"bis:";" "
  "Sortiert nach:";"Buchungstag";"absteigend"
  
  "Buchungstag";"Valuta";"Auftraggeber/Zahlungsempfänger";"Empfänger/Zahlungspflichtiger";"Konto-Nr.";"IBAN";"BLZ";"BIC";"Vorgang/Verwendungszweck";"Kundenreferenz";"Währung";"Umsatz";" "
  "09.02.2021";"09.02.2021";"Otto Otto";"Berta Berta";;"DE12345678901234567890";;"GENODEXXXXX";"Blabla";;"EUR";"1,00";"H"
  "08.02.2021";"08.02.2021";"Otto Otto";"Chris Chris";;"DE12345678901234567890";;"GENODEXXXXX";"Blabla";;"EUR";"1,00";"H"
  "05.02.2021";"05.02.2021";"Otto Otto";"Dora Dora";;"DE12345678901234567890";;"GENODEXXXXX";"Blabla";;"EUR";"1,00";"H"
  "05.02.2021";"05.02.2021";"Otto Otto";"Emil Emil";;"DE12345678901234567890";;"GENODEXXXXX";"Blabla";;"EUR";"1,00";"H"
  
  "05.02.2021";;;;;;;;;"Anfangssaldo";"EUR";"100,00";"H"
  "09.02.2021";;;;;;;;;"Endsaldo";"EUR";"104,00";"H"
  
  Configuration JSON
  Some fields are not yet configured, this is simply because we did not get that far, as there were already these problems at the beginning.
  {
    "plugin_type_name": "import",
    "plugin_class_name": "importer_csv",
    "name": "CSV Kontoauszug",
    "description": "Importiert CSV Kontoauszüge",
    "weight": "1000",
    "config": {
      "delimiter": ";",
      "encoding": "iso-8859-1",
      "skip": 11,
      "header": 13,
      "title": "Test",
      "defaults": [],
      "rules": [
        {
          "from": "Buchungstag",
          "to": "booking_date",
          "type": "strtotime:d.m.Y"
        },
        {
          "from": "Valuta",
          "to": "value_date",
          "type": "strtotime:d.m.Y"
        },
        {
          "from": "Auftraggeber/Zahlungsempfänger",
          "to": "name",
          "type": "set"
        }
      ]
    },
    "state": []
  }
  
  It would be really great if someone could help us with the appropriate plugin configuration or tips on the error message.
  
  **Tags:** drupal, csv, civibanking
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2021-06-30. Score: 2 | Accepted answer
  
  I faced the same problem and double-checked date settings in Civi. All well.
  
  My solution was to delete the "head" and "footer" rows from the csv file, marked yellow in this screenshot:
  [![screenshot csv](https://i.sstatic.net/dEZfn.jpg)](https://i.sstatic.net/dEZfn.jpg)
  
  The result is a clean csv spreadsheet with 1 row for header and a rows for every transaction. This file was imported as expected to CiviBanking.
  
  
  ---
  
  ### Answer by username_2 on 2022-02-02. Score: 3
  
  I encountered the same problem with very similar data and searched for the mistake longer then I would like to admit.
  To my big disappointment it was not caused by a wrong configuration per se, but by stupid copy-and-paste without thinking.
  Into the config-part on the web interface you should only copy the config-part of the json and not the 'name,description,weight,...'-part , i.e
  {
   "delimiter": ";",
   "encoding": "iso-8859-1",
   "skip": 11,
   "header": 13,
   "title": "Test",
   "defaults": [],
   "rules": [
     {
       "from": "Buchungstag",
       "to": "booking_date",
       "type": "strtotime:d.m.Y"
     },
     {
       "from": "Valuta",
       "to": "value_date",
       "type": "strtotime:d.m.Y"
     },
     {
       "from": "Auftraggeber/Zahlungsempfänger",
       "to": "name",
       "type": "set"
     }
   ]
  }
  
  I also found out that the 'skip' parameter denotes numbers of line to skip which is less important than the 'header' parameter which denotes the line number of the header in the csv. Setting the right 'header' and not setting the 'skip' parameter still worked for my case as civiBanking did not find the right information in those lines and skiped them automatically.
  Hope that helped. This is my first entry on any StackOverflow site.
  
  > **Comments:**
  > **username_1**: Great, thanx @username_2 ! In my GLS Bank case the solution was:   "skip": 15,   "header": 16,  
  
  ---
  
  