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

Schedule a report in ACC

Avatar

Avatar
Validate 1
Level 2
shiyamalad17317
Level 2

Likes

13 likes

Total Posts

35 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
shiyamalad17317
Level 2

Likes

13 likes

Total Posts

35 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
shiyamalad17317
Level 2

19-11-2019

Hi Team,

I have report which needs to be schedule at 10AM daily to the me and another one. Can you guys help me to support on this? Attached screenshot is for your reference.

Thanks,

Shama.

1857122_pastedImage_0.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 3
asktam1410
Level 3

Likes

18 likes

Total Posts

37 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
asktam1410
Level 3

Likes

18 likes

Total Posts

37 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
asktam1410
Level 3

21-11-2019

You can automate the report through java script.

vars.AshokDeliveryRpt="/usr/local/neolane/nl6/var/xxxxxxxxx/export/Ashok_DS_1.xls";

      var reportName = "CustomDeliveryStatistics";

      var path = vars.AshokDeliveryRpt;

      var exportFormat = "XLS";

      isAdHoc = false;

      var _ctx = <ctx _context="selection" _selectionCount="1" _selection={campId} _schema="nms:delivery" _reportContext={reportName} />

      xtk.report.export(reportName,_ctx,exportFormat,path,isAdHoc);

Once report is generated in the export directory - you can add it as an attachment and send it everyday in a specified time.

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 3
asktam1410
Level 3

Likes

18 likes

Total Posts

37 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
asktam1410
Level 3

Likes

18 likes

Total Posts

37 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
asktam1410
Level 3

22-11-2019

Create a new report - whatever you are trying to view in Descriptive analysis - you could do it through report query then create a output page. Refer the query whatever you created as 'contextual data'. Save and publish.

Then Call that report internal name in the above mentioned Java script.

Avatar

Avatar
Validate 1
Level 2
shiyamalad17317
Level 2

Likes

13 likes

Total Posts

35 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
shiyamalad17317
Level 2

Likes

13 likes

Total Posts

35 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
shiyamalad17317
Level 2

25-11-2019

Hi Vinod,

Thanks for getting me back.

I haven't used Javascript by creating report.

Could you share any screenshot reference on how did you create the report with query builder plus Javascript functionality on ACC please?

Thanks,

Shama.

Avatar

Avatar
Validate 1
Level 2
shiyamalad17317
Level 2

Likes

13 likes

Total Posts

35 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
shiyamalad17317
Level 2

Likes

13 likes

Total Posts

35 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
shiyamalad17317
Level 2

21-11-2019

Hi Ashok,

Thanks for getting me back.

I have created the report by using descriptive analysis mode. Then how should we able to use the above script in the report? Sorry. Since I am new to create reports in Adobe Campaign Classic, I need your guidance on this.

Much appreciated.

Shama.