Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Session.SaveDataAsFile - and get it back for a report

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Session.SaveDataAsFile - and get it back for a report

    I'm saving a plain ascii file ("MyFile.txt") with Session.SaveDataAsFile(), but then trying to get it's contents into a report.

    It would seem that I can could have a calc field in the report like this:

    Code:
    filedata = printhtml(Session.FormatFileDataURL("MyFile.txt"))
    But it only returns this:

    /A5SessionFile.MyFile.txt

    Can't seem to find any syntax that will retrieve the .txt file for use in the report. Any ideas?
    -Steve
    sigpic

    #2
    Re: Session.SaveDataAsFile - and get it back for a report

    Hi Steve:
    I am in the same situation. The file is created and stored in a session folder, I can see it and open it. It shows in 'attachment' control on my dlg as
    /A5SessionFile/Invoice_sa2486.pdf
    However when the email is sent, the file is not attached, the email is received without any attachment.
    Any pointer how I can attach the file to the email will be much appreciated.

    Comment


      #3
      Re: Session.SaveDataAsFile - and get it back for a report

      Session.GetDataFromFile(Key as C, BYREF Data as B, [RemoveAfterFirstRetrieval = .F. as L])

      Lenny Forziati
      Vice President, Internet Products and Technical Services
      Alpha Software Corporation

      Comment


        #4
        Re: Session.SaveDataAsFile - and get it back for a report

        Lenny:
        This is an excerpt from V11 release notes
        Web Applications - Working with Session Files - New Methods of the Session Object - Three new methods of the session object have been introduced. These methods are:

        SaveFileToSessionFile � Copies a disk (presumably temp file) file to the session storage.
        GetDataFromFile - Retrieves data from session storage by key previously stored using SaveDataAsFile.
        DeleteSessionFile - Deletes a file from session storage

        Syntax:
        Session.SaveFileToSessionFile(key as c,data as a)

        Example:
        dim b as b
        b = file.to_blob("<some file name>")
        dim key as "temp.jpg"
        Session.SaveFileToSession(key,b)


        Syntax
        Session.GetDataFromFile(BYREF data as B,key as c)

        Example:
        dim b as b
        dim key as c
        key = "temp.jpg"
        Session.GetDataFromFile(b,key)
        1st) Session.GetDataFromFile(b, realname) returns true, it does not return the path to the pdf file saved in the session folder. The good old session.session_folder does return the path to the file and that's what I am currently using to attach files to emails and the file does get attached. Since session.session_folder will be deprecated in future releases, I am looking for something that returns the path to the file like session.session_folder does.

        2nd) Session.SaveFileToSessionFile() is not working with me. I get this error " Session.SaveFileToSessionFile(realname,b) Property not found "
        On the other hand (*) Session.SaveDataAsFile(realname,b) does work. It saves the file in the session folder.


        (*) In 'Storing Files in Sessions' in the wiki it is mentioned Session.SaveDataToFile() along with Session.SaveDataAsFile(). Are these two different methods? Session.SaveDataAsFile() works, Session.SaveDataToFile() never worked with me.

        Comment


          #5
          Re: Session.SaveDataAsFile - and get it back for a report

          Originally posted by gaby_h View Post
          1st) Session.GetDataFromFile(b, realname) returns true, it does not return the path to the pdf file saved in the session folder. The good old session.session_folder does return the path to the file and that's what I am currently using to attach files to emails and the file does get attached. Since session.session_folder will be deprecated in future releases, I am looking for something that returns the path to the file like session.session_folder does.
          As stated in the release notes, Session.GetDataFromFile() retrieves data, not the path to the file. Session.GetDataFromFile(b,realname) will return true or false, and b will be populated with the contents of the file if the return value is true. There is no way to retrieve the physical path to the file. Session.Session_Folder is already deprecated and it will NOT be in V12.

          Originally posted by gaby_h View Post
          2nd) Session.SaveFileToSessionFile() is not working with me. I get this error " Session.SaveFileToSessionFile(realname,b) Property not found "
          On the other hand (*) Session.SaveDataAsFile(realname,b) does work. It saves the file in the session folder.
          Session.SaveFileToSessionFile() takes 2 strings, the source file name and a key. This method then copies the specified file into Session storage using the supplied key.

          Originally posted by gaby_h View Post
          (*) In 'Storing Files in Sessions' in the wiki it is mentioned Session.SaveDataToFile() along with Session.SaveDataAsFile(). Are these two different methods? Session.SaveDataAsFile() works, Session.SaveDataToFile() never worked with me.
          Thank you for bringing this to our attention. There is no Session.SaveDataToFile() method, Session.SaveDataAsFile() is the correct method. I have fixed this in the Wiki.



          If you want to attach a physical file to an email, and the source for that file is stored in the Session, you would need to copy the file out of Session and store it as a local temp file and attach that. You should look at Request.GetRequestTempFileName() for this purpose, as it will automatically clean up the temp file for you when processing for the Request completes.

          But, if you are creating your PDF and emailing it in the same page execution, you don't need the Session file at all and can just use the Request temp file.

          Lenny Forziati
          Vice President, Internet Products and Technical Services
          Alpha Software Corporation

          Comment


            #6
            Re: Session.SaveDataAsFile - and get it back for a report

            There are only two known sources documenting Session.GetDataFromFile, and they have contrary information!

            The release notes have one way...

            Session.GetDataFromFile(BYREF data as B,key as c)
            ...the wiki states another:

            Session.GetDataFromFile(Key as C, BYREF Data as B, [RemoveAfterFirstRetrieval = .F. as L])
            For what it's worth, only the release notes are correct.

            Someone fix the wiki!
            Alpha Anywhere latest pre-release

            Comment

            Working...
            X