To prevent spam users, you can only post on this forum after registration, which is by invitation. If you want to post on the forum, please send me a mail (h DOT m DOT w DOT verbeek AT tue DOT nl) and I'll send you an invitation in return for an account.

timestamp not recognized in CSV file

lauraUnivpm
lauraUnivpm
edited February 2014 in - Usage

Hello,

I'm new in this forum and I would ask you for some help. I'm trying to covert a very simple CSV file in a log format to analyze it with Prom. I've imported it in Prom and then I've tried the key/value convert to log plugin, but it seems that it can't recognize the timestamp field, i.e. in the final log there isnt't the timestamp field (and if I try to inspector the log in Prom it says "no-timestamp" in in the Inspector view). The content of csv file is :



CaseID;EventID;TransactionLifecycle;Timestamp

1;Activity1;complete;2005-10-24 9:05

1;Activity2;complete;2006-10-24 9:06

1;Activity3;complete;2007-10-24 9:07

1;Activity4;complete;2008-10-24 9:08



I've also tried PromImport and its result is very strange: it adds the timestamp, but it is fixed to "1970-01-01T01:00:00.000+01:00" for all instances.

Can you help me? Where I'm wrong?

Thank you very much
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories