PB with some Data_type importing with ODBC link in QLIKVIEW

bati_taf
bati_taf Member Posts: 6
edited 2013-03-20 in NAV/Navision Classic Client
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:

130304114926117565.jpg

When I tried to view data in Qlikview

130304115026486875.jpg

130304115101443843.jpg

When I import, I have no error message.

13030411512813516.jpg

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)

Comments

  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    You have to be careful which version (32bit/64bit) of ODBC driver you use. Please have a look at your QlikView help (topic "connect"). There should be a table containing the connect statement you have to use depending on your current system setup.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • bati_taf
    bati_taf Member Posts: 6
    Hello einsTeIn.NET,

    Thanks for your answer. My server, and client are in 32bits, I used the 32 bits odbc driver.
    I search in the QLIKVIEW HELP, and try to connect with connect32 option, for the same result.

    Thanks for your help,
  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    In your ODBC driver setup, what did you set-up in "Option Field Type" and in "Language"?
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • bati_taf
    bati_taf Member Posts: 6
    This is my configuration:

    130306045216856332.jpg

    So strange, but in Excel when I use this ODBC driver i have no problem all is working (I can export data with type "TEXT", but in QLIKVIEW, it's not working (I can export all data except fiel whith data "TEXT" :(

    Thanks,
  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    Try to use Option Field Type Integer instead.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • bati_taf
    bati_taf Member Posts: 6
    I tried with integer for the same result :(
  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    Are you sure that you use the correct ODBC version for your database?
    Maybe a restart helps to apply your settings?
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • bati_taf
    bati_taf Member Posts: 6
    Hello,

    I try to reboot without more sucess, always the same problem.
    I'm sure I used the good ODBC driver (NODBC V4.0 SP3). This driver work perfectly in Excel. I have only problem in Qlikview :(
  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    Strange! We use it in NAV 3.60. No problem so far. Can't believe that it don't work in higher version. :-k I'll test it next week and give you a feedback.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    For me it works like a charm. I can even use Type Text for Option Fields and it shows the correct equivalent.

    Are you sure your NODBC driver has the same Build No. than your client? I use 23305.
    "Money is likewise the greatest chance and the greatest scourge of mankind."

Categories