bcombs18 / osticket-inventory-manager Goto Github PK

The database should have a function that allows osTicket to flush out Inventory tables in the database

Describe the bug
I have successfully installed version 1.1.5 by following the installation steps.
Once the plugin is activated, inside the agent panel, in Applications, the Inventory Manager drop-down appears and when I click on it, it takes me to the URL "/scp/dispatcher.php/inventory/asset/handle" and it gives me a 404 response, telling me it can't find the file.

I have tried to install other versions of the plugin, but the same thing happens to me.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Applications in Agent panel'
2. Click on 'Inventory Manager'
3. See error 404 at url /scp/dispatcher.php/inventory/asset/handle

Expected behavior
View plugin Dashboard

Additional context
OsTicket 1.16.1
PHP: 8.0

Add a new feature to allow users to generate reports on assets. Should be implemented similar to queues in the ticketing system

The header row is being imported as an asset. Additionally, the importer is not checking headers against form fields.

The dispatcher needs to be re-worked so all requests are not processed through the import controller

When exporting assets from Inventory Tracker I'm getting a 400 (Bad Request). Please provide insight on how to fix this.

The scp.js and dispatcher.php files should automatically be added to their respective locations using shell commands to simplify the installation process for the user. Must support Windows and Linux environments.

This will break the plugin if the user has changed the root of the URL for their instance of osTicket

Describe the bug
I have SSL installed on my Server and a custom domain pointing to my OS ticket instance.

eg. https://support.mydomain.com

I completed the setup but I cannot create assets.

When testing API via curl using the server IP address I get "301 Moved Permanently" as an error.

When testing API via the custom hostname I get "Valid API key required"

In the API section of the app I can create the API and enable "Can Create Assets" I get a message "Successfully updated this API key" on save but the tick box for Can create assets is empty.

Screenshots

I want to try this plug in but it seems that I get this error

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'A1.host_name' in 'order clause' in /home/support/upload/include/mysqli.php:189 Stack trace: #0 /home/support/upload/include/mysqli.php(189): mysqli->query() #1 /home/support/upload/include/class.orm.php(3470): db_query() #2 /home/support/upload/include/class.orm.php(3517): MySqlExecutor->execute() #3 /home/support/upload/include/class.orm.php(2097): MySqlExecutor->getArray() #4 /home/support/upload/include/class.orm.php(2047): HashArrayIterator->{closure}() #5 /home/support/upload/include/class.orm.php(2026): CallbackSimpleIterator->next() #6 /home/support/upload/include/class.orm.php(2035): CallbackSimpleIterator->rewind() #7 /home/support/upload/include/class.orm.php(1706): CallbackSimpleIterator->valid() #8 /home/support/upload/include/class.orm.php(1741): CachedResultSet->fillTo() #9 /home/support/upload/include/class.orm.php(1602): CachedResultSet->offsetGet() #10 /home/support/upload/include/class.orm.php(1458): QuerySet->offsetGet() #11 /home/support/upload/include/plugins/osTicket-Inventory-Manager-1.0.1/views/queue-assets.tmpl.php(212): QuerySet->exists() #12 /home/support/upload/include/plugins/osTicket-Inventory-Manager-1.0.1/include/model/assets.php(242): require('...') #13 /home/support/upload/include/plugins/osTicket-Inventory-Manager-1.0.1/include/controller/Asset.php(190): require_once('...') #14 /home/support/upload/include/class.dispatcher.php(145): controller\Asset->handle() #15 /home/support/upload/include/class.dispatcher.php(38): UrlMatcher->dispatch() #16 /home/support/upload/include/class.dispatcher.php(120): Dispatcher->resolve() #17 /home/support/upload/include/class.dispatcher.php(38): UrlMatcher->dispatch() #18 /home/support/upload/scp/dispatcher.php(45): Dispatcher->resolve() #19 {main} thrown in /home/support/upload/include/mysqli.php on line 189

and some part of the personal queue are displayed in the page

osticket 1.16.3
php 8.1
ubuntu 20.4

The Inventory Form uses ID 'G' to make it visible in the Custom Forms menu. This causes an issue when a second custom form already exists or is created since 'G' is reserved for all custom forms, not just the Inventory Form.

ID should be changed to 'I' and a settings menu should be created to provide access to the form for customization.

The Search bar should be searching on all data fields. Not just assignee names.

Investigating the possibility of linking assets to tickets, potentially through the assigned user.

Assets should have a viewable history of changes made to them.

This can be in the form of Notes

Asset locations should be tied to a user-customizable list storing each location and should be accessible in the form of a drop down

Assets which have been removed from circulation should be able to be marked as such and removed from the active listing to a "retired assets" table.

The user would like to be able to create views with custom columns similar to ticket queues

The main inventory form needs a rework. Should only have a few required/pre-installed fields. The rest should be up to the user to set up.

Assigning a user results in a failed AJAX call and infinite loading screen.

Data should be fully indexed. This should help resolve issues with the search engine and exporter

Hi I'm using osTicket v1.16.2 and php 8.0.0, i followed your steps to install the plugin but I am stuck on the step of creating the api key as the table and settings aren't showing up in application>inventory manager

Importer currently does not check for pre-existing copies of an asset before inserting into the database. Serial Numbers should be checked before executing insert.

URLs should be utilizing global variables so they are easy to update in the future

This included a revision to the current search feature and the addition of an advanced search feature.

The install script should add a blank cdata table to prevent issues with it being unavailable when loading the plugin.

Add an API call to enable remote asset creation for use in deployment processes.

[ ] - Add API
[ ] - Add installer for API
[ ] - Add uninstaller for API

Hi

I followed the installation instructions but receive a HTTP ERROR 500 when accessing the Inventory Manager from the Agent Panel.
Is there any additional steps I perhaps missed?

My installation details are in the attached file.

Regards

• The exporter will export core data fields, but fails to export any custom form fields