List of Contributions

Jon Varo

Contact Details

My Content

1 to 20 of 50+ total

RE: Creating A Validation Error If A Hierarchy Catalog Record Node Value Doesn't Exist In The Hierarchy Itself

Posted By Jon Varo 05-09-2023 16:04
Found In Library: Precisely Enterworks

RE: Creating A Validation Error If A Hierarchy Catalog Record Node Value Doesn't Exist In The Hierarchy Itself

Posted By Jon Varo 05-09-2023 16:04
Found In Egroup: Precisely Enterworks \ view thread
Thanks a lot Eric! Really appreciate your help. Question... why is your account listed as "Accounts Payable"? ------------------------------ Jon Varo Fender Musical Instruments Corporation AZ ------------------------------

Creating A Validation Error If A Hierarchy Catalog Record Node Value Doesn't Exist In The Hierarchy Itself

Posted By Jon Varo 05-03-2023 12:50
Found In Egroup: Precisely Enterworks \ view thread
Hi! How can I find the hierarchy information within SQL so that I can compare Node Values in Hierarchy Catalog and trigger an error if the Node Value doesn't match what is in the hierarchy itself? Thanks, -Jon ------------------------------ Jon Varo Fender Musical Instruments Corporation AZ ---- ...

RE: editing an attribute based on the value of another attribute

Posted By Jon Varo 02-07-2023 11:46
Found In Egroup: Precisely Enterworks \ view thread
How about creating a date field, named "Restricted Intro Date", not visible to users? Create a rule or change notification that will always copy the value from Intro Date into Restricted Intro Date when Product Status is not a "locked value". When the Product Status is set to the locked value, reverse ...

RE: editing an attribute based on the value of another attribute

Posted By Jon Varo 02-07-2023 10:38
Found In Egroup: Precisely Enterworks \ view thread
Hi Ruthy, It sounds as if you're wanting to adjust the Attribute Security Filter in real time, which I've never seen in my experience (unless EW has a trick up it's sleeve that I'm not aware of.). To go over the need here, essentially, you want Intro Date to be available only when Product Status equals ...

RE: Date - Date Type Attribute Manipulation

Posted By Jon Varo 02-02-2023 15:19
Found In Egroup: Precisely Enterworks \ view thread
I agree with Vijay. VTL is most likely the best way to go here. Good luck! ------------------------------ Jon Varo | Manager - Master Data and PIM Teams Fender Musical Instruments Corporation | (480) 845-5823 ------------------------------ ------------------------------------------- Original ...

RE: Help Needed To Remove Spaces Surrounded By Paragraph Tags from HTML Enhanced Field In PIM

Posted By Jon Varo 02-02-2023 15:18
Found In Egroup: Precisely Enterworks \ view thread
Just wanted to follow up. In addition to extra spaces, there are always excess HTML code in the copy fields that is copied from a users rich text editor. I wrote this SQL query to find all offending code and will be splitting it up into rules in PIM to not allow formatting of any kind. This will allow ...

RE: Assistance With A SQL Query

Posted By Jon Varo 09-23-2022 19:51
Found In Egroup: Precisely Enterworks \ view thread
Thanks! This is definitely working for the SKU level. ------------------------------ Jonathan Varo | Manager - Master Data and PIM Teams Fender Musical Instruments Corporation | (480) 845-5826 ------------------------------ ------------------------------------------- Original Message: Sent: ...

RE: Assistance With A SQL Query

Posted By Jon Varo 09-23-2022 10:20
Found In Egroup: Precisely Enterworks \ view thread
I come up with this JOIN and, so far, it's working: JOIN Area_Staging a ON a.SKU_Number = s.SKU_Number AND a.Status = 'Discontinued' AND a.Status NOT LIKE 'Activ%' FYI... The NOT LIKE is finding all records that match both ACTIVE and ACTIVE_BEING DISCONTINUED statuses. ------------------------------ ...

RE: Assistance With A SQL Query

Posted By Jon Varo 09-23-2022 09:57
Found In Egroup: Precisely Enterworks \ view thread
Thanks again Rick!​ Unfortunately, I ran the query but it was still finding SKUs with mixed results. Here is one SKU that it identified yet still had Active Area records: SKU Number Area Status 7709946000 CAN_DEALER Active 7709946000 INTL_DEALER Active 7709946000 US_DEALER ...

