[web2py] list:string type issues

2014-10-05 Thread Greg Vaughan
Hi Guys, I am using a list:string to store a list of lists. Each seperate list has 4 values, qty (int), name (string), description (text) and price(double). Stores nicely and looks fine in the db table eg. [1, 'OS 7030', 'OS 7030', 755.0], [3, 'SMT 24 Btn', 'SMT IP Phone', 360.0], [1, 'SMT

[web2py] Re: list:string type issues

2014-10-05 Thread Greg Vaughan
type, which will automatically serialize back and forth between Python and JSON (the list:string type is meant for storing a list of strings, not a list of Python lists). Anthony On Sunday, October 5, 2014 5:45:44 AM UTC-4, Greg Vaughan wrote: Hi Guys, I am using a list:string to store

[web2py] insert and update SQLFORM.factory

2014-09-09 Thread Greg Vaughan
I am trying to do a combined update and insert using SQLFORM.factory with some redirects for good measure. Everything works fine except the update which fails to alter the record in question. @auth.requires_login() def remote_check(): j_id=request.args[0] for row in

[web2py] Re: insert and update SQLFORM.factory

2014-09-09 Thread Greg Vaughan
with the same name (business_name), so putting them both in SQLFORM.factory won't work properly. Anthony On Tuesday, September 9, 2014 9:10:50 AM UTC-4, Greg Vaughan wrote: I am trying to do a combined update and insert using SQLFORM.factory with some redirects for good measure

[web2py] Re: insert and update SQLFORM.factory

2014-09-09 Thread Greg Vaughan
include a field with the same name (business_name), so putting them both in SQLFORM.factory won't work properly. Anthony On Tuesday, September 9, 2014 9:10:50 AM UTC-4, Greg Vaughan wrote: I am trying to do a combined update and insert using SQLFORM.factory with some redirects for good

[web2py] type 'exceptions.RuntimeError' File.../databases/c8b....sales.table appears corrupted

2014-09-05 Thread Greg Vaughan
Somehow the sales table in my site has been corrupted... it is now a 0kb file (was about 600KB). Every other table is fine however. How can I reconstruct the data in this table? I have a backed up csv which is a little out of date but would do. Thanks Greg -- Resources: - http://web2py.com -

[web2py] Re: type 'exceptions.RuntimeError' File.../databases/c8b....sales.table appears corrupted

2014-09-05 Thread Greg Vaughan
Yeah... everything was fine one moment then it all just stopped... when I looked at the file it was 0kb. I have no idea what happened... cannot access database admin... site still runs except for the functions that access that table... On Saturday, 6 September 2014 02:22:31 UTC+10, Greg

[web2py] Re: type 'exceptions.RuntimeError' File.../databases/c8b....sales.table appears corrupted

2014-09-05 Thread Greg Vaughan
I wasn't working on the site at the time... I was notified by some of the employees... yes it looks like the table has been dropped... I cannot for the life of me work out how that could have happened though. On Saturday, 6 September 2014 02:41:30 UTC+10, Leonel Câmara wrote: Err wait a

Re: [web2py] Re: type 'exceptions.RuntimeError' File.../databases/c8b....sales.table appears corrupted

2014-09-05 Thread Greg Vaughan
... Make sure to backup everything, and then do a fake migrate. Marin On Fri, Sep 5, 2014 at 6:51 PM, Greg Vaughan greg.s@gmail.com javascript: wrote: I wasn't working on the site at the time... I was notified by some of the employees... yes it looks like the table has been dropped

Re: [web2py] Re: type 'exceptions.RuntimeError' File.../databases/c8b....sales.table appears corrupted

2014-09-05 Thread Greg Vaughan
corrupted' % table._dbt) RuntimeError: File /home/gsv/enertek/web2py/applications/welcome/databases/c8b669d15150d7109e5f7ab36744a5b7_sales_leads.table appears corrupted On Saturday, 6 September 2014 03:05:27 UTC+10, Greg Vaughan wrote: Tried fake_migrate... production site on pythonanywhere so disk

Re: [web2py] Re: type 'exceptions.RuntimeError' File.../databases/c8b....sales.table appears corrupted

2014-09-05 Thread Greg Vaughan
to true 5) Deleted this model and renamed the model holding the backup files back to its original name... and (quite miraculously) everything appeared as it was immediately before the crash... Thanks for the help everyone... On Saturday, 6 September 2014 03:15:27 UTC+10, Greg Vaughan wrote: Version

[web2py] Web2py Mobile Interface

