CloverETL is now CloverDX - Learn Why

How to read XLSB

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

aposkala2
Posts: 2
Joined: Wed Mar 07, 2018 9:05 am

How to read XLSB

Postby aposkala2 » Wed Mar 07, 2018 9:23 am

Hello,

Is there a component that can read XLSB files?

bartonv
Posts: 87
Joined: Wed May 03, 2017 12:10 pm

Re: How to read XLSB

Postby bartonv » Wed Mar 07, 2018 2:41 pm

Hello Aposkala2,
unfortunately, reading XLSB files is not supported in CloverETL Designer. However, there are a couple of workaround solutions how to handle this situation. Attached is an example graph which demonstrates one of the possible options that involves converting the XLSB file to a CSV file with Libre Office command line tool. The main idea is the following:
  1. Converting the XLSB file to a CSV file headlessly
  2. Extracting the CSV filename and sending the respective file URL to FlatFileReader
  3. Reading the CSV file by using FlatfileReader
Please note that the graph file uses parameter values related to my local environment. In order to make the graph work on your side, make sure to adjust the parameters accordingly.
Kind regards,
Attachments
XLSBReading.zip
(10.9 KiB) Downloaded 48 times
---
Vladimir Barton
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com

aposkala2
Posts: 2
Joined: Wed Mar 07, 2018 9:05 am

Re: How to read XLSB

Postby aposkala2 » Thu Mar 08, 2018 11:10 am

Hi Bartonv,

Thanks for the answer.

I adjusted some parameters, I get an error though saying that it does not recognize the user-defined FLAT_FILE_READER?

Any insight on that?

Thanks in advance,
Apostolos

bartonv
Posts: 87
Joined: Wed May 03, 2017 12:10 pm

Re: How to read XLSB

Postby bartonv » Tue Mar 13, 2018 1:45 pm

Hi Apostolos,
feel free to review the attachment (an older version of the same sample graph) which should be compatible with older versions of CloverETL Designer. Another option would be to simply replace the FlatFileReader component with its predecesor - UniversalDataReader. Finally, a recommended option is to download a newer version (or ideally our latest 4.8.1 version) of the Designer from our website and test the original example there.
Kind regards,
Attachments
XLSBReading_original.zip
(10.16 KiB) Downloaded 47 times
---
Vladimir Barton
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com