963 results found

1. archibus.log sql statements

   Starting from 2022.02 seems that there is no more option to disable prepared statements globally in web central.

   You need to take each parameter one by one and replace the ? value in original sql. If the parameter is of type date the thing is even more complex as you need to convert the date string into date object (to_date(……).
   So for debug purposes these are almost useless.

   My suggestion is to update DbConnectionImpl class and to adapt these 2 methods and use them instead of just logging the original sql string. This should work for Oracle

               private String formatSql(String sqlQuery, Object... parameters) {
                   String[] parts = sqlQuery.split("\\?");
                   StringBuilder sb = new StringBuilder();
   
                   // This might be wrong if some '?' are used as litteral '?'
                   for (int i = 0; i < parts.length; i++) {
                       String part = parts[i];
                       sb.append(part);
                       if (i < parameters.length) {
                           sb.append(formatParameter(parameters[i]));
                       }
                   }
                   return sb.toString();
               }
   
               private String formatParameter(Object parameter) {
                   if (parameter == null) {
                       return "NULL";
                   } else {
                       if (parameter instanceof String) {
                           return "'" + ((String) parameter).replace("'", "''") + "'";
                       } else if (parameter instanceof Timestamp) {
                           return "to_timestamp('" + new SimpleDateFormat("MM/dd/yyyy HH:mm:ss.SSS").
                                   format(parameter) + "', 'mm/dd/yyyy hh24:mi:ss.ff3')";
                       } else if (parameter instanceof oracle.sql.DATE) {
                           return "to_date('" + new SimpleDateFormat("MM/dd/yyyy HH:mm:ss").
                                   format(((DATE) parameter).timestampValue()) + "', 'mm/dd/yyyy hh24:mi:ss')";
                       } else if (parameter instanceof Boolean) {
                           return ((Boolean) parameter).booleanValue() ? "1" : "0";
                       } else {
                           return parameter.toString();
                       }
                   }
               }
   

   Thanks

   Starting from 2022.02 seems that there is no more option to disable prepared statements globally in web central.

   You need to take each parameter one by one and replace the ? value in original sql. If the parameter is of type date the thing is even more complex as you need to convert the date string into date object (to_date(……).
   So for debug purposes these are almost useless.

   My suggestion is to update DbConnectionImpl class and to adapt these 2 methods and use them instead of just logging the original sql string. This should work for Oracle

               private String formatSql(String

   … more
   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Platform  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. Dynamic Scheduling for SLAs

   Add the ability to use the date to perform (or similar) field instead of a certain number of days when setting up an SLA.

   Example: User submits a Conf. Room Setup request, these requests can vary widely in when they need to be performed. Some users submit them a week ahead, some users submit them a month ahead. Using the time to perform as the due date would alleviate the issue of setting a specific numbers of days to perform.

   5 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Maintenance  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

3. A dot in an AutoCAD layer should not break redlining in floor plans

   If you structure/name you layer in AutoCAD to match some standards the layer names often contains character like a ..

   But having a . (dot) in a layer name breaks the redlining as the picture that contains the redlining cannot be generated.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Space  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

4. Apply Service Desk Security Group Restriction to Workplace

   Currently you can apply a security group to a service request type to restrict it in the Web Central "Create Service Request" view. This restriction should be carried over to workplace.

   With the questionnaire functionality added to workplace, clients would like to use the new interface for all requests, but for some requests like badge and key they should not be open to anyone to request.

   14 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Service Desk  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

5. Manage Service Level Agreements- Add filter option for Checklists

   Add a filter option in the manage service level agreements task to search for specific checklists.

   This would allow users to search for outdated checklists that need to be removed/replaced

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Maintenance  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

6. In the space console 2 different user defined fields have the same highlight color

   When creating user-defined fields, there are instances where two colors with similar shades are generated for different fields (see attached picture). According to the documentation, the highlight color is chosen randomly. I believe there should be an option to manually adjust these colors in case two very similar ones are used.

   •  

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Space  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

7. maintenance priority

   In Maintenance Console when I open a WR that has 3 priority P2, P4 and P5 (with default priority being P2) and I changed its priority from P2 to P5, then in the activities of the WR, I see that I changed the priority from 1 to 3, which are the order of the priorities, not their label.

   It would be better to display the label, e.g. Changed Priority from P2 to P5.

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Maintenance  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

8. Visionline

   Our client is considering to use Visionline to book our hostel rooms. Visionline is a system that programs hotel door access cards. Check the links below for further details.

   https://www.assaabloyglobalsolutions.com/hospitality/images/solutions/visionline/documents/Visionline-Product-Sheet_EN.pdf
   On-premise Access Management | Vingcard

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Workplace  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

9. Names with apostrophe can not edit in form

   With version V20224-02 it is no longer possible to display apostrophe characters in the ID fields. They can still be saved, but the data record can no longer be displayed afterwards. This behavior occurs in many places in the system.
   One example is the employee definition screen. Although the employee RONALD.MC'DONALD (em_id) can be saved there, the data record can no longer be displayed afterwards. It would be nice if the behavior could be restored.

   28 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   3 comments  ·  Platform  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

10. Adding Sender email, cc'd & external emails to Maintenance Console

    For tagging/emailing from work requests in the maintenance console please add the following:

    1. add the option to email non-Archibus users (external emails)

    2. add a cc'd function so that all the people that are tagged are on the same email instead of separate ones

    3. The option to enter a sender email address. Such that when a client replies to an email from the maintenance console, it goes to the person sent the email from the maintenance console by default, or if selected, the sender email address specified.

    I have found that most people just hit the reply button when they receive emails, which for our environment sends it to our service desk email. This works well for the service desk, but for anyone else, they have to wait for someone with access to the service desk email to forward it back to the person the reply was intended for

    For tagging/emailing from work requests in the maintenance console please add the following:

    1. add the option to email non-Archibus users (external emails)

    2. add a cc'd function so that all the people that are tagged are on the same email instead of separate ones

    3. The option to enter a sender email address. Such that when a client replies to an email from the maintenance console, it goes to the person sent the email from the maintenance console by default, or if selected, the sender email address specified.

    I have found that most people just hit the reply button when they receive… more

    6 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Maintenance  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

11. Dark mode

    Can we have a "dark mode" option for the browser version of "Archibus" and "Onsite" on the phone, for those of us who are photo sensitive. Dark mode also reduces energy consumption.

    5 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Platform  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

12. Cancel future bookings when an employee leaves the company

    When a user leaves the company, we set their account to Disabled. We would like an automated way to be able to locate and cancel that employee's future Workplace bookings thus freeing up the workspaces they had booked.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Workplace  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

13. Add Project Type Filter

    Enhancement request – Our customer is requesting that “Project Type” be added as a filter option from Projects | Monitor | View Active Projects Timeline. This filter option is provided on all of the other reports and views under the Monitor submenu. This is how our customer’s Managers will be filtering their projects.

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Capital Projects  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

14. Meeting Space Booking - Available Spaces in Building Modal

    In Workspace Booking, users can view the available spaces within a building without needing to click on each building. However, in Meeting Space Booking, the available spaces are not displayed directly. This requires users to click on each building individually to check availability, which can be time-consuming and less user-friendly.

    Proposed Improvement:
    Add a feature to Meeting Space Booking that displays the number of available spaces next to each building, like Workspace Booking.

    •  

    •  

    5 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Workplace  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

15. SLA Due Date option - end of the Month for PM Procedures

    For PMs that need to be completed within the month they are created, there is no way to specify "last day of the month" as the Due Date. Since the number of days in the month varies, some months the 30 day due date works and the date due is the last day, but and in other months, its the 1st of the next month.

    •  

    •  

    4 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Maintenance  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

16. In the maintenance survey report, the question text for creating a service request is displayed in the confirmation contents

    The checklist provide an option to create a service request. Depending on the answer to the follow-up question, the maintenance survey report can be displayed in three different ways.
    Screenshots are available in the File tab.

    Example
    When the answer to the question is "No," the option is set to enable the creation of a service request

    NO1. the answer to the question is "Yes" → no record is added in the maintenance survey report screen.(wr_id=1150004568)

    NO2. if the answer to the question is "No Follow-up service request is displayed → Create a service request and complete the checklist → One record is added on the maintenance survey report screen, and "null" is displayed in the confirmation contents.(wr_id=1150004566)

    NO3. answer "no" to the question → follow-up service request is displayed→Complete the checklist without creating a service request→One record is added on the maintenance survey report screen, and the confirmation remains blank.(wr_id=1150004565)

    In the above example scenario, this should be the logical and correct behaviour. (This is our expectation from the system)
    In NO2, the confirmation should not be null, but should indicate that a "service request was created".
    In NO3, please do not add a record to the maintenance survey report (I do not want options that were not selected to be displayed in the record).

    The checklist provide an option to create a service request. Depending on the answer to the follow-up question, the maintenance survey report can be displayed in three different ways.
    Screenshots are available in the File tab.

    Example
    When the answer to the question is "No," the option is set to enable the creation of a service request

    NO1. the answer to the question is "Yes" → no record is added in the maintenance survey report screen.(wr_id=1150004568)

    NO2. if the answer to the question is "No Follow-up service request is displayed → Create a service request and complete the checklist →… more

    •  

    •  

    •  

    •  

    •  

    •  

    •  

    5 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Maintenance  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

17. Adjust label text in charts to white when against dark background

    When using standard charts in Web Central (ex: Allocation and Benchmark Report) if the highlight color is dark the label text should format to white automatically. Otherwise it may be unreadable.

    •  

    4 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Space  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

18. Redlining of Lease Terms and Templates

    Create the ability to redline lease terms once templates have been applied to agreements. We have a requirement to track changes on a lease-by-lease basis made to lease terms. Printing or PDFing the agreement would have the option of printing either the redlined or final altered document.

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Leases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

19. Move "Save" button to bottom of data entry views

    The Save button disappears as the user scrolls down through data entry views. Users often click the button in the lower right-hand corner without reading it - it is a CLOSE button. This causes the user to lose their work.

    4 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Platform  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

20. Add Forgot Password link to Workplace login page

    Users are becoming more dependent on the Workplace app and never need to log in to WebCentral for any of their tasks (ie. workspace bookings only)
    It would be convenient to add a 'Forgot Password' link to the Workplace App login page

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Workplace  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating