topic Re: Read files .DBI in QlikView

Read files .DBI

spividori — Tue, 17 May 2016 14:54:29 GMT

Hi.

I have some files with .DBI extension. Some of you can help me to read from qlikview.

Attached files.

Regards.

Re: Read files .DBI

spividori — Wed, 18 May 2016 11:21:24 GMT

please help, any ideas?

Regards.

Re: Read files .DBI

jerrysvensson — Wed, 18 May 2016 12:58:32 GMT

Google said:

DBI file is a Data Explorer Information. Data Explorer is a program you can use to manage BDP (Borland Data Provider) data sources and to browse the databases.

Re: Read files .DBI

Wed, 18 May 2016 13:17:29 GMT

Hi,

I have had a look at this and the files and am not sure that It can be done, as far as I can see the file types are not supported by qlikview, and when you try opening them in a text editor they are either encrypted, or do not actually contain any data and are instead system related files

Re: Read files .DBI

avinashelite — Wed, 18 May 2016 13:34:23 GMT

As per my knowledge , we need to convert this files to QV readable formats like CSV or excel etc than you need to feed the same for QV

Re: Read files .DBI

spividori — Wed, 18 May 2016 13:52:03 GMT

Hi.

Thanks for answering.

So I should get a program to open these files and then convert them.

Regards.

Re: Read files .DBI

Anil_Babu_Samineni — Wed, 18 May 2016 14:03:21 GMT

Hello,

I don' know which file is this.

Anyway, Is this .dbi is created from PERL / What?

Try to change .dbi to SQL / CSV Then try..

For reference, Please find This Link

https://www.experts-exchange.com/questions/21973815/DB-DBI-and-DBX-Files-to-CSV-or-SQL.html

Re: Read files .DBI

Wed, 18 May 2016 15:00:57 GMT

Yes that would be the way to go but where you would find a program to convert it I am usure

Re: Read files .DBI

spividori — Wed, 18 May 2016 20:50:55 GMT

Hi.

I changed the file extension to .xls, then opened with Excel and did so without problems, then "Save As" and save it as a file excel to read from qlikview.

Thanks everyone for your help.

Regards.

Re: Read files .DBI

Anil_Babu_Samineni — Thu, 19 May 2016 03:21:52 GMT

Sandro,

Wrote this..

And then he wrote something like below...

Note: What is the meaning of this???

Re: Read files .DBI

spividori — Thu, 19 May 2016 10:51:29 GMT

Hi.

I changed the file extension to .xls.

Then I open the file with the extension .dbi with the excel application.

Then I go to the menu and select "File," "Save As" and saved as an Excel file.

Then, from qlikview, I read this file excel.

My English is bad, sorry.

Regards.

Re: Read files .DBI

Wed, 11 Jan 2017 13:48:29 GMT

Hola Sandro, no encontraste otra forma que no sea renombrarlo a .xls?

Saludos

Re: Read files .DBI

spividori — Wed, 11 Jan 2017 15:20:48 GMT

Hola. No, tampoco seguí insistiendo porque me pasan los datos en excel.

Saludos.