I am working on an Excel spreadsheet that contains employee information from various markets. My aim is to extract this data and import it into the ArcGIS portal. However, the only transformer I know of that can accomplish this task is the ArcGIS Online Connector. The problem I am facing is that it requires a file to be uploaded, which is not very useful in my workspace. I do not want to save my output file; instead, I want to write it directly to the portal. I would greatly appreciate any feedback. Thank you!
Page 1 / 1
@fme_can_do_it, I understand you want to read data and then write it to ArcGIS Online. If you choose not to upload a file, you can opt to use the default 'FeatureWriter'. Below you'll find an example.
I have created a spreadsheet in Excel for you.
I read the data using a FeatureReader, perform a dummy transformation, and then write everything using the FeatureWriter.
In the settings of the FeatureWriter, I select 'Esri ArcGIS Online (AGOL) Feature Service' as the format.
After running my workspace, I can see the data in ArcGIS Online.
This means I was able to read, transform, and publish the data from the Excel file without having to write it temporarily in between. Does this answer your question?
If you are working with ArcGIS Portal, I'd suggest having a look at the Esri ArcGIS Portal Feature Service Reader/Writer. I have only used it to read/update existing services, but based on the documentation you should be able to create service as well (with a few limitations).
@fme_can_do_it, I understand you want to read data and then write it to ArcGIS Online. If you choose not to upload a file, you can opt to use the default 'FeatureWriter'. Below you'll find an example.
I have created a spreadsheet in Excel for you.
I read the data using a FeatureReader, perform a dummy transformation, and then write everything using the FeatureWriter.In the settings of the FeatureWriter, I select 'Esri ArcGIS Online (AGOL) Feature Service' as the format.
After running my workspace, I can see the data in ArcGIS Online.
This means I was able to read, transform, and publish the data from the Excel file without having to write it temporarily in between. Does this answer your question?
thanks @ernie ! That solves my problem!
thanks @ernie ! That solves my problem!
That's good to hear. Best of luck with your workspace, and feel free to reach out to me for any questions or feedback.