[web2py] Re: importing .csv to create DAL object

2015-02-25 Thread Niphlod
by hand. On Wednesday, February 25, 2015 at 4:29:52 PM UTC+1, Abhijit Chatterjee wrote: I haven't tried to code yet. But if I have .sql file. How to import. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: importing .csv to create DAL object

2015-02-25 Thread Abhijit Chatterjee
I haven't tried to code yet. But if I have .sql file. How to import. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because

[web2py] Re: importing .csv to create DAL object

2015-02-25 Thread Dave S
On Wednesday, February 25, 2015 at 7:43:46 AM UTC-8, Niphlod wrote: by hand. That is, use the import functions of the database the site will use, right? And then use migrate=False and/or fakemigrate to create the DAL's .table files?

[web2py] Re: importing .csv to create DAL object

2015-02-25 Thread Niphlod
.sql files are files filled with insert into table(col1, col2, col3) values ('a', 'b', 'c') web2py can't parse them, and frankly, it doesn't need to. it's a job best served by native tools. it'll better to restore the dump using native tools, then read the section on the book

[web2py] Re: importing .csv to create DAL object

2015-02-25 Thread Dave S
On Wednesday, February 25, 2015 at 1:14:34 PM UTC-8, Niphlod wrote: .sql files are files filled with insert into table(col1, col2, col3) values ('a', 'b', 'c') I used to know that =8-O web2py can't parse them, and frankly, it doesn't need to. it's a job best served by native tools.

[web2py] Re: importing .csv to create DAL object

2015-02-24 Thread Greg Born
This is one approach. http://stackoverflow.com/questions/17799041/how-to-import-existing-mysql-database-into-web2py On Monday, February 23, 2015 at 1:44:27 PM UTC-7, Abhijit Chatterjee wrote: If I have an old site n mysql database. N want to convert to web2py, rather than typing up the

[web2py] Re: importing .csv to create DAL object

2015-02-23 Thread Niphlod
you can try to extract models using https://github.com/web2py/web2py/blob/master/scripts/extract_mysql_models.py . To load the data, it'll be best to do the work table by table. On Monday, February 23, 2015 at 9:44:27 PM UTC+1, Abhijit Chatterjee wrote: If I have an old site n mysql