Hi guys,
I'm trying to upload a .csv file and show the entities in a table.
but the weird thing is it seems like the put() only stores the last
record from the .csv file!
here is the code to read the .csv file, store to big table and show
the first 10 records:
===================
class Processfile(webapp.RequestHandler):
def post(self):
cardcost=Cardcost()
memfile=StringIO.StringIO(self.request.get('titles_file'))
Mylist = csv.reader(memfile,dialect='excel')
for row in Mylist:
cardcost.Bom=row[0]
cardcost.unitprice=row[1]
print '%s %s ' % (cardcost.Bom, cardcost.unitprice)
cardcost.put()
print 'record fetched from datastore'
cardcosts_query = Cardcost.all().order('-date')
cardcosts = cardcosts_query.fetch(10)
for cc in cardcosts:
if cc.Bom:
print '%s %s %s' % (cc.Bom,
cc.unitprice,cc.date )
else:
print ' No value'
class Cardcost(db.Model):
Bom = db.StringProperty()
unitprice=db.StringProperty()
date = db.DateTimeProperty(auto_now_add=True)
=======================
here is the .csv file;
=========
BOM,Unit Price
13032341,1000
10421110,1200
23781234,780
34324321,3210
12346553,32
16781234,6789
112,5000
==========
after clear up the datastore, here is the result after the first
running:
========
BOM Unit Price
13032341 1000
10421110 1200
23781234 780
34324321 3210
12346553 32
16781234 6789
112 5000
record fetched from datastore
112 5000 2008-09-05 03:22:11.218000
Status: 200 OK
Content-Type: text/html; charset=utf-8
Cache-Control: no-cache
Content-Length: 0
========
Is there anybody have similar problem or solution? Thanks.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
