[web2py] Re: Prince - Print Python Html to PDF

2015-04-21 Thread Calvin
Or why not http://html2pdfrocket.com instead? It's free. On Tuesday, 21 April 2015 03:52:10 UTC+8, Ovidio Marinho wrote: Has anyone tried to use it with web2py? http://www.princexml.com/doc/9.0/python/ [image: http://itjp.net.br] http://itjp.net.br

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Ron Chatterjee
Can you confirm if it was working before? I just don't know if it was. On Tuesday, April 21, 2015 at 11:56:27 AM UTC-4, Richard wrote: :) You may also consider fixing the scripts which may just need a little tweak if it where working before... Richard On Tue, Apr 21, 2015 at 11:12 AM,

[web2py] Re: SQLFORM.grid order of fields on create or edit form

2015-04-21 Thread Niphlod
I know that may sound as not-really-a-reply, but can't you just switch Field order in the table definition ? On Tuesday, April 21, 2015 at 6:36:11 PM UTC+2, Kyle Flanagan wrote: I know you can specify the order of fields for the main view of an SQLFORM.grid using the optional fields

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Niphlod
On Tuesday, April 21, 2015 at 9:39:14 PM UTC+2, Ron Chatterjee wrote: I tried this: db = DAL('mysql://root@127.0.0.1:8000/my_database_name',migrate_enabled=False, pool_size=20) It didn't work either. I guess someone needs to look at how to connect to legacy database. where is the

Re: [web2py] database chema recommendations needed

