topic problem loading data from dbf in QlikView

problem loading data from dbf

Wed, 27 Jul 2011 10:32:05 GMT

Hello.

I try to load data from dbf file (FoxPro)

but have 2 problems

1) when loading data from table "filed id problem double" there are filds - id -'customer id' and descr-'customer name'

in sourse table -every thing is ok- every customer has a unic name, but when Ioad data to QlikView with FoxPro driver - something changes

and some customers have the same id (see attached application test id).

2) I when loading data from table 'filed doesn't load sp1279' in QlikView there is no filed sp1279...

see application test field

Re: problem loading data from dbf

Miguel_Angel_Baeyens — Wed, 27 Jul 2011 11:20:33 GMT

Hello Alexander,

If you do a preview of table 'filed doesn't load sp1279', field sp1279 is empty, so the script is working just fine. So where is the problem? Can you please elaborate?

EDIT: Field sp1279 is empty in both tables.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: problem loading data from dbf

Wed, 27 Jul 2011 12:33:38 GMT

if you open dbf table with another viewer, then you will see the filed

see attachment

Re: problem loading data from dbf

Thu, 28 Jul 2011 14:17:12 GMT

we found several ways to solve this problem

1) To create small dbf with another charset that driver understand

2) to reload dbf file to a txt and load data from there- them there is no problem.

but we a still looking for another driver..

Re: problem loading data from dbf

Wed, 03 Aug 2011 07:40:09 GMT

The problem was in field id.

we loaded id '2e2' then the value was loaded to exponetional 2,00E+01 and then transfered to '20',

anothe id had value '20' and QV combunet 2 ids into 1.

so the solution was to load id as text.

see attached file.

Re: problem loading data from dbf

agigliotti — Thu, 27 Feb 2014 16:12:52 GMT

what version of visual fox pro (VFP) do you have ?

i'm trying to read .dbf database table of VPF 9 but the odbc driver asking me for .dbc file (

SQL##f - SqlState: S1000, ErrorCode: 171, ErrorMsg: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file d:\vfoxprotest\anagrafe\private.dbc.

SQL select * From `anagrafe.DBF`

)

I don't have .dbc file but only .dbf, .fpt and .cdx

Can you help me ?

Thanks

Regards