folder creation

Pri17

hi all,

i have created the following query to create folder

CREATE cm_folder OBJECT

SET object_name = 'Miscellaneous\Temporary + user_name',

SET acl_domain = 'bst',

SET acl_name = 'cm_default_acl',

LINK '/user_os_name'

in the above query i want the object name as 'Miscellaneous\Temporary Ithape,Priyanka' where Ithape,Priyanka is the user_name.

In short i want to append it!!!

And also the LINK should be her wwid ie user_os_name.

How can des be done???

Find more posts tagged with

Documentum

Comments

JorgKrause

Hi,

well, to start with, you can't create folder containing \ as a character. Secondly, where do you want to retrieve the user_name/user_os_name from? I guess from dm_user, but what are you trying to do exactly?

Regards

Jørg

Pri17

CREATE cm_folder OBJECT

SET object_name = 'kf743',

SET acl_domain = 'bst',

SET acl_name = 'cm_default_acl',

LINK '/kf743'

des is d query...which i executed and it created folder in the home cabinet of kf743 with the name kf743.

i want to create folder for all the users in their home cabinet with the name 'Miscellaneous\Temporary + user_name' .

This is the code which i have written

String userList =

"select user_os_name from dm_user where user_state=0 and user_login_domain='cm_ldap_bst' and user_name in (select i_all_users_names from dm_group)";

query.setDQL(userList);

IDfCollection userCollection = null;

IDfQuery queryCreateFolder = new DfQuery();

try {

userCollection = query.execute(session, IDfQuery.DF_READ_QUERY);

String folderCreateQuery = "";

String osName = "";

while(userCollection.next())

{

userCollection.getString("user_os_name");

folderCreateQuery = "CREATE cm_folder OBJECT SET object_name = '"+osName+"', "

+" SET acl_domain = 'bst', SET acl_name = 'cm_default_acl',LINK '/"

+osName+"'";

queryCreateFolder.setDQL(folderCreateQuery);

queryCreateFolder.execute(session,IDfQuery.DF_READ_QUERY);

System.out.println("Folder successfully created for " + osName + "\n");

}

} catch (Exception e) {

e.printStackTrace();

}

JorgKrause

And the problem/question is?

Pri17

as i wrote above d query which i created,i have given object_name as osName

But i want to create folder for all the users in their home cabinet with the name 'Miscellaneous\Temporary + user_name' .

so how should i do that???

JorgKrause

Well,

