Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

problem loading data from dbf

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: problem loading data from dbf

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.

5 Replies
MVP
MVP

Re: problem loading data from dbf

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

Not applicable

Re: problem loading data from dbf

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

see attachment

Not applicable

Re: problem loading data from dbf

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..

Not applicable

Re: problem loading data from dbf

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.

agigliotti
Honored Contributor II

Re: problem loading data from dbf

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

Community Browser