CSV Import & Time

[JCStewart]

Hi all -

I've got an issue with trying to import some login times for my staff with PP. The file format is as below and is saved as a .txt file:

Agent Name,Extn,Login Time,Logout Time,Logout Date,Logout Reason,Skill 1,Skill 2,Skill 3,Skill 4,Skill 5,Skill 6,Skill 7,Skill 8,Skill 9,Skill 10,Skill 11,Skill 12,Skill 13,Skill 14,Skill 15
Adib,2896,8:10a.m.,4:44p.m.,28/01/2014,0,66,2,4,3,617,618,616,0,0,0,0,0,0,0,0
Brian,2870,11:15a.m.,9:00p.m.,28/01/2014,0,66,2,4,3,617,618,616,0,0,0,0,0,0,0,0
Chamil,2568,8:05a.m.,4:44p.m.,28/01/2014,0,66,2,4,3,616,617,618,0,0,0,0,0,0,0,0
Falcon,2854,12:41p.m.,9:03p.m.,28/01/2014,0,66,11,2,4,3,617,618,616,0,0,0,0,0,0,0
Jacqui,2543,8:10a.m.,7:03p.m.,28/01/2014,0,66,11,3,2,4,616,0,0,0,0,0,0,0,0,0
Jesto,2572,8:21a.m.,5:03p.m.,28/01/2014,0,66,2,4,3,617,618,616,0,0,0,0,0,0,0,0
Lavanya,2865,8:09a.m.,5:23p.m.,28/01/2014,0,66,3,2,4,616,617,0,0,0,0,0,0,0,0,0
Miriama,2273,10:28a.m.,7:11p.m.,28/01/2014,0,66,3,2,4,616,0,0,0,0,0,0,0,0,0,0
Molly,2863,10:19a.m.,9:25p.m.,28/01/2014,0,66,11,2,4,3,617,618,616,0,0,0,0,0,0,0
Mostafa,2861,8:17a.m.,4:48p.m.,28/01/2014,0,66,2,4,3,617,618,616,0,0,0,0,0,0,0,0
Patrice,2285,9:21a.m.,6:12p.m.,28/01/2014,0,66,11,3,2,4,616,0,0,0,0,0,0,0,0,0
Yadira,2542,12:42p.m.,12:46p.m.,28/01/2014,0,66,2,4,3,617,618,616,0,0,0,0,0,0,0,0

The only data I need from the above is the name and the login time (not the logout time). When I first link the report to PP, it imports fine. The issue however is when I edit the Login Time column to show the time in decimal and if the file is update, I get the following error when trying to refresh:

We couldn’t refresh the connection. Please go to existing connections and verify they connect to the file or server.

I assume I have to have the time in decimal so that the pivottable can show me the time rather than just a "1" for count (I can't do MIN while the format in PP is no decimal).

What am I doing wrong here?


Thanks in advance,


James