I need to bulk /batch load my PVA Topics from an external file, otherwise I have to build a lot of content 'by hand'. I have an existing excel repository of 400-500+ Topics with each row containing: (1) Topic, (2) Question (trigger phrase 1) and (3) Message response. It's essential for me to be able to build our new PVA quickly; that I can bulk /batch load these Topics /entries from an excel (or other) file.
Thanks for any information on this!
An anonymous share link shares a file to a specific email address, it doesn't share the page. You also need to input a code when you open the anonymous share link. It doesn't require traditional authentication, but its not anonymous authentication either.
Even with the anonymous share link?
Unless its on-premises there is no such thing as a public SharePoint page anymore. All SharePoint online pages require login.
I dropped it in a google docs page, and that did not work - it picked up on the structure of the docs page itself and not the content. So then I figured out I could create a google sites page (apologies to those at MS - LMK how to do the same in MS?). My prior '3-column Word content' was then pivoted to row-based (see sample below) when I pasted in Sites (likely the better format for import - doh!), and it WORKED!! I was very excited to see my sample of 33 suggestions I could approve and set as new Topics! #Winning
Thank you!!
Example: In the below example the Question was used for the Topic Name and also the Trigger phrase, and the Response Message was used for the Message. The suggestion utility just seemed to ignore my Topic title. This is fine, and I am very happy with this result! So lesson - just list as line 1 question, line 2 answer, and then a blank line (or maybe none). I'd suggest to anyone to try 1-3 dozen of these and then ensure you're topics are working well after you have turned them on. You have to (1) move them to topics and (2) turn them on - before they will work in your CB.
ABC Topic Name
What color of golf ball is best to use in the Fall?
Most golfers prefer to use a yellow or orange neon golf ball in the Fall due to the leaves and extras debris on the course. However typically more golf balls are lost despite the color.
Thank you - that's what I figured. I'll look at my SP page and see if I can make it public.
Cheers!
SharePoint sites are by definition NOT anonymous access. This has to be on a publicly accessible page, at least temporarily.
It needs to be a public sharepoint page, is that one accessible without login? That's the "anonymous" bit.
I took my excel content, pasted special as HTML in Word, then copied that, pasted as text and published to a Sharepoint page that does have "https://" but I am getting the error message below. Any ideas on how to get the suggest topics to work on this. Could it be that PVA does not have access to this page? You say above "... that can be accessed anonymously" - so I am thinking this is my issue.
Thanks!
Assuming you can temporarily add the excel file to a web site that can be accessed anonymously the easiest way to do this would be to use the Suggested Topics feature in PVA. Take a look at the video walkthrough here for how to do it. Get topic suggestions from online content (contains video) - Power Virtual Agents | Microsoft Learn