Hi Delzad, Can you provide a oneliner (datetime.datetime.striptime(...)) that reproduces this behaviour? The problem is with date formatting, so it will be useful to remove the extraneous issues of the bulkloader from the equation.
-Nick Johnson On Thu, Apr 15, 2010 at 1:46 AM, Delzad <[email protected]> wrote: > 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)" <[email protected]> > 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 <[email protected]> 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 [email protected] > . > > > To unsubscribe from this group, send email to > > > [email protected]<google-appengine%[email protected]> > <google-appengine%[email protected]<google-appengine%[email protected]> > > > > > . > > > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine%[email protected]> > . > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
