Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Can QV read finger print data file which end with dat ?

Hi All

I just purchase a finger print device , each staff when come in office , they must use their finger to let the machine record when their arrive at office , and the device provide me 3 data file . and the data file will be copy to computer , and the finger print device provide the software which able to convert the 3 row data file into 1 excel file.

my question is can QV directly read the raw data file ? So that user don't need to convert it into excel file.

enclosed one of the data file for your ref.

Paul

1 Solution

Accepted Solutions
sokkorn_cheav
Honored Contributor

Re: Can QV read finger print data file which end with dat ?

Hi Mr. Paul,

Just download your attached file and test with my QlikView. It simple

[Att]:

LOAD

     @1,

     @2,

     @3,

     @4,

     @5,

     @6

FROM

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

Can you tell me which is the problem you faced?

Regards,

Sokkorn

4 Replies
sokkorn_cheav
Honored Contributor

Re: Can QV read finger print data file which end with dat ?

Hi Mr. Paul,

Just download your attached file and test with my QlikView. It simple

[Att]:

LOAD

     @1,

     @2,

     @3,

     @4,

     @5,

     @6

FROM

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

Can you tell me which is the problem you faced?

Regards,

Sokkorn

jonasheisterkam
Contributor III

Re: Can QV read finger print data file which end with dat ?

It is a csv-file wth tab as seperator. You can load it with.

LOAD @1,

     @2,

     @3,

     @4,

     @5,

     @6

FROM

[1_attlog finger print]

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

Not applicable

Re: Can QV read finger print data file which end with dat ?

Yes it work fine. many thank for both of your help. But i have 2 more file which is not able to load in to QV.

sokkorn_cheav
Honored Contributor

Re: Can QV read finger print data file which end with dat ?

Hi Mr. Paul,

Can you share those files?

Regards,

Sokkorn

Community Browser