backslash is actually allowed as character in folder name, my bad :-(

But I'm still puzzled a bit. You have a perfect query in your question, and another query to create the folder in a loop.

So why don't you simply add the 'Miscellaneous\Temporary + user_name' in your folder creation query?

Why do you use a query, btw? You could easily create the folder by something like

IDfFolder fld = (IDfFolder)session.newObject("dm_folder");

and assign all properties exactly like you want to have.

fld.save() would create the object.

Jørg

Pri17

as i said i want to set object name of all users as 'Miscellaneous\Temporary + user_name'

In the place of user_name their name should come from repository.........i want to appl that in my code and i am stuck!!!

In my query i have given osName ie wwid and not user_name........can u provide me solution in my existing code??

DCTM_Guru

Using Jørg's method, you can still set the object name dynamically:

IDfFolder fld = (IDfFolder)session.newObject("dm_folder");

fld.setObjectName( 'Miscellaneous\Temporary ' + user_name);

fld.save() would create the object.

JorgKrause

Hmmh,

you could try something like this

while (userCollection.next()) {    IDfFolder fld = (IDfFolder) session.newObject("dm_folder");    fld.setObjectName("Miscellaneous\\Temporary " + userCollection.getString("user_name"));    fld.setACLDomain("bst");    fld.setACLName("cm_default_acl");    fld.link("/" + userCollection.getString("user_os_name"));    fld.saveLock();    }

You would have to add user_name,user_os_name to your select query, of course

Regards

Jørg

Pri17

hey,thanks joerg!!!

Now in the above code,i also want to find that if the folder is already present den no need for that user to create the Miscellaneous folder ,but if the folder is not there den to execute the code which u have given

Can u help me in des???

lastnitescurry

Pri17 wrote:hey,thanks joerg!!!Now in the above code,i also want to find that if the folder is already present den no need for that user to create the Miscellaneous folder ,but if the folder is not there den to execute the code which u have givenCan u help me in des???

Tell you what... send me some beer and pizza and I'll do your job for you!!!

JorgKrause

Haha,

that would be something, right?

But I do certainly agree with you Brian! I suggest that you spend some time to investigate DFC coding, there are TONS of examples in forums, and a lot of other places.

Best of luck

Jørg

DCTM_Guru

I'll help out for a coffee and a bagel

JorgKrause

I'll keep that in mind for later, then Good to know that there's help for a coffee and a bagel!

DCTM_Guru

Mind you, the quality of work may be low given that I might still be asleep before the first cup of coffee

JorgKrause

Hi,

As far as I can see, your question is pretty much answered, right?

Plz take a minute and read this

https://community.emc.com/community/support/blog/2011/07/15/let-your-peers-know-you-appreciate-their-help-mark-their-replies-as-helpful-answered-with-one-click

Regards

Jørg

Pri17

thank you guys for ur suggestions!!!

JorgKrause

Wow!

Pri17

hey joerg, in my following code :

IDfQuery query = new DfQuery();
String userList = "select user_os_name from dm_user where user_state=0 and user_login_domain='cm_ldap_bst' and user_name in

(select i_all_users_names from dm_group)";
query.setDQL(userList);

IDfCollection userCollection = null;
IDfQuery queryCreateFolder = new DfQuery();
try {

   userCollection = query.execute(session, DfQuery.DF_READ_QUERY);

   String folderCreateQuery = "";
   String osName = "";
   while (userCollection.next()) {

osName = userCollection.getString("user_os_name");

    folderCreateQuery = "CREATE cm_folder OBJECT SET object_name = '"
      + osName
      + "', "
      + " SET acl_domain = 'bst', SET acl_name = 'cm_default_acl',LINK '/"
      + osName + "'";
    queryCreateFolder.setDQL(folderCreateQuery);
    queryCreateFolder.execute(session, DfQuery.DF_READ_QUERY);
    System.out.println("Folder successfully created for " + osName
      + "\n");
   } } catch (Exception e) {
   e.printStackTrace();
}

i am getting this error

Exception in thread "main" java.lang.NoClassDefFoundError: com/documentum/services/config/IDocbaseContext

at java.lang.ClassLoader.defineClass1(Native Method)

at java.lang.ClassLoader.defineClassCond(Unknown Source)

at java.lang.ClassLoader.defineClass(Unknown Source)

at java.security.SecureClassLoader.defineClass(Unknown Source)

at java.net.URLClassLoader.defineClass(Unknown Source)

at java.net.URLClassLoader.access$000(Unknown Source)

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at com.documentum.operations.impl.DfOperationManager.getOperation(DfOperationManager.java:25)

at com.documentum.com.DfClientX.getNewOperation(DfClientX.java:638)

at com.documentum.com.DfClientX.getExportOperation(DfClientX.java:654)

at com.documentum.fc.client.impl.bof.cache.InboundModuleMetadata$BofFile.persist(InboundModuleMetadata.java:126)

at com.documentum.fc.client.impl.bof.cache.DefaultLocalAccessor.saveFiles(DefaultLocalAccessor.java:178)

at com.documentum.fc.client.impl.bof.cache.DefaultLocalAccessor.cacheObject(DefaultLocalAccessor.java:65)

at com.documentum.fc.client.impl.bof.cache.DocbaseClassCache.cacheObject(DocbaseClassCache.java:95)

at com.documentum.fc.client.impl.bof.cache.ClassCacheManager.downloadAndCache(ClassCacheManager.java:454)

at com.documentum.fc.client.impl.bof.cache.ClassCacheManager.retrieveObject(ClassCacheManager.java:94)

at com.documentum.fc.client.impl.bof.classmgmt.ClassLoaderFactory.addUrlsToLoader(ClassLoaderFactory.java:104)

at com.documentum.fc.client.impl.bof.classmgmt.ClassLoaderFactory.getModuleClassLoader(ClassLoaderFactory.java:64)

at com.documentum.fc.client.impl.bof.classmgmt.ClassLoaderFactory.getTBOClassLoader(ClassLoaderFactory.java:41)

at com.documentum.fc.client.impl.bof.compoundclass.CompoundClassMgr.loadTboClass(CompoundClassMgr.java:295)

at com.documentum.fc.client.impl.bof.compoundclass.CompoundClassMgr.getTboClass(CompoundClassMgr.java:223)

at com.documentum.fc.client.impl.bof.compoundclass.CompoundClassMgr.getImpClass(CompoundClassMgr.java:72)

at com.documentum.fc.client.impl.objectmanager.AbstractPersistentObjectFactory.getCompoundClassEntry(AbstractPersistentObjectFactory.java:39)

at com.documentum.fc.client.impl.objectmanager.PObjectFactoryWithAspects.makeObject(PObjectFactoryWithAspects.java:48)

at com.documentum.fc.client.impl.objectmanager.PersistentObjectManager.newUncachedObject(PersistentObjectManager.java:100)

at com.documentum.fc.client.impl.objectmanager.PersistentObjectManager.newObject(PersistentObjectManager.java:66)

at com.documentum.fc.client.impl.objectmanager.PersistentObjectManager.newObject(PersistentObjectManager.java:52)

at com.documentum.fc.client.impl.dql.DqlUpdate.processCreate(DqlUpdate.java:624)

at com.documentum.fc.client.DfQuery.runQuery(DfQuery.java:184)

at com.documentum.fc.client.DfQuery.execute(DfQuery.java:208)

at Test_Method.execute(Test_Method.java:103)

at Test_Method.main(Test_Method.java:136)

Caused by: java.lang.ClassNotFoundException: com.documentum.services.config.IDocbaseContext

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

... 37 more

Pri17

hey the above code worked....but it is creating cabinet by the name of its wwid inside main cabinet

i want the folder by the name of its wwid created inside the home cabinet!!!

can u help in the above code......where i went wrong in the query...

coz when i run the create query in DA.......it is creating folder for one user......inside home cabinet....

but when i run the above code,it is creating cabinet and not folder....that too not under home cabinet!!!

thanks in advance

DCTM_Guru

Include debugging statements in your code to make sure you are passing values that you expect. FYI - if you are linking to a cabinet (eg /John Doe) that your user that you are using to run this code from does NOT have WRITE permissions on that cabinet, then content server will create in the users default folder (as defined in the default_folder attribute for the dm_user object).

Pri17

hey thanks johnny!!!

it had not added the proper jar files!!!

in the code below:

while (userCollection.next()) {

IDfFolder folder=session.getFolderByPath("/"+userCollection.getString("user_os_name")+ "/Miscellaneous\\Temporary " + userCollection.getString("user_name"));

if(folder!=null)

{

System.out.println("Folder not created for " + userCollection.getString("user_name")

+ "\n");

}

else

{

IDfFolder fld = (IDfFolder) session.newObject("cm_folder");

fld.setObjectName("Personnel Files " + userCollection.getString("user_name"));

fld.setACLDomain("bst");

fld.setACLName("cm_default_acl");

fld.setOwnerName(userCollection.getString("user_name"));

fld.link("/" + userCollection.getString("user_os_name"));

System.out.println("Folder created for " + userCollection.getString("user_name")

+ "\n");

// IDfSysObject s1=(IDfSysObject)fld;

// s1.setString("cm_rsn", arg1)

fld.link("/Corporate Records/General/GEN130 - General Presentations");

fld.saveLock();

the first link is creating folder in that location!!!

now i want to link that folder to some other folder!!!

will the above code work??

and also if i have to unlink the folder if it is already linked but from some other location,how to unlink and then link again???

DCTM_Guru

will the above code work??

- It should. Instead of asking, why dont you try and see?

and also if i have to unlink the folder if it is already linked but from some other location,how to unlink and then link again???

- I'm not sure I understand you. Just provide the folderpath for either link/unlink. As long as the folderpath link exists, the unlink will work regardless of where it was originally link.