[web2py] appadmin CSV Import / Manual insertion ascii "ordinal out of range" error

Good afternoon all, I have been coming across errors while trying to work with the built-in appadmin to set up tables by manually inserting entries or importing CSVs (using MSSQL primarily). Put simply, any text with German umlauts (characters with the symbols above them, such as Ä, ö) would ca

[web2py] SQLite lock (using DAL in a module)

Good afternoon all, I am experiencing issues while trying to perform operations using my DAL from a module. I recently moved code from the default controller to a module for better coding practices. The code was running previous to the move, but now I experience an error ( database is locked

[web2py] Re: plugin_lazy_options widget

OK so I could never figure out how to use this widget on itself, I ruptured a few brain cells in the process and just decided to learn jquery. In case anyone is ever in my position here is my working solution 1)scrap the second lazy_options_widget and just use the default web2py select box.

[web2py] Re: plugin_lazy_options widget

Here is an example of what I'm trying to do... Don't forget to install the plugins *IN CONTROLLER* def index(): form = SQLFORM(db.product) if form.accepts(request.vars, session): session.flash = 'submitted %s' % form.vars redirect(URL('index')) return dict(form=for

[web2py] Re: plugin_lazy_options widget

I've tried everything, I'm sure its just something easy I'm missing or its possibly just some needed javascript to trigger the ajax call. Anyone out there wanna take a look, maybe give me a hint? http://dev.s-cubism.com/plugin_lazy_options_widget -- Resources: - http://web2py.com - http://web

[web2py] Re: plugin_lazy_options widget

The first two args for the widget seem to reference the fields class "suggest_selected" in the source of the plugin they are referred to as on_key and off_key. There is also a trigger option however I cant figure out what that does... -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] plugin_lazy_options widget

