/ TRAVELTRAX Web Reporting
Release Notes 7.x
November 14, 2013

TABLE OF CONTENTS

v7.1.13 3

v7.1.12 5

v7.1.11 6

v7.1.9 7

v7.1.8 8

v7.1.7 8

v7.1.6 11

v7.1.5 12

v7.1.4 14

v7.1.3 15

v7.1.2 15

v7.1.1 16

v7.1 17

V7.0 17

November 2014

v7.1.13

Feature #1

Purpose / Scheduled Task file name
Summary / Users can now change the file name that shows when a report is sent via scheduled task to email or an FTP location.
Technical Details / On the page where users enter dates and prompts, they can now enter a different file name for this scheduled task.
Our system sends one report at a time (per email or SFTP file).
Client Considerations / You can configure the Scheduled Task file name by using parameters like those in the email's subject. Example - %Report_Name%, %Profile_Name%, etc.
Example: If you have multiple reports in a scheduled task and you want to change the scheduled task file name and you need the name of the report to be part of the file name, then you can configure it using %Report_Name%. This will enter the actual report name in the file as well as any other text you add.
If you leave it blank, it will default to what our system currently addes (Scheduled task name, profile, name, and report name)

Feature #2

Purpose / Scheduled Tasks – Can now add an end date and time to a scheduled task
Summary / When you add or edit a scheduled task, you’re now able to add an end date and time. This will be the last date and time you want the scheduled task to run.
Technical Details / This is not a mandatory field, so you don’t have to select an end date or an end time.
Client Considerations / An End Date and an End Time have to be added together. You cannot add one without the other.

v7.1.13 continued

ID / STATE / SYNOPSIS / NOTES
76706834 / Fixed / Transaction Overview Report errored for one client. / Logo was causing the error. It’s been fixed.
80667656 / Fixed / Client ran report using Previous Fiscal Month YTD and the dates are incorrect when looking at the fiscal dates entered into the Entity. / This issue has been fixed.
80669250 / Fixed / Client ran a report using Previous Fiscal Month Previous Year and it did not run the report for the correct dates. / This issue has been fixed and, as long as the fiscal dates have been entered by your administrator, the reports should run for the correct dates.
79689406 / Fixed / Client ran report using Current Fiscal Year as it was defined in their Entity. The report ran for the wrong dates. / This issue has been fixed.
77612164 / Fixed / Prompt values were not showing correctly on reports. / This issue has been fixed.
79912026 / Fixed / Several emails were never sent from Scheduled Tasks. / The emails were stuck in Queue mode. We changed the code and this issue is fixed.
80480902 / Fixed / Administrators were unable to delete FTP locations if necessary. / This has been fixed. Please see the screenshot below to see where this can be done.

October 2014

v7.1.12

Feature #1

Purpose / Set FTP Location
Summary / Level 2 administrators can now set a secure FTP location for their entity’s users to send reports to.
Technical Details / None
Client Considerations / They can only set the FTP location for their entity and no other.

Feature #2

Purpose / Scheduled Task file name
Summary / A system administrator can now exclude the Task name from the File name (zip file name in the email sent to the user).
Technical Details / A Concur system administrator has to set this up and it will apply to ALL users on the site.
Client Considerations / With this option, the administrator can now exclude the task name from the report’s file name (in the email sent to the user).
If you want this for all your users, someone from your company needs to open a case on the TRAVELTRAX portal http://portal.traveltrax.com/ and ask that this option be enabled.

Bug Fixes

ID / STATE / SYNOPSIS / NOTES
PT-78586142 / FIXED / When a user edits a scheduled task that had FTP as the Output Destination, the system automatically switched the Output Destination back to Browser, forcing the user to change it back to FTP (if they noticed it). / This issue has been fixed.
PT-78831272 / FIXED / The FTP Setup page should display the MetaLayerID. / This issue has been fixed.
PT-79552356 / FIXED / Previous Month Previous Year throws report error / This issue has been fixed.

September 2014

v7.1.11

Feature #1

Purpose / Secure FTP Output Destination
Summary / Users now have the option to run reports to an FTP server that is set up by an Administrator to the Web Reporting site (someone from their company would set it up).
Technical Details / PT-77050180
Client Considerations / You must be a level3 administrator in order to add the FTP information to your site. The FTP information must be set before users can see this option in the Output Destination area when running a report.

Feature #2

Purpose / Scheduled Task names cannot contain special characters.
Summary / We will no longer accept the following characters in a scheduled task name
/ \ : * ? “ < >
Technical Details / This causes a problem when saving to the file system.
PT-76965954
Client Considerations / Use only underscore _ and dashes – in the scheduled task name.
ID / STATE / SYNOPSIS / NOTES
PT76452578 / Fixed / Client is running a report and entering CC numbers in a prompt. When they enter too many credit card numbers, the report fails. / This issue is fixed.
PT 78014040 / Fixed / Using “Previous 12 Month” period generate wrong report as the dates are reversed / This issue is fixed.
PT 78392218 / Fixed / Clients are unable to save Fiscal Calendars at Entity Level / This issue is fixed.
PT 78413568 / Fixed / Admin users are unable to save Fiscal Calendars at Meta Level / This issue is fixed.

July 2014

v7.1.9

Feature #1

Purpose / Give each company the ability to create their own fiscal calendar.
Summary / The company’s site administrator is now able to create a fiscal calendar. Users will then be able to run reports against their fiscal year if that prompt is included in the report.
Technical Details / N/A
Client Considerations / See instructions below to see how your site administrator can set up the fiscal calendar and how the user can run reports using the fiscal calendar.

Feature #2

Purpose / Scheduled Task Email Subject
Summary / The name of the scheduled task will now be included in the subject line of the email (see screenshot below).
Technical Details / N/A
Client Considerations / N/A

Feature #3

Purpose / Forgotten Password (Reset)
Summary / Users will now be able to click on a “Forgot Password?” link to reset their own password.
Technical Details / N/A
Client Considerations / See instructions below on how to reset your own password.

Bug Fixes

ID / STATE / SYNOPSIS / NOTES
ID-75902632
SF-40138 / Fixed / The format for the date field in adhoc reports were coming out in an unreadable format. / The format will default to mm/dd/yyyy for adhoc reporting.

June 2014

v7.1.8

Only Bug Fixes in this release

ID / STATE / SYNOPSIS / NOTES
SF-00020622 / Fixed / The SQL is pulling the Car ReferenceNum from the ReservationNum column in the VehicleRentalDetailAddendum_5040 table. / We are now importing the reference number from AcquirerReferenceData field.
PT-65660220
SF- 29846 / Fixed / Client prompt request on CCHDR016 field. / Prompt has been added and decrypted.

May 2014

v7.1.7

Feature #1

Purpose / Users can reset their own password if they’ve forgotten it.
Summary / A link has been added so users can reset their password if they’ve forgotten it. They’ll click that link, enter their email address, and then click the link in the email and that will take them to the page where they can create a new password.
Technical Details / PT- 68538322
Client Considerations / See steps to reset forgotten password below:

Feature #2

Purpose / The person that creates a scheduled task can opt out of receiving emails from scheduled tasks.
Summary / Users will be able to opt out of receiving emails from all scheduled tasks. If they need to receive emails for specific scheduled tasks they can add their own email address to the scheduled task (see instructions below).
Technical Details / PT-68183390
Client Considerations / The opt out option is on the second page of your user settings. It will opt out of sending emails from any scheduled task you create.
·  See instructions below on how to opt out.
·  See instructions below on how to have emails sent to you on specific scheduled tasks after you’ve opted out.

Feature #3

Purpose / Allow the user to leave a prompt value blank if it’s a numeric value.
Summary / Prompts on a numeric field were automatically required even though the prompt wasn’t built that way.
Technical Details / PT-67208350
Client Considerations

v7.1.7 continued

