Adobe Report Builder to FTP - Overwrite file | Community
Skip to main content
December 21, 2017
Solved

Adobe Report Builder to FTP - Overwrite file

  • December 21, 2017
  • 3 replies
  • 1401 views

I've scheduled a request from report builder to be sent to an FTP on a daily basis, however, i would like that the new file overwrites the existing one but this is not the case and it's creating a new file every day (e.g "filename (1).csv", "filename (1) - copy.csv", etc.)

Does anyone have any ideas how to do this?

Thanks,

David

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Hyder_Ziaee

Trying to understand the reason...

Why are you re-requesting the entire 265 days of data on a rolling date? Is the data for the past changing? (offline data). Or looking at visitor loyalty?

In most scenarios, for rolling date, you don't require the previous data again.

3 replies

Hyder_Ziaee
Adobe Employee
Adobe Employee
December 21, 2017

This functionality is not present.

The thought process is that the report builder files are mostly for human consumption and so files don't get overwritten and lost.

Similarly, the Data Warehouse tool overwrites the files, since these files are commonly fed into a system and need to have a static or a certain pattern of name for the files.

If you are using the Report Builder for dashboarding, you will need to continue as it is. If the file you are generating is for feeding into a system, you can check whether Data Warehouse resolves your issue.

December 21, 2017

Thanks Hyderziaee, it's clear now.

The main reason to use report builder rater than Data Warehouse was to use a rolling date (last 365 days).

With Data Warehouse i'm only able to go back the last 4 weeks. Is there any way to extend this rolling date range?

Thanks,

David

Hyder_Ziaee
Adobe Employee
Hyder_ZiaeeAdobe EmployeeAccepted solution
Adobe Employee
December 21, 2017

Trying to understand the reason...

Why are you re-requesting the entire 265 days of data on a rolling date? Is the data for the past changing? (offline data). Or looking at visitor loyalty?

In most scenarios, for rolling date, you don't require the previous data again.