Arif's Profile
Agile Angel
2212
points

Questions
19

Answers
152

PLM Enthusiast since 2011. Like Developing extensions,utilities,scripts and provide Configuration and Support on PC,PPM, PG&C, PQM,PCM on 9.3.5,9.3.3 and 9.3.2. Experienced in dev,config and design on PLM4P(6.0.0.3 till 6.1.1.x)
Title Agile PLM Technical Consultant
Company Company Not Entered
Agile Version 9.3.5, 9.3.3 , 6.X.X.X.
  • Agile Angel Asked 7 days ago in Product Collaboration.

    Hi Surya,

    Sawagoto has pretty much given a good solution. There is no direct way to get the data apart from creating ATO/CTO but again you need to have access to ACS destination location.

    Apart from the one mentioned above, I have couple of approaches to suggest:->

    1. From back-end :
         – Form a simple SQL query and get the desired results. If you are interested let me know, will share the SQL query.
          – You need to have access to Agile schema to do this.

    2. From Front End:
            a.  Run an advanced search for Changes –> ECO/,MCO –> Object Search
            b. On the format field select ECO and Affected Item.Number
            c. Run a report to generate Item and Title block details using advanced search.
            d. Do a V-Lookup between these two and you should get the required data.
            e. The problem with the approach is it can hamper your system performance.

    Regards,

    • 70 views
    • 3 answers
    • 0 votes
  • Agile Angel Asked on September 17, 2018 in Product Collaboration.

    Hi John,

    What’s your business case for this. Generally bulk-attachments extract comes in picture when we are trying to copy attachments from old to new Manufacturer parts.

    Generally i format an advance search and extract the documents using PDX package. This PDX gives the zip file which you can extract to get all your attachment.  The timing varies based on the count of your files.

    Regards,
    Arif

    • 58 views
    • 2 answers
    • 0 votes
  • Hi Swagoto,

    Just to add to Kevin, Preliminary lifecycle is generally stored as Null value since it doesn’t map to any revision. So you can use NVL(n.description,’Preliminary’) AS LIFECYCLE for more accurate results.  Sample query that i used to give the latest revision of an item.

    SELECT   ITEM_NUMBER,  NVL (NODE.DESCRIPTION, ‘Preliminary’) AS LIFECYCLE
     FROM   AGILE.ITEM I, AGILE.NODETABLE NODE, AGILE.REV R
     WHERE       I.ID = R.ITEM(+)
             AND I.DEFAULT_CHANGE = R.CHANGE(+)
             AND R.RELEASE_TYPE = NODE.ID
             AND I.ITEM_NUMBER=’XXXXXXX

    Regards,
    Arif

    • 52 views
    • 2 answers
    • 0 votes
  • Agile Angel Asked on July 23, 2018 in Product Collaboration.

    Mostly it’s about data that get refreshed. When it comes to configuration, File manager configurations are certainly copied as per production. So you should change it as per your lower instance.

    • 268 views
    • 2 answers
    • 0 votes
  • Agile Angel Asked on July 19, 2018 in Other APIs.

    Hi Karan,

    I have shared a sample code that i implemented just now, go through it and let me know in case it works.

    General flow is :

    1. Take the existing value in a string.
    2. Concatenate the values you want to append to string.
    3. Create an Array List from the string array(obtained after splitting the string based on the regular exp. using to split. )
    4. Iterate through the Array List and set the array as selection.

    Regards,
    Arif

    • 116 views
    • 1 answers
    • 0 votes
  • Agile Angel Asked on July 10, 2018 in Product Collaboration.

    It is not possible to have History attributes however if you want to track activities of user on a particular class or object, you can write a simple sdk program or scripts.

    • 130 views
    • 5 answers
    • 0 votes
  • Hi Naren,

    Do you have security certificates installed on url you trying to access. Normally firefox does that. One way to bypass is :

    1. Go to about:config
    2. Type “security.tls.version.max” and set it to 1 and re-try.

    You can also try to run it in private mode to see if the issue persists.

    • 88 views
    • 1 answers
    • 0 votes
  • Well i don’t have real data to play around with but based on what i have worked earlier on, all the Projects related information is stored in Activity table.

    Activity table id has few important column called Name,Activity_Number and Parent_ID. Generally when Parent_ID is null that’s project and you can find out the phase/tasks by querying that table and giving Project id as Parent_Id.

    Regards,

    • 142 views
    • 2 answers
    • 0 votes
  • As Steve mentioned yes it is possible. Prepare a spread-sheet with the data you need, read it and perform your action.

    • 116 views
    • 2 answers
    • 0 votes
  • Agile Angel Asked on June 8, 2018 in Product Collaboration.

    As you want to ensure that Item’s are not visible and not to permanently delete it means you should go ahead with soft-delete.

    Now coming to soft-delete, generally as a best practice you should ensure that part is an Orphan part i.e. Not having any dependencies like pending changes or attached MPNs or BOMs or Where Used. You can delete it using Agile SDK thereafter or SQL statement where SDK is preferred one.  You can use Object.delete() and soft delete it. It will be there in your recycle bin.

    If you must go ahead with Soft-Delete via DB then

    1. Take a prior back up of your DB.
    2. Execute the statement –>   UPDATE  ITEM SET DELETE_FLAG=1  WHERE ITEM_NUMBER IN (‘ITEM1′,’ITEM2’);
    3.  Execute A-verify and ensure all the data errors are taken care of.
    4. Generally this approach worked for me.

    Have tried both SDK and SQL script approach and both have worked fine. Preferred is SDK 

    Regards,
    Arif

    • 219 views
    • 4 answers
    • 0 votes