Skip to main content
Solved

How to write csv file to AGOL?

  • November 23, 2022
  • 7 replies
  • 217 views

datablue
Contributor
Forum|alt.badge.img+8

I have a writer that creates a CSV file to a folder on my computer. How do I write this CSV file to AGOL (ArcGIS Online account)?

 

I already understand how to write data to an AGOL Feature Service. I need to create a CSV file to my AGOL account. I plan to update this CSV file every night (via the Task Scheduler) and share it with others. I'm using FME Desktop (not FME Server). Thanks.

Best answer by nielsgerrits

Thanks. I see how ArcGISOnlineConnector can upload a file to my ArcGIS account. I don't understand how to incorporate ArcGISOnlineConnector in the workspace that creates my CSV file. The writer (for the CSV file) is the last transformer. I'm not sure how to use ArcGISOnlineConnector after the CSV file has been created.

If you use a FeatureWriter, you can use the summary outputport to initiate the arcgisonlineconnector.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

7 replies

nielsgerrits
VIP
Forum|alt.badge.img+62

Multiple ways to do this, but one way to do this is to use the ArcGISOnlineConnector.


datablue
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • November 23, 2022

Multiple ways to do this, but one way to do this is to use the ArcGISOnlineConnector.

Thanks. I see how ArcGISOnlineConnector can upload a file to my ArcGIS account. I don't understand how to incorporate ArcGISOnlineConnector in the workspace that creates my CSV file. The writer (for the CSV file) is the last transformer. I'm not sure how to use ArcGISOnlineConnector after the CSV file has been created.


nielsgerrits
VIP
Forum|alt.badge.img+62
  • Best Answer
  • November 23, 2022

Thanks. I see how ArcGISOnlineConnector can upload a file to my ArcGIS account. I don't understand how to incorporate ArcGISOnlineConnector in the workspace that creates my CSV file. The writer (for the CSV file) is the last transformer. I'm not sure how to use ArcGISOnlineConnector after the CSV file has been created.

If you use a FeatureWriter, you can use the summary outputport to initiate the arcgisonlineconnector.


datablue
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • November 23, 2022

Thanks. I see how ArcGISOnlineConnector can upload a file to my ArcGIS account. I don't understand how to incorporate ArcGISOnlineConnector in the workspace that creates my CSV file. The writer (for the CSV file) is the last transformer. I'm not sure how to use ArcGISOnlineConnector after the CSV file has been created.

That works great. Thanks.

I need to replace this csv file every day. I believe that it's best to "Upload" the file daily using ArcGISOnlineConnector, rather than "Update" it. Does that sound correct?


nielsgerrits
VIP
Forum|alt.badge.img+62

Thanks. I see how ArcGISOnlineConnector can upload a file to my ArcGIS account. I don't understand how to incorporate ArcGISOnlineConnector in the workspace that creates my CSV file. The writer (for the CSV file) is the last transformer. I'm not sure how to use ArcGISOnlineConnector after the CSV file has been created.

I’m not sure, it depends on what you need exactly. Do you want a new item evert day? Then upload. Do you want to replace the data of the same item everyday? Then update. I think you want the latter.


datablue
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • November 23, 2022

Thanks. I see how ArcGISOnlineConnector can upload a file to my ArcGIS account. I don't understand how to incorporate ArcGISOnlineConnector in the workspace that creates my CSV file. The writer (for the CSV file) is the last transformer. I'm not sure how to use ArcGISOnlineConnector after the CSV file has been created.

I want to completely replace the csv file everyday. It seems like using Upload (for the ArcGISOnlineConnector parameter) is working for me. When I change it to Update, ArcGISOnlineConnector prompts me for a Path and I'm not sure what to enter. I may need to experiment with this.


datablue
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • November 24, 2022

Thanks. I see how ArcGISOnlineConnector can upload a file to my ArcGIS account. I don't understand how to incorporate ArcGISOnlineConnector in the workspace that creates my CSV file. The writer (for the CSV file) is the last transformer. I'm not sure how to use ArcGISOnlineConnector after the CSV file has been created.

I discovered that attempting to Upload a CSV file to AGOL when the file already exists generates an error (that I didn't initially notice). Using Update for the ArcGISOnlineConnector parameter is the correct way to replace a CSV file.

 

Thank you for all of your help!