FlexPro Forum – Discuss Your Topic!

Automated export from formula to CSV file

Home > Community > FPScript > Automated export from formula to CSV file

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • June 19, 2012 at 2:36 pm #12767
    norbert.bakkers@lr.orgnorbert.bakkers@lr.org
    Participant

    I’ve written a FlexPro function (in FlexPro script) with a number of arrays defined within the function e.g:

    myTime = 0. # NumTimeSteps
    myResult1 = 0. # NumTimeSteps
    myResult2 = 0. # NumTimeSteps
    myResult3 = 0. # NumTimeSteps
    myResult4 = 0. # NumTimeSteps
    myResult5 = 0. # NumTimeSteps

    Then I populate them with data.

    I would then like to export the resulting arrays into CSV files from within the formula. The formula will be called multiple times, so I would like the process to be as automated as possible.

    What would be the best way to go about this?

    June 19, 2012 at 2:36 pm #8433
    norbert.bakkers@lr.orgnorbert.bakkers@lr.org
    Participant

    I’ve written a FlexPro function (in FlexPro script) with a number of arrays defined within the function e.g:

    myTime = 0. # NumTimeSteps
    myResult1 = 0. # NumTimeSteps
    myResult2 = 0. # NumTimeSteps
    myResult3 = 0. # NumTimeSteps
    myResult4 = 0. # NumTimeSteps
    myResult5 = 0. # NumTimeSteps

    Then I populate them with data.

    I would then like to export the resulting arrays into CSV files from within the formula. The formula will be called multiple times, so I would like the process to be as automated as possible.

    What would be the best way to go about this?

    June 25, 2012 at 12:42 pm #9242
    Bernhard KantzBernhard Kantz
    Participant

    If you want to automate the export you have to write a VBA macro.

    Example:
    …
    Dim oFml As Formula
    Set oFml = ThisDatabase.RootFolder.Object(“Formula”, fpObjectTypeFormula)
    oFml.Export fpExportFormatCSV, “…Path…”
    …

    support@weisang.com

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.