topic Re: Problem with some Data_type when importing with ODBC link in QlikView

Problem with some Data_type when importing with ODBC link

Sun, 03 Mar 2013 17:45:51 GMT

Hello all,

I just began using the Personnal version of Qlikview.

I was able to connect my Qlikview with my Microsoft Navision Dynamics (which is in C/SIDE, native database) with the ODBC connector.

I also was able to import part of my data without problem (data type = Code)

My problem : for some fields who are in navision in these two formats, "Option" and "Text" it did not work:

When I tried to view data in Qlikview

I have no data in Qlikview, whereas in the navision table I have data. I don't understand why?

I think I forgot to do something, I'm a beginner in Qlikview with ODBC connection.

I tested my odbc connector in Excel and It's working, I was able to have all data in all type of data (Text or Option).

Thanks in advance for your answer (and sorry if it's very simple, i searched on the web without success)

Re: Problem with some Data_type when importing with ODBC link

pljsoftware — Mon, 04 Mar 2013 00:10:34 GMT

Hi Bati,

try to load one field per time, and test when you have the error.

Try to cast the data, e.g. Text(MyFieldData) as MyFieldData

I hope this can help you

Regards

Luca Jonathan Panetta

PLJ Software

Re: Problem with some Data_type when importing with ODBC link

Mon, 04 Mar 2013 06:44:57 GMT

Hello Luca, thanks for your quick answer,

I tried to load only one field per time and I have no error. During the script execution, it show me that it arrived to load the exact number of line, but always no data.

I tried to load my field like

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

SET ThousandSep=' ';

SET DecimalSep='.';

SET MoneyThousandSep=' ';

SET MoneyDecimalSep='.';

SET MoneyFormat='# ##0.00 €;-# ##0.00 €';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY';

SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

ODBC CONNECT TO [ODBC_T2;DBQ=C:\DOCUME~1\bal\LOCALS~1\Temp\8\];

//-------- Start Multiple Select Statements ------

PAYS:

LOAD //"Code" as "Code pays",

Name;

SQL SELECT //"Code",

Name

FROM "Country";

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

Without success too, no error message but no data. With other fields with other data typse, I have no problem, I received all the data.

Another idea? Idon't understand where I made a mistake, or which parameter I have to change

Re: Problem with some Data_type when importing with ODBC link

pljsoftware — Wed, 06 Mar 2013 09:41:34 GMT

Hi Bati,

try to define an ODBC source in Windows by Control Panel > Data Source.

Afther try to use that connection

ODBC CONNECT TO MyNewSource;

Table:

Load *;

SQL Select *

From Country;

To exclude problems on QVW file create a new QVW to make this new test.

Regards

Luca Jonathan Panetta

PLJ Software

Re: Problem with some Data_type when importing with ODBC link

Wed, 06 Mar 2013 10:36:10 GMT

Hello Luca,

Thanks to try to help me, I have tried what you said with same result. On the picture, we can see that ODBC return me no data for the type "String".

Here, there is a picture of my Navision table.

We can see that when there is no data in my navision table, in QLIKVIEW my field "Name" is blank and when there is data he don't return me the value of the field but the caracter "-"? Why?

Thanks for your help,

Re: Problem with some Data_type when importing with ODBC link

pljsoftware — Fri, 08 Mar 2013 16:06:41 GMT

Hi Bati,

can I know what DB do you use?

Try to see the data preview (Aperçu), this to know if Qlikview read correctly the data.

Regards

Luca Jonathan Panetta

PLJ Software

Re: Problem with some Data_type when importing with ODBC link

Sat, 09 Mar 2013 07:29:16 GMT

Hi Luca,

My DB is the native Microsoft Dynamcis Navision database (C/SIDE). With the same ODBC connector, in Excel I have all data in preview and in QLIKVIEW, it doesn't show any data in the field where the data_type is SQL_CHAR.

In Qlikview

In my Navision Database

Re: Problem with some Data_type when importing with ODBC link

pljsoftware — Sat, 09 Mar 2013 14:51:43 GMT

Hi Bati,

have you tried to use OLE DB connection?

You can try to connect others SQL tools by ODBC to check if you have the same problem that you have in Qlikview. I recommend you Squillel SQL

Regards

Luca Jonathan Panetta

PLJ Software