Hi Nick!
thanks for the post dear,
yes I did try to send in an example date..and it gave back that same
string and said that the format did not match, and it inserted an
extra set of Inverted quotes..
I have a feeling it's something to do with my CSV file...
here is the code..
***loaders.py******
import datetime
from google.appengine.ext import db
from google.appengine.tools import bulkloader
import models
class BookLoader(bulkloader.Loader):
def __init__(self):
bulkloader.Loader.__init__(self, 'Book',
[('title', str),
('author', str),
('copyright_year', str),
('author_birthdate', lambda x:
datetime.datetime.strptime(x, '%m/%d/%Y').date()),
])
loaders = [BookLoader]
*****models.py*******
from google.appengine.ext import db
class Book(db.Model):
title = db.StringProperty()
author = db.StringProperty()
copyright_year = db.StringProperty()
author_birthdate = db.DateProperty()
******new_delzad.csv *******
title author copyright_year author_birthdate
app_en Delzad 2010 12/25/2012
****** ERROR MESSAGE******
File "/usr/lib/python2.6/_strptime.py", line 325, in _strptime
(data_string, format))
ValueError: time data "'author_birthdate'" does not match format '%m/
%d/%Y'
[INFO ] Backing off due to errors: 1.0 seconds
[INFO ] An error occurred. Shutting down...
[ERROR ] Error in WorkerThread-0: time data "'author_birthdate'"
does not match format '%m/%d/%Y'
these inverted commas, which i have entered in the loaders.py is the
format which I am specifying right?
the csv file in Excel spreadsheet does not contain any inverted
commas...
so this kind of leaves me a bit baffled..where could I be going wrong?
can i just remove the strptime thing and add just a simple date
format?
thanks dear
regards
Delzad
On Apr 14, 3:09 pm, "Nick Johnson (Google)" <nick.john...@google.com>
wrote:
> Hi Delzad,
>
> Can you provide sample data? Have you tried passing an example date directly
> to datetime.datetime.strptime with that format string, to see if it works?
>
> -Nick Johnson
>
>
>
> On Wed, Apr 14, 2010 at 1:00 AM, Delzad <delzad.da...@gmail.com> wrote:
> > Hi there!
>
> > Bit confused about the data stores ability to take in data.
>
> > i'm trying to upload a data value in the format, %m/%d/%Y, but i keep
> > getting the error message: ValueError: time data 'Date' does not match
> > format '%m/%d/%Y'.
>
> > My CSV file contains data in this exact same format.
>
> > here is the main bit of my loader file.
>
> > class loaders(bulkloader.Loader):
> > def __init__(self):
> > bulkloader.Loader.__init__(self, 'New_aviva',
> > [('Date',lambda x:
> > datetime.datetime.strptime(x, '%m/%d/%Y').date()),
> > ('Open', int),
> > ('high', int),
> > ('low', int),
> > ('close', int),
> > ('volume', int),
> > ('adjclose', int)
> > ])
>
> > Although I have managed to fix this error...if I take in the date
> > property as a STRING, it works just fine, but then I have issues with
> > the GQL in the data store, as I would not be able to access them in
> > any order.
>
> > So i need to take in date as a DATE value.
>
> > Guidance appriciated.
>
> > --
> > 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-appeng...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > google-appengine+unsubscr...@googlegroups.com<google-appengine%2bunsubscr...@googlegroups.com>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/google-appengine?hl=en.
>
> --
> Nick Johnson, Developer Programs Engineer, App Engine Google Ireland Ltd. ::
> Registered in Dublin, Ireland, Registration Number: 368047
> Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration Number:
> 368047
--
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-appeng...@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.
