Skip to main content
Solved

How to write csv file to AGOL?

  • November 23, 2022
  • 7 replies
  • 162 views

datablue
Contributor
Forum|alt.badge.img+7

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

datablue wrote:

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.

View original
Did this help you find an answer to your question?

7 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

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


datablue
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • November 23, 2022
nielsgerrits wrote:

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+54
  • Best Answer
  • November 23, 2022
datablue wrote:

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+7
  • Author
  • Contributor
  • November 23, 2022
datablue wrote:

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+54
datablue wrote:

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+7
  • Author
  • Contributor
  • November 23, 2022
datablue wrote:

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+7
  • Author
  • Contributor
  • November 24, 2022
datablue wrote:

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!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings