osticket mass ticket update - new function development

Ukončen Zveřejněno před 4 lety K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

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

PHP MySQL

Identifikační číslo projektu: #21774481

O projektu

18 nabídek Projekt na dálku Aktivní před 4 lety

18 Freelnceři na tento projekt zveřejňují nabídky v průměru $515

coolguyinus2004

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 Další

$400 USD za 3 dní
(348 Recenzí)
7.6
talhamq

I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server 20 Další

$250 USD za 1 den
(133 Recenzí)
5.8
bluebear1888

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. Další

$500 USD za 7 dní
(29 Recenzí)
5.3
pujaroy22

Hello We are a team of experts, we can design any web page and make it functional with any back end technology whether it is php, laravel, ci or wordpress. We are having some fine developers for CMS and server side scr Další

$500 USD za 7 dní
(13 Recenzí)
4.6
KonstanBer

$$$$$- 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 Další

$500 USD za 7 dní
(9 Recenzí)
4.6
tutulsoft

---- OSTICKET & CSV Importer EXPERT ---------------- i read details of your requirements ---------- i can fulfill your requirements as per my experiences ------------you can chat with me for details ------------ 17 ye Další

$670 USD za 7 dní
(5 Recenzí)
4.6
athminteam

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 Další

$500 USD za 7 dní
(4 Recenzí)
2.5
AITSoft

Hello there, How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills MySQL, PHP. Right now I am placing a place holder bid, We will decide the price and ti Další

$555 USD za 6 dní
(2 Recenzí)
1.6