[web2py] PYFPDF and printing labels

2013-01-12 Thread Paul Rykiel
Greetings, Has anyone used the PYFPDF library to build and print labels Are there setting to control the label sizes and to skip to print the next label. Please advise --

[web2py] Re: PYFPDF and printing labels

2013-01-12 Thread Paul Rykiel
; from the Pckt recipes book. In the same place you can also find the code. > > On Saturday, 12 January 2013 19:15:11 UTC-6, Paul Rykiel wrote: >> >> Greetings, >> >> Has anyone used the PYFPDF library to build and print labels >> Are there setting to control the

[web2py] Having some strange occurence with label printing and FPDF

2013-01-15 Thread Paul Rykiel
Greetings this is my code: def triagePrintTags(bikeIds): assert(bikeIds != None) assert(isinstance(bikeIds, list) or isinstance(bikeIds, tuple)) pdf = FPDF('P', 'mm', (66.548, 25.4)) # get all the r(ows rows = db(db.bike.id.belongs(bikeIds)).select() for row in rows:

Re: [web2py] Having some strange occurence with label printing and FPDF

2013-01-16 Thread Paul Rykiel
gt; Best regards, > > Mariano Reingart > http://www.sistemasagiles.com.ar > http://reingart.blogspot.com > > > On Tue, Jan 15, 2013 at 8:02 PM, Paul Rykiel > > wrote: > > Greetings this is my code: > > > > def triagePrintTags(bikeIds): > >

Re: [web2py] Having some strange occurence with label printing and FPDF

2013-01-16 Thread Paul Rykiel
t += "Size: " + row.size + "\n" if row.size else "" > pdf.add_label(more_text) > > response.headers['Content-Type'] = 'application/pdf' > response.headers['Content-Disposition']='attachment.filename = >

Re: [web2py] Having some strange occurence with label printing and FPDF

2013-01-16 Thread Paul Rykiel
n" if row.model else "" > more_text += "Size: " + row.size + "\n" if row.size else "" > pdf.add_label(more_text) > > response.headers['Content-Type'] = 'application/pdf' > response.headers['

[web2py] why is my "\n" not working

2013-01-16 Thread Paul Rykiel
greetings, I have a string that I have defined string = "line 1" + "\n" string += "line 2" + "\n" shouldn't my string print as follows: line 1 line 2 it does not what do I seem to be doing incorrectly? --

[web2py] Anyone have experience printing labels Avery 5160

2013-01-16 Thread Paul Rykiel
I need to create a sheet of labels (Avery 5160) I am using FPDF cells any assistance would be greatly appreciated. Regards, --

[web2py] Re: why is my "\n" not working

2013-01-16 Thread Paul Rykiel
I am printing the text in a cell in PDF pdf.cell() On Wednesday, January 16, 2013 9:57:45 PM UTC-6, Massimo Di Pierro wrote: > Are you printing it or writing it into HTML? In html \n is not newline. > > On Wednesday, 16 January 2013 21:51:56 UTC-6, Paul Rykiel wrote: >> >>

Re: [web2py] Having some strange occurence with label printing and FPDF

2013-01-17 Thread Paul Rykiel
py it > at gluon/contrib/fpdf directory so you can use: > > from gluon.contrib.fpdf.pdflabels import PDFLabel > > PDFLabel accepts "\n" , if you use cell, it doesn't understand "\n" > > Regards. > > 2013/1/16 Paul Rykiel >: > > Hi Jose, &

Re: [web2py] Having some strange occurence with label printing and FPDF

2013-01-17 Thread Paul Rykiel
dates. You can download it from > > http://code.google.com/p/pyfpdf/source/browse/pdflabels.py and copy it > > at gluon/contrib/fpdf directory so you can use: > > > > from gluon.contrib.fpdf.pdflabels import PDFLabel > > > > PDFLabel accepts "\n" , if you

Re: [web2py] Having some strange occurence with label printing and FPDF

2013-01-17 Thread Paul Rykiel
upid example app? > > Thank you > António > > 2013/1/17 Paul Rykiel > >> I just want to say a big Thank you! >> this works perfectly!! >> I am so happy! >> Best Regards, >> >> On Thu, Jan 17, 2013 at 1:49 AM, Mariano Reingart wrote: >&

[web2py] Need a simple to follow Database to PDF for reporting

2012-11-11 Thread Paul Rykiel
Hi, I am new to Web2py ... I am just looking for a simple Database to PDF I will need to create a form to enter a selection criteria and then I will need to create a PDF. everything I am finding in search is too complex. This can't be that difficult any help will be appreciated. --

[web2py] Re: Need a simple to follow Database to PDF for reporting

2012-11-11 Thread Paul Rykiel
thank you ... this did not come across in my search. Regards, On Sunday, November 11, 2012 7:41:26 AM UTC-6, Paul Rykiel wrote: > Hi, I am new to Web2py ... I am just looking for a simple Database to PDF > I will need to create a form to enter a selection criteria and then I will >

[web2py] Where do I find the import pdf

2012-11-12 Thread Paul Rykiel
Hi, I need to import pdf, because I keep getting an error "cannot import pdf", where do I find this? --

[web2py] Trying to create a simple report from DB to PDF need to import pdf

2012-11-12 Thread Paul Rykiel
Greetings, I need to know where to get and how to import pdf ... I am getting an error "cannot import pdf" --

[web2py] request args

2012-11-14 Thread Paul Rykiel
Hi just learning WEB2py and I have a question: why do i get an error on this code This code errors out, but when I replace "tag_no" with 1 for record id 1, it works, also the variable "tag_no" has a 1 as a value when i type in an argument 1 on the end of the URL * def tag(): tag_no =

[web2py] Re: request args

2012-11-17 Thread Paul Rykiel
rectly. > > localhost:8000///tag/1 > > > I never reassign request.args() unless I'm going to use it a > lot and want to save some typing. Same with request.vars. > > On Tuesday, November 13, 2012 6:28:59 PM UTC-5, Paul Rykiel wrote: >> >> Hi just learning

[web2py] Form question

2012-11-17 Thread Paul Rykiel
Greetings, I am new to Web2py and I have to do something very basic, but I am not certain how to do it, can someone explain. I want to create an empty form to be used to enter parameters that will perform a function, print an "n" number of tags. . I used the following to create the input fie

[web2py] Entry forms

