List of Contributions

Brian Zupke

Employee

Contact Details

My Content

1 to 20 of 50+ total

RE: Format Email body in Scheduled Export

Posted By Brian Zupke 03-16-2024 04:06
Found In Egroup: Precisely Enterworks \ view thread
Joseph, They way to have an e-mail to be sent has HTML requires the first characters of the body to be and the last characters of the body to be . ------------------------------ Brian Zupke Precisely Software Inc. ------------------------------

RE: Allow users to manually set UI display timezone

Posted By Brian Zupke 03-14-2024 02:04
Found In Egroup: Precisely Enterworks \ view thread
Eli, I think this is a good idea - are you thinking of having a setting as part of a user's profile where they can select which timezone they want presented in the UI? Then if they intend to troubleshoot, they might set that timezone to match the one under which the application's VMs are set to, so ...

RE: Change attribute value after 30 days

Posted By Brian Zupke 03-09-2024 20:40
Found In Egroup: Precisely Enterworks \ view thread
The simplest way to do this would be to have a TIMESTAMP attribute to accompany each attribute for which you need to independently track how long a specific setting has been present. Then define a Scheduled Export that runs once a day that performs a SQL query to find all rows for which the Product Status ...

RE: Predefined Filter based of linked relationship attribute 2020 UI Filter Side Bar

Posted By Brian Zupke 03-01-2024 02:42
Found In Egroup: Precisely Enterworks \ view thread
Joseph, Unfortunately, the Filter functionality is only available for the repository being viewed, not for linked repositories. You will need to use Advanced Searches to perform the equivalent of the Filter for linked attributes. You may want to look at the Precisely Ideas web site and submit a new ...

RE: Best way to create a dropdown of attributes from another repo

Posted By Brian Zupke 02-15-2024 19:55
Found In Egroup: Precisely Enterworks \ view thread
Ryan, Can you tell me approximately how many rows are in the repository that is driving the selection list? What is the frequency of changes to this repository and how soon would those changes need to be reflected in what is viewed in the record editor? ------------------------------ Brian Zupke ...

RE: How to add Primary key to Repository

Posted By Brian Zupke 02-13-2024 18:04
Found In Egroup: Precisely Enterworks \ view thread
Joseph, For the benefit of others who may view this thread, this issue was avoided by exporting the attributes for the Profile as the default CSV format and then ensuring the primary key attributes were sorted by their Is Primary Key number before saving the modified CSV file and importing into the ...

RE: How to add Primary key to Repository

Posted By Brian Zupke 02-11-2024 16:34
Found In Egroup: Precisely Enterworks \ view thread
Joseph, Please disregard my previous response, at least for now. I had misunderstood where you were having the problem. Please open a Customer Support case with the details, including the original export attributes file (prior to making they key change) along with the modified file that was imported ...

RE: How to add Primary key to Repository

Posted By Brian Zupke 02-11-2024 16:11
Found In Egroup: Precisely Enterworks \ view thread
Joseph, I suspect the issue is that according to EnterWorks, there is already a duplicate record in the repository. It appears that in newer versions of EnterWorks, there has been additional logic checking for duplicates and preventing any update to an existing record. Previously, only the attempt ...

RE: How to add Primary key to Repository

Posted By Brian Zupke 02-09-2024 03:31
Found In Egroup: Precisely Enterworks \ view thread
Joseph, There is a KB article on how to change the primary key of a populated repository: https://customer.precisely.com/s/article/How-to-Change-the-Primary-Key-of-a-Populated-Repository-10044027616283 -Brian ------------------------------ Brian Zupke Precisely Software Inc. ------------------ ...

RE: Change notification help

Posted By Brian Zupke 11-22-2023 02:28
Found In Egroup: Precisely Enterworks \ view thread
Ryan, Instead of populating CN_Target_Value_Source_SQL and its associated fields, change the CN_Target_SQL to produce a result set where the first column is the InternalRecordId of the records that need to be updated and the subsequent columns are the attribute names (not restricted names) of each ...

RE: Excess Database Tables

