topic Re: Custom Export Action (Standalone Java) for Metadata through in Alfresco Archive

Custom Export Action (Standalone Java) for Metadata through

sselvan — Wed, 17 Feb 2010 21:09:36 GMT

Hi,I have written a code to export metadata for selected files through the WebServices API.This code is standalone Java program and it compiles and when executed against Alfresco 3.1 Enterprise edition, the export works and I am able to create a CSV file with file name and all the properties which I

Re: Custom Export Action (Standalone Java) for Metadata through

sselvan — Thu, 18 Feb 2010 05:39:45 GMT

Since the same code is working for 3.1, but not for 3.2 - I am assuming that there is something changed in the WebServices API and that is making the bulk export of metadata fields not working - given the file names.

Any comments on it?
I know it is a big statement, but I am hoping I am not wrong. Please clarify.

Any help is really really appreciated…

Thank you

Re: Custom Export Action (Standalone Java) for Metadata through

sselvan — Thu, 18 Feb 2010 08:19:23 GMT

To start with - the same code works as expected for 3.1, but not for 3.2.

I was able to spot which line is creating the problem -

QueryResult queryResult = repositoryService.query(STORE, query, false);

the queryResult returned in the code above or in the attached file via the RepositoryService is different in 3.1 than in 3.2. Hence, I am thinking there is something different in Repository Service in 3.2.

Please let me know, if I am wrong.

Re: Custom Export Action (Standalone Java) for Metadata through

sselvan — Fri, 19 Feb 2010 01:09:37 GMT

This is a problem in Alfresco, but solved by following the sample code below -

Store STORE = new Store(Constants.WORKSPACE_STORE, "SpacesStore");
String ROOT = "/app:company_home/cm:"+ISO9075.encode("Folder Name");
String path = "PATH:\"/" + ROOT + "//.\" AND TYPE:\"{http://www.alfresco.org/model/content/1.0}content\""; 
final List<String> result = new ArrayList<String>();
final Query query = new Query(Constants.QUERY_LANG_LUCENE, path);
Node [] nodes = null;
try {      
nodes = WebServiceFactory.getRepositoryService().get(new Predicate(null,STORE,query));      
} catch (RepositoryFault e) {
e.printStackTrace();
} catch (RemoteException e) {
e.printStackTrace();
}
if (null != nodes){
NamedValue[] props = null;
for (final Node node : nodes) {
   props = node.getProperties();
   for(NamedValue prop : props) {
      if(prop.getName().endsWith(Constants.PROP_NAME) == true) {                   
         result.add(prop.getValue());
   }
}

}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hope this will be helpful for someone encountering the same issue. Good luck!

Re: Custom Export Action (Standalone Java) for Metadata through

hariprasad — Thu, 26 Jun 2014 10:30:47 GMT

Hi Selvan,

I need a standalone utility java class for the below items with different methods, could you please provide

1.   Upload File along with Meta Data
public void uploadFile( ) {

}

2.   Download File along with Meta Data
public void downloadFile( ) {

}

3.   Search File By Name
public void SearchFileByName( ) {

}

4.   Search File with Meta Data
public void SearchFileWithMetaData( ) {

}

5.   List GUIDs for Files matching the criteria
public void listOfGuids( ) {

}
6.   Search File by GUID

public void searchGuid( ) {

}

Thanks,
-Hari
harip36@gmail.com

Re: Custom Export Action (Standalone Java) for Metadata through

krutik_jayswal — Sat, 15 Jul 2017 08:20:19 GMT

There is one generic example using which you can export any kind of data in excel.Below link will help you understanding that stuff.

Alfresco Webscript : Export Data In Excel | Krutik Jayswal