topic Re: Access TNG Telephone Management Database in QlikView

Access TNG Telephone Management Database

Mon, 16 Sep 2013 12:31:50 GMT

Hi Guys

has anyone got it right to access the TNG database file via QlikView?

TNG is a database for a telephone management system

Re: Access TNG Telephone Management Database

Gysbert_Wassenaar — Mon, 16 Sep 2013 14:34:22 GMT

If you're talking about this TNG then there is no database. According to the user manual you can export to csv.

Re: Access TNG Telephone Management Database

Mon, 16 Sep 2013 17:00:42 GMT

Hello

I actually found the following:

Under c:\Program Files (x86)\datatex\tng\export\*.txt]

...the is a whole lot of TXT files.

You can import them into QlikView by setting up the following:

LOAD @1 as 'Unique ID',

     @2 as CallDate,

     @3 as Ext,

     @4 as 'Name and Surname',

     //@5,

     @6 as 'department',

     @7 as number,

     @8 as DIDdigits,

     @9 as Destination,

     @10 as IncomingOutgoing,

     @11 as Duration,

     @12 as TrunkLine,

     @13 as Action,

     @14 as Pulse,

     @15 as Costingunit,

     @16 as 'Ring Time',

     @17 as AccountCode,

     @18 as Cost,

     @19 as Reference,

     @20 as 'Private or Busiiness',

     @21 as Phonebook,

     @22 as category,

     @23 as TrunkName,

     @24 as AccountName,

     @25 as ratebook,

     @26 as CallType,

     @27 as BranchCode,

     @28 as Price,

     @29 as MyLink

FROM

[\\hostname\c$\Program Files (x86)\datatex\tng\export\*.txt]

(txt, utf8, no labels, delimiter is '|', msq);

CALLS2:

NoConcatenate

LOAD [Unique ID],

     CallDate,

     num(month(CallDate)) as 'Month',

     year(CallDate) as Year,

     Ext,

     [Name and Surname],

     department,

     number,

     DIDdigits,

     Destination,

     IncomingOutgoing,

     Duration,

     TrunkLine,

     Action,

     Pulse,

     Costingunit,

     [Ring Time],

     AccountCode,

     Cost,

     Reference,

     [Private or Busiiness],

     Phonebook,

     category,

     TrunkName,

     AccountName,

     ratebook,

     CallType,

     BranchCode,

     Price,

     MyLink





resident CALLS;

drop table CALLS;

rename table CALLS2 to CALLS;

Re: Re: Access TNG Telephone Management Database

Gysbert_Wassenaar — Mon, 16 Sep 2013 17:20:14 GMT

Ok, so it's not csv, but psv (pipe separated values)

You don't need an extra resident load if all you want to do is calculate some extra fields.

LOAD @1 as 'Unique ID',
@2 as CallDate,

num(month(@2)) as Month

    year(@2) as Year
    @3 as Ext,
    @4 as 'Name and Surname',
    @6 as 'department',
    @7 as number,
    @8 as DIDdigits,
    @9 as Destination,
    @10 as IncomingOutgoing,
    @11 as Duration,
    @12 as TrunkLine,
    @13 as Action,
    @14 as Pulse,
    @15 as Costingunit,
    @16 as 'Ring Time',
    @17 as AccountCode,
    @18 as Cost,
    @19 as Reference,
    @20 as 'Private or Busiiness',
    @21 as Phonebook,
    @22 as category,
    @23 as TrunkName,
    @24 as AccountName,
    @25 as ratebook,
    @26 as CallType,
    @27 as BranchCode,
    @28 as Price,
    @29 as MyLink
FROM
[\\hostname\c$\Program Files (x86)\datatex\tng\export\*.txt]
(txt, utf8, no labels, delimiter is '|', msq);

Re: Access TNG Telephone Management Database

Mon, 16 Sep 2013 17:27:23 GMT

Hello, you are right. Was playing with code, did a CTRL+ A and pasted…oops

Re: Access TNG Telephone Management Database

Mon, 16 Sep 2013 17:27:36 GMT

Hello, you are right. Was playing with code, did a CTRL+ A and pasted…oops