2012-11-17 Thread Paul Rykiel
Greetings ... can someone tell me the best way to create a form which has entry fields on in? for Example: Enter the Number of Apples : ___ Enter thel Number of Pears: _ I set up my code to look something like this: apples = FORM(Input(_type="integer", _name="appl

Re: [web2py] request args

2012-11-17 Thread Paul Rykiel
llo Paul, > > request.args[0] returns a string, and for *Rows = > db(db.bike.id==tag_no).select() > *you need an integer. > Try this: > > tag_no = int(request.args(0)) >> > > And let me know. > > Cheers, > David > > > On 14 November 2012 00:28, Paul Rykiel

[web2py] having problems importing pyfpdf

2012-11-17 Thread Paul Rykiel
Where do I load this, in gluon.contrib? I keep getting wierd erros "module not found," or "cannot load fpdf" import from gluon.contrib.pyfdpf as pdf does not seem to work any assistance, I just want to use whatever took ships with Web2py, no special configs --

[web2py] Simple PDF process

2012-11-17 Thread Paul Rykiel
Greetings, can anyone direct me to a simple PDF process... here is what I would like to do: query a db and print 1 field out of the database onto a PDF Very simple My research has lead me to pyfpdf ... which supposedly is supposed to be included in the gluon.config already when i try to i

[web2py] import gluon.contrib.pyfpdf

2012-11-17 Thread Paul Rykiel
Greetings, Having difficulty trying to just do a basic PDF test, but getting error's on the import, well actually not an error, just no results. Here is my code, you may recognize it from tutorial from gluon.contrib.fpdf import FPDF def pdfexp(): pdf=FPDF() pdf.add_page() pdf.set_f

[web2py] args

2012-11-17 Thread Paul Rykiel
Greetings: The following line of code doesn't seem to be working, any ideas record = db(db.bike.bike_identifier != "").select()[0] assert(record != None) form = SQLFORM(db.bike, record, showid=False) form.add_button("Print_Tag", URL("tagprint", args=form.vars.bike_identifier)) Whe

[web2py] Re: request args

2012-11-17 Thread Paul Rykiel
ier==*request.args(0*)) * request.args(0) shows a NONE am I coding this incorrectly. On Saturday, November 17, 2012 6:34:08 AM UTC-6, Massimo Di Pierro wrote: > What error do you get? Are you trying to access the url with an extension? > > On Tuesday, 13 November 2012 17:28:59 UTC-6, Pau

Re: [web2py] Re: request args

2012-11-17 Thread Paul Rykiel
> Feel free to show me exact controller code. You can email me to my google > address. > > > On Saturday, 17 November 2012 12:06:36 UTC-6, Paul Rykiel wrote: >> >> Hi Massimo, >> >> This post is fixed, but I am having a similar issue when I tr

Re: [web2py] Re: request args

2012-11-17 Thread Paul Rykiel
as you can see I am still learning, but getting more comfortable, I didn't know that was a possibility. I will try thank you for your response!! Safe travels!! On Sat, Nov 17, 2012 at 5:02 PM, Anthony wrote: > @auth.requires_login() >> def repair(): >> ## TODO Need to add a way to find the

Re: [web2py] Re: request args

2012-11-17 Thread Paul Rykiel
well...that is not working, but I will keep working at it. mostly I just wanted to make certain that I wasn't doing something incorrectly. On Sat, Nov 17, 2012 at 5:09 PM, Paul Rykiel wrote: > as you can see I am still learning, but getting more comfortable, I didn't >

[web2py] Re: args

2012-11-17 Thread Paul Rykiel
thank you... that did not work but I will keep trying On Friday, November 16, 2012 7:10:35 PM UTC-6, Paul Rykiel wrote: > Greetings: > > The following line of code doesn't seem to be working, any ideas > > record = db(db.bike.bike_identifier != "").select()[

[web2py] Re: import gluon.contrib.pyfpdf

2012-11-17 Thread Paul Rykiel
this works great... Thank you Massimo! :) On Friday, November 16, 2012 5:26:51 PM UTC-6, Paul Rykiel wrote: > > Greetings, > Having difficulty trying to just do a basic PDF test, but getting error's > on the import, well actually not an error, just no results. > > H

Re: [web2py] Re: request args

2012-11-17 Thread Paul Rykiel
ke_identifier field? If so, the button url should include the > bike_identifier value as an arg -- is that the case? Is it breaking down > somewhere else? > > Anthony > > > On Saturday, November 17, 2012 6:16:02 PM UTC-5, Paul Rykiel wrote: > >> well...that is not work

Re: [web2py] Re: request args

2012-11-17 Thread Paul Rykiel
ote: > Do you mean request.args(0)? There is no request.vars(0). Maybe it would > help if you could show all the relevant code and describe the workflow (if > possible, you can simplify the code to the minimal code that reproduces > your problem). > > Anthony > > > On Saturd

Re: [web2py] Re: request args

2012-11-18 Thread Paul Rykiel
Thank you, I will try ... yes I do understand the difference between a field and an array and now that I think about it, it does make more sense since request.vars(0) is an array. LOL Thanks again!! On Sun, Nov 18, 2012 at 12:56 AM, Vasile Ermicioi wrote: > 2 errors > > 1) args should be an arra

Re: [web2py] Re: request args

2012-11-18 Thread Paul Rykiel
works for me > and I find pyfpdf pretty good. > > Peter > > > On Tuesday, 13 November 2012 23:28:59 UTC, Paul Rykiel wrote: > >> Hi just learning WEB2py and I have a question: >> >> why do i get an error on this code >> This code errors out, but whe

