As a user, I want to be able to import/export AF tables using PI Builder, so that I can make changes as needed.

Currently, PI Builder does not support editing or adding of annotation/comment to Event Frame. The suggestion will easily allow users to backfill or edit annotation/comment in bulk.

Currently, there is no button in PI Builder which allows users to bring in Global Notifications Formats. The button would allow users to read in current Formats and then users would be able to Publish edited formats or newly created formats. This would give users another tool to manage Formats other than using PSE.

When editing PI Points, PI Builder does not return any error if one of the headers is wrong or misspelled. Simply, nothing is edited for that header and you  only find out at a later time when looking at the PI point. It would be useful if PI Builder could inform you when one of the headers does not match any PI Point attributes.

PI Builder should use tables (the kind of table found in the Insert tab on the Ribbon) whenever headers are set up and whenever data is imported from the PI Data Archive or the PI Asset Framework.

Benefits of PI Builder using tables:
• filters are on by default, and they do not use up the 1 filter that is allowed per sheet
• readable formulas that automatically fill the table column
• explicit isolation of PI Builder data from the rest of the sheet
• banded rows are an option

If Excel is installed as a Windows Store Application instead of a Desktop Application, the PI AF Client installer doesn't allow PI Builder to be installed. The reason for that is that it can't determine the Excel version through the registry.

PI DataLink faces the same problem, but there you have a workaround by editing the Setup.ini file. See this KCS: "PI DataLink setup kit does not detect Office that has been installed via Windows Store (220739)". This does not appear to exist for PI Builder.

Either a workaround or a genuine solution would be appreciated.

When retrieving all PI points, there should be an option to also include the Snapshot value. Currently, a user must use other means to retrieve all current values and then merge the two together.

It would be nice to split the configuration string of an Analysis Rule along several Excel cells, for (i) better readability and (ii) avoid hitting the limit of characters on a single Excel cell (currently, 32,767 characters).

It would be specially helpful with large analyses.

When I use datalink, it will not overwrite my cell formatting like background color. When I use PI Builder to retrieve data, it overwrites all cell formatting. Can you please edit your PI Builder code to behave more like Datalink in regard to preserving cell formatting?

It is possible to search for Templates, Elements and Attributes, however the only way to obtain Analyses is to perform a full Element search then filter out the Analyses columns.
I have an extensive AF structure with many 100,000 rows. It would be useful for such large AF structures to be able to search for Analyses in the same way that you can search for Elements or Attributes.

After Microsoft Updates, PI Builder or DataLink users sometimes find that their KST (known servers table) has gone empty. A potential fix is to launch Excel as admin and try to any PI Data Archive in the list.

Under the hood, the KST information would be copied from the HKEYLOCALMACHINE to the HKEYCURRENTUSER branch in the registry.

However, this becomes a maintenance issue for large organizations where users don't typically have local admin permissions. Therefore, we request an alternative for regular users to populate their KST.

Allow users more selection of which columns to include in search results (before tag selection). Some customers may wish to reference tag metadata that cannot currently be displayed, including InstrumentTag and UserInt1.

Note that this is not referring to the information PI Builder puts into an Excel file, but the results of the tag search before even selecting which metadata for each tag to include in the Excel export.

A significant number of companies are moving from the Microsoft Office suite to "G Suite" (Google). This move takes customers from MS Excel to Google Sheets, and they would like to retain PI Builder as a functional add-on.

Currently, in PI Builder there is a hard limit on the number of columns that can be selected (it is set to 1023 columns). It makes it hard to work with templates that have over 1020 attributes configured and limits the configuration capabilities.

As a user, I want my experience to be as seamless as possible when using PI Builder so that I can get the information I need quicker.

Currently, PI Builder will Default the servers/database chosen to <None> when a user first opens up PI Builder (after a fresh installation). I would prefer that PI Builder Default to the default servers and AF database from the local KST instead of <None>.

There is currently no way to edit priority for member of an escalation team in bulk, it has to be done one by one in PSE. For users that have 30+ escalation teams, this is a lot of tedious work. it would be nice to be able to pull in the escalation team object with its members and their priority number, edit the priority numbers, and publish to AF.