List of Contributions

Hi Ryan, That is strange. It should be a relatively quick load on the SQL dropdown. Feel free to reach out and we can do a quick screen share to review. Thanks, Eric GIlboe - Practice Director Amplifi Cell: 480-284-3296 Email: eric.gilboe@goamplifi.com ------------------------------ ...

Hi Ryan, Try using the Custom Dropdown List Dynamic option, but use the following SQL instead: SELECT Vendor_Name as 'Code', Vendor_Name as 'Description' FROM VENDOR_STAGING For the 'Description' and 'Code' fields, feel free to use whatever attributes you would like form the Vendor repository ...

Ha ha. Not quite sure why. Think it was just set up that way with Precisely for Amplifi. Either that or it's my code name when I play Fortnite with the kids. :-) Hope all is well sir! ------------------------------ Eric Gilboe Practice Director - EnterWorks eric.gilboe@goamplifi.com Atlanta | Chicago ...

Hi Jon, Here is a query you can use to report on this info: SELECT Product_Id, NodeValue, Id FROM Hierarchy_Catalog_Staging WHERE Hierarchy_Name = 'MSS Product Catalog 2022' AND NodeValue NOT IN (SELECT Code FROM B_CODE_SET_DETAIL WHERE CODE_SET_ID = 14144) This query selects records in the Hierarchy ...

Hi Lindsey, To handle the second issue, we created a custom JAVA class that strips any illegal characters (spaces, commas, etc.) prior to dropping the file in the DAM Drop to be processed.  We also included the feature to add the Vendor ID to the file name to avoid scenarios where Vendor A submits abc.jpg ...

Hello All, Ran into an interesting use case a few months back for a customer that was worth sharing for future implementations. Use Case: Customer wanted to have an additional random ID generated for a new record in addition to the Sequenced Attribute as an ID.  EnterWorks only allows one sequenced ...