Posted By Brian Zupke 10-30-2023 19:52
Found In Egroup: Precisely Enterworks \ view thread
Mark, The PLT and PLT TMP tables are supposed to be deleted after processing has completed for the associated imports. However, if there are any errors or if the services are stopped during processing, the tables will not be removed. I recommend you manually clean these tables up and then monitor moving ...

RE: Excess Database Tables

Posted By Brian Zupke 10-21-2023 04:01
Found In Egroup: Precisely Enterworks \ view thread
Mark, Those tables are associated with previous import jobs and can be removed if they are more than a day old. -Brian ------------------------------ Brian Zupke Precisely Software Inc. ------------------------------

RE: Scheduled Exports with Export Template with output type of json

Posted By Brian Zupke 10-15-2023 17:42
Found In Egroup: Precisely Enterworks \ view thread
Ruthy, There are several different avenues you can consider: Define the attribute that is the concatenation of the other two attributes and use VTL or Change Notification (the latter required if those two attributes are not in the same repository) to keep the concatenation attribute in-sync. Switch ...

RE: Date - Date Type Attribute Manipulation

Posted By Brian Zupke 09-07-2023 02:10
Found In Egroup: Precisely Enterworks \ view thread
Brittany, VTL comes with some Classes including DateTool, which includes methods to convert a String to a date (using a specified format). The set of classes can be found at the following URL: https://velocity.apache.org/tools/1.4/javadoc/org/apache/velocity/tools/generic/package-summary.html Using ...

RE: How can I create a child repo and keep its attributes and properties in sync with the parent repo and auto move records to the child repo based on an attributes value?

Posted By Brian Zupke 07-28-2023 14:35
Found In Egroup: Precisely Enterworks \ view thread
Ryan, One thing to keep in mind is that the use of the Precisely Ideas web site for EnterWorks has only officially started recently with the earlier posts being made before that official start in the sense that Customer Support being notified of it being active. It is only now that Customer Support ...

RE: How can I create a child repo and keep its attributes and properties in sync with the parent repo and auto move records to the child repo based on an attributes value?

Posted By Brian Zupke 07-28-2023 03:17
Found In Egroup: Precisely Enterworks \ view thread
Matthew, Using Record Security Filters is a good idea and would be the simplest way to accomplish the desired core requirements, but may not be an option if Record Security Filters are already being used in the same repository for other purposes. However, I think the opposite filter would be needed ...

RE: How can I create a child repo and keep its attributes and properties in sync with the parent repo and auto move records to the child repo based on an attributes value?

Posted By Brian Zupke 07-28-2023 03:05
Found In Egroup: Precisely Enterworks \ view thread
Ryan, If you weren't concerned about the history, a simple workflow could be constructed that soft-deletes the selected record by copying it to the delete repository (which would be using the same profile) and then delete the record from the original repository. The undelete action would be a simple ...

RE: APIs Best Practices Documentation

Posted By Brian Zupke 04-28-2023 04:36
Found In Egroup: Precisely Enterworks \ view thread
Nicolas, The fastest way to retrieve data from EnterWorks is using SQL directly against the EPIM database.  The next fastest would probably be using a custom Micro-Service that implements a new EnterWorks REST endpoint (or set of endpoints) to perform SQL against the EPIM database.  There is an example ...

RE: Digital Asset Custom Uploader Questions

Posted By Brian Zupke 04-26-2023 03:24
Found In Egroup: Precisely Enterworks \ view thread
Lindsey, Are you referring to the custom action that allows for files to be uploaded and linked to the record being edited?  I have not seen a date format resulting in a zero-based month being specified.  I suggest you attach the JSP file that is configured for this upload to a support ticket with the ...

RE: APIs Best Practices Documentation

Posted By Brian Zupke 04-24-2023 14:58
Found In Egroup: Precisely Enterworks \ view thread
Nicolas, There are several ways to extract data from EnterWorks using the REST API: * Items Search endpoint - provides ability to retrieve one or more records (1000 records maximum) from a repository.  Uses paging if more records than the specified page size.  Requires obtaining mappings of EnterWorks ...