Skip to Content
author's profile photo Former Member
Former Member

Starting point for CSV export to FTP server with flag file

Good morning.

Forgive my simplified question, but this is a first explorative question for a project at a customer site, about which I don't have all the information available right now.

The client has prepared a wid report, which I need to be uploaded daily in CSV format (properly quoted, escaped, etc.) to an FTP server, and the completion of the transfer should be flagged by the creation of a particular yyyymmdd.csv.OK file, for each data yyyymmdd.csv produced.

From initial conversations I was told that this is not possibe, first because the option CSV exports the universe, not the query of the report and second that it is not possible to produce flag files (as a wish I would even prefer to use sftp rather than ftp).

While I understand that the combination of it all may not be there out of the box, by reading this article (http://scn.sap.com/community/bi-platform/java-sdk/blog/2013/09/24/a-demo-to-schedule-and-publish-reports-to-google-via-publication-extension), it seems to me as there is always a way with the sdk (rhymes and hopefully is true too :-) ).

Can someone more versed on the versions of BO and SDK outline me a "roadmap" of what I'd need to read/do to achieve my goal ?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 20, 2015 at 07:05 PM

    See http://scn.sap.com/thread/1103822 on How to give specified file name while exporting a file


    Regards,

    Jin-Chong

    Add a comment
    10|10000 characters needed characters exceeded

    • In CMC, you can schedule a report job with Notification to email address(es) based on the success or failure. Or, you can define the success event to the success completion of your Webi report so that a recurring program object (script or Java script) that is waiting for this success event would be triggered to produce yyyymmdd.csv.OK file on a shared folder for each data yyyymmdd.csv produced.

      The default Webi job with %SI_STARTTIME% would not produce output file name like yyyymmdd.%EXTENSION%. You'd have massage the default timestamp format to meet your need.

      Regards,

      Jin-Chong

  • Posted on May 21, 2015 at 08:31 AM

    It is pretty simple and out of the box.

    Here is how you have to achieve you requirement.

    1. Log on CMC -> Select Events and create a new schedule event under system events (figure 1)
    2. In your actual(main) report under schedule options select events and choose the above created event as "events to trigger on completion" (figure 2)
    3. Create a new dummy web-I report with destination as where ever you want to create the "OK" file. and in the schedule properties select the event under "Events to wait for" (figure 3)

    Once you have setup this event chain. First your main csv will be created. Once the CSV is "Successfully" created, a OK file will be created in the any path you choose.

    Makes sense?

    Figure (1):

    Figure (2):

    Figure (3):

    Regards,

    Naras


    1.jpg (66.7 kB)
    2.jpg (111.4 kB)
    3.jpg (95.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.