how to read CSV file from alfresco repository

Isha — Wed, 29 Apr 2020 09:47:41 GMT

Hi,

I have stored CSV file in repository using bulk import .Now I want to read that CSV file in my java class .Also I have noderef of the particular CSV file.

Kindly suggest API's/Sample code to read CSV file in alfresco .

Thanks

Isha

Re: how to read CSV file from alfresco repository

sp2 — Wed, 29 Apr 2020 10:11:12 GMT

Hi,

You can use ContentReader service read content of file.

http://dev.alfresco.com/resource/AlfrescoOne/5.0/PublicAPI/org/alfresco/service/cmr/repository/ContentReader.html

Re: how to read CSV file from alfresco repository

abhinavmishra14 — Wed, 29 Apr 2020 12:46:55 GMT

Hi @Isha

Use NodeService (NodeService Docs) to double check the node existance and get the name of csv file for creating a temp file which you will use during the processig of your program and at the end delete the temp csv file.

Use ContentService (ContentSerice Docs) to get the instance of ContentReader (as mentioned by Sanjay) for the csv nodeRef.

Pseudo Code:

File tempCSVFile = null;
try {
	if (csvNodeRef != null && nodeService.exists(csvNodeRef)) {
	    final String csvFileName = (String) nodeService.getProperty(csvNodeRef, ContentModel.PROP_NAME); //get the file name from node.

		//create temp file in temp directory
		final File tempDir = new File(System.getProperty("java.io.tmpdir"));
		tempCSVFile = File.createTempFile(csvFileName, tempDir);
							
		final ContentReader reader = contentService.getReader(csvNodeRef, ContentModel.PROP_CONTENT);
		if (reader.getSize() > 0) {
			reader.getContent(tempCSVFile);
		}
		//Now you have csv temp file, you can read it as file input stream and process the stream
		final InputStream inStreamJson = Files.newInputStream(Paths.get(tempCSVFile));
		//Process the stream as needed.
		
	}
} catch(InvalidNodeRefException | ContentIOException nodeEx) {
  //log error appropriately 
} catch(AlfrescoRuntimeException alfEx) {
  //log error appropriately 
} catch(RuntimeException runEx) {
  //log error appropriately 
} catch(Exception excp) {
  //log error appropriately 
} finally {//delete temp csv file.
	if (tempCSVFile != null && tempCSVFile.exists()) {
		tempCSVFile.delete();
	}
}

topic how to read CSV file from alfresco repository in Alfresco Forum

how to read CSV file from alfresco repository

Re: how to read CSV file from alfresco repository

Re: how to read CSV file from alfresco repository