ID / STATE / SYNOPSIS / NOTES
PT68194682 / Fixed / Users received the following error: General Error in Thread; Error 8181; Section #; Message Collection was modified; enumeration operation may not execute. Collection was modified error from Section Builder / Issue was fixed.
PT68191724 / Fixed / Users received the following error: General Error in Thread; Error 8181; Section #; Message Collection was modified; enumeration operation may not execute. Collection was modified error generated from "FromGenerator.cs" / Issue was fixed.
PT69656414 / Fixed / Reports with Excel macro designs were using the same icons as adhoc reports so users couldn’t tell the difference between the two design types. / Reports with Excel Macro designs (.xlsm) will now show the Excel icon instead of the adhoc reporting icon.
PT69656414 / Fixed / Standard reports using xlsm and adhoc reports were showing the same icon. / Reports using .xlsm will now show the Excel icon.
PT70975502
SF-35955 / Fixed / When using was changing a user date to the Prev 12 month’s system date, they got a 7371 error message stating that * is not a valid integer value. / Expanded the field from 1 to 3 characters.

April 2014

v7.1.6

Feature #1

Purpose / Previous Month Previous Year system date added.
Summary / A new system date called Previous Month Previous Year has been added to Web Reporting site.
Technical Details
Client Considerations / This system date should be used when you want the beginning of the previous month from last year to the end of the month of this year.
Example: Today is 4/9/2014. If you use this system date today, you would get 3/1/2013 – 2/28/2014.
ID / STATE / SYNOPSIS / NOTES
PT-60665210 / Fixed / Scheduled tasks are not considering daylight savings time for the next run. / Scheduled tasks will look at the start date and the next run date to determine daylight savings time and will run the report(s) at the correct time.

March 2014

v7.1.5

Feature #1

Purpose / Enhanced Security
Summary / Enhanced security has been added to the administration of the Web Reporting site.
Functional Details / N/A
Client Considerations

Feature #2

Purpose / A new system date has been added: Previous Month Previous Year.
Summary / This system date will pull up data from 13 months ago.
Functional Details / N/A
Client Considerations / Example:
Today is February 28, 2014.
If I added this system date, it would pull up data for:
January 1, 2013 – January 31, 2013
ID / State / Synopsis / Notes
56909924 / Fixed / Duplicate emails sent from scheduled tasks / Tasks that executed in the last 5 minutes will not be re-executed. Additionally logic changes were made to ensure that the next scheduled run time is being set properly.Added a timestamp column to keep track of the last execution time. Tasks that have executed in the last five minutes will not be re-executed.Added a timestamp column to keep track of the last execution time. Tasks that have executed in the last five minutes will not be re-executed.Added a timestamp column to keep track of the last execution time. Tasks that have executed in the last five minutes will not be re-executed.Added a timestamp column to keep track of the last execution time. Tasks that have executed in the last five minutes will not be re-executed.
53732661
SF - 1423114231 / Fixed / If a scheduled task uses a hierarchy and the hierarchy node used is no longer a part of the client’s hierarchy, then filters are dropped. / This issue has been fixed.
N/A / Fixed / XLSWriter - too many rows exception handling. Error mssg is not displaying for the user. Or, if it does display, then it does not show the number of rows attempted. User is getting assertion error pop up to the screen. / Error messages now show “This report exceeds the 65,000 row limit for Microsoft Excel please try running the report with a smaller date range or add prompt values to filter the report" or
“Too many rows exception: Max num rows allowed has been exceeded 65536 allowed, (insert num rows used) attempted.”
This report exceeds the 65,000 row limit for Microsoft Excel please try running the report with a smaller date range or add prompt values to filter the report".

v7.1.5 continued

62754330
SF - 27968 / Fixed / Scheduled Task Error:
Collection was modified; enumeration operation may not execute.Scheduled tasks and interactive tasks not producing same results with default corporate structure. Checking for duplicate entries resolves the issue reported. However I don't know if there will be side effects.Scheduled tasks and interactive tasks not producing same results with default corporate structure. Checking for duplicate entries resolves the issue reported. However I don't know if there will be side effects. / This was a random error that has been fixed.
64835484
SF - 30385 / Fixed / Scheduled tasks and interactive tasks not producing same results with default corporate structure. / This issue was fixed.
65122116
SF - 30295 / Fixed / A scheduled task failed due to unexpected response from db. / This issue was fixed.
63648340 / Fixed / Frame-busting issue. / This issue was fixed.
PT66954222
SF-32077 / Fixed / CC Decryption only decrypted first CC Number in a result set / All credit card numbers are now decrypting.

February 2014