Extract / import blob Cube

Sandra Bartl

Dear Community - this question is coming from @Oliver Etterli, can anyone help?

 

We are using a specific blob cube to save excel files on it. I created a procedure to extract the cube to a specific folder. It saves the normal txt. file and also the uploaded excel files. Now I want to import the cube (in our case from the prod to the test-system) including the excel file within a procedure. Is it possible to import the excel files using an ASCII Data Reader or is the another possibility to import them?

 

Board version 10.6

Revision: 1.5.41077

 

Thank you in advance

 

Best regards,

 

Freundliche Grüsse

Oliver Etterli

 

------------------------------------------------------------

Fachhochschule Nordwestschweiz FHNW

Services

------------------------------
Sandra Bartl
Community Manager
------------------------------

Brendan Broughton

HI @Oliver Etterli
Yes, I believe it will be. I have loaded pdf's (created by Broadcast in BOARD) back into a Blob cube with an ascii reader, so I would think it is possible with xlsx files too.

Without going back and looking at how I did it, if I remember correctly you will need a txt/csv file with the path/file as one of the columns (and the blob cube dimensions as the other)..you load the file in your ascii reader, with the path/file field mapped to the 'CUBE' in your datareader.  

I think I probably created my own layout extract to create the ascii file so that I could add the relevant path (as the file name was already in BOARD).  So you'll just need to work out how to create this ascii file extract from BOARD with the file names in it.

If you can't work it out let me know and I'll go and have a look at the old DB I did this on (it was in an earlier version of 10, so I assume it will still work in 10.6)

Cheers
Brendan

------------------------------
Brendan
bbroughton@bi5.com.au
Australia
------------------------------
-------------------------------------------

Oliver Etterli

Hi @Brendan Broughton

Thank you for you answer. The ectract of the cube saves me a txt/csv file with the cube dimension including the path of the excel files:  

I created a data reader with the three columns with the path information mapped to the cube:

Do I have to configure something else that BOARD is uploading the excel files into the cube as it doesn't work with just the path in the cube columns.

Thank you in advance

Cheers,

Oliver

------------------------------
Oliver Etterli
BI Specialist
Fachhochschule Nordwestschweiz FHNW
Switzerland
------------------------------
-------------------------------------------

Brendan Broughton

Hi @Oliver Etterli

As I mentioned below, I created my own export layout. I didn't just 'extract cube', I'm not sure if there's a difference and that's the issue you're having. Instead I created a layout which had the required fields and extracted that. I was able to do this as I was using BOARD to create the files in the first place, so I had the list of names.

I used export layout and it worked so perhaps try that.  

It was these two steps

The export was of a cube that had the name of the file stored in text, by the same dimensions as the cube I wanted to load the PDF into. If you don't have the list of file names in BOARD to export, perhaps you'll need to extract the cube you have, and then read the names back in to a text cube, and then create the export.  I'm not sure if BOARD treats a cube extract and layout export differently when using them to load.

The export created the below csv

and the Datareader set up as below

the D6 is just concatenating a network path to the file name that came from the export extract. E6 was just formatting the date so it could be read

I've tested it just now (on the old B10.3 where its still sitting) and it's loaded a pdf into the cube so it is working.

Hopefully that helps

------------------------------
Brendan
bbroughton@bi5.com.au
Australia
------------------------------
-------------------------------------------