DB Extractor

Hi ​@Pablo Palacios,

Mind sharing what "hasn't worked" means in terms of any error messages when starting it, log file info, etc?

FWIW, it's one of our work horses, so we know it works in most cases. And many of the on-premises systems run Windows 11, so without more info I can't even begin to speculate on a better response than "works on my system" (J/K!)

Hello:
We are using the extractor to extract data from Excel spreadsheets, same Excel file, same folder, everything is the same in terms of configuration of the YML file, the service runs without problems in Windows 10 and not in Windows 11, it does not generate any log at the config.yml level.
I share a part of the config.yml

  data-set:
    id: 1243781567353350  #dataset sx5
    #id: 6208043143431882  #dataset sx5_events

databases:
  - 
    type: spreadsheet
    name: "SAT_DBexcel"
    path: "C:\\Users\\ppalacios\\Documents\\Proyectos DPA\\RA Software\\FT DataMosaix\\SQM SX5\\SAT\\SAT- OT-12582 SX5.xlsx"
    #path: "C:\Compartida\A-PROYECTOS DPA\SQM\SX5\12852 Programacion Planta SX5\SAT- OT-12582 SX5.xlsx"

queries:

  - 
    name: "VDF_query"
    database: "SAT_DBexcel"
    sheet: "P_VSD"
    skip_rows: 7        #Specify the number of rows to be skipped when reading a spreadsheet.
    query:  
      "SELECT * FROM P_VSD"               
    destination:
      type: "raw"
      database: "SX5"
      table: "SAT_VDF"
    primary-key: "{row_number}"   

Hi again Pablo,

If you haven’t already, would you mind configuring the logging functionality (debug logging) for the extractor, and try again? Then upload a sanitized version of the log here?

In the config file:

logger:
  # Logging to file. Remove or comment out to disable file logging
  file:
    level: DEBUG
    path: "/path/to/file.log"

    # (Optional) Log retention (in days).
    #retention: 7

Thanks Rogelio for answering
I have version 3.5.0 installed. I'll try the version you mentioned and let you know.

​@Pablo Palacios were you able to try out the latest version 3.6.0? If yes, can you please provide an update?