Use CSV from Extract Fields from Array?

Brian_Richardson

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

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

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.