Re: [web2py] Re: request args

2012-11-18 Thread Paul Rykiel
thanks for all of your help ... I still don't have it working, but I have another idea and I will keep working on this. I will try out all of the different combination listed here and if they do not work, I have a workaround. thanks so much for your effort, I will fill you in when I get it working

[web2py] Re: request args

2012-11-18 Thread Paul Rykiel
folder into the modules folder of your app. Remember to restart web2py to > allow the changes in the module folder to filter through. This works for me > and I find pyfpdf pretty good. > > Peter > > On Tuesday, 13 November 2012 23:28:59 UTC, Paul Rykiel wrote: >> >>

[web2py] pyfpdf

2012-11-18 Thread Paul Rykiel
Greetings, I am new to Web2py and I am trying to create PDF's. The following example code works great and I believe it will work for my project; however, instead of the output going to the screen I would like it to download to a directory ... what do i need to do to make this happen. Thank y

Re: [web2py] Re: request args

2012-11-18 Thread Paul Rykiel
Anthony ... got it working, thanks for all of your help!! Best Regards, On Sunday, November 18, 2012 9:25:39 AM UTC-6, Anthony wrote: > It's still not clear exactly what isn't working. > > @auth.requires_login() >> record = db(db.bike.bike_identifier != "").select()[0] >> assert(record

Re: [web2py] Re: pyfpdf

2012-11-18 Thread Paul Rykiel
Thank you so much, this is working really well!! On Sun, Nov 18, 2012 at 9:45 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > response.headers['Content-Disposition'] = 'attachment; filename=tuto1.pdf' > > > On Sunday, 18 November

Re: [web2py] Re: request args

2012-11-19 Thread Paul Rykiel
er which is maybe why you are not > seeing it. > > if you do > > pdf.output(name=request.folder+'/static/tuto1.pdf') > > It would put it in the static folder of your application. > > Peter > > > On Monday, 19 November 2012 02:30:14 UTC, Paul Rykiel

[web2py] images folder

2012-11-19 Thread Paul Rykiel
Hi all, What folder inside of Web2py is the best place to store and retreive images for things like LOGO's and ICONS? Please advise. Thank you! --

[web2py] PDF to directory

2012-11-19 Thread Paul Rykiel
Greetings... I am using PYFPDF to create my pdf's ... all is great, but instead of automatically creating the PDF, I would like the system to prompt the user to enter the directory where they want the PDF saved to? Can this be done, this would be a big help. Thanks in advance for your assist

[web2py] Re: PDF to directory

2012-11-20 Thread Paul Rykiel
n(request.folder+'/static/temp.pdf','rb'),chunk_size=4096) > > > Peter > > On Tuesday, 20 November 2012 05:57:43 UTC, Paul Rykiel wrote: >> >> Greetings... >> >> I am using PYFPDF to create my pdf's ... all is great, but inst

Re: [web2py] images folder

2012-11-20 Thread Paul Rykiel
; *Bruno Cezar Rocha** - @rochacbruno* > rocha...@gmail.com | > www.CursoDePython.com.br | www.rochacbruno.com.br > Blog: Search form with > web2py<http://rochacbruno.com.br/search-form-with-web2py/> > > On Tue, Nov 20, 2012 at 3:52 AM, Paul Rykiel > > wrote: >

Re: [web2py] images folder

2012-11-20 Thread Paul Rykiel
This is great, but the image is too large ... I tried width and height, but I am not getting errors. do I need to do something in a On Tuesday, November 20, 2012 10:29:10 AM UTC-6, Paul Rykiel wrote: > Thank you... will do! > On Tuesday, November 20, 2012 12:09:55 AM UTC-6, rochacbruno

Re: [web2py] images folder

2012-11-20 Thread Paul Rykiel
nevermind figured it out!! On Tuesday, November 20, 2012 10:41:50 AM UTC-6, Paul Rykiel wrote: > This is great, but the image is too large ... I tried width and height, > but I am not getting errors. > do I need to do something in a > > On Tuesday, November 20, 2012 10:29:10

