Insert a record (ISODate) to MongoDB

[莊興旺]

Dear all:

What could I do differently to achieve the target ?

thanks~

data (csv)

Leonardo,2015-09-02 12:36:15:
Michelangelo,2015-09-03 06:23:11:

configure

<source>
  type tail
  tag mongo
  path /home/vagrant/fluentd/data/*
  format csv
  keys user,date
  types user:string, date:string
  pos_file /home/vagrant/fluentd/pos_file/temp.pos  
</source>

<match forward1.**>
...

  type mongo
  host localhost
  port 27017
  database test
  collection foo
</match>

MongoDB Query Document
current

> db.foo.find() 
{ "_id" : ..., "user" : "Leonardo", "date" : "2015-09-02 12:36:15:" , "time" : ISODate("2015-09-17T05:42:15Z")}
{ "_id" : ..., "user" : "Michelangelo", "date" : "2015-09-03 06:23:11:", "time" : ISODate("2015-09-17T05:42:15Z") }

target

> db.foo.find()
{ "_id" : ..., "user" : "Leonardo", "date" : ISODate("2015-09-02T12:36:15Z") , "time" : ISODate("2015-09-17T05:42:15Z")}
{ "_id" : ..., "user" : "Michelangelo", "date" : ISODate("2015-09-03T06:23:11Z"), "time" : ISODate("2015-09-17T05:42:15Z") }

PS:  In fact , there are a lot of  "date"  fields  in my really data (date1, date2, date3...).

[Mr. Fiber]

Do you mean you want to convert all time fields into ISOData type in mongodb?

Masahiro

--
You received this message because you are subscribed to the Google Groups "Fluentd Google Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to fluentd+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[莊興旺]

Dear Masahiro:

  Yes, I want to convert all time fields into ISOData type in mongodb.

   thank you ~ 

repeatedly於 2015年9月18日星期五 UTC+8下午9時43分02秒寫道：

[Abhi Chaudhari]

I am also having the same requirement , can someone please help to convert fields to ISO date format