osticket mass ticket update - new function development
$250-750 USD
货到付款
This customisation is required for osticket v1.9.x
We want a new feature to be able to import a CSV spreadsheet file, and do batch message update, and/or closing of any tickets in osticket. Currently, any ticket updates can only be made manually, one by one through online form.
we initially expect our .csv to contain a list of the below fields:
1. ticket number
2. ticket status
3. post reply message
4. post internal note title
5. post internal note message
(1) ticket number will identify the ticket to be updated
(2), (3), (4), (5) are the data fields to be mass updated according to the CSV file.
We expect:
~~~~~~~~~~~~~~~~
- best if this customisation is implemented as an osticket plug-in. if this is not possible, we can also accept changes to core files.
- maybe a new section of form, or a new form will be provided after SCP staff/agent login, for us to select the .CSV file and do the CSV file import.
- we expect the .csv file to be first saved into a new database table, we call it a "ticket interface". And then a new, separate process shall start to update each of the listed tickets at the backend, and provide a success/failure status with error codes if any after the whole .csv file is fully processed. All the update status and error codes should be written back to the new database table as log.
- this customisation shall check if the ticket number in the CSV is within access authority by the logged-in staff/agent. If the logged-in staff doesn't have authority to access tickets (decided by "Agent Groups" in OST), of course that should be rejected and this ticket update shall fail with an error.
- a simple report listing all ticket update status shall pop-up on screen once the whole upload and import process finishes.
- "ticket interface" database table may contain the below columns:
01. ticket number
02. ticket status
03. post reply message
04. post internal note title
05. post internal note message
06. creation date
07. created by (osticket agent)
08. last updated date
09. last updated by (osticket agent)
10. import result (success/failure)
11. import error
项目ID： #21774481
关于项目
有18名威客正在参与此工作的竞标，均价$515/小时
This wont be a plugin. It will be a stand alone script for mass update via csv file. I need ftp and cpanel access for the code and database access for it. I dont know why you need sep table named "ticket interface" for 更多
Glad to meet you. I have checked your project description and requirements carefully. --OSticket Expert(customizing, plugin developement, many experiences)-- I am a senior web developer has 8+ years of good experience. 更多
$$$$$- Good Lucky!-$$$$$ Expert Here!!!!! I am very interested to your project and ready to start right now. I have read your project requirement carefully. I have many experience in Laravel PHP, Angular and React, Rea 更多
Hi, This is Vipin, an alumnus of IIT Kanpur. I have 6+ years of experience in customized software, web and mobile app development and has expertise in Android, iOS, Python, Magento, PHP, HTML, Java, Angular and Ioni 更多