[web2py] Re: PDF to directory

2012-11-20 Thread Paul Rykiel
with multiple pages ... I am sure it is in the identation, I will keep trying. thanks so much, this is working great! On Tuesday, November 20, 2012 10:28:23 AM UTC-6, Paul Rykiel wrote: > Thank you Peter, I will try and let you know > On Tuesday, November 20, 2012 4:09:44 AM UTC-6, peter wr

[web2py] Need to save a multipage PDF

2012-11-20 Thread Paul Rykiel
Greetings everyone, this is my code and I am having difficulity creating a "Multipage" PDF to save to a directory. any assistance will be welcomed. Regards, def taggen_print(): rows = db(db.bike_no.id > 0).select() for row in rows: tag_no = row.bike_typ+str(row.id) pfil

[web2py] Re: Need to save a multipage PDF

2012-11-20 Thread Paul Rykiel
Nevermind ... figured it out On Tuesday, November 20, 2012 3:06:22 PM UTC-6, Paul Rykiel wrote: > > Greetings everyone, > > this is my code and I am having difficulity creating a "Multipage" PDF to > save to a directory. > any assistance will be welcomed. > &g

Re: [web2py] Re: Need to save a multipage PDF

2012-11-21 Thread Paul Rykiel
=4096) > # pdf.output(pfile, 'F') > redirect(URL("index")) > > > On Wed, Nov 21, 2012 at 5:18 AM, LightDot > > wrote: > >> This group is a wealth of information for other users, so when you can, >> please do post what is it that you&#x

[web2py] Re: Need to save a multipage PDF

2012-11-21 Thread Paul Rykiel
is a wealth of information for other users, so when you can, > please do post what is it that you've figured out. :) > > It's highly likely someone will have the same or similar problem and > search for answers. > > Regards, > Ales > > On Wednesday, Novembe

[web2py] Form Vars and request Vars

2012-12-31 Thread Paul Rykiel
hello, I have two form vars 1) startDt (defined as _class="date" 2) endDt (defined as _class="date" if form.accepts(request,session) redirect (URL('Labor_report')) def Labor_report(): strDT = request.vars(0) endDT = request.vars(1) My issue is strDT and endDT are both

[web2py] Re: Form Vars and request Vars

2012-12-31 Thread Paul Rykiel
uld take those two variables then. Unless of course, > you store them in a session. > > On Monday, December 31, 2012 5:29:33 PM UTC-7, Paul Rykiel wrote: >> >> hello, >> >> I have two form vars >> >> 1) startDt (defined as _class="date" >

[web2py] Re: Form Vars and request Vars

2012-12-31 Thread Paul Rykiel
On Monday, December 31, 2012 6:29:33 PM UTC-6, Paul Rykiel wrote: > > hello, > > I have two form vars > > 1) startDt (defined as _class="date" > 2) endDt (defined as _class="date" > > if form.accepts(request,session) >red

Re: [web2py] Re: Form Vars and request Vars

2012-12-31 Thread Paul Rykiel
> > Try putting something like: > > redirect(URL('Labor_report', args=[form.vars.startDt, form.cars.endDT])) > El 31/12/2012 20:21, "Paul Rykiel" > > escribió: > >> >> On Monday, December 31, 2012 6:29:33 PM UTC-6, Paul Rykiel wrote: >>

[web2py] any publications or sites on Using SQL in Web2py

2013-01-03 Thread Paul Rykiel
Hello, Are there any reference guides to build SQL statements in Web2py? --

[web2py] Re: any publications or sites on Using SQL in Web2py

2013-01-03 Thread Paul Rykiel
s/default/chapter/29/06#Raw-SQL > > -Jim > > On Thursday, January 3, 2013 2:14:05 PM UTC-6, Paul Rykiel wrote: >> >> Hello, >> Are there any reference guides to build SQL statements in Web2py? >> > --