2014-08-21 Thread Greg Vaughan
Hi Everyone, I decided that it would be advantageous if i were able to code on the go to fix any issues that I see occurring in my hosted webapps. So I installed web2py on my android tablet. The process was relatively painless and the standard welcome app works perfectly... however when I

[web2py] Re: Web2py Mobile Interface

2014-08-21 Thread Greg Vaughan
Hi Massimo I get the requires gitpython module so I cannot complete a pull request. I was hoping to be able to install the app as I would on the PC but that option is not available... should it be? Thanks Greg On Friday, 22 August 2014 00:07:36 UTC+10, Massimo Di Pierro wrote: What error do

[web2py] appadmin is disabled because insecure channel using default ipv6 local ::1 on windows with w2p 2.95

2014-06-16 Thread Greg Vaughan
Heading says it all... no problems using localhost IPv4... Is this expected behaviour? Seems rather strange if so... -- 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

[web2py] Set which browser web2py opens in

2014-05-24 Thread Greg Vaughan
Is there any way to set the default browser for web2py to open in. It's normal behaviour is to use the computer default... can this be changed? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Display table as dictionary

2014-05-05 Thread Greg Vaughan
tyvm Massimo exactly what I was looking for... it works perfectly and now the rest of my code works :) On Monday, 5 May 2014 14:46:19 UTC+10, Massimo Di Pierro wrote: fields = db(db.address.business==4L).select().first().as_dict() On Sunday, 4 May 2014 16:59:34 UTC-5, Greg Vaughan wrote

[web2py] Display table as dictionary

