Look at the date/time format ('%Y-%m-%dT%H:%M:%S'). Your data does
not match the import format. Either reformat your data to match this
format. Looking at your sample data, you could also change the format
to '%Y-%m-%d %H:%M:%S.%f'
Marc
On Mar 24, 1:43 pm, Philippe REGALL <philippe.reg...@gmail.com> wrote:
> 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 <null> type & value loaded into
> date column:
> ID/name date tag value
> id=13108 <null> 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.