Can you use the plugin_lazy_options_widget on itself? For example, db.service_order.so_company.widget = suggest_widget(db.company.company_name, id_field=db.company.id, limitby=(0, 10), min_length=1) """Below Works Just fine""" db.service_order.so_location.widget = lazy_options_widget(

Re: [web2py] Web2py Forms and Javascript

The service order on the right is what is completed in the field by the techs. (The part they bring me). The form on the left is what our company calls a Work-Up. The work up Is created by me by taking the service orders information and the information from a rolodex card. The rolodex card (not

Re: [web2py] Web2py Forms and Javascript

I am working to move the company from paper to electronic, I work in a remote office and have to fax all of this right now. basic workflow: Service Orders Created in the field at Job site get delivered to me every day. I take the service order and create a workup (basically an invoice) usi

[web2py] Re: Help me stop bashing me head on keyboard...

Oh and the conditional problem is that I would like to populate items, Like if you chose a city that's in the database it would auto populate the state input because the city table has a reference to the state.. I would also like to keep the auto-complete functionality (if not in db add to db) f

[web2py] Re: Help me stop bashing me head on keyboard...

On Thursday, July 24, 2014 6:12:43 PM UTC-7, Anthony wrote:def myfunction(): if request.post_vars._autocomplete_name_aux and not request.post_vars. category: request.post_vars.category = db.category.insert(name=request. post_vars._autocomplete_name_aux) return dict(form=SQLFORM(db

[web2py] Re: Help me stop bashing me head on keyboard...

I actually went that route and then realized it would only work for one field, I would Like to have a few fields with the autocomplete/add, I would also like the form to have some conditional select boxes, and some fields that would be auto-filled if some condition is met... I'm starting to won

[web2py] Re: Help me stop bashing me head on keyboard...

Thanks Anthony, I just didn't know what search terms to use, this video someone linked is the functionality I am looking for. However It looks like some of the attempts are pretty outdated so I will attempt to re-write something. If successful I will share w

[web2py] Help me stop bashing me head on keyboard...

I have a Form that will submit to multiple tables, most items reference items.. For the life of me I cannot figure out how to make the form item not a select box (default behavior). I would like a input/suggest input field and if the input is not in db I would like to add it to DB. If it is in

Re: [web2py] Web2py Forms and Javascript

I think this would work better however I am not sure about the items.. is the item_entry table how its normally done? Examples online vary... A completed Service order would have multiple Item_entry references... Just doesn't seem like the right way to do it.. db.define_table('company', > >

[web2py] Web2py Forms and Javascript

y javascript is weak but I'm working on it :)) Thanks in advance! Jesse Ferguson EXAMPLE MODEL db.define_table('invoice', Field('price_list', 'integer'), Field('account_code','string'), Field('company', 'stri

[web2py] Re: routes.py confusion

It seems to be working now... I guess it just takes a while to kick in?? -- 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] routes.py confusion

I deployed my app using the nginx script and created a routes.py file like so: # -*- coding: utf-8 -*- > > >> routers = dict( > > BASE = dict( > > default_application='myapp', ) > > ) > > > However when i go to mywebsite.com i get "invalid request" but mywebsite.com/myapp loads t

[web2py] Re: Ajax LOAD

I "Think" the way to go about this would be to have the .load file a js script that gets the current list of items on the table, then compare that list to the one returned and remove the items if they are not in the list and then add the items that are in the list does that sound sane? --

[web2py] Re: Ajax LOAD

In the long run i would like to do something like http://blockchain.info/ 's main page and have a semi live feed of database items that are added and removed depending on what the controller returns -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/

[web2py] Ajax LOAD

Im trying to wrap my head around web2py and AJAX, I can use it to load a page.html however Its a little unclear to me when or how to use the page.load. For example, say I have a table of database items and I want to check that table every x amount of seconds and add a new element but only if i

[web2py] Re: Live data

Brilliant! I skipped that part of the book thinking it was about loading in java helpers or extending web2py somehow... Just read the LOAD docs and i think it is exactly what I needed. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (

[web2py] Live data

I'm building a single page app with a lot of data from the database displayed, I would like to have it auto-refresh or update the tables with the newest information. Its not time critical (ie it doesnt need to be instantanous maybe every 60secs) What are my options? AJAX timebased ca

[web2py] Re: list:reference

On Tuesday, May 13, 2014 12:52:24 PM UTC-7, Jesse Ferguson wrote: > > anthony copy Mandar's Code exactly and then jus go and add a few parents > then try to add a child with two parents, you will encounter this error.. > Traceback > > 1. > 2. > 3. > 4. > 5. &

[web2py] Re: list:reference

anthony copy Mandar's Code exactly and then jus go and add a few parents then try to add a child with two parents, you will encounter this error.. Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. Traceback (most recent call last): File "C:\Users\User\Desktop\web2py\gluon\restricted.py", li

[web2py] Re: list:reference

https://groups.google.com/forum/#!searchin/web2py/list$3Areference/web2py/pXBj0EhX3iA/vamglS5txQsJ seems this may be a bug in web2py... Does anyone know if this bugfix is still only in trunk or if it has been put into stable? -- Resources: - http://web2py.com - http://web2py.com/book (Documenta

[web2py] Re: list:reference

ok so it actually doesnt work which is really strange. it works on console however when i do it in a scheduled task it jacks up the database somehow, i think I may be inserting the references incorrectly... I will investigate this tonight and try to give everyone an answer -- Resources: -

[web2py] Re: list:reference

I FIgured it out, I was missing the field name when trying to add values i was doing row.update(data) instead of row.update(posts=data) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2p

[web2py] list:reference

how can i add a reference in code? I have a scheduled task and i want to update a field to reference 10 most current posts db.define_table('daily', Field('example'), Field('datetime'), Field('current', 'boolean') Field('posts','list:reference post'), ) db.define_table('post',

Re: [web2py] Re: Web2py gevent-socketio

ah yes i keep forgetting that pep333 i believe -- 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 you are subscribed to the

Re: [web2py] Re: Web2py gevent-socketio

Thank you Ricardo, I watched videos and read into the docs of everything you listed, Only thing I am bit unclear on is "WSGI", If Im understanding correctly its really just a Middleware that sits between a Sever and a python Framework. However Im a bit confused How the stack works when implemen

[web2py] Re: Web2py gevent-socketio

OK so I've been reading/researching and I'm still trying to wrap my head around how the above code works, First let me define what I *think* is going on, The script imports socket.io modules needed and the imports web2py's wsgibase... SocketIOServer (('0.0.0.0', 8080), wsgibase, resource="s

[web2py] Web2py gevent-socketio

I'm trying to learn how to use websocket-io and the only thing I could find about using it with web2py is here : https://groups.google.com/forum/#!newtopic/web2py/web2py/nJmML_jeZfc I can get the example working, however I dont really understand whats going on with run_iochat.py from geven

Re: [web2py] Re: list:reference painfull to fill

sorry to hop in and ask a silly question but, when you say init the js on the field how is that supposed to be done in web2py? Is it done in the view? would it be ideal to put the js in the template and then pass params? any named optional attribute is passed to the tag > > for ex

[web2py] Re: custom chosen.jquery.js widget

> > Ok so that didn't work so great... now I am trying to use this slice as a > template to make a widget: > http://www.web2pyslices.com/slice/show/1411/widgets-widgets-widgets > anyone know of any tutorials that would a novice like myself? > -- Resources: - http://web2py.com - http://web2py

[web2py] custom chosen.jquery.js widget

How would i Implement a custom widget using this http://harvesthq.github.io/chosen/? Or is there an easier way to use this? I assume I can probably just pass the table rows and use something like {{response.files.insert( ALL THE REQUIRED JS STUFF HERE ) {{=form.custom.begin}} {{for row in ro

Re: [web2py] reference field or add if not in db

want to be able to add more like it is now (plus and minus next to input) however i would like it to be a drop down of referenced items... for the life of me i cannot figure out how to have both. > On Mon, Dec 9, 2013 at 12:16 PM, Jesse Ferguson > > wrote: > >&g

[web2py] reference field or add if not in db

Is there a way to do this using a autocomplete field? would i put the logic in a custom validator? or is there a easier better way? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues

[web2py] Re: Online classes

I have watched the first few videos and they are so helpful for a beginner like myself, I would like to thank you for these! I would also like to request that you share the source code, I have been using the videos as reference and its a pain to try to find the parts that explained xyz functio

[web2py] Re: one to many tables in views

for t in tcrows:}} > {{=A(t.timecard.employee.fname, etc, etc > {{=t.timecard_entry.company.name}}, etc, etc > {{pass}} > > > On Monday, December 2, 2013 9:20:38 PM UTC-8, Jesse Ferguson wrote: > >> I have two tables set up and i want to sh

[web2py] one to many tables in views

I have two tables set up and i want to show the TimeCard with all the entries for said time card however im unsure of how to create such a view... CONTOLLER: def timecard_index(): tcrows =db(db.timecard).select(orderby=~db.timecard.tc_date) tcinputs =db(db.timecard_entry).select(orderb

[web2py] Re: SQLFORM not validating!

I will check out your suggestions, however for now i have solved like this SOLVED WITH THIS: db.define_table('timecard', Field('tc_date','date'), Field('employee', 'reference employee',requires=IS_IN_DB(db,'employee.id','%(fname)s %(lname)s')), Fie

[web2py] SQLFORM not validating!

ok im going crazy here... Ive tried every example or solution i can find and nothing works for me...I am trying to build a Time Card app so i can keep track of employees time cards and I want to make sure only one card per employee per day can be submitted... So the two fields need to validate

[web2py] Re: Formatting the Time Field

ok so the format now looks Great on the form however on submitting it i get this invalid literal for int() with base 10: '00PM'> It seems like its trying to store the value 00PM as mins which should be an integer... however i was under the impression that the dal handled time conversion for th

[web2py] Re: Formatting the Time Field

OK I figured it out! {{include 'web2py_ajax.html'}} jQuery.timeEntry.setDefaults({show24Hours: false, showSeconds: false, timeSteps:[1,30,1]}); -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.goog

[web2py] Formatting the Time Field

Having a hard time figuring out this one and after googling my eyeballs off Im here to beg for someone to throw me a bone, here is my code: MODEL: db.define_table('timecard_entry', Field('timecard', 'reference timecard', readable=False, writable=False,), Field('c

[web2py] python scripts/extract_mysql_models.py username:password@databasename > db1.py problem

#x27;@'localhost' to database 'pythontest'") .i modified my db by putting "id" fields as primary keys with auto increment option but still nothing then I searched some more and got the extract_mysql_models.py solution ,but the output "db1" file while I was trying to edit it with idle and web2py gave me a " USAGE: extract_mysql_models.py username:password@data_basename " Sorry for the bother. I'm a total newbie and help would be very much appreciated . Jesse --

[web2py] Re: web2py on hostmonster

I don't know if it will help you or not but I just went through this with Dreamhost. I summarized most of it at: http://wiki.dreamhost.com/Web2py My thread of questions are at: http://groups.google.com/group/web2py/browse_thread/thread/6e2aadc3718b7dc/6950f23f74207b43?lnk=gst&q=dreamhost#6950f23f

[web2py] Re: Dream Host Deployment

Unfortunately, none of those work. Result from using pretty much any of the above: $ python web2py.py -i 0.0.0.0 -p 8001 -a "password" The profile/pstats modules cannot be found Please install the python-profiler package web2py Enterprise Web Framework Created by Massimo Di Pierro, Copyright 2007

[web2py] Re: Dream Host Deployment

I put the update on: http://wiki.dreamhost.com/Web2py For anyone that is interested. Also, I can migrate the info to another location if someone has a suggestion as to where. Cheers, Jesse On Mar 6, 10:33 pm, Jesse wrote: > Fabulous, > > That seemed to do the tricked. > > Dre

[web2py] Re: Dream Host Deployment

x27;s wiki. Thanks a bunch, Jesse On Mar 6, 7:04 pm, Kuba Kucharski wrote: > let's get you through it. > > for development I use two instances of web2py. > > one: > > python web2py.py -i public_ip -p 80 -a "" > > two: > > python web2py.py -i public_ip -p

[web2py] Re: Dream Host Deployment

t:8080 and got nada Clearly my shellFu is not up to snuff but I would think one of my guesses would have worked. I guess I'll just cripple the security, since it's not exactly a big deal if my testing site gets hacked anyway. Jesse On Mar 5, 12:19 am, Thadeus Burgess wrote: >

[web2py] Re: Dream Host Deployment

ages. Any other ways? On Mar 4, 12:45 pm, Jesse wrote: > Using virtualenv seemed to do the trick. > > Although, I'm sure it doesn't matter now when I ran "import dbhash" I > got a several line long error: > Traceback (most recent call last): >   File ""

[web2py] Re: Dream Host Deployment

Using virtualenv seemed to do the trick. Although, I'm sure it doesn't matter now when I ran "import dbhash" I got a several line long error: Traceback (most recent call last): File "", line 1, in File "/home/username/opt//lib/python2.5/dbhash.py", line 5, in import bsddb File "/home/u

[web2py] Re: Dream Host Deployment

I tried running the python code from the passenger_wsgi.py manually to see if there were any issues. When I got down to import gluon.main I got: WARNING:root:unable to import dbhash issues??? My passenger_wsgi.py / wsgihandler.py code: #!/usr/bin/env python # -*- coding: utf-8 -*- """ This is a

[web2py] Dream Host Deployment

Hello, I've been trying to set up web2py on my dreamhost account. I've searched the web over trying to find something that works finally found: http://www.web2pyslices.com/main/slices/take_slice/1 Which I effective followed save that I used different directory (/opt instead of /local) and installe

[web2py:24140] Re: web2py.com down?

e been able to get to it by name all afternoon / > evening... > > > > On Sun, Jun 7, 2009 at 9:56 PM, Jesse Bever > wrote: > > > I can't access it it either I thought it was just me > > > > > On Sun, Jun 7, 2009 at 1:30 PM, Hans Donner > wrote: &g

[web2py:23561] Re: web2py.com down?

I can't access it it either I thought it was just me On Sun, Jun 7, 2009 at 1:30 PM, Hans Donner wrote: > > for me it works fine... > > On Sun, Jun 7, 2009 at 10:27 PM, mdipierro wrote: > > > > Now I cannot access web2py.com either. I cannot look into this until > > tomorrow morning. > > > > Mas