Skip to Main Content
IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Delivered
Workspace IBM i
Categories Db2 Web Query
Created by Guest
Created on Jun 9, 2017

Add date to file name on download from HTML page

The option to add the date to the end of a file name at on demand download.


Use Case:

User views a file on an HTML page. Chooses Output to Excel 2007. File downloads with name: filename_20170609.xlsx


Idea priority Low
  • Guest
    Reply
    |
    Jul 30, 2020

    Since there was no response or confirmation, IBM assumes the delivered option below suffices.

  • Guest
    Reply
    |
    Jun 27, 2017

    Maybe we have something that might work.

    You can change by output file type to have the generated name appended with date stamp and time stamp.

    For example, a file that today would be named Report1.html would become Report1_20170627_121055.html (name_yyyymmdd_hhmmss.html). Try enabling it and see if it does what you want.

    To enable:

    1. Sign on to Web Query (http://:12331/Webquery) using the QWQADMIN user profile (it MUST be QWQADMIN).
    2. Choose Administration->Administration Console from the upper right options
    3. Copy the URL on the window that comes up, paste it into a new browser window, and append ?showall to it. For example: http://:12331/webquery/console/webfocusconsole.jsp?showall
    4. Click on 'Redirection Settings' in the left tree
    5. in the setting that come up on the right, scroll down until you find .htm and .html and change 'Save report' from no to yes
    6. Click the Save button at the bottom of the list of settings
    7. Go rerun a report that outputs htm or html and verify the resulting output file name has the date and timestamps

    If it works, you can go back in to the redirection settings and change other file types as you want.

  • Guest
    Reply
    |
    Jun 23, 2017

    My users don't see the portal. It was decided (not by me) to restrict access to HTML pages via a custom web page. The users cannot see the url pointing to the Restful service. These are on demand files, not scheduled reports. Currently, when files are output to any format other than screen, the file name is the same as the fex file (when that does work. See PMR26279,122,0). I would like the option to change what the file output name is, specifically the ability to put a date stamp on the end of the name.

  • Guest
    Reply
    |
    Jun 22, 2017

    There are I believe two perspectives to this request.

    1.
    For report distribution using report broker, there is a solution today on Web Query v2.2. It involves using the global variable &YYMD on the save as file name. For example, the save as name on the schedule could be

    myreport_&YYMD

    When the report runs it would generate, for example, an output file myreport_20170622.

    2.
    It appears you are asking for the 'default' name of the output file to have the name with date preset? But the customer can always specify the file name themselves in that interface, so overriding what the default is seems like a lower priority item.

    Please let me know if I missed something.

  • Guest
    Reply
    |
    Jun 19, 2017

    Thank you for the suggestion. We will investigate.