It looks You try to split date with '-' but you'll should use '/'. The
result of splitting your date is whole date string, which is not a proper
int value.
09.02.2018 03:37 "Peter Yoon" napisał(a):
> Hello,
>
> I imported a csv to my table but there were issues in the csv. I fixed the
> csv but
imagine table with thousands data
e.g.
name quantity price
product a 10 1
product b 15 11000
and every several months (5 or 6 months) the supplier send the update of
the product price
is it possible to import csv that can update some existing data (*not
insert new data*) in existing table
Hi,
I have defined tables:
db.define_table('BL',
Field('name'),
format='%(name)s'
)
db.define_table('PL',
Field('name'),
Field('BL_name', 'reference BL'),
format='%(name)s'
)
db.defi
trying to import *.csv with before insert callback not work correctly (no
error occured but the result is not expected)
*e.g. *
*csv_files_0.csv*
TABLE bonus
bonus.bonus_date,bonus.employee,bonus.is_packing
2016-11-10,4,1
END
*csv_files_1.csv*
TABLE bonus
bonus.bonus_date,bonus.employee,bonus.is_
Hi folks, glad to join this group
I tried to import in Web2Py the attached CSV file ( no sensible data, just
fake info for training ;), after having created the corresponding db.py
It works but only IDs are created for the correct number of rows ( held in
CSV ) but no field is actually loaded,
Hello
I would like to import csv file into a database table - user imports
how do you recommend to do it. I guess telling users to set the column
names matching the headers in CSV but how do i match them after for import.
I also have to add two fields with user id and another one that is based o
I am using import csv option to insert records in the database. When I use
the csv file from the web application, then a single record is inserted in
the database with all the records being updated properly as per the headers.
But If I try to use "import_from_csv_file" outside the web2py, it in
Hi,
I am trying to change my database from SQLite to postgres (As some of you
already know :) ) I created a copy of my app (without the database folder)
and changed the database to postgres (which finally works :) )
To get my database I exported every table to a csv file. but when I import
the c
Hi all,
I've recently started playing around with web2py and i have encountered a
problem with the csv importing function.
I have a table defined called 'production' and i have already implemetned a
smartgrid that will allow me to view,edit each row in the table.
However, I want to implement a f
I would like to know how I would add an import csv (from excel) option to
appadmin that would update multiple database tables (one of them a
relational/intermediate table).
For example, the CSV file would look like this (in excel)
ID | posttitle |category
Is there a way I can add an import excel (saved as csv) option in the
appadmin that can update multiple data tables (one of them an
intermediate/relational table)?
for example the excel file (saved as csv):
*ID | title |category|*
1 | one |
I want to provide import/export CSV file from a specific table for
users. All I want is just like appadmin works. I'm referencing
appadmin code trying to write the code below but I get error
messages. Does anyone can point out what's the problem ?
Example for auth_user table.
Model
-
I have this table:
db.define_table('region',
Field('name'),
Field('longname'),
Field('subdomain', unique=True),
Field('status_', 'reference region_status')
)
The unique constraint is preventing me in the appadmin from adding
regions with the same subdomain, as intended. However, i
hello
how I can automatically load a database from a csv.
The idea is that when my application starts for the first time, load
the database as countries, states, etc. without having to do it by
hand.
I tried loading it through the next line.
db.country.import_from_csv_file(open('.../static/cont
Export your actual table you will get the exact format you need csv to
have for the import!
Cheers
Jonhy
On 2010-07-14 14:31, Deepan wrote:
d is auto increment.
What should be the format of the csv file to import into the db table
using web2py interface.
I have table format as
Tablename (id, col1, col2, col3)
id is auto increment.
16 matches
Mail list logo
