Hi Philippe,
try this,
import 'datetime' on the preamble
- import: datetime
import transform for uploading '2011-03-22 10:10:21.812274' style
datetime(omit milliseconds)
import_transform: lambda
x:datetime.datetime.strptime(x.split(".")[0], "%Y-%m-%d %H:%M:%S")
or if you want current datetime,
import_transform: lambda x:datetime.datetime.today()
hope this might help,
Pomu
2011/3/25 Philippe REGALL :
> How to upload date/time csv data in google app engine with bulkloader
> tool ?
>
> For example, I uploaded a csv file:
> date,tag,value
> 2011-03-22 10:10:21.812274,abacus,abaque
>
> but in the datastore viewer I have a type & value loaded into
> date column:
> ID/name date tag value
> id=13108 abacus abaque
>
>
> My bulkloader.yaml looks like:
>
> python_preamble:
> - import: base64
> - import: re
> - import: google.appengine.ext.bulkload.transform
> - import: google.appengine.ext.bulkload.bulkloader_wizard
> - import: google.appengine.ext.db
> - import: google.appengine.api.datastore
> - import: google.appengine.api.users
>
> transformers:
> - kind: StoredData
> connector: csv
>
> property_map:
>
> - property: date
> external_name: date
>
> # Type: Date/Time Stats: 11 properties of this type in this kind.
> import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
> export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')
>
> - property: tag
> external_name: tag
> # Type: String Stats: 11 properties of this type in this kind.
>
> - property: value
> external_name: value
> # Type: String Stats: 11 properties of this type in this kind.
>
>
> => How to upload date/time value from my csv file ?
>
> In fact, I don't mind if it is an auto generated date/time when
> uploading.
>
>
> Many thanks in advance.
>
> Philippe R
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
