[web2py] How to manage web2py app and php application under the same Apache server

2018-04-25 Thread Sandeep Patel
Hello, I am running my web2py application on AMPPS web server. Now I want to run PHP application on this same server. I have configured both applications in httpd.conf file (PFA.) What is happing here, my web2py application is running fine but I am not able to

Re: [web2py] Re: How to iterate through column items and display its rows data

2018-04-30 Thread Sandeep Patel
Try this rows = db(db.person.id>0).count() On Tue, May 1, 2018 at 8:33 AM, Maurice Waka wrote: > I get this error : AttributeError: 'Rows' object has no attribute 'count' > > On Mon, 30 Apr 2018, 22:10 pbreit wrote: > >> I would think something like: >> >> rows = db(db.person.id>0).select() >

[web2py] How to show conditional fields with multiple conditions

2018-05-09 Thread Sandeep Patel
Hello, I want to show form fields based on the user input so I used conditional fields, what happens to me whenever I select ''*FIRE*" or " *FIRE1*" fields appear in my form but when I select "*Both*" nothing appear in my form what going wrong with my code, please correct me # Model.py auth.se

[web2py] it's possible to use Autocomplete widget in SQLFORM.grid ?

2018-05-21 Thread Sandeep Patel
Hello, Can anyone, let me know how to work Autocomplete widget with SQLFROM.grid in the search filed. I have used Autocomplete widget in SQLFROM that's work fine but in the grid, nothing in happen. Please give me some direction how to do that Thank's Sandeep -- Resources: - http://web2py.co

Re: [web2py] Re: Menu option on We2py 2.16.1-stable doesnt open on cellphones

2018-05-24 Thread Sandeep Patel
Change The default layout.html with this ** than menu will open in cellphone too. Thank sandeep On Fri, May 25, 2018 at 6:23 AM, Dave S wrote: > > > On Thursday, May 24, 2018 at 9:37:58 AM UTC-7, mostwanted wrote: >> >> Hi guys, my menu is not opening on cellphones, i can not access my menu >

Re: [web2py] Re: it's possible to use Autocomplete widget in SQLFORM.grid ?

2018-05-24 Thread Sandeep Patel
Just want to update you and others. Thanks for your advice. Greatly appreciated On Fri, May 25, 2018 at 2:19 AM, isi_jca wrote: > Sandeep: > > Look at this link: http://web2py.com/books/default/chapter/29/07/forms- > and-validators?search=autocomplete#Autocomplete-widget > >

Re: [web2py] Re: it's possible to use Autocomplete widget in SQLFORM.grid ?

2018-05-24 Thread Sandeep Patel
uot;this.style.backgroundColor='yellow'", _onmouseout="this.style.backgroundColor='white'" ).xml() for k in selected]) Thanks Sandeep On Fri, May 25, 2018 at 11:21 AM, Sandeep Patel wrote: > > @isi_jca > I have read some old threads, i

Re: [web2py] Re: Send args from a button in views

