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!
Solved
Is there any other way to write data into the ArcGIS portal besides the ArcGIS Online Connector?
+9- Enthusiast
Best answer by rickklopping
@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?
- Best Answer
@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?
+14- Contributor
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).
+9- Enthusiast
ernie wrote:
@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!
fme_can_do_it wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.