RE: Assistance With A SQL Query

Posted By Jon Varo 09-23-2022 09:31
Found In Egroup: Precisely Enterworks \ view thread
I will try it out now... Thanks so much Rick. I'll report back. ------------------------------ Jonathan Varo | Manager - Master Data and PIM Teams Fender Musical Instruments Corporation | (480) 845-5826 ------------------------------ ------------------------------------------- Original Message: ...

Assistance With A SQL Query

Posted By Jon Varo 09-21-2022 11:04
Found In Egroup: Precisely Enterworks \ view thread
Hi. I'm still learning about SQL and need assistance with something. I have a one to many relationship from our SKU Repository (SKU_STAGING) to our Area Repository (AREA_STAGING) using SKU Number as the join. Area consists of up to thirty records with varying status values. When all ...

RE: Global Trim Rule in EnterWorks

Posted By Jon Varo 08-01-2022 11:30
Found In Egroup: Precisely Enterworks \ view thread
Hi Brian, Is there a brown bag session on this functionality? Unfortunately, I can't find the Edit -> Properties option to ignore white space. Adding that option to any repository that we import to will help immensely. Unfortunately, it won't do much for copying and pasting where, even if you copy ...

Global Trim Rule in EnterWorks

Posted By Jon Varo 07-27-2022 09:24
Found In Egroup: Precisely Enterworks \ view thread
Hi. One thing that is absolutely useless is having spaces at the end of data entries by users and administrators alike. Since you can't see them, it's hard to detect them. Is there a way to add a global trim command in the java coding of the system, that will remove all blank spaces inadvertently ...

RE: Broken image links

Posted By Jon Varo 02-14-2022 12:14
Found In Egroup: Precisely Enterworks \ view thread
I'm wondering if a Change Notification or validation rule in DAMLink can create an error on Sonia's record so that it doesn't move to Production and inadvertently update their web site. ------------------------------ Jon Varo | Manager, Product Information Management Fender Musical Instruments ...

Validation Error For A Dynamic Attribute

Posted By Jon Varo 02-14-2022 11:53
Found In Egroup: Precisely Enterworks \ view thread
Hi. Is there a SQL query that can flag an attribute as an error if a value has been established and then a user sets the value to null? We don't want to flag the error if a value was never set for it though. Example: For our B2B system, we have a flag called Dealer Portal Displayable. This ...

RE: Preferences as assignable to user groups?

Posted By Jon Varo 02-14-2022 11:45
Found In Egroup: Precisely Enterworks \ view thread
We've asked for this feature a couple years ago as well. I did submit a feature request related to this... the ability to choose which Dynamic Attributes are seen by users. Best, -Jon ------------------------------ Jon Varo | Manager, Product Information Management Fender Musical Instruments ...

RE: Importing a tabbed Excel file

Posted By Jon Varo 02-14-2022 11:40
Found In Egroup: Precisely Enterworks \ view thread
Hi Sidd. In the past, I've always split the information with different tabs into different Excel files. Then I imported the files. Nothing too technical on our end for this. Best, -Jon ------------------------------ Jon Varo | Manager, Product Information Management Fender Musical Instruments ...

RE: Broken image links

Posted By Jon Varo 12-01-2021 12:59
Found In Egroup: Precisely Enterworks \ view thread
Hi Brian, Image Report is helpful but extremely slow to run. The 20 images that I ran the report for the other night, when you and I were working on another issue... that ran for 3 and a half hours and ended in an error. Unfortunately, it's not very practical to use if you need to run the report ...

EnterWorks Users Familiar With Winshuttle Evolve

Posted By Jon Varo 11-29-2021 18:14
Found In Egroup: Precisely Enterworks \ view thread
Hi Everyone. We have been looking into Winshuttle Evolve and would be interested in hearing about the platform working in the wild; preferably in parallel with EnterWorks. Is anyone available to speak to me and my Master Data colleague about this? Thanks so much! -Jon ------------------------------ ...