2018-05-25 Thread Sandeep Patel
@Matthew J Watts You can try this grid = SQLFORM.grid(query,selectable=[('Name',lambda ids :redirect(URL('default','func',args=ids)))]) best sandeep On Fri, May 25, 2018 at 4:00 AM, 黄祥 wrote: > pls try (not tested) > {{=A('Finish',_href=URL('my_collections/%s/%s', % ('args0', 'args1') > ),_cla

Re: [web2py] Re: Send args from a button in views

2018-05-26 Thread Sandeep Patel
egroups.com> wrote: > Thanks for your help all! > i'll give these a go. Sorry if i want that clear, but i'm not trying to > use a grid, i'm trying to redirect from a button in views > > >{{=A('Cancel',_href=URL('my_collections'),_clas

Re: [web2py] Required field label

2018-06-22 Thread sandeep patel
If yor are using SQLFROM than You can try this labels={'field_name':P('name',B('*',_style:'color:red'))} Best On Tue, Jun 19, 2018 at 11:24 PM Tu Duong wrote: > Hi, what is the best way to add red * (or any indication that the field is > required for user) in the label of the required field? Th

Re: [web2py] Web2Py Smartgrid - it is possible to link to a pdf file?

2018-07-05 Thread sandeep patel
Hello Annika, You can try this. grid = SQLFORM.grid(query,selectable=[(' Link to PDF-File ',lambda ids :redirect(URL('default','file.pdf',vars=dict(id=ids Best/ On Thu, Jul 5, 2018 at 12:52 PM wrote: > Hello, > > I have my sqlgrid working but would need a link to a pdf f

Re: [web2py] Deleting a db table row

2018-07-22 Thread sandeep patel
You can delete row this way!! db((db.table.id==id_s)&(db.table.created_by == auth.user.id)).delete() if you want delete rows upto a certain limit so you can you put this quarry under for loop. Best, On Sun, Jul 22, 2018 at 4:43 PM Maurice Waka wrote: > I have tried this example but I get this er

[web2py] Sum/Total of the column values in SQLFROM.grid?

2018-07-24 Thread sandeep patel
Hello, I have a grid that is worked as I expected. now I want to sum all the values that have in "number_of_bags" Field. So that I have used grid.rows (*sum([int(grid.rows[i].number_of_bags) for i in range(len(grid.rows))])*) but this gives me sum of first 10 records but i want sum of all the v

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

2018-07-25 Thread sandeep patel
Thanks to all for your support @Anthony, I have done this way!! That provie all values sum which is having in grid. #controller.py grid = SQLFROM.grid(query,..,...) a = grid.__dict__ b = sum([int(i.number_of_bags) for i in a['dbset'].select()]) Please, Let let me know if any other way to do that

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

2018-07-26 Thread sandeep patel
@Anthony, This gives me an error.becouse of some values float type in the field. ('float' object is not iterable) How can I successfully sum all the values within this solution? Thanks On Thu, Jul 26, 2018 at 4:09 PM Anthony wrote: > #controller.py >> >> grid = SQLFROM.grid(query,..,...) >> a

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

2018-07-26 Thread sandeep patel
Thank Anthony, The error was getting just because I used {{=sum(b)}} in my view. now this works fine. Best On Thu, Jul 26, 2018 at 5:12 PM Anthony wrote: > On Thursday, July 26, 2018 at 7:39:05 AM UTC-4, sandeep patel wrote: >> >> @Anthony, This gives me an error.becouse of so

Re: [web2py] Re: How to go publick with web2py

2018-07-28 Thread sandeep patel
@Stauros >From where you are an executing your app?.in you local computer or from any cloud-based virtual environment like (heroku, amazon, google cloud). On Sat, Jul 28, 2018 at 6:56 PM Stauros Mpol wrote: > I do this but i cant accses it and the ip is 127.0.0.1 as you see.. gonna > check my fi

[web2py] widget not working with list:string

2018-07-29 Thread sandeep patel
Hello All, In my case widget and list: string Field is not working properly. *Case 1 (Without Widget)* In this case, my form work proply with list:string Field # db.py db.define_table('content_ck', Field('title', length=255), Field('public_ck', 'boolean', default=True), Field('text_c

Re: [web2py] Re: widget not working with list:string

2018-07-29 Thread sandeep patel
t widget used by web2py is > SQLFORM.widgets.list.widget. In case 2, you are replacing that with the > "string" widget, which is intended to work with a "string" field, not a > "list" field. > > Anthony > > On Sunday, July 29, 2018 at 8:21:23 AM

Re: [web2py] Re: update multiple tables from one csv and get row id after update_or_insert

2018-07-31 Thread sandeep patel
@Mattew J Watts, #Model db.define_table('person', Field('name'), Field('age'), Field('country'), format='%(name)s') db.define_table('thing', Field('person_id,'reference preson')

Re: [web2py] web2py 2.17.1

2018-08-11 Thread sandeep patel
Hello, In Version, 2.16.1-stable Plugins work fine when clicking on plugin web2py administrative interface gives all information about the plugin, but in 2.17.1 gives Error. is that bug or I am doing something wrong? Version web2py™ Version 2.17.1-stable+timestamp.2018.08.06.01.02.56 Python Python

Re: [web2py] Re: web2py 2.17.1

2018-08-13 Thread sandeep patel
Thanks, @Leonel Câmara Now works fine! /sp On Mon, Aug 13, 2018 at 5:30 PM Leonel Câmara wrote: > Sandeep I think that's this issue: > > https://github.com/web2py/web2py/issues/1972 > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2

[web2py] name 'unicode' is not defined in 2.17.1

2018-08-13 Thread sandeep patel
Hello, This was working with 2.16 and python3 but in 2.17.1 I get an error. name 'unicode' is not definedVersion web2py™ Version 2.17.1-stable+timestamp.2018.08.06.01.02.56 Python Python 3.6.2: C:\Program Files\Python36\python.exe (prefix: C:\Program Files\Python36)Traceback 1. 2. 3. 4. 5. 6.

Re: [web2py]

2018-09-13 Thread sandeep patel
You can use *request.vars *in your controller function you will get your form input values under the Storage class. Best On Thu, Sep 13, 2018 at 6:41 PM elisha bere wrote: > Hie, > > i would like to know how i can create a form in html and then get the > input as variables in my controls. > N

Re: [web2py] how to customize user registration form

2018-09-15 Thread sandeep patel
What do you want to modify in form? If you want to add more fields in the form so you can add this way. #modal.py auth.settings.extra_fields['auth_user'] = [ Field('new filed name') ] If you want to customize look and feel of the form or even you can change entry form according to your

[web2py] how to break migration at table defining label

2018-09-25 Thread sandeep patel
Hello, My question is break migration when defining a new table in modal. #modal.py db = DAL('mysql://*@*.amazonaws.com/ware1', pool_size=configuration.get('db.pool_size'), migrate_enabled=configuration.get('db.migrate'), check_reserved=['all

[web2py] Strange behaviour of calendar size in grid?

2018-10-05 Thread sandeep patel
Hello, I am using bootstrap3_stacked formstyle in grid. Everything works fine except one thing (calendar size) please refer image for more information. NOTE- I am using Version-2.16.1 #modal db.define_tabel('name', Field('date_of_entry','date',default=date.today(),label=

Re: [web2py] Re: Future of web2py

2018-10-07 Thread sandeep patel
I am also in one of them which use groups, permission, and role very often. Best, Sandeep On Sun, Oct 7, 2018 at 10:55 PM Martin Weissenboeck wrote: > Me too (not #metoo :-) > I like groups and permissions and I use both very often. > Regards, Martin > > Am So., 7. Okt. 2018 um 17:19 Uhr schri

Re: [web2py] My SQLFORM() is not saving anything after putting my APP online

2018-10-19 Thread sandeep patel
Try this def index(): form=SQLFORM(db.vehicleLogging) if form.process().accepted: response.flash = T("Record Made") elif form.errors: response.flash = T('Error') return locals() In *form.process().**accepted *does not need request.vars and session arguments. Best/

Re: [web2py] Making a calculation of two database fields set a value for the third database field

2018-10-20 Thread sandeep patel
There are many ways to solve this problem. you can achieve by computed fields. #modal db.define_table('logging', Field('startingDistanceValue','integer', requires= IS_NOT_EMPTY(),default=0), Field('endingDistanceValue','integer', requires=IS_NOT_EMPTY (),default=0),

Re: [web2py] Re: mobile friendly login page

2018-10-25 Thread sandeep patel
@lbjc Add some margin between the buttons. you can try this. Add this in user.html file .btn{ margin-left: 10px; margin-top: 10px; } Best/ SP On Thu, Oct 25, 2018 at 6:34 PM mostwanted wrote: > The attachment link gives *error 404* > > On Thursday, October 25, 2018 at 2:06:15 PM UTC+

Re: [web2py] How to strip away and get rid of (… days, 0:00:00) from a value acquired from a date calculation

2018-10-25 Thread sandeep patel
*You can directly count days from date type.this belongs to datetime class.db.define_table('hotels',Field('Hotel'), Field('Bookin', 'date'),Field('Bookout', 'date'), Field('days', compute=lambda r: (r['Bookout']-r['Bookin']).days), Field('guests', 'integer'),Fi

Re: [web2py] Re: Unable to update database entry after compute=lambda r: calculation of some field values in the DB

2018-10-25 Thread sandeep patel
I think there is a problem in field type in Days because the default is a string so days have a string value, you are multiplying string with an integer in the computed field. # 1 db.define_table('ClientDetails', Field('CheckIn', 'date', label=SPAN('Check-In Date', _style="font-wei

Re: [web2py] Unable to display dropdown lists in forms

2018-12-04 Thread sandeep patel
@Arindam: Try the following code instead def test(): form = FORM(LABEL("File(s):"), INPUT(_name='pic_upload', _type='file', _multiple=''), BR(), LABEL("Comments:"), INPUT(_name='comments'), BR(), LABEL("Print Size:"), INPUT(_name='print_size'),

Re: [web2py] Unable to display dropdown lists in forms

2018-12-04 Thread sandeep patel
elif form.errors: >>response.flash = T('form has errors') >> >> return dict(form=form) >> >> In views/default/company_login.html : >> >> {{extend 'layout.html'}} >> {{=form}} >> >> >>

Re: [web2py] Conditional Checks on output from DB.Select statements?

2018-12-07 Thread sandeep patel
Yes, Arjun you are right you are comparing row object to a string.so first you have to extract value from row object. You can use first or last function to get values. if measure_1.first()['name']=='DBD': instead, store a row object in variables you can store values which you want to compare. m

Re: [web2py] removing / hiding SQLFORM.grid links in the view, edit, add forms?

2018-12-11 Thread sandeep patel
@Paul, You can do this way, grid = SQLFORM.grid(query, editable=False,details=False,create=False,..) Thanks SP On Wed, Dec 12, 2018 at 4:40 AM Paul Ellis wrote: > I have a grid with some links. One of the buttons is a placeholder which > some Jquery attaches to. How do I stop this button from

Re: [web2py] Need to integrate paytm payment gateway in my app

2018-12-14 Thread sandeep patel
@Arindam, I have made a PayuMoney payment gateway for web2py apps. if you need help on that please let me know. Thanks SP On Fri, Dec 14, 2018 at 9:36 PM Arindam Dasgupta wrote: > Hi, > I need to integrate the paytm payment gateway in my application . For that > I have already created an accou

[web2py] Web2py- PayUMoney Secure Online Payment Gateway.

2018-12-14 Thread sandeep patel
Hello All, I have customized PayUmoney <https://www.payumoney.com/>python SDK for the Web2py user. This <https://github.com/coodblooded/Web2py-PayUmoney>app can in integrate with any web2py app and customize according to your needs. Thanks Sandeep Patel -- Resources: - http:

Re: [web2py] Re: Need to integrate paytm payment gateway in my app

2018-12-14 Thread sandeep patel
@Arindam Please go through this . On Sat, Dec 15, 2018 at 9:06 AM Arindam Dasgupta wrote: > @Dave , I learnt that stripe dont support payments from India. So Stripe > will not be useful for me. I also tried for Google pay , but the >

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

2018-12-15 Thread sandeep patel
table = self.lazy_define_table(tablename,*fields,**args) > File "/home/earinda/FarmFresh/gluon/packages/dal/pydal/base.py", line 873, > in lazy_define_table > polymodel=polymodel) > File "/home/earinda/FarmFresh/gluon/packages/dal/pydal/adapters/base.py", &

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

2018-12-15 Thread sandeep patel
de it to one of your > version ( 2.16.1 or 2.17.2). And also I I do, then will my existing apps be > still there or I will have to reinstall them? > Sorry If I am asking too much questions. Thanks in advance. :-) > > > [image: image.png] > > On Sat, Dec 15, 2018 at 1:43 PM sa

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

2018-12-16 Thread sandeep patel
t your /view/default folder. 4. Change MERCHANT_KEY, Key, SALT with real ids Now Payment Gateway will work. Thanks Sandeep Patel On Sun, Dec 16, 2018 at 3:32 PM Lovedie JC wrote: > What about python 2.7 compatibility > > On Sat, 15 Dec 2018 at 15:02, Arindam Dasgupta > wrote: >

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

2018-12-18 Thread sandeep patel
e no. etc. Please help. > And yes, My website is http and not https yet. > > [image: image.png] > > BR//Arindam > > > > > On Sun, Dec 16, 2018 at 8:45 PM sandeep patel > wrote: > >> @Lovedie, >> This app generated with python3 so if you are directly

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

2018-12-20 Thread sandeep patel
@Arindas, I have updated default.py and index.html in the git repository . Please check it. Now transactions make in one click and Even you can change user info and pricing programmatically in a wen2py way. Let me know if you have any questions Tha

Re: [web2py] Creating charts and trends from db

2018-12-20 Thread sandeep patel
You can achieve this way. Controller.py import pygal def chart(): response.files.append(URL('default','static/js/pygal-tooltips.min.js')) response.headers['Content-Type']='image/svg+xml' import pygal from pygal.style import Style custom_style = Style( background='trans

Re: [web2py] Creating charts and trends from db

2018-12-21 Thread sandeep patel
gt; The form appears well, but the chart area doesn't show any chart, looks a > small box at the top left side of the page. > Trying to show it shows a message: 'insufficient privileges'. > Regards > > On Fri, Dec 21, 2018 at 9:58 AM sandeep patel > wrote: > >>

Re: [web2py] Web2py- PayUMoney Secure Online Payment Gateway.

2018-12-22 Thread sandeep patel
@Arindas, Are you using one app for Payment and one app for a web application or both of contains in one app? Thanks On Sat, Dec 22, 2018 at 6:10 PM Arindam Dasgupta wrote: > Hi Stifan, > > I have already web2py 2.17.2 installed and I dont have a option to select > python 3.6.6. In the list it

Re: [web2py] Error Handling in the view

2018-12-24 Thread sandeep patel
@Mostwanted This is because of try-except block under if block. when price value has None than if condition false. I have tested this code than is work fine for me. .{{ for price in pricing: try: vat=round(price.total*0.12, 2) except: redirect(URL('notRegistered')) else:

[web2py] Upload CSV file though app admin getting an error in 2.17.2

2018-12-31 Thread sandeep patel
Hello All, I am getting an error while uploading a CSV file to table though app admin. [image: error.PNG] I am using python3.6 and web2py 2.17.2. Thanks SP -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://cod

Re: [web2py] Re: Upload CSV file though app admin getting an error in 2.17.2

2018-12-31 Thread sandeep patel
Please Refer attached image. Seeing a flash message from web2py unable to parse CSV. iterator should return strings, not bytes (did you open the file in text mode?) Thanks On Tue, Jan 1, 2019 at 12:39 PM Dave S wrote: > On Monday, December 31, 2018 at 10:17:38 PM UTC-8, sandeep patel wr

Re: [web2py] Happy New Year

2019-01-01 Thread sandeep patel
Happy New Year to you too, I wish, Developer Tool Kit, which mak working on web3py fun and easy. On Wed, Jan 2, 2019 at 12:30 AM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Happy new year everybody. I hope this is the year we can have a minimalist > web3py for everybody to play with.

Re: [web2py] Re: modular web2py - need help

2019-01-01 Thread sandeep patel
I am getting an ImportError error during setup. Steps: git clone --recursive https://github.com/web2py/web2py.git git checkout modular python setup.py Traceback (most recent call last): File "setup.py", line 4, in from gluon.fileutils import tar, untar, read_file, write_file File "D:\T

Re: [web2py] Re: modular web2py - need help

2019-01-02 Thread sandeep patel
@Carlos Cesar Caballero, I have taken the same steps as you suggested but I am getting the same error. Robodia@DESKTOP-E4IOU2U MINGW64 /d/TestingWeb3py/web2py/gluon/packages/dal (modular) $ python ../../../setup.py Traceback (most recent call last): File "../../../setup.py", line 4, in fro

Re: [web2py] Re: modular web2py - need help

2019-01-03 Thread sandeep patel
is because > it either is not imported in gluon or pydal, so, I think that you are not > using the modular branch of pydal. Start the steps again as @sitfan post in > his last message. > > Greetings. > El 3/1/19 a las 12:33 a.m., sandeep patel escribió: > > @Carlos Cesar C

Re: [web2py] Re: modular web2py - need help

2019-01-03 Thread sandeep patel
@Stifan OS Windows 10, Python 3.6.6 The shell sign is indicated in *nix environment because I am using Git Bash CLI. Thanks SP On Thu, Jan 3, 2019 at 8:13 PM 黄祥 wrote: > pls provide your environment (os and python version), the log errors > indicate in windows but the shell sign is indicate in

Re: [web2py] Re: modular web2py - need help

2019-01-06 Thread sandeep patel
Thank you, Massimo, Now it's working Thanks & Regards Sandeep On Sat, Jan 5, 2019 at 11:42 PM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > > If you are getting the error: > > ImportError: cannot import name 'Cookie' > > Either your are not installing the latest pydal or you have two

Re: [web2py] Editing the default formstyle styles

2019-01-09 Thread sandeep patel
@mostwanted In my case your code working as you expected. what web2py version you are using? You can try this def search(): form=SQLFORM.factory(Field('SEARCH', requires=IS_NOT_EMPTY()), widget = lambda field, value: SQLFORM.widgets.string.widget( field, va

[web2py] Getting SQL syntax error during import as CSV file in gird - 2.17.2

2019-01-10 Thread sandeep patel
Hello, I am surprised, why I am getting an SQL syntax error in 2.17.2 while that is well working in 2.16.1. This error getting when I import CSV file form gird. Has any new SQL reserved Keyword added to Web2py 2.17.2? Ticket ID 127.0.0.1.2019-01-10.14-01-36.65d7947a-df35-4a9c-89c2-c3575c69821

Re: [web2py] Check an empty upload field in database

2019-01-11 Thread sandeep patel
You can use an if-else or try-except block for that Like this. def index(): form = SQLFORM(db.orders) if form.process().accepted: if form.vars.pic_upload: makeThumbnail(db.orders,form.vars.id,(175,175)) else: #do whatever you want else:

Re: [web2py] Form Validation not working (v2.17.2)

2019-01-17 Thread sandeep patel
@lyn2py instead of using Field Type Integer use double Like This Field('one_field_only', 'double')) Thanks SP On Thu, Jan 17, 2019 at 3:47 PM lyn2py wrote: > My code did not change, but upgrading web2py caused my Form Validation to > fail. > > Older (working) version: Version > 2.17.1-stable+ti

Re: [web2py] standalone templates

2019-01-23 Thread sandeep patel
@ Carlos I think you can use the current app modules folder. This executes all the .py files on the top label of every request For more information here Thanks SP On Wed, Jan 23

Re: [web2py] standalone templates

2019-01-23 Thread sandeep patel
all...@cfg.jovenclub.cu> wrote: > Hi sandeep patel, thanks for your answer. > > In my use case I am using the template module outside web2py as a > standalone package, and I need to inject some objects in the template by > default. I am not using the whole web2py framework. > &

Re: [web2py] Re: Need to change text Size of the header

2019-02-09 Thread sandeep patel
@ Arindam, Lionel says that create a new .css and store in static/css folder and add that path in the layout.html file. Add that path after bootstrap.css Even you can directly put a style tag in the layout.html file. Style tag will be inside the end of the head tag. Change the font size according t

Re: [web2py] Re: Need to change text Size of the header

2019-02-10 Thread sandeep patel
) and > auth.navbar('Welcome',mode='dropdown') or ''}} > > {{if response.menu:}} > {{=MENU(response.menu, _class='nav > navbar-nav',li_class='dropdown',ul_class='dropdown-menu')}} > {{p

Re: [web2py] Increment the value of a variable in one page by clicking a link in a different page

2019-02-10 Thread sandeep patel
@Mostwanted I think you can achieve this functionality by a couple of ways. One, you can store every clicks value in session but you can only store for the time being. Another way you can directly store every clicks values in DB. You can try this code #Model db.define_table('countclick', Field

Re: [web2py] Increment the value of a variable in one page by clicking a link in a different page

2019-02-10 Thread sandeep patel
, I dont know if i am > missing something. > > On Sunday, February 10, 2019 at 3:24:38 PM UTC+2, sandeep patel wrote: >> >> >> @Mostwanted >> I think you can achieve this functionality by a couple of ways. >> One, you can store every clicks value in session but you

Re: [web2py] Error importing csv file in python3.6

2019-02-11 Thread sandeep patel
I had the same issue. I have solved this way. Please try this You have to changing line 926 of gluon/packages/dal/pydal/objects.py from reader = csv.reader(csvfile, delimiter=delimiter, quotechar=quotechar, quoting=quoting) to reader = csv.reader(codecs.iterdecode(csvfile,'utf-8'), delimiter=delimi

Re: [web2py] Error importing csv file in python3.6

2019-02-11 Thread sandeep patel
In fact, this is an open issue <https://github.com/web2py/web2py/issues/2015> for the same problem. You can check that as well On Mon, Feb 11, 2019 at 11:27 PM sandeep patel wrote: > I had the same issue. I have solved this way. > Please try this > You have to changing li

Re: [web2py] Error importing csv file in python3.6

2019-02-11 Thread sandeep patel
')): db['table name'].insert(**i) except Exception as e: print(e) form.errors.csvfile = 'Invalid file format.' Thanks SP On Mon, Feb 11, 2019 at 11:45 PM Lovedie JC wrote: > Works. > But I can't access the data. &

Re: [web2py] Over ride SQLFORM defaults

2019-02-11 Thread sandeep patel
@Ben I don't think that Field has a _style attribute but in SQLFORM.factory you can use _style attribute. This style applies for all input Fields in form. You can try this way. in_form = SQLFORM.factory( Field('userid', label='User Id: ', requires=IS_NOT_EMPTY()), Field('password',

Re: [web2py] How can I return file name after inserting?

2019-02-27 Thread sandeep patel
If you are using the form to summiting data. You can use form vars to summiting data into multiple tables. form = SQLFORM(...) if form.process().accepted: db['table name'].insert(**form.vars) Even you only want to insert a specific field to the table you can do so. db.['table name'].insert

Re: [web2py] Re: Error: Exporting CSV file in SQLFORM.grid

2019-03-12 Thread sandeep patel
I have solved this problem. This problem is occurring because of filter object you have to convert into the list. You have to need some changes in the sqlhtml file. go to gluon/sqlhtml.py change line no : 2688 >From - sfields = reduce(lambda a, b: a + b, [filter(is_searchable, t) for t in tables])

[web2py] How to insert data into Database?

2017-11-20 Thread Sandeep Patel
I want to take data from the user using my HTML template and insert that data into my database without using SQLFROM and FROM in my controller file. can I do it? Actually, I am new in web2py, please give me direction. Here file #model file from gluon import DAL, Field mysql = DAL('mysql://*

[web2py] What is the diffrence between Web2py local host and Apache local host (wamp server)

2017-11-29 Thread Sandeep Patel
Hello Everyone, I hosted my web2py on AWS ec2 and Connected it with AWS RDS and ran web2py server (0.0.0.0:8000) locally. This provided me a global access. Now, I am curious as to what would have been the difference if i chose to host my web2py app on Apache local host (wamp server). Would gr

[web2py] Problem enabling Email services

2017-12-06 Thread Sandeep Patel
Hello I am trying to send a welcome message to user as an email. To achieve this, I have followed all the steps as they are described in the official documentation. Additionally all the settings that I have adopted for the purported functionality, can be found in the trailing email thread. How

Re: [web2py] Re: web3py -> py4web

2019-07-23 Thread sandeep patel
Absolutely Great!! But http://py4web.com/_documentation/static/ though 404 On Wed, Jul 24, 2019 at 11:28 AM Dave S wrote: > > > On Tuesday, July 23, 2019 at 10:40:27 PM UTC-7, Massimo Di Pierro wrote: >> >> OK. I know. I am not good with names. >> But there are lots of requirements to be ful

Re: [web2py] Website automatically gets logged out

2019-09-05 Thread sandeep patel
Hey Saranya, I have successfully depoyed PayUMoney payment gateway in web2py apps. Here is code repo for that. Please have a look at it. Thanks SP On Thu, Sep 5, 2019 at 4:58 PM Saranya S wrote: > Website automatically logs out after 'PayUMoney

[web2py] How can add new fields in the existing table in PY4WEB?

2019-09-21 Thread sandeep patel
Hello Massimo, In web2py, We can add new fields in the existing table by *auth.settings.extra_fields*. In Py4web. we can do the same? Thanks Sandeep -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.googl

[web2py] Unable to add auth.signature in table - PY4WEB

2019-09-21 Thread sandeep patel
Hello, I am getting an error to add auth.signature in the table. #model.py from . import common auth = common.auth db.define_table('organization_info', Field('name'), Field('date_of_birth', 'date'), Field('village'), Field('block'), Field('district'), Field('state'), Field('country'), Field('pin

[web2py] Does Database validators work in PY4WEB?

2019-09-21 Thread sandeep patel
Hello Massimo, I have added *IS_EMPTY_OR* validator in the field. I am getting an error. Is there any way to add a validator in the field in py4web? Please have a look at attached file. Thanks SP -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.c

Re: [web2py] Re: Does Database validators work in PY4WEB?

2019-09-21 Thread sandeep patel
Thanks Massimo, Now, it's working fine. On Sat, Sep 21, 2019 at 9:06 PM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > They work the same as in web2py but you must import them > > from pydal.validators import * > > On Saturday, 21 September 2019 08:15:43

Re: [web2py] Re: How can add new fields in the existing table in PY4WEB?

2019-09-21 Thread sandeep patel
ms. > Maybe I will make this easier later. > > You can also make another table that refences auth_user and create your > own forms to handle it. > > On Saturday, 21 September 2019 05:11:59 UTC-7, sandeep patel wrote: >> >> Hello Massimo, >> >&g

Re: [web2py] Re: Unable to add auth.signature in table - PY4WEB

2019-09-21 Thread sandeep patel
;), Field('pin'), auth.signature() ) On Sat, Sep 21, 2019 at 9:07 PM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Minor change of behavior. In py4web you need auth.signature() notice the () > > On Saturday, 21 September 2019 07:20:02 UTC-7, sandeep patel w

Re: [web2py] Re: Unable to add auth.signature in table - PY4WEB

2019-09-25 Thread sandeep patel
Massimo, Thanks a lot. Now it's working fine. Thanks Sandeep Patel On Mon, Sep 23, 2019 at 6:30 AM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Posted a new _scaffold. Now both db and auth are defined in common. If you > import common from models, you are fine.

Re: [web2py] Re: py4web has now a grid ...

2019-10-05 Thread sandeep patel
@Massimo, Grid not working properly, Only seeing a blank page. Please, Give me some direction. Thanks Sandeep On Mon, Sep 16, 2019 at 2:49 AM isi_jca wrote: > Hi! > > This is output from console and the browser is Google Chrome Versión > 66.0.3359.181 (Build oficial) (64 bits) > > [jalborn

Re: [web2py] Re: Web2py survey ??

2020-01-08 Thread sandeep patel
@ I agree with you. On Wed, 8 Jan, 2020, 6:27 PM Ari Lion BR Sp, wrote: > Good Idea > > Em quinta-feira, 26 de dezembro de 2019 13:23:54 UTC-3, Ramos escreveu: >> >> Hi all, i think that it could be important to question users about many >> things to be known by us all. >> I think it could serve

Re: [web2py] py4web nw version and new example

2020-02-09 Thread sandeep patel
Hello Martin, Three are a couple of ways to try the new version, You can create a new virtual environment and install the newest version by pip or if you want to update the version in exiting ENV so you can also update by using pip command. Thanks & Regards Sandeep On Mon, Feb 10, 2020 at 12:47

Re: [web2py] py4web new docs

2020-11-27 Thread sandeep patel
@Massimo, Thanks for sharing. On Sat, Nov 28, 2020 at 11:22 AM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > > https://py4web.com/_documentation/static/en/index.html > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2p

Re: [web2py] Re: Application Issues After MySQL Database Update

2024-06-01 Thread sandeep patel
Thank you @villas for guidance. I'm pleased to inform you that I have identified and fixed the problem. The application is now running smoothly. Many Thanks SP~ On Thu, May 30, 2024 at 5:25 PM villas wrote: > As this error seems to indicate a mismatch in the expected char set of the > data. >