Forum Discussion

sdayringer's avatar
sdayringer
New Contributor III
2 years ago

Extract MultiPeriod Uploaded File Using ExportStageArchives

I'm able to extract the monthly csv files uploaded using BRAPi.Import.Data.ExportStageArchives, but this doesn't seem to work for multiperiod uploads (specifically budget) or I'm just referencing a parameter incorrectly. I've tried entering the time parameter as "2021", "2021M12", "2021M1", even "2021M1-2021M12" within the business rule, but nothing is exported at all for the Budget scenario.... Any ideas?

 

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    This smells like a known bug with Scenarios with the Workflow Tracking Frequency set to Yearly, first observed on 6.4. I would get in touch with Support for details.

  • Hi Both,

    please help me to find, where the files are stored once it's loaded in OneStream, i couldn't find the path even within onestream.

    is there any configuration setting which needs to be enabled to locate the file in file share ?

    Regards 

    Darpan

    • JackLacava's avatar
      JackLacava
      Honored Contributor

      They're not on the FileShare, they are in the application database. You should use the API for extraction.

      • darpan13's avatar
        darpan13
        Contributor

        Hi JackLacava , thanks for the quick response, i understand that the source file name and log file name i can get into an application database table - StageArchivesinformation.

        yes as you mentioned, we can use the api - brapi.stagearchivesinformation, but again, it's asking for the source path, which i am unable to find 😞 

        Regards 

        Darpan