1751
Points
Questions
1
Answers
64
-
- 2533 views
- 7 answers
- 0 votes
-
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 KendallPS where are you based?
- 1732 views
- 8 answers
- 0 votes
-
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
-
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
-
- 1732 views
- 8 answers
- 0 votes
-
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
-
- 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