Re: Where are the call tickets?
Posted: 24 May 2021 05:30
Hi!
I have a set of TAXA files that I need to somehow convert so that I can upload them to a Database.
Following this thread and others I understand the way to convert the files is (1) either using "accview" or (2) renaming the .dat into .z + unzip.
The problem is that I don't have the needed Software to run "accview" on the files and when trying to rename to .z or .zip + unzip, I always get an error.
Is there any way I can understand the meaning of the TAXA files?
This is what I have:
#TicketVersion,1,5,L,CalledNumber,6,35,L,ChargedNumber,36,65,L,ChargedUserName,66,85,L,ChargedCostCenter,86,95,L,...
My understanding is that 1 column is made up of groups of 4 items from above. For example:
- COLUMN 1: TicketVersion,1,5,L
- COLUMN 2: CalledNumber,6,35,L
- COLUMN 3: ChargedNumber,36,65,L
- COLUMN 4: ChargedUserName,66,85,L
- ...
meaning (as per the info I could find here and there) "Column name, initial position, end position, type of data (L, N, R... not sure about this).
Can you please help me convert this so that I can kind of automatically upload the data into a DB?
Many thanks!
Regards,
Cristina.
I have a set of TAXA files that I need to somehow convert so that I can upload them to a Database.
Following this thread and others I understand the way to convert the files is (1) either using "accview" or (2) renaming the .dat into .z + unzip.
The problem is that I don't have the needed Software to run "accview" on the files and when trying to rename to .z or .zip + unzip, I always get an error.
Is there any way I can understand the meaning of the TAXA files?
This is what I have:
#TicketVersion,1,5,L,CalledNumber,6,35,L,ChargedNumber,36,65,L,ChargedUserName,66,85,L,ChargedCostCenter,86,95,L,...
My understanding is that 1 column is made up of groups of 4 items from above. For example:
- COLUMN 1: TicketVersion,1,5,L
- COLUMN 2: CalledNumber,6,35,L
- COLUMN 3: ChargedNumber,36,65,L
- COLUMN 4: ChargedUserName,66,85,L
- ...
meaning (as per the info I could find here and there) "Column name, initial position, end position, type of data (L, N, R... not sure about this).
Can you please help me convert this so that I can kind of automatically upload the data into a DB?
Many thanks!
Regards,
Cristina.