Adrian Kendall's Profile
Agile Angel
1751
Points

Questions
1

Answers
64

  • Agile Angel Asked on May 22, 2017 in IT and Networking.

    Hello,

    Yes – unfortunately cut and pasting code can cause unexpected character substituting. Glad you go it working OK.

    PS I am no programmer either so hope your softie was not too horrified by my coding 😉

    • 2533 views
    • 7 answers
    • 0 votes
  • Agile Angel Asked on May 16, 2017 in Agile PLM (v9).

    I have been using and become a bit of  a fan of Talend it can make SOAP calls to access the webservice and will process many forms of input (txt,csv,excel, database) and probably could navigate the folder structure and infer attribute values from folder names if that applicable. You could even get it to write the fileload catalog for you to.

    There are probably a whole bunch of ETL data tools equivalent to Talend, but that’s what my company uses. Desktop version if open source too.

    That’s what I’d use, but having learn’t enough to be dangerous with it and having other more experienced users nearby to seek help that relatively easy for me to say. But, other than paying a third party with dataload for Agile, leveraging the webservice interface or the other API is my recommendation.

    Regards
    Adrian Kendall

    PS where are you based?

    • 1732 views
    • 8 answers
    • 0 votes
  • Agile Angel Asked on May 16, 2017 in Agile PLM (v9).

    Blevitan is correct the file folder would have to exist so it can be identified in the secondary Key / version

    FILEFOLDER,DESIGN00011,1,D:/docs/Design.doc,FILE,Design Document

    So you still need a utility to create the design objects on-mass. The OP didn’t state the use of Designs but if it for something MCAD you really need to create the structure too.

    If its MCAD we have found the MCAD integration to CREO in our case quite capable of  importing complete product design creating the designs / parts / structure / relationships as well as uploading the files

    • 1732 views
    • 8 answers
    • 0 votes
  • Agile Angel Asked on May 16, 2017 in IT and Networking.

    What job do you aspire to hold?
    Get some job descriptions for that job to see what skill and experience is required?
    Find some people doing the job (successfully) ask them what they think are the important skills, and behaviors to do the job well.
    Be honest, what skill need do you have, are your behaviors the same as successful incumbents of the job.
    The courses you need are those that teach your skills and behaviors you lack.

    Thank you for taking my online careers planning course, I look forward to receiving the tuition fee shortly 😉

    • 2427 views
    • 3 answers
    • 0 votes
  • Agile Angel Asked on May 15, 2017 in Agile PLM (v9).

    You’re correct import for file folders is not part of Agile functionality. You’d have to create something (using webservices) or seek out a third party tool.

    • 1732 views
    • 8 answers
    • 0 votes
  • Agile Angel Asked on May 9, 2017 in IT and Networking.

    We use this to deactivate any user who has not logged in for 95 days or more.   As previous post runs as a scheduled  PX once a month.

    //
    import com.agile.agileDSL.ScriptObj.*;
    import com.agile.api.*;
    import com.agile.px.*;
    import com.agile.util.sql.*;
    import java.sql.*;

    void invokeScript(IBaseScriptObj object) {

    Connection connection = null;
    PreparedStatement statement = null;
    ResultSet rows = null;

    try {
    connection = ConnectionFactory.getFactory().getConnection();
    statement = connection.prepareStatement(“SELECT a.LOGINID FROM (SELECT MAX(LOGIN_TIME)AS LAST_LOGIN, AU.LOGINID
    from USER_USAGE_HISTORY uuh
    JOIN AGILEUSER AU ON(uuh.USERNAME LIKE AU.LOGINID)
    WHERE AU.ENABLED = 1
    AND AU.DATE_CREATED < (SYSDATE-95)
    GROUP BY AU.LOGINID) a
    JOIN AGILEUSER AUU ON (a.LOGINID = AUU.LOGINID)
    WHERE LAST_LOGIN < (SYSDATE-95)”);
    rows = statement.executeQuery();

    while(rows.next()) {

    // modify user status
    IUser user = (IUser)m_session.getObject(IUser.OBJECT_TYPE, rows.getString(“LOGINID”));
    IAttribute attr = (String)user.getValue(UserConstants.ATT_GENERAL_INFO_STATUS);
    if ( attr == “Active” ) {
    // user.setValue(UserConstants.ATT_GENERAL_INFO_STATUS, “Inactive”);
    object.logMonitor( rows.getString(“LOGINID”) + “deactivated due to account inactivity” );
    }
    }

    } catch (Exception e) {
    object.logMonitor( e.getMessage() );
    }
    }

    AK

    This answer accepted by Matt Paulhus. on January 4, 2025 Earned 15 points.

    • 2533 views
    • 7 answers
    • 0 votes
    • 2186 views
    • 2 answers
    • 0 votes
  • Even if you use a web service you have to authenticate (log in) and create a session with the agile system. Why don’t you want to log in?

    • 1953 views
    • 6 answers
    • 0 votes
    • 1953 views
    • 6 answers
    • 0 votes
  • That’s true, but you’re still logging in with the stored credential, just not requiring the user to enter the authentication credentials and sharing that stored user account / license with multiple users in your custom application. Its my understanding doing that would violate Oracle licensing agreement for Agile.

    OP did ask ‘without logging into the agile application’  IMHO the only way to truly do this is not use the agile application and write a standalone app to query the DB and retrieve files from the vault.

    Until he reveal what he is trying to achieve, we’re guessing as to the best advice.

    • 1953 views
    • 6 answers
    • 0 votes