Enterprise portalを使用してサインインするオプションは、一部のケースでは利用できません。 ArcGIS for Excel Basicsトレーニングチュートリアルを進めようとしています。サインインしようとすると、ArcGISログインまたはArcGIS org urlのオプションしか表示されません。私たちのENT portal urlを使いたいです。以前は、この問題（まれに発生するla.arcgisエラーがあった時）を回避するために、空のExcelドキュメントを開き、ENT portalにサインインしてから必要なデータファイルを開いていました。現在、この方法を試すと標準のArcGISログイン画面（上記）が表示されます。空のドキュメントを開いてENT portal経由でサインインすることはできますが、トレーニングファイルを開こうとすると、上記のウィンドウでサインインするよう求められます。

Happy Friday @Jennifer_Parmeley thanks for reaching out again. You should be able to geocode in the Portal account with no issues. Are you asked to sign in once or does the sign-in option continue to pop up? Maybe restart, clear the cache, and try a fresh excel worksheet? Maybe 'something' is stuck somewhere in the workflow.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Enterprise portalを通じてExcelにサインインする

Jennifer_Parmeley

Enterprise portalを使用してサインインするオプションは、一部のケースでは利用できません。

ArcGIS for Excel Basicsトレーニングチュートリアルを進めようとしています。
サインインしようとすると、ArcGISログインまたはArcGIS org urlのオプションしか表示されません。私たちのENT portal urlを使いたいです。<\/P>

<\/span><\/P><\/P><\/span><\/P>以前は、この問題（まれに発生するla.arcgisエラーがあった時）を回避するために、空のExcelドキュメントを開き、ENT portalにサインインしてから必要なデータファイルを開いていました。
現在、この方法を試すと標準のArcGISログイン画面（上記）が表示されます。

空のドキュメントを開いてENT portal経由でサインインすることはできますが、トレーニングファイルを開こうとすると、上記のウィンドウでサインインするよう求められます。<\/P><\/span><\/P><\/P>

<\/P>

タグ付きの投稿をもっと見る

Accepted answers

All comments

Jennifer_Parmeley

It never fails that as soon as I post I find something useful.
I was able to copy the sheet of data I need from the training file to my empty workbook (where I have the ENT sign in).
This is still frustrating and is only a work around. This will only complicate (and potentially confuse) staff in our org that I need to create training for.

abureaux

From the FAQ. Did you try this yet?

Why can't I connect to my ArcGIS Enterprise portal instance from ArcGIS for Excel

If you can't connect to your ArcGIS Enterprise portal instance from ArcGIS for Excel, ensure that the ArcGIS connection specified in the ArcGIS for Excel configuration settings uses the HTTPS protocol (for example, https://sampleportal.xyz.com/portal). Specifically, confirm that the maps.arcgis.com extension, for example, https://example.maps.arcgis.com does not support HTTP.

Jennifer_Parmeley

I hadn't seen that. I sent it to our GIS admin to see if they could access those settings, I'm not sure it will fix the issue, but it's worth a look to see. Thanks!

I can something access the portal (through an empty excel workbook), but not always (when trying to open the training data for the ESRI class related to Excel)

abureaux

By chance, are you able to check if your company Portal is still selected when you launch the training? I am wondering if the training is setting AGO as the default login option. Or, its potentially opening a difference instance of Excel (If you had more than one install of Excel, that could potentially confuse things).

Jennifer_Parmeley

I created a support ticket with ESRI associated with the training issue. I found that the issue persisted when using data in an excel sheet we created. It looks like this is by design and not seen as an issue.

You have to sign in to AGOL in order to geocode in Excel.
I signed in with my enterprise portal, set up the geocode, and still had to sign in to an AGOL to get the "add to map" button to work. Looking at the portal/sign in after the geocode I am still signed into the enterprise portal. In this case the AGOL sign in doesn't appear to do anything.

If signed into our enterprise portal and using a custom locator no credits were used from the AGOL account.
If signed into our enterprise portal and using ESRI world geocoder, credits were used from the AGOL account.

There is no warning or notice on credit use in Excel.

abureaux

Well, that's all really good (if not disappointing) information! Thank you for following up on this.

ShannonCardoza

Good afternoon @Jennifer_Parmeley

Based on your description above, I believe this is an easy fix. You may reset the map and be provided the option to set your URL.

Thank you for reaching out. Please let me know if this is helpful!

Jennifer_Parmeley

@ShannonCardoza is this a new feature? I had a support ticket with ESRI on this and they did not give this as an option, for switching portals.

After using the Reset Map option, I signed into our ENT portal. I am still being asked to sign into ArcGIS Online when I try to geocode (add points from an address). I can add points from x,y, but not from an address.

ShannonCardoza

@Jennifer_Parmeley Firstly, I apologize for the support ticket situation. Our add-in is a new-ish UI/UX so some may be unfamiliar just yet.

As for sign-in, ArcGIS for Excel works directly with your ArcGIS subscription to allow you to access geographic content. To access all map tools and content in ArcGIS for Excel, your ArcGIS user type must have been granted privileges to create, analyze, and share content in an ArcGIS Online organization or an on-premises ArcGIS Enterprise deployment. Geocoding would require sign-in. Add xy does not.

Let me know if you have any other questions!

-SC

Jennifer_Parmeley

Can you geocode a list of locations (I was experimenting with 10 at a time) using the credentials from an ArcGIS ENT deployment?

In our portal I have a custom role, but I'm allowed do do most things. I can create any type of application, create and share feature services (hosted and referenced), and manage groups. When I'm logged into our portal and I try to geocode I'm being prompted to sign into an ArcGIS Online org.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.