144 results found

1. Compliance/Maintenance Checklist - Restrict the look up question

   The compliance questionnaire question builder has a good look up option except there is no restriction in place so if the user should be selecting only a subset, say 10 particular answers, but they get to access a whole table, they can be accessing 30000 records when they don't need it.

   It would be nice to either
   1. define an advance search for the look up, could be tough since all tables have their own fields
   2. apply a SQL restriction

   Some examples where there would be too long of a look up:
   1. Trying to find a room but then gets all rooms
   2. Trying to find an equipment of a certain type but then all equipment show up

   The compliance questionnaire question builder has a good look up option except there is no restriction in place so if the user should be selecting only a subset, say 10 particular answers, but they get to access a whole table, they can be accessing 30000 records when they don't need it.

   It would be nice to either
   1. define an advance search for the look up, could be tough since all tables have their own fields
   2. apply a SQL restriction

   Some examples where there would be too long of a look up:
   1. Trying to find a room but… more

   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

   Approved for Product Roadmap  ·  0 comments  ·  Platform  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Impactful You must login first! Fundamental 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. Configurable field naming for fields (since Multi-line headers don't seem to work globally)

   It would be better to have a framework that supports easy global field renaming. Multi-line headers used to be the quicker way to modify the field names but even then it was not a global effect due to potentially hard coded titles within the axvws.

   It should noted that even if you change the multi line headings that the workplace portal is hard-coded to use a separate language and file system to reference the field names. Also the newer html5 like views tend to ignore the multi line headings.

   One example of needed configurable field name is rooms. Many see that a concept of a room doesn't align to modern day vocabulary. A room originally appears to be a space clearly defined by 4 walls. But nowadays many people use a concept of a 'resource' or a 'space.' It would be nice to really have a configurable field ability that is transparent across the application (from the reports, to the navigator, to the portal).
   
   Ie some may also call it an asset.

   It would be better to have a framework that supports easy global field renaming. Multi-line headers used to be the quicker way to modify the field names but even then it was not a global effect due to potentially hard coded titles within the axvws.

   It should noted that even if you change the multi line headings that the workplace portal is hard-coded to use a separate language and file system to reference the field names. Also the newer html5 like views tend to ignore the multi line headings.

   One example of needed configurable field name is rooms. Many see… more

   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?

   Nice to have You must login first! Impactful You must login first! Fundamental 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. 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?

   Nice to have You must login first! Impactful You must login first! Fundamental 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. Update connector email to include Connector Description

   When migrating code and connectors to different environments for a client, often times the connectors in DEV, UAT and PROD will have the same connector name. This could be due to many factors, including custom db code that runs based on the connector name.

   It would be helpful to include the Connector Description in the email that is sent out via the connector email notifications. This way the connector code can remain the same in all environments w/ only the description being updated to include the environment name being sent from.

   This would also be nice to include so that users that receive the email get a description as to what the connector is doing / does (provided thats included in the description field.

   When migrating code and connectors to different environments for a client, often times the connectors in DEV, UAT and PROD will have the same connector name. This could be due to many factors, including custom db code that runs based on the connector name.

   It would be helpful to include the Connector Description in the email that is sent out via the connector email notifications. This way the connector code can remain the same in all environments w/ only the description being updated to include the environment name being sent from.

   This would also be nice to include so that… 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?

   Nice to have You must login first! Impactful You must login first! Fundamental 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. Batch Emails Before Sending

   Currently, Archibus sends an email notification as soon as it's created in the system. This is usually fine for small volumes of email, but some SMTP servers won't allow Archibus to authenticate multiple times in a row in quick succession. Please consider adding a batching mechanism, so emails can be sent in groups using a single authentication with the SMTP server.

   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?

   Nice to have You must login first! Impactful You must login first! Fundamental 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. Queue Failed Notifications For Resending

   Create a queue for notifications, so Archibus can resend when there's a temporary mail server outage. Currently, if a notification fails because of an issue with the mail server, then that notification is "lost".

   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?

   Nice to have You must login first! Impactful You must login first! Fundamental 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. Notifications Log - Missing Create Date in Filter and Result Set

   After v26.3, Eptura added 4 new fields to the [afmnotificationslog] table. These fields are, [createdtime], [createdat], [emailcc], and [emailbcc].

   The View Notifications Log view in WebCentral that is used to view with Notification Log has not been updated to include those fields. The number of records in that table can get quite large, making the filters very valuable. In v26.3 and earlier, the Search by Date Range - From and Search by Date Range - To were valuable to search by the [serverdatesent] value. Since v26.3, the [created_at] is used when notifications are generated, but there is no way to filter or sort by date to find those notifications now.

   It would be nice to be able to filter and search for all fields in [afmnotificationslog], but I don't think it would be necessary. I think just having the four new fields in the result set would be a minimum and adding the [createdat] and [createdtime] to the filter would be one step better. That way, users can at least search for new or recently created notifications. Allowing users to add/remove fields in the result would be nice, but is also not necessary.

   Task: View Notifications Log
   Task File: ab-notifications-log.axvw
   Path: System/System/Archibus Administrator - User and Security/View Notifications Log

   After v26.3, Eptura added 4 new fields to the [afmnotificationslog] table. These fields are, [createdtime], [createdat], [emailcc], and [emailbcc].

   The View Notifications Log view in WebCentral that is used to view with Notification Log has not been updated to include those fields. The number of records in that table can get quite large, making the filters very valuable. In v26.3 and earlier, the Search by Date Range - From and Search by Date Range - To were valuable to search by the [serverdatesent] value. Since v26.3, the [created_at] is used when notifications… 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?

   Nice to have You must login first! Impactful You must login first! Fundamental 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. Ability to join more than direct relations in Reports Central

   From Reports Central you can only join directly related tables (for example Floor to Building) but the joined table cannot be related to their related tables (for example Floor to Building to Sites)

   It would be needed to join with the joined tables both in Reports Central and in Smart Client

   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?

   Nice to have You must login first! Impactful You must login first! Fundamental 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. Improve the Notifications Log to support Enterprise deployments

   Redesign the notifications log so it can be used to debug email issues for large enterprise deployments.

   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

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

   Nice to have You must login first! Impactful You must login first! Fundamental 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. Change the color of the Navigator so it is not white.

    The navigator is washed out with the rest of the screen -- everything is white. Make the navigator another color to distinguish it from the rest of the screen.

    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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. Record ID in Event Log

    In the "Data Events Log" for a Record Change, the view shows who made the change and when. Clicking on the record shows the old and new values for the fields that were change. However, nothing tells me which record it was changed for.

    I recommend adding a new field to the table for the pkey value. When changes are recorded, populate that field with the pkey value and display it in the primary view (search results) for the data event log view.

    Example I have it tracking the equipment table and I changed the status of a piece of equipment. I can see that I changed in from In Service to In Storage, but nothing tells me it was for equipment record SRL-0110. I can only see that in Smart Client and only if I sift through the concatenated values to find the primary record value. End users should be able to see that quickly in the Data Event Log view.

    In the "Data Events Log" for a Record Change, the view shows who made the change and when. Clicking on the record shows the old and new values for the fields that were change. However, nothing tells me which record it was changed for.

    I recommend adding a new field to the table for the pkey value. When changes are recorded, populate that field with the pkey value and display it in the primary view (search results) for the data event log view.

    Example I have it tracking the equipment table and I changed the status of a piece of… 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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. View Access Security

    Please add a better option for view level security. The current restrictLoadingOfUnassignedViews setting makes startup take 2-3 hours for many clients, which is unacceptable.

    I would suggest using the afmptasks.securitygroup field to prevent users without the security group assigned from opening the view at all. At the platform level, an "afterViewLoad" check could be performed to check that field and show a message instead of loading view if they are not authenticated.

    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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. Profile pop-up feedback duration after changing locale

    Client feedback (Archibus SaaS) for the dialog message indicating that a user has to sign-out and sign-in after changing the the locale is too short.
    The request would be to make the duration a little longer or replace the temporary message with a pop-up giving the option to Logout Now.

    UX reading suggests the time for the popup be 1 second for every 4 words which translates into the popup being 4-5 seconds especially for the French language and it is also compounded by the fact there are 2 pop-ups at the same time (The other being 'Record Saved')

    Thanks in advance!

    Client feedback (Archibus SaaS) for the dialog message indicating that a user has to sign-out and sign-in after changing the the locale is too short.
    The request would be to make the duration a little longer or replace the temporary message with a pop-up giving the option to Logout Now.

    UX reading suggests the time for the popup be 1 second for every 4 words which translates into the popup being 4-5 seconds especially for the French language and it is also compounded by the fact there are 2 pop-ups at the same time (The other being 'Record Saved')

    Thanks… 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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. Ability to add links that can open URLs to sites that require sign-on/open in a new tab

    Currently we can create custom tasks that redirect to URLs in View Definition Wizard. However it seems that these URLs do not properly load within Archibus when they require some sort of log-in (ex for google docs or sites created by Canva).

    Please provide an option for a URL to load in a new tab from an Archibus task (I believe that this may resolve the issue)

    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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. Connectors can extract data from multiple tables/joined tables

    If needed it would be good option to be able to extract data from more than one table.

    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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. Set fiscal year based on the end month

    This is a request for additional functionality related to fiscal year setup.
    Briefly, I would like to be able to determine the fiscal year based on the end month in Archibus.

    With the current specifications, Archibus determines the fiscal year based on the start month. For example, if the starting month is April, the fiscal year 2023 would be from April 2022 to March 2023.

    For example, in Japan, a typical fiscal year's period is from April to March of the following year. For example, fiscal year 2015 is from April 2015 to March 2016 in Japan.
    In other words, the same fiscal year would be one year off.
    The fiscal year is used frequently for analysis and other purposes in Japan, so it is quite critical. Many Archibus reporting views also use the fiscal years, but using it confuses users because they are not the correct fiscal year for Japan. Most of our Japanese customers point this out.

    This is a request for additional functionality related to fiscal year setup.
    Briefly, I would like to be able to determine the fiscal year based on the end month in Archibus.

    With the current specifications, Archibus determines the fiscal year based on the start month. For example, if the starting month is April, the fiscal year 2023 would be from April 2022 to March 2023.

    For example, in Japan, a typical fiscal year's period is from April to March of the following year. For example, fiscal year 2015 is from April 2015 to March 2016 in Japan.
    In other words,… 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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. Improve RestrictLoadingOfUnassignedViews feature to check processes assigned to users

    The RestrictLoadingOfUnassignedViews feature only checks views assigned to a user's role. This needs to be updated to also check views assigned directly to a user.

    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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. Tomcat 10

    Please add support for Tomcat 10.1 (Servlet 6.0 and JavaServer Pages 3.1 specifications). Clients are increasingly requesting to stay ahead of the curve on tomcat, and now that Tomcat 8.5 is being de-supported, it would be helpful for those clients to move directly to tomcat 10 instead of 9.

    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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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
    In Development  ·  Adminoctavian.vlad@eptura.com (Director, Product Management, Eptura) responded

    Exciting update - this idea is now in active development! Stay tuned for progress and upcoming product announcements in the “What’s New?” section of the Eptura Knowledge Center.

19. ability to access all fields in related tables in list based reports similar to report central

    A lot of clients overtime have customized reports like what they originally see in archibus, For example a maintenance history report or a invoice list and go and include fields that exist in the schema to these list style reports. While a lot of consoles now have the ability to pick available fields in many areas, it's not always pointing to the fields that clients need to use to make business decisions or have the kind of audit logging process they need. It would be nice to have what report central has where all fields in a used table and reference table are accessible to the report. Then this can be saved as a configured preference to use these fields in a client report. I'm starting in the list based view for now but I'm sure in reality there are more Archibus panel types a client would really like such functionality to exist in.

    A lot of clients overtime have customized reports like what they originally see in archibus, For example a maintenance history report or a invoice list and go and include fields that exist in the schema to these list style reports. While a lot of consoles now have the ability to pick available fields in many areas, it's not always pointing to the fields that clients need to use to make business decisions or have the kind of audit logging process they need. It would be nice to have what report central has where all fields in a used table and… 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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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. greg.landgraf@buildingi.com

    Using the SaaS product, we've been provided with a security key to be able to upload files via sftp for connector processing.

    When configuring a connector, in order to read a file from the sftp server, we are required to convert the pem to ppk and then upload the ppk to the /transfer-to folder to have it placed on the server.

    As this is controlled by the SpaceIQ/Archibus team, it would be very helpful for the SaaS team to pre-place a ppk file for sftp connections as well as have documentation for the required connector parameters to read the file.

    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?

    Nice to have You must login first! Impactful You must login first! Fundamental 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