Is there a quicker and easier way to input data into a Fusion Data Store? I've got quite a lot of data (strings and arrays) and entering field-by-field is very time consuming. Was wondering if there was a way to get those updated with a CSV or some | Community
Skip to main content
S
smmurphy2342
New Participant
June 30, 2021
Solved

Is there a quicker and easier way to input data into a Fusion Data Store? I've got quite a lot of data (strings and arrays) and entering field-by-field is very time consuming. Was wondering if there was a way to get those updated with a CSV or some

  • June 30, 2021
  • 2 replies
  • 1712 views
No text available
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by William--

Hi Sean, sorry if I'm oversimplifying this, but can you put the CSV data into an Excel Online or Google Sheets worksheet; call that worksheet in a scenario, then use an iterator to cycle through each row in the worksheet, each time using the "Add/Replace a Record" action on the data store module?

2 replies

ChrisBudgen
ChrisBudgen
New Participant
July 14, 2021

You can also upload your csv as a document to Workfront and then use the Read Document Module -> Parse CSV Module -> Add/Replace Row. It iterates by itself via the parse CSV module.

William--
William--
New Participant
July 15, 2021

Hi Chris, can you show where you find the Workfront "Read Document" module?

I'm familiar with the "Read Record" module that allows you to read attributes of the Workfront document, but I have never seen a module that will read the content of a Workfront document or make the content available for parsing. The only module I found that appears to do that is in the Sharepoint connector.

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
ChrisBudgen
ChrisBudgen
New Participant
July 16, 2021

My bad, it is called "Download Document". It can retrieve the CSV that you uploaded to Workfront and you will be able to use File Name, File Size, File Extension and Data. So the Data is what we want to add to the Parce CSV module. Here a short screencast of one of our import scenarios: https://www.awesomescreenshot.com/video/4505023?key=48216d28fa58993fc7048613adf8d042

    William--
    William--Accepted solution
    New Participant
    July 1, 2021

    Hi Sean, sorry if I'm oversimplifying this, but can you put the CSV data into an Excel Online or Google Sheets worksheet; call that worksheet in a scenario, then use an iterator to cycle through each row in the worksheet, each time using the "Add/Replace a Record" action on the data store module?

    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
      S
      smmurphy2342Author
      New Participant
      July 1, 2021

      Oh my gosh! Thank you for the reminder about the Fusion "Add/Replace a Record" modules! We actually already have a scenario built that pulls values from a Task Template and adds or removes items from the Data Store. I can't believe I forgot about that. One button click and the data store is updated with all new values! Thanks for the mental poke!

      Terms & ConditionsAccessibility statement

      Loading footer...