Use CSV from Extract Fields from Array?

Options
Brian_Richardson
Brian_Richardson Overachievers
edited 09/11/23 in Add Ons and Integrations

Anyone know how to use the CSV output from the "Extract Fields" step in Array management? I'd like to save the results as a CSV and then use Data Shuttle to import it. I'm reading utilization data from Smartsheet Resource Management into a sheet in Smartsheet. But there's about 9000 rows and Bridge seems to be choking on the size of it, it runs through about half and then simply stops working with no error or a "reset" error.

There's an option to extract in CSV format instead of the default Array format, but I don't see any documentation or description about how to write that to a CSV file.

I have a feeling I might have to learn enough Javascript to do that. If anyone has some simple code or has addressed a similar problem, I'd love to hear about it.

BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

SEATTLE WA, USA

IRON MOUNTAIN

Tags:

Best Answer

  • Brian_Richardson
    Brian_Richardson Overachievers
    Answer ✓
    Options

    Smartsheet Support investigated and answered this question. The answer is: no, Bridge cannot export data to a CSV.

    I'm frankly unclear on what the CSV format option in Extract Fields is for then... but I guess that's a different question.

    I'm also unclear what the best practice is to read a larger data set (say 10,000 objects) using Bridge and use the info. Because it chokes and resets when I try.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers
    Answer ✓
    Options

    Smartsheet Support investigated and answered this question. The answer is: no, Bridge cannot export data to a CSV.

    I'm frankly unclear on what the CSV format option in Extract Fields is for then... but I guess that's a different question.

    I'm also unclear what the best practice is to read a larger data set (say 10,000 objects) using Bridge and use the info. Because it chokes and resets when I try.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN