We have created a custom OpenAI GPT tool that is a Spire expert. This tool is freely available to anyone on the OpenAI website. You will need to log into ChatGPT with either a free or paid account to use it. OpenAI currently limits free accounts on all GPT’s to 10 questions per 5 hours.
While the normal GPT is fairly good at answering Spire questions, SpireAssistsGPT has considerable advantages:
- It has only been given specific Spire resources and told to use them before anything else. It even once told me “I don’t know”!
- These Spire resources have been ingested and indexed into a custom RAG search engine for much better retrieval and less hallucination.
- It has been given information that is public domain, but not readily accessible on the internet, such as Crystal report details, multi-version Spire Postgres database schemas, and full transcripts of every official Spire video on YouTube.
- Web search has been disabled.
Resources
The SpireAssistsGPT has access to an indexed version of the following public web resources. When possible, direct links to specific topic URL in the web source are provided (or can be requested).
- Spire User Manual 3.13 Spire Manual 3.13
- Spire API Documentation: Spire API Documentation
- Spire Public Knowledge Base: Spire Knowledge Base
In addition, the following resources were scraped:
Spire Crystal Reports
The Spire 3.13 Crystal Reports were scraped for the following information:
- All SQL queries on the main report and sub-reports
- Report metadata: keywords, comments, templates
- All SQL expressions
- Every report “changelog”: What changed in each report in each version.
This information is not just helpful for writing Crystal Reports. The GPT is able to understand the relationships between Spire tables in the context of specific business areas such as orders, invoices, or purchase orders.
Spire PostgreSQL Database
The Spire 3.13, 3.12, 3.11 and 3.10 PostgreSQL databases were scraped for:
- All public tables and v3 views: field names, data types, comments, indexes
- All functions specific to returning data from spire such as: ap_aged_list and format_phone_number.
- Sample data from the first few rows of each table (INSPIRE)
One use of this resource is to give the ability to answer questions about version differences.
Spire YouTube videos
All Spire YouTube videos have had the dialog scraped into text. This uses the built in subtitles when present or Whisper AI voice recognition when not. Each video transcript has the title, the date modified and the description. The GPT has been instructed to prioritize info from the most recent video. All dialog elements are time-stamped with the intention of allowing the GPT to link you to a relevant portion of the video to the nearest minute. If it doesn’t comply just ask it for a link to the relevant section of the video.
Conclusion & Links
SpireAssists is committed to providing useful tools and resources to Spire users, Partners and Integration Providers. We are very excited about the potential of these new technologies, and we are learning to make them better all the time. This is lots of fine tuning or additional resources that could made these tools better. We very much appreciate feedback on your experiences with SpireAssistsGPT.
You can access SpireAssists right from your logged-in OpenAI ChatGPT account. Look for Explore GPTs and search for Spire.
Or you can use this direct link: SpireAssistsGPT
How it Works & Privacy Policy
The OpenAI web site accepts and processes your prompts. If it needs to, it makes calls to SpireAssists as an external resource to look-up information about Spire in a database we created. OpenAI will take your long complex question and could make multiple short searches of 3 or 4 words such as : “crystal invoice form” , “postgres customer table” “changes version 3.11”. These words are what SpireAssistsGPT receives. Anything returned from SpireAssistsGPT to Open AI comes only from official, verifiable publicly available information. We do not construct the final response you get from OpenAI.
This external resource does NOT:
- see your full prompt.
- see what OpenAI returned to you in the answer other than the data our search gave back to it.
- see any information about the user whatsoever including their IP address etc.
- have the ability to know two searches came from the same source.
- persist any logs not required for the service to function.
The first time you make a request to SpireAssists GPT you will see a confirmation request:
If you click Allow, the text after “query:” will be sent to the SpireAssists search engine. You can continue clicking Allow for each request to confirm what information is being set anonymously to SpireAssists. To avoid this confirmation in the future, you can click Always Allow.
Even after clicking Allow All, at any point you can ask SpireAssistsGPT: “What data did you just send to SpireAssists?”
The behavior of SpireAssistsGPT is governed by a privacy policy:
https://spireassists.com/downloads/SpireAssistsGPTPrivacyPolicy.txt