2014-05-04 Thread Greg Vaughan
The following code fields = db(db.address.business==4L).select().as_dict() returns a dictionary of dictionaries {1L: {'street_name': 'Another', 'postcode': '4888', 'id': 1L, 'unit': False, 'building_name': '', 'city': 'Deadsville', 'lot_section': None, 'sub_building': '', 'street_suffix':

[web2py] Re: web2py conference, next week!

2014-04-26 Thread Greg Vaughan
Make the next one in Sydney (Australia) Massimo :) Just joking... all the best for it and looking forward to seeing the videos... On Saturday, 26 April 2014 13:08:01 UTC+10, Massimo Di Pierro wrote: Please register only if you plan to attend in person. We will record the talks and post

[web2py] pass current page id to load function in sidebar

2014-04-24 Thread Greg Vaughan
Hi everyone... I am using a LOAD function for a notes field in the sidebar of my app. I am able to load the notes for a specific business by hardcoding the id of the business in the controller like so... @auth.requires_login() def note(): current==1

[web2py] Re: SQLFORM.factory and jQueryUI effects

2014-04-24 Thread Greg Vaughan
containing all the fields from all the tables you pass, so there's only one table_name available. Of course, all field names MUST be different (i.e. unique within the form). On Tuesday, April 22, 2014 5:35:18 AM UTC+2, Greg Vaughan wrote: Hey Niphlod, Thanks for that answer... you are spot

[web2py] Re: pass current page id to load function in sidebar

2014-04-24 Thread Greg Vaughan
Hi Niphlod... {{=response.vars}} shows nothing... nor does {{response.toolbar()}}... db stats shows notes.business = 1 when I hardcode it as above... I took a screenshot here http://screencast.com/t/mmRPGOHUAjt I assume that the filter will have to be sorted in the controller as the LOAD

[web2py] Re: pass current page id to load function in sidebar

2014-04-24 Thread Greg Vaughan
: how are you using LOAD to load the component ? On Thursday, April 24, 2014 5:23:21 PM UTC+2, Greg Vaughan wrote: Hi Niphlod... {{=response.vars}} shows nothing... nor does {{response.toolbar()}}... db stats shows notes.business = 1 when I hardcode it as above... I took a screenshot

[web2py] Re: pass current page id to load function in sidebar

2014-04-24 Thread Greg Vaughan
Cheers Anthony Worked a treat... Thanks everyone for the help... On Friday, 25 April 2014 03:12:00 UTC+10, Anthony wrote: {{extend 'layout.html'}} {{=form}} {{pass}} {{block right_sidebar}} {{=LOAD('default','note.load',ajax=True)}} {{end}} Just do: {{=LOAD('default', 'note.load',

[web2py] Re: alternate date and time picker

2014-04-21 Thread Greg Vaughan
Hi Annet... Thank you so much for the detailed reply... I have made it a point to check out the styling you have done... However the issue that I have is not just with the look but also with the way that the default one functions... particularly on tablets... it is clunky. So I have hacked

[web2py] SQLFORM.widgets.radio.widget and jQuery Validation

2014-04-21 Thread Greg Vaughan
Hi everyone, When I am using the SQLFORM.widgets.radio.widget my jquery selection code does not work. If I comment out the widget it works fine. Does anyone know if there is a workaround or is it just not possible to combine the two together. In the Model... db.define_table('leads',

[web2py] SQLFORM.factory and jQueryUI effects

2014-04-21 Thread Greg Vaughan
Hi everyone, I am using a bunch of jQuery hide effects based on the example code in the book... (Chapter 11... Conditional fields in forms) which work great with my SQLFORM. However when I change the controller to use SQLFORM.factory so that I can post to two tables (based on Chapter 7... One

[web2py] Re: SQLFORM.factory and jQueryUI effects

2014-04-21 Thread Greg Vaughan
Hey Niphlod, Thanks for that answer... you are spot on in seeing the problem... my #appointments_blah id's did get changed to #no_table_blah hence the jQuery was targeting id's that no longer existed... To fix it I simply changed the hard coded script at this point to target #no_table_unit,

[web2py] alternate date and time picker

2014-04-19 Thread Greg Vaughan
Is there any way that I can use a different date and time picker. The default one is horrible but it seems to be baked in to web2py? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: Paypal Recurring Payments? Any experience? Any alternatives?

2014-04-03 Thread Greg Vaughan
it a far more difficult proposition to get to the smaller economies. On Wednesday, 2 April 2014 15:28:35 UTC+10, mweissen wrote: Stripe looks good, but could not be used in Austria/Europe. Sorry! :-( Martin 2014-04-02 5:38 GMT+02:00 Greg Vaughan greg.s@gmail.com javascript: : Stripe charges

[web2py] Re: web2py logo - need immediate help

2014-04-02 Thread Greg Vaughan
2014 06:46:16 UTC-5, Greg Vaughan wrote: Hi Massimo Only just saw this... so bit quick and dirty... but just in case no one else gets something in for you can use as a fallback... I don't know what the base font is so roughed one up... png and svg attached Cheers On Wednesday, 2 April

[web2py] Re: Paypal Recurring Payments? Any experience? Any alternatives?

2014-04-01 Thread Greg Vaughan
Stripe charges me (in Australia) 2.7% + 30cents for each transaction processed, Visa, Mastercard or American Express. No other fees that are typically charged by other alternatives (Authorize.net) monthly fee, annual fee, chargeback fee etc... it is very much the simplest and most direct...

[web2py] Re: Paypal Recurring Payments? Any experience? Any alternatives?

2014-03-31 Thread Greg Vaughan
Check out Stripe... https://stripe (dot) com/ Massimo has a library created here and there is some support in the docs... On Monday, 31 March 2014 19:57:14 UTC+10, Mika Sjöman wrote: Hi I wonder if anyone here has implemented recurring payments with Paypal here with Web2py? Any experience

[web2py] Integrating Stripe with the gluon/contrib/stripe.py usage and template examples

2014-03-26 Thread Greg Vaughan
So i am trying to implement a stripe payment page and using the examples in the current gluon/contrib/stripe.py I cut and pasted the Template into a page with the default controller to see how it went but it failed first up with a global name not defined error on pk=PUBLISHABLE_KEY_GOES_HERE.

[web2py] Stripe example from book out of date

2014-03-24 Thread Greg Vaughan
Just to inform that the example here does not work with Stripe V3 (current) The script reports that the payments are accepted (provided you supply valid currency and date arguments) however they are not received at the stripe end. (they do not show in the stripe console log file.) Was hoping

[web2py] Re: Question on linking fields

2014-02-18 Thread Greg Vaughan
Hi Jim That was exactly what I needed thanks so much. Works perfectly. -- 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] Question on linking fields

2014-02-16 Thread Greg Vaughan
Hi everyone... Linked tables like... db.define_table('calls', Field('business', 'string'), ... and db.define_table('leads', Field('business', 'reference calls'), ... with controller containing def calls(): form = SQLFORM(db.calls) if form.process().accepted:

[web2py] Masking User Input

2014-02-05 Thread Greg Vaughan
Hi everyone, Building a series of telemarketing and sales forms for a friends company to use. Looking to utilise an input mask such as the one mentioned in this post. https://groups.google.com/forum/#!searchin/web2py/form$20input$20mask$20jquery/web2py/zRt9whk6y68/3jqiiRII9QYJ and wanted

[web2py] Re: Important New Year News: Edison Award

2014-01-18 Thread Greg Vaughan
Congratulations... and a big thank you also... I have just found web2py and absolutely amazed at how brilliant it is On Saturday, 4 January 2014 14:08:38 UTC+10, Massimo Di Pierro wrote: Web2py/me have been nominated for the Edison Award. Please wish web2py (and me) good luck. :-) --