Combined Cloud Managed Services

User Tools

Site Tools

wiki:ai:chatbot-helpdesk-sentiment

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
wiki:ai:chatbot-helpdesk-sentiment [2025/06/24 20:35] – ddehamerwiki:ai:chatbot-helpdesk-sentiment [2025/07/02 21:10] (current) – zhein
Line 1: Line 1:
-====== AI Chatbot wit Sentiment and In Kind Responses ======+====== AI Chatbot with Sentiment and In Kind Responses ====== 
  
 ===== Requirements ===== ===== Requirements =====
Line 12: Line 13:
  
 ===== Prerequisites ===== ===== Prerequisites =====
 +
 Install These Install These
-<code>+ 
 +<code ->
 brew install dotnet-sdk #This will be version 9 which will not work but gives you the rest of the stuff needed. brew install dotnet-sdk #This will be version 9 which will not work but gives you the rest of the stuff needed.
 brew install azure-cli brew install azure-cli
 </code> </code>
  
 +Assuming you already have created a Resource Group named don-test-rg, an OpenAI deployment named don-openai-useast, and deployed a gpt model named gpt-4.1 inside openai.  Those all require the portal.
  
-Assuming you already have created a Resource Group named don-test-rg, an OpenAI deployment named  and deployed a gpt model named gpt-4.1.+Install this from the webpage and follow directions. [[https://dotnet.microsoft.com/en-us/download/dotnet/8.0|dotnet 8.x]]
  
-Install this from the webpage and follow directions. +Create a folder in your workspace and save the files at the end of this document. 
-[[https://dotnet.microsoft.com/en-us/download/dotnet/8.0|dotnet 8.x]]+
  
-Then these +Open a terminal, set your folder to the one where the files are saved, then run these commands: 
-<code>+ 
 +These commands are only needed for Windows users: 
 +<code -> 
 +dotnet nuget add source https://api.nuget.org/v3/index.json -n nuget.org 
 +npm install -g azure-functions-core-tools@4 --unsafe-perm true 
 +dotnet nuget locals all --clear 
 +dotnet restore 
 +</code> 
 + 
 +The rest of the instructions are for every OS: 
 + 
 +<code ->
 dotnet add package Microsoft.Azure.Functions.Worker.Extensions.OpenApi --version 1.4.0 dotnet add package Microsoft.Azure.Functions.Worker.Extensions.OpenApi --version 1.4.0
 dotnet --list-sdks dotnet --list-sdks
Line 33: Line 47:
  
 Create Storage Account Create Storage Account
-<code>+ 
 +<code ->
 az storage account create \ az storage account create \
   --name dehamerfuncstorage \   --name dehamerfuncstorage \
Line 42: Line 57:
  
 Create Function Plan for Windows Create Function Plan for Windows
-<code>+ 
 +<code ->
 az functionapp plan create \ az functionapp plan create \
   --resource-group don-test-rg \   --resource-group don-test-rg \
-  --name donfuncplan \+  --name dehamerfuncplan \
   --location eastus \   --location eastus \
   --sku B1 \   --sku B1 \
Line 52: Line 68:
  
 Create Function App Create Function App
-<code>+ 
 +<code ->
 az functionapp create \ az functionapp create \
   --resource-group don-test-rg \   --resource-group don-test-rg \
   --name dehamerfuncapp \   --name dehamerfuncapp \
-  --plan donfuncplan \+  --plan dehamerfuncplan \
   --storage-account dehamerfunctstorage \   --storage-account dehamerfunctstorage \
   --runtime dotnet-isolated \   --runtime dotnet-isolated \
Line 64: Line 81:
  
 Create TexAnalytics Create TexAnalytics
-<code>+ 
 +<code ->
 az cognitiveservices account create \ az cognitiveservices account create \
   --name dehamersentimentai \   --name dehamersentimentai \
Line 74: Line 92:
  
 az cognitiveservices account update \ az cognitiveservices account update \
-  --name donsentimentai \+  --name dehamersentimentai \
   --resource-group don-test-rg \   --resource-group don-test-rg \
   --set properties.publicNetworkAccess=Enabled   --set properties.publicNetworkAccess=Enabled
Line 80: Line 98:
  
 Get keys and endpoint for export and app settings Get keys and endpoint for export and app settings
-<code>+ 
 +<code ->
 export TEXT_ANALYTICS_ENDPOINT=`az cognitiveservices account show \  export TEXT_ANALYTICS_ENDPOINT=`az cognitiveservices account show \ 
   --name dehamersentimentai \   --name dehamersentimentai \
Line 87: Line 106:
  
 export TEXT_ANALYTICS_KEY=`az cognitiveservices account keys list \ export TEXT_ANALYTICS_KEY=`az cognitiveservices account keys list \
-  --name dehamersentimentai \+  --name dehamersentamentai \
   --resource-group don-test-rg \   --resource-group don-test-rg \
   --query "key1" -o tsv`   --query "key1" -o tsv`
Line 104: Line 123:
  
 export OPENAI_ENDPOINT=https://don-openai-useast.openai.azure.com/ export OPENAI_ENDPOINT=https://don-openai-useast.openai.azure.com/
 +
 +export OPENAI_DEPLOYMENT=gpt-4.1
  
 az functionapp config appsettings set \ az functionapp config appsettings set \
-  --name donfuncapp \+  --name dehamerfuncapp \
   --resource-group don-test-rg \   --resource-group don-test-rg \
   --settings \   --settings \
   OPENAI_KEY=$OPENAI_KEY \   OPENAI_KEY=$OPENAI_KEY \
   OPENAI_ENDPOINT=$OPENAI_ENDPOINT   OPENAI_ENDPOINT=$OPENAI_ENDPOINT
 +  OPENAI_DEPLOYMENT=$OPENAI_DEPLOYMENT
      
 #Confirm they were set #Confirm they were set
Line 120: Line 142:
  
 Create a directory to store the functionapp files Create a directory to store the functionapp files
-<code>+ 
 +<code ->
 mkdir ~/FeedbackFunctionDotNet mkdir ~/FeedbackFunctionDotNet
 cd ~/FeedbackFunctionDotNet cd ~/FeedbackFunctionDotNet
Line 179: Line 202:
  
         // OpenAI Setup         // OpenAI Setup
-        var openaiEndpoint = Environment.GetEnvironmentVariable("OPENAI_API_ENDPOINT")?.TrimEnd('/'); +        var openaiEndpoint = Environment.GetEnvironmentVariable("OPENAI_ENDPOINT")?.TrimEnd('/'); 
-        var openaiKey = Environment.GetEnvironmentVariable("OPENAI_API_KEY");+        var openaiKey = Environment.GetEnvironmentVariable("OPENAI_KEY");
         var deployment = Environment.GetEnvironmentVariable("OPENAI_DEPLOYMENT");         var deployment = Environment.GetEnvironmentVariable("OPENAI_DEPLOYMENT");
  
Line 265: Line 288:
  
 Make sure this matches the version of dotnet 8.x you install. Make sure this matches the version of dotnet 8.x you install.
 +
 <code - global.json> <code - global.json>
 { {
Line 301: Line 325:
  
 From the FeedbackFunctionDonnet directory: From the FeedbackFunctionDonnet directory:
-<code>+ 
 +<code ->
 dotnet clean dotnet clean
 dotnet publish -c Release -o publish dotnet publish -c Release -o publish
Line 311: Line 336:
  
 After running you will see additional files in the FeedbackFunctionDotnet directory.  This is normal. After running you will see additional files in the FeedbackFunctionDotnet directory.  This is normal.
-<code>+ 
 +<code ->
 ls ls
 bin                     FeedbackFunction.csproj host.json               obj                     publish bin                     FeedbackFunction.csproj host.json               obj                     publish
Line 318: Line 344:
  
 To test if it is working To test if it is working
-<code>+ 
 +<code ->
 export FUNCTION_KEY=`az functionapp function keys list \ export FUNCTION_KEY=`az functionapp function keys list \
   --name dehamerfuncapp \   --name dehamerfuncapp \
Line 331: Line 358:
  
 You should see something like: You should see something like:
-<code>+ 
 +<code ->
 {"sentiment":"negative","message":"Oh, absolutely\u2014because we totally specialize in time travel, right? Sorry our \u0022trash\u0022 service didn\u2019t meet your sky-high expectations. Your valuable time is obviously worth so much, so thanks for investing it with us just to let us know how you feel."}% {"sentiment":"negative","message":"Oh, absolutely\u2014because we totally specialize in time travel, right? Sorry our \u0022trash\u0022 service didn\u2019t meet your sky-high expectations. Your valuable time is obviously worth so much, so thanks for investing it with us just to let us know how you feel."}%
 </code> </code>
  
 Confirmation tests Confirmation tests
-<code>+ 
 +<code ->
 az functionapp function list --name dehamerfuncapp --resource-group don-test-rg --query "[].{name:name, status:invokeUrlTemplate}" -o table az functionapp function list --name dehamerfuncapp --resource-group don-test-rg --query "[].{name:name, status:invokeUrlTemplate}" -o table
 Name                                    Status Name                                    Status
Line 343: Line 372:
 </code> </code>
  
-<code>+<code ->
 az functionapp show --name dehamerfuncapp --resource-group don-test-rg --query "enabledHostNames" az functionapp show --name dehamerfuncapp --resource-group don-test-rg --query "enabledHostNames"
 [ [
Line 351: Line 380:
 </code> </code>
  
-<code>+<code ->
 az functionapp function list \ az functionapp function list \
   --name dehamerfuncapp \   --name dehamerfuncapp \
Line 361: Line 390:
 </code> </code>
  
-<code>+<code ->
 az functionapp function show \ az functionapp function show \
   --name dehamerfuncapp \   --name dehamerfuncapp \
Line 372: Line 401:
  
 If true If true
-<code>+ 
 +<code ->
 az functionapp function update \ az functionapp function update \
   --name dehamerfuncapp \   --name dehamerfuncapp \
Line 381: Line 411:
  
 Tailing logs if enabled.  Notice it says webapp, not functionapp.  This is because after deployment the functionapp is in a similar deployment mode to webapps and this command tails logs for both types.  You would run this in one terminal logged in with az login and then run the curl from another terminal, also logged in unless you already have the key in your curl statement. Tailing logs if enabled.  Notice it says webapp, not functionapp.  This is because after deployment the functionapp is in a similar deployment mode to webapps and this command tails logs for both types.  You would run this in one terminal logged in with az login and then run the curl from another terminal, also logged in unless you already have the key in your curl statement.
-<code>+ 
 +<code ->
 az webapp log tail \ az webapp log tail \
   --name dehamerfuncapp \   --name dehamerfuncapp \
Line 388: Line 419:
  
 If you want it to autostart after issues. If you want it to autostart after issues.
-<code>+ 
 +<code ->
 #Optional #Optional
 az webapp config set \ az webapp config set \
Line 397: Line 429:
  
 Get a list of your functionapps Get a list of your functionapps
-<code>+ 
 +<code ->
 az functionapp function list \ az functionapp function list \
   --name dehamerfuncapp \   --name dehamerfuncapp \
Line 407: Line 440:
 https://dehamerfuncapp.azurewebsites.net/admin/functions/DeHamerFeedbackFunction  https://dehamerfuncapp.azurewebsites.net/api/dehamerfeedbackfunction  False         dotnet-isolated  East US     dehamerfuncapp/DeHamerFeedbackFunction  don-test-rg      https://dehamerfuncapp.azurewebsites.net/admin/vfs/site/wwwroot/FeedbackFunction.dll              https://dehamerfuncapp.azurewebsites.net/admin/vfs/data/Functions/sampledata/DeHamerFeedbackFunction.dat https://dehamerfuncapp.azurewebsites.net/admin/functions/DeHamerFeedbackFunction  https://dehamerfuncapp.azurewebsites.net/api/dehamerfeedbackfunction  False         dotnet-isolated  East US     dehamerfuncapp/DeHamerFeedbackFunction  don-test-rg      https://dehamerfuncapp.azurewebsites.net/admin/vfs/site/wwwroot/FeedbackFunction.dll              https://dehamerfuncapp.azurewebsites.net/admin/vfs/data/Functions/sampledata/DeHamerFeedbackFunction.dat
 </code> </code>
 +
 +Only do this for testing.  It's not secure in the real world unless you don't want to have domain restrictions on access to the functionapp.  I had to do it so I could test from my home webserver.
 +
 +<code ->
 +az functionapp cors add \
 +  --name dehamerfuncapp \
 +  --resource-group don-test-rg \
 +  --allowed-origins "*"
 +</code>
 +
 +If you have a webserver that you trust, you can create this webpage and test it:
 +
 +<code - index.html>
 +<!DOCTYPE html>
 +<html lang="en">
 +<head>
 +  <meta charset="UTF-8" />
 +  <title>Dennis Feedback Page</title>
 +  <style>
 +    body {
 +      background-color: white;
 +      color: red;
 +      font-family: Arial, sans-serif;
 +      margin: 40px;
 +    }
 +
 +    header {
 +      display: flex;
 +      align-items: center;
 +      margin-bottom: 40px;
 +    }
 +
 +    header img {
 +      height: 50px;
 +      margin-right: 20px;
 +    }
 +
 +    h1 {
 +      font-size: 2em;
 +    }
 +
 +    textarea {
 +      width: 100%;
 +      height: 100px;
 +      font-size: 1em;
 +      padding: 10px;
 +    }
 +
 +    button {
 +      margin-top: 10px;
 +      padding: 10px 20px;
 +      font-size: 1em;
 +      background-color: red;
 +      color: white;
 +      border: none;
 +      cursor: pointer;
 +    }
 +
 +    #response {
 +      margin-top: 20px;
 +      font-weight: bold;
 +      white-space: pre-line;
 +    }
 +  </style>
 +</head>
 +<body>
 +  <header>
 +    <img src="https://webobjects2.cdw.com/is/image/CDW/cdw23-logo-no-tag-88x48?$transparent$" alt="CDW Logo" />
 +    <h1>Dennis Feedback Page</h1>
 +  </header>
 +
 +  <form id="feedbackForm">
 +    <label for="feedback">Enter your feedback:</label><br>
 +    <textarea id="feedback" name="feedback" required></textarea><br>
 +    <button type="submit">Submit</button>
 +  </form>
 +
 +  <div id="response"></div>
 +
 +  <script>
 +    document.getElementById('feedbackForm').addEventListener('submit', async function (e) {
 +      e.preventDefault();
 +
 +      const feedback = document.getElementById('feedback').value;
 +      const responseDiv = document.getElementById('response');
 +
 +      responseDiv.textContent = "Processing...";
 +
 +      try {
 +        const res = await fetch('https://dehamerfuncapp.azurewebsites.net/api/dehamerfeedbackfunction', {
 +          method: 'POST',
 +          headers: {
 +            'Content-Type': 'application/json'
 +          },
 +          body: JSON.stringify({ feedback })
 +        });
 +
 +        if (!res.ok) {
 +          throw new Error("API error: " + res.status);
 +        }
 +
 +        const data = await res.json();
 +        responseDiv.innerHTML = `<strong>Sentiment:</strong> ${data.sentiment}<br><strong>Response:</strong> ${data.message}`;
 +      } catch (err) {
 +        responseDiv.textContent = "Error: " + err.message;
 +      }
 +    });
 +  </script>
 +</body>
 +</html>
 +</code>
 +
 +===== Dennis Additions =====
 +
 +==== Azure CLI vs Azure Portal Instructions ====
 +
 +| Task | Azure CLI Command | Azure Portal Steps |
 +| Create Resource Group | az group create --name don-test-rg --location eastus | Go to Azure Portal > Resource Groups > Create |
 +| Create Storage Account | az storage account create --name dehamerfuncstorage --location eastus --resource-group don-test-rg --sku Standard_LRS | Go to Storage Accounts > Create |
 +| Create Function App | az functionapp create --resource-group don-test-rg --consumption-plan-location eastus --runtime dotnet-isolated --functions-version 4 --name dehamerfuncapp --storage-account dehamerfuncstorage | Go to Function Apps > Create > Choose .NET Isolated |
 +| Deploy Code via Zip | az functionapp deployment source config-zip --src publish.zip --name dehamerfuncapp --resource-group don-test-rg | Go to Function App > Deployment Center > Zip Deploy |
 +| Create Cognitive Services Resource | az cognitiveservices account create --name dehamersentimentai --resource-group don-test-rg --kind TextAnalytics --sku S --location eastus --yes | Search 'Cognitive Services' > Create > Choose Text Analytics |
 +| Set App Settings | az functionapp config appsettings set --name dehamerfuncapp --resource-group don-test-rg --settings KEY=value | Go to Configuration > Application Settings > Add New |
 +
 +==== Successful Deployment Steps ====
 +
 +After resolving early build issues and switching from Linux to a Windows-hosted function plan due to SDK compatibility, the deployment succeeded with the following workflow:
 +
 +- Rewrote the function class to eliminate naming conflicts\\ - Set AuthorizationLevel to Anonymous to permit open feedback submission\\ - Used curl to verify responses from the deployed function\\ - Created an HTML frontend to POST feedback to the function endpoint
 +
 +==== Architectural Diagram ====
 +
 +{{:wiki:ai:chatgpt_image_jun_24_2025_05_00_18_pm.png}}\\ \\
 +
 +[[ai_knowledge|AI Knowledge]]
 +
  
wiki/ai/chatbot-helpdesk-sentiment.1750797314.txt.gz · Last modified: by ddehamer

Page Tools

Trace:
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) IP:10.0.136.41