Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

View an external .csv file at a site of an AEM project

Avatar

Avatar
Validate 1
Level 1
maxq7501091
Level 1

Likes

2 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
maxq7501091
Level 1

Likes

2 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile
maxq7501091
Level 1

20-07-2017

Hi,

I would have a general question of the architecture ob my AEM application.

I have to do a simple task -> show an external .csv file at a page of an AEM application - there should be no author actions or something else.

Currently I am not clear how to develop it - should I create a Component where I will load the csv over a javascript file or is it better to make an OSGi Bundle which loads the data and I access the bundle over REST- Service or ...

I would be glad for any hint in this direction.

Thanks a lot!

View Entire Topic

Avatar

Avatar
Boost 5
Level 4
zeeshank1500736
Level 4

Likes

29 likes

Total Posts

103 posts

Correct Reply

33 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
zeeshank1500736
Level 4

Likes

29 likes

Total Posts

103 posts

Correct Reply

33 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
zeeshank1500736
Level 4

21-07-2017

Hi,

Every time reading the data from external file from NTFS or TFS will somehow degrade the performance.If the .csv file is not updated regularly and the file size is not huge then you can provide the option to upload the .csv file into the particular folder into DAM and then on upload write a workflow to read the file and create the node and update the node in some location and set all value of CSv in the property of nodes.For triggering the workflow you have to create workflow launcher and set the event type and path of the dam where .csv file is updated.

Read the Csv data from node and display into page for this you can create the component.

If the file updated on regular interval of time(cron job) for this you have to write Schedular that will start on the bases of cron job expression and do the same process to fetch and create or update node and read the value as same as above.

If the file updated any time and many time in the day for this you have to fetch the file directly from the external TFS for this you can write java code or js for fetching and get the data and parse the .csv file  and get those data into the component UI and display it.

Hope these information will help!

For Workflow Launcher follow this link :Workflow Launcher | Content Management

Creating Process Step in workflow follow and update this link :Adobe Experience Manager Help | Creating custom AEM workflow steps that send email messages

Example Implementation of a Workflow Process Step

Thanks