Re: [web2py] Import CSV issue - can't import new CSV

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.

[web2py] import csv that can update some existing data in existing table

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

[web2py] import csv (referenced fields)

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' )

[web2py] import *.csv with before insert callback not work correctly

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

[web2py] Import CSV file

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,

[web2py] import csv file into table

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

[web2py] Import csv outside the web2py causes multiple entries in db corresponding to each column.

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

[web2py] import csv database admin

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

[web2py] import csv files to update database

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

[web2py] Import CSV in appadmin to update database

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 |

[web2py] Import CSV in appadmin to update database

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

[web2py] Import CSV

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

[web2py] import csv not respecting unique?

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,

[web2py] import csv automatic

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.

[web2py] Import csv

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.

Re: [web2py] Import csv

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.