[web2py] Auto authentification using PAM or LDAP

2018-02-09 Thread J-Michel Angers
I'm developping an workflow application, to create documents (or needs or purchase requests..) that have to be validated by many users. This appli will work in an intranet. The user are authentified thru an AD. I have 2 questions, 2 needs : First one, due to the AD and internal policy, users

[web2py] The ondelete in a grid seems do nothing...

2017-10-24 Thread J-Michel Angers
Hi, I manage a page with a sqlform ("Order") and a sqlform.grid ("Articles"). Test1 : On the grid, when I click on the button "Delete", this Article is removed from the grid ... on the screen. When I reload the order, I see the article again. Test2 : I add a line un my grid instruction, with an

[web2py] default filter in SQLFORM.grid

2017-08-30 Thread J-Michel Angers
Hi, I'm writing an app to manager tasks / worflows / Purchase requests, ... So the first screen (index) is a SQLFORM.grid, that displays the active orders. But the most usefull should be that this grid shows the active order via a filter. The user can remove this filter to see all orders (and

[web2py] Re: FPDF "ne commence pas par '%PDF-' "

2017-06-26 Thread J-Michel Angers
SUPER ! With thiw, it works exactly as I wish. => A message appears "Do you want to open/save/saveAs ?", and after the choice "Open", I see my PDF in the "Acrobat" tool. Thank you very much for this advice :-) :-) Le lundi 26 juin 2017 07:12:49 UTC+2, Peter a écrit : > > Have been outputting

[web2py] FPDF "ne commence pas par '%PDF-' "

2017-06-21 Thread J-Michel Angers
Hi, A try to write my first PDF report (the user fill a form, manager it, at the end another user print this order). All the test I read in this forum or in the documentation alwyas end with "Le fichier ne commence pas par '%PDF-' Local\EWH-3508-0 " First test : from gluon.contrib.fpdf

[web2py] Re: SQLFORM.grid filtering with local and external table

2017-06-12 Thread J-Michel Angers
Oh Yes ! Instead of an algorythm with variables and loops and I saw this "belongs", but I hadn't imagined that it was the as the "IN" of a select... Thank you very much. I appologized, not to understand this myself :):):) -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] SQLFORM.grid filtering with local and external table

2017-06-12 Thread J-Michel Angers
Hi, My app goes forward, I have plaisure to develop with web2py. But sometimes I don't find myself the solution for very specific search. My app works well now, I can fill a request, add/remove parts, add/remove attached, calculate price, send this request to collect signatures Now I try to

[web2py] Re: Codec MS-SQL, unicode Latin1 UTF8

2017-05-19 Thread J-Michel Angers
Hello, Many thanks at both of you :-) I've just made a lot of tests, a lot of combinations I confirm : mssql4 is NOT the good connector for this. mssql2 works much better ! ! For unicode fields (type nvarchar in SQL-Server), mssql2 without codec works very well, but doen't work for varchar

[web2py] Codec MS-SQL, unicode Latin1 UTF8

2017-05-18 Thread J-Michel Angers
Hello, For my app, with data in SQL-Server 2012, I cannot have all letter correctly written. First, in SQL-Server, there are 2 types for storing a string : * char and varchar are string types with "old" charset, ie not uniccode, and dependant on the site. * nchar, nvarchar are string types

[web2py] Re: upload and download, in order to manage attached files

2017-05-18 Thread J-Michel Angers
One step more :-) Without changing the above code, it's working now. The change I've written ==> in the DAL, I had "db_codec='latin1' ". I just removed it for another reason, and it works now. ... And I understand now the link /default/download/ : it's / controlleur="default" /

[web2py] Re: upload and download, in order to manage attached files

2017-05-18 Thread J-Michel Angers
Thank you Dave for your advices ! You're right, I didn't look at the "download" function, and I didn't change it. I've done this now : (1) I've removed the "auth" condition, and I change the db to dbW = the database for my app I also change the line in the view. New version of download : def

[web2py] upload and download, in order to manage attached files

2017-05-17 Thread J-Michel Angers
Hi, I'm building an app to fill "PurchaseRequest", to valid it by the staff, and then type a "PurchaseOrder". Exactly like with a paper form that we fill, and get signatures to valid it. Now the main boby of the app works (fill the form, set/choose the route, send emails to the concerned