Alpha Video Training
Results 1 to 15 of 15

Thread: How to create a pdf file from txt File or Xbasic function or another Third party software?

  1. #1
    Member
    Real Name
    ferry kurniawan
    Join Date
    Apr 2015
    Location
    Jakarta
    Posts
    96

    Default How to create a pdf file from txt File or Xbasic function or another Third party software?

    Hi all,

    Is there a way to create a pdf file from .txt file, or Xbasic function or another third party software?
    Let's say I have an user registration form. After user submit, I want to email user along with pdf attachment (so we don't use a pdf preview or something like that, just running in Xbasic)

    Fyi, I use email_send2 function to send email.

    - I have tried SAVE_TO_FILE() function, it's work if I create a *.txt file. But it's not working for *.pdf file (error when open that file).

    - I read on this thread,http://www.alphasoftware.com/alphafo...om-a-text-file , but how to run that third party software ?
    Maybe SYS_SHELL Function ? But it's only run for desktop application. Please show me an example to run another program from alpha if this method works.

    - I have read on thread that show an example to populate pdf when sending email. He used mandrill email function, and populate a pdf file using msg.AttachmentArrays[0], then declare msg.AttachmentArrays.file_name, msg.AttachmentArrays.file_type, msg.AttachmentArrays.file_body variables. However it's not working when I try this method in email_send2 function. (sorry I forgot the thread link)

    Thanks.

  2. #2
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    After user submit, I want to email user along with pdf attachment
    what pdf attachment?
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  3. #3
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Fyi, I use email_send2 function to send email.
    email_send2 does allow attachments.
    please see documentation.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  4. #4
    Member
    Real Name
    ferry kurniawan
    Join Date
    Apr 2015
    Location
    Jakarta
    Posts
    96

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Quote Originally Posted by GGandhi View Post
    email_send2 does allow attachments.
    please see documentation.
    Hi Gandhi,

    Yes I do know email_send2 can include attachment with msg.Attahcments = "c:\xx\xxx.pdf" and can include multi files with crlf() delimiter.

    I have problem to "create" the pdf file based on datasubmitted.fieldcolumn values. So I need to define the pdf file in the xbasic function.
    The PDF file is not exist before. It created when I submit record.


    I tried SAVE_TO_FILE() function. It's only work if I save it as .txt file.

    Can we do that?
    Last edited by ferryk17; 06-28-2016 at 04:53 AM.

  5. #5
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    datasubmitted.fieldcolumn values.
    are you talking about how to take the values from the form and make a report and attach it to the email.
    if the form has fields
    field-a
    field-b
    field-c
    then
    the report will contain
    field-a + field-b+ field-c
    ?
    looks like i need lot of explanation, right?
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  6. #6
    Member
    Real Name
    ferry kurniawan
    Join Date
    Apr 2015
    Location
    Jakarta
    Posts
    96

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Quote Originally Posted by GGandhi View Post
    are you talking about how to take the values from the form and make a report and attach it to the email.
    if the form has fields
    field-a
    field-b
    field-c
    then
    the report will contain
    field-a + field-b+ field-c
    ?
    looks like i need lot of explanation, right?
    Hi Gandhi,
    So, first I need to create a report (*.rpt file) then call it in Xbasic? Can I call the report from xbasic without displaying it? I never used it so I am little bit confused.
    I usually handle report with using javascript action - open report based on report layout.

    I am sure you understand what I try to do (sorry no offense).
    I want to submit a form, then in serverside event -> after_insert_record, I need to write send email code with email_send2 function.
    The email function is working fine, and I know I can attach some files in the msg.Attachments = "" paramaters. The only problem is I don't know how to include a pdf attachment that created from my form values.

    Thanks. Sorry if I look dumb.
    Last edited by ferryk17; 06-28-2016 at 05:30 AM.

  7. #7
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Code:
    filePO = "c:\A5Webroot\Reports\PurchaseOrder_"+poID+"_"+date_format(date(),"yyyMMdd")+"_"+time("0h0m")+".pdf"
    	dim vReport as c
    	vReport = report.saveAs("purchase_order@[claretPOS]\claretpos.alb","PDF",vFilter,"",filePO)
    I do send email with pdf attatchments, the data from the dialog is saved to a record and the report is created and attached to the email like this.

    this xbasic script runs after saving record.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  8. #8
    Member
    Real Name
    ferry kurniawan
    Join Date
    Apr 2015
    Location
    Jakarta
    Posts
    96

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Quote Originally Posted by GGandhi View Post
    Code:
    filePO = "c:\A5Webroot\Reports\PurchaseOrder_"+poID+"_"+date_format(date(),"yyyMMdd")+"_"+time("0h0m")+".pdf"
    	dim vReport as c
    	vReport = report.saveAs("purchase_order@[claretPOS]\claretpos.alb","PDF",vFilter,"",filePO)
    I do send email with pdf attatchments, the data from the dialog is saved to a record and the report is created and attached to the email like this.

    this xbasic script runs after saving record.
    Thanks Gandhi!

    I think this is what I need. I will give it a try. :)

  9. #9
    Member
    Real Name
    Paul Verboom
    Join Date
    Apr 2006
    Location
    Halifax, Nova Scotia, Canada
    Posts
    139

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    I've also genereated PDF reports under xBasic control. I can add. I you want to use bar codes or non standard fonts in the PDF the fonts need to be added to the PDF report. There is a Genie for doing this.
    Last edited by pboomwork; 06-28-2016 at 12:47 PM.

  10. #10
    Member
    Real Name
    ferry kurniawan
    Join Date
    Apr 2015
    Location
    Jakarta
    Posts
    96

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Quote Originally Posted by pboomwork View Post
    I've also genereated PDF reports under xBasic control. I can add. I you want to use bar codes or non standard fonts in the PDF the fonts need to be added to the PDF report. There is a Genie for doing this.
    Hi Paul,

    which one? Thanks
    Capture.JPG

  11. #11
    Member
    Real Name
    ferry kurniawan
    Join Date
    Apr 2015
    Location
    Jakarta
    Posts
    96

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    FINALLY IT WORKS!

    fn = request.GetRequestTempFileName(".pdf")
    fn = report.SaveAs(request.applicationRoot + "testpdf.a5rpt","PDF","","",fn)
    that code generate a temporary pdf file in webroot based on repot layout, then in sending email code :
    dim msg as P
    msg.html_message = param_message
    msg.to = param_to
    msg.cc = param_cc
    msg.bcc = param_bcc
    msg.subject = param_subject
    msg.Attachments = fn
    Thanks all.
    Last edited by ferryk17; 06-29-2016 at 03:30 AM.

  12. #12
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    exactly,
    good.

    if you have multiuser situation you might want to consider adding time as i did to a standard name, since each report will be unique rather than getting the name from them.
    regardless, good job.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  13. #13
    Member
    Real Name
    ferry kurniawan
    Join Date
    Apr 2015
    Location
    Jakarta
    Posts
    96

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Quote Originally Posted by GGandhi View Post
    exactly,
    good.

    if you have multiuser situation you might want to consider adding time as i did to a standard name, since each report will be unique rather than getting the name from them.
    regardless, good job.
    Yes Gandhi,
    I just want to make it works first. The next steps are easier to give a standard naming, etc.

    vReport = report.saveAs("purchase_order@[claretPOS]\claretpos.alb"
    Btw, I think that layout name only works for desktop application.

  14. #14
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Btw, I think that layout name only works for desktop application.
    never used desktop, only involved in web apps and mobile.
    it works both places.

    you probably not aware of aliases, it is aliasing desktop with webroot.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  15. #15
    Member
    Real Name
    ferry kurniawan
    Join Date
    Apr 2015
    Location
    Jakarta
    Posts
    96

    Default Re: How to create a pdf file from txt File or Xbasic function or another Third party software?

    Quote Originally Posted by GGandhi View Post
    never used desktop, only involved in web apps and mobile.
    it works both places.

    you probably not aware of aliases, it is aliasing desktop with webroot.
    Owh okay, my bad. I said that because when I write report.Saveas(" <-- it say click ctrl+down key to select report, but it doesn't show anything when I clicked it.

Similar Threads

  1. Can xbasic create a PDF from a text file?
    By drgarytraub in forum Application Server Version 10 - Web/Browser Applications
    Replies: 5
    Last Post: 05-19-2012, 07:55 AM
  2. Multiple embedded file Upload to MS SQL Server 2008 - Xbasic function needed
    By lsprowls in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 01-18-2012, 08:25 PM
  3. Capturing the newly create file name after file.watch_create() trigger.
    By bergmd in forum Alpha Five Version 10 - Desktop Applications
    Replies: 2
    Last Post: 05-25-2011, 02:25 PM
  4. Xbasic function declaration - file upload
    By Cammy in forum Application Server Version 10 - Web/Browser Applications
    Replies: 8
    Last Post: 01-31-2011, 06:57 AM
  5. Replies: 10
    Last Post: 06-13-2007, 06:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •