What is the best way to read and update the part page 3 attribute from the excel sheet?
Hi Team,
I have requirement where i need to read the attribute from the excel sheet and upadate attibiute values in the part subclass page three .
Let me know which is the best way i can start with. dirctly through java code, using REST api or any other technology?
Thanks
Hello
If one-time or adhoc, use Agile import
If automation, one way is to use Apache POI to read the Excel, get the data and use SDK to do the updates
– Raj
If, as Raj suggested, this is more of a one-time case, or occasional data updates (meaning you not making a PX for someone to do this by simply clicking a button), here’s how I would deal with it. I would query the database for the items I needed to update, then either export that to excel, such that it could be imported into Agile (after manipulating data in Excel or via the query). In many cases, I have coded my SQL query such that it also outputs the string for a SOAP Request, which can be pasted into SOAP UI to run the updates. This works real well if the attributes you’re updating are not change controlled. If they are, you’re better off importing the items onto Change orders.
Here is a made up example: Let’s say you have parts that are painted, but you have to update all the yellow parts to now be green. Lets say the paint is stored in PAGE_THREE.LIST31. For simplicity, let’s assume I’ve looked up the list ID for yellow and it is 123456. Let’s further assume that subclass is called ‘Design Part’, and its ID is 222123
SELECT I.ITEM_NUMBER
,’Design Part’ AS SUBCLASS
,’Green’ AS COLOR
FROM AGILE.ITEM I
INNER JOIN AGILE.PAGE_THREE P3 ON I.ID = P3.ID
WHERE I.SUBCLASS = 222123
AND P3.LIST31 = 123456;
Hope this helps,
Steven