2015-04-21 Thread Richard Vézina
? Richard On Tue, Apr 21, 2015 at 2:29 PM, Ron Chatterjee achatterjee...@gmail.com wrote: Is this the link that takes to genealogical research? On Tuesday, April 21, 2015 at 12:04:29 PM UTC-4, Richard wrote: And what about just using Gramps (https://gramps-project.org/features/)??

[web2py] Re: SQLFORM.grid order of fields on create or edit form

2015-04-21 Thread Dave S
On Tuesday, April 21, 2015 at 12:32:28 PM UTC-7, Niphlod wrote: I know that may sound as not-really-a-reply, but can't you just switch Field order in the table definition ? Perhaps it is a legacy table and he's stuck with the table field order. If so, a temporary table could be a

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Richard Vézina
I can't I remember having read that mysql script worked or have been used... You may consider write a dummy web2py model generate the DB (SQLite) export the SQLite Schema and attach here or to a ticket you open on github it will help to troobleshoot and fix it... Richard On Tue, Apr 21, 2015 at

[web2py] Re: SQLFORM.grid order of fields on create or edit form

2015-04-21 Thread Niphlod
On Tuesday, April 21, 2015 at 9:36:40 PM UTC+2, Dave S wrote: On Tuesday, April 21, 2015 at 12:32:28 PM UTC-7, Niphlod wrote: I know that may sound as not-really-a-reply, but can't you just switch Field order in the table definition ? Perhaps it is a legacy table and he's stuck with

Re: [web2py] database chema recommendations needed

2015-04-21 Thread Ron Chatterjee
Is this the link that takes to genealogical research? On Tuesday, April 21, 2015 at 12:04:29 PM UTC-4, Richard wrote: And what about just using Gramps (https://gramps-project.org/features/)?? Richard On Tue, Apr 21, 2015 at 2:08 AM, John jhnp...@gmail.com javascript: wrote: New to

Re: [web2py] LOAD component inside component

2015-04-21 Thread Dave S
On Tuesday, April 21, 2015 at 6:14:35 AM UTC-7, Dmitry Ermolaev wrote: before to reload a sub-LOAD need stop it auto-loading - for preventing from double loads of sub-LOAD component Does this replace the reload() function that was in your post from Sunday? (Shown quoted below) /dps

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Ron Chatterjee
I tried this: db = DAL('mysql://root@127.0.0.1:8000/my_database_name',migrate_enabled=False, pool_size=20) It didn't work either. I guess someone needs to look at how to connect to legacy database. On Tuesday, April 21, 2015 at 2:49:33 PM UTC-4, Ron Chatterjee wrote: I can write it. But

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Ron Chatterjee
I can write it. But it will take some time to go through the syntax. I will let you know. On Tuesday, April 21, 2015 at 2:35:29 PM UTC-4, Richard wrote: I can't I remember having read that mysql script worked or have been used... You may consider write a dummy web2py model generate the DB

Re: [web2py] Re: Prince - Print Python Html to PDF

2015-04-21 Thread Ovidio Marinho
This sounds good, but I can not implement in web2py, you already tried this? [image: http://itjp.net.br] http://itjp.net.br http://itjp.net.b http://itjp.net.brr *Ovidio Marinho Falcao Neto* ovidio...@gmail.com

[web2py] Re: Web2py ckEditor

2015-04-21 Thread Jim S
1. Go here http://ckeditor.com/download and download CKEditor. I just use the Standard Package. 2. Open the zip file that you downloaded and copy the entire ckeditor folder to web2py/applications/your_app/static/js 3. Add this line to your layout.html after jquery is loaded script

Re: [web2py] LOAD component inside component

2015-04-21 Thread Dmitry Ermolaev
before to reload a sub-LOAD need stop it auto-loading - for preventing from double loads of sub-LOAD component full script: def remake_reload_script(timeout=None): return SCRIPT(''' var jelement = $(#show_update); var element = jelement.get(0); var statement =

Re: [web2py] Re: [OT] HTML to PDF

2015-04-21 Thread Ovidio Marinho
Hello Arya, How did you do this can publish the code? [image: http://itjp.net.br] http://itjp.net.br http://itjp.net.b http://itjp.net.brr *Ovidio Marinho Falcao Neto* ovidio...@gmail.com Brasil

Re: [web2py] Re: web2py Complete Reference Manual

2015-04-21 Thread Johann Spies
Maybe https://colflash.cdm.depaul.edu/colflashweb/COLFlashPlayer.aspx?ID=183272 On 9 April 2015 at 01:00, Carlos Zenteno cmzent...@gmail.com wrote: @Ron: There is a video somewhere, where Anthony talks about the inner works of web2py. Let me see if I can find it, unless someone nice, beats

[web2py] Intergrating another python tool in web2py

2015-04-21 Thread max
I would like to runs a typesetting tool which generates a TEI xml from a word doc , after a file is uploaded to web2py. I have the ubuntu script configuration from web2py with the user www-data running the web2py framework. I have given the typesetting script the www-data rights , but it

[web2py] Re: auth.wiki()

2015-04-21 Thread Ben Lawrence
Hi, did you manage to get the search to work? I have the same problem on 2.10.3-stable+timestamp.2015.04.02.21.42.07 (Running on Apache/2.4.7 (Ubuntu), Python 2.7.6) On Wednesday, April 8, 2015 at 3:23:48 PM UTC-7, Alex Glaros wrote: just looked at auth.wiki(). Not sure if I understand

[web2py] Trying to persist a DAL connection to save time connection

2015-04-21 Thread Michel Krav
Hi, my goal is to save time at each request processing. my context is a connection to an Oracle database with unfortunately poor network response, so in model.py , defining : dbo = DAL(uri , auto_import = False, migrate = False , lazy_tables = False) on every request it cost time to connect.

[web2py] database chema recommendations needed

2015-04-21 Thread John
New to programming and web2py. Been dabbling in web design for a while, building sites with wordpress, plugging things in. My first real project will be a site/app for my sister. Genealogical resources. Lots of records that will need to be added via csv and also via forms. Will also need to be

[web2py] AJAX div reload indicator

2015-04-21 Thread Gary Cowell
Hello I have a DIV component I'm reloading using another controller , so I end up calling: response.js = jQuery('#stackList').get(0).reload() Problem is, my stackList controller function does a lot of work to rebuild the grid, it makes many AWS api calls, to populate the grid. The

[web2py] Re: Trying to persist a DAL connection to save time connection

2015-04-21 Thread Anthony
You should use the built-in connection pooling mechanism for this purpose. See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-pooling. Anthony On Tuesday, April 21, 2015 at 11:05:32 AM UTC-4, Michel Krav wrote: Hi, my goal is to save time at each

Re: [web2py] Re: web2py Complete Reference Manual

2015-04-21 Thread Ron Chatterjee
Thanks. If the link only works. lol. Its all good:-), cheers On Tuesday, April 21, 2015 at 5:25:39 AM UTC-4, Johann Spies wrote: Maybe https://colflash.cdm.depaul.edu/colflashweb/COLFlashPlayer.aspx?ID=183272 On 9 April 2015 at 01:00, Carlos Zenteno cmze...@gmail.com javascript: wrote:

Re: [web2py] Re: auth.wiki()

2015-04-21 Thread Alex Glaros
no, did not get it to work, but submitted bug report I have not gotten back to working on it but it's pretty for even a beginner to write their own search On Mon, Apr 20, 2015 at 6:13 PM, Ben Lawrence benlawr...@gmail.com wrote: Hi, did you manage to get the search to work? I have the same

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Ron Chatterjee
I need to stop being lazy I guess. lol. Thanks Richard. Will do. On Tuesday, April 21, 2015 at 12:52:31 AM UTC-4, Richard wrote: Does the script complete correctly... These scripts are old, and I don't know many person who have use them... Anyway, 20 tables 50 tables is not much... You

[web2py] Re: csv download problem from an SQLFORM.grid populated by an AJAX call

2015-04-21 Thread Massimo Di Pierro
Please open a ticket. This may be a bug and an easy one to fix. On Monday, 20 April 2015 17:55:19 UTC-5, drm...@gmail.com wrote: I regularly use the SQLFORM.grid, does exactly what I need with very little effort. Recently I've been doing a lot more with AJAX to enhance how my pages look and

[web2py] Re: Web2py ckEditor

2015-04-21 Thread Dmitry Ermolaev
How use ckeditor in FORM - not SQLFORM ?? среда, 18 июня 2014 г., 12:56:48 UTC+3 пользователь Sharjeel Ali Shaukat написал: i m using ckeditor here i want to show runtime preview in div and also using its options like Bold button dont highlights the text and are not working perfectly

Re: [web2py] Re: Prince - Print Python Html to PDF

2015-04-21 Thread 黄祥
i think, it can implemented in web2py, base on the website example code is very simple e.g. a href=http://html2pdfrocket.com/html/topdf?url=www.google.co.nzapikey=ABCD-1234;Download PDF/a u must registered first to get your api key, after that replace the api key on example above with your

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Richard Vézina
:) You may also consider fixing the scripts which may just need a little tweak if it where working before... Richard On Tue, Apr 21, 2015 at 11:12 AM, Ron Chatterjee achatterjee...@gmail.com wrote: I need to stop being lazy I guess. lol. Thanks Richard. Will do. On Tuesday, April 21, 2015

Re: [web2py] database chema recommendations needed

2015-04-21 Thread Richard Vézina
And what about just using Gramps (https://gramps-project.org/features/)?? Richard On Tue, Apr 21, 2015 at 2:08 AM, John jhnpl...@gmail.com wrote: New to programming and web2py. Been dabbling in web design for a while, building sites with wordpress, plugging things in. My first real project

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Richard Vézina
And what would be the utility since you already have INSERT INTO TABLE... Someone can just use something like SQLite Manager ( https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/) to import it... Once in SQLite DB (which anyway it should) he can use web2py csv export import if he want

Re: [web2py] creating DAL from SQL file

2015-04-21 Thread Ron Chatterjee
I have sqlite browser. I am guessing its the same like SQlite Manager where someone can import, export csv or sql file. I don't have password in that database and work externally to the python *I guess one possibility will be:* import MySQLdb import sys try: db = MySQLdb.connect(host =

[web2py] Validating SQLFORM decimal input field

2015-04-21 Thread Andy W
My app includes a simple SQLFORM for generating payment receipts. The payment amount is stored as type='decimal(10,2)' using a MySQL database. All works fine if the user enters the payment amount using just numbers (eg '1000'). However, if they include a ',' for the thousands separator in the

[web2py] SQLFORM.grid order of fields on create or edit form

2015-04-21 Thread Kyle Flanagan
I know you can specify the order of fields for the main view of an SQLFORM.grid using the optional fields parameter, however, whenever you choose to add a new record, the order seems to be dictated by the order in which the fields were created in the table definition. Is there a way to