search

snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
10.85k stars 3.14k forks source link

Csv Export Asset #10368

Open mich-de opened 2 years ago

mich-de commented 2 years ago

Debug mode

Describe the bug

Good day

When exporting CSV from Assets, it shows href links in the export file. It should be all text, without links

Thank you

Reproduction steps

1.All Assets 2.select assets 3.export assets to csv ...

Expected behavior

It should be all text, without links

Screenshots

ID,Asset Name,Device Image,Asset Tag,Serial,Model,Category,Status,Checked Out To,Location,Manufacturer,Supplier,Purchase Cost,Notes,Operative system,Mac address,IP address,Licence number,OS version,Firmware version,Hardware version,Software release,Fire zone (FZ),Mobility controller,TID DOLLAR,TID EURO,Assembly Station,Manning Number,Phone Number,IMEI,Last Support,MMS Codes,Checkin/Checkout,Actions 672, OP-PHOTOCOPY-01,"<img src=""https://mywebsite.com/uploads/models/assetmodel-ypAmZ1nK2erjptIMwF.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-01"">", OP-PHOTOCOPY-01, A5C2021034820,"<a href=""https://mywebsite.com/models/483""> Bizhub C284e","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/15"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Partially Damaged <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/201""> Konica Minolta",,,"print both side, paper stuck only on budge paper tray 2 stuck if page is vertical",,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/672/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/672/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 673, OP-PHOTOCOPY-02,"<img src=""https://mywebsite.com/uploads/models/assetmodel-gUXY9J3KkYdRS9qFJm.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-02"">", OP-PHOTOCOPY-02, A7PY021033835,"<a href=""https://mywebsite.com/models/494""> Bizuhub C308","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/15"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Partially Damaged <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/201""> Konica Minolta",,,"print both side, paper stuck only on budge paper tray 2 stuck if page is vertical",,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/673/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/673/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 674, OP-PHOTOCOPY-03,"<img src=""https://mywebsite.com/uploads/models/assetmodel-ItQa3lq8BxEU301g6y.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-03"">", OP-PHOTOCOPY-03, AOPN021001411,"<a href=""https://mywebsite.com/models/551""> Bizhub 754e","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/12"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Broken <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/201""> Konica Minolta",,,,,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/674/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/674/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 675, OP-PHOTOCOPY-04,"<img src=""https://mywebsite.com/uploads/models/assetmodel-NCG9Rp2JfoHcgWRWa8.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-04"">", OP-PHOTOCOPY-04, AOXY025111632,"<a href=""https://mywebsite.com/models/552""> Bizhub 185","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/18"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Healty <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/26"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> BRIDGE", BRIDGE,"<a href=""https://mywebsite.com/manufacturers/201""> Konica Minolta",,,,,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/675/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/675/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 676, OP-PHOTOCOPY-05,"<img src=""https://mywebsite.com/uploads/models/assetmodel-kEcK24i0DsbTPq8lVX.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-05"">", OP-PHOTOCOPY-05,2134767,"<a href=""https://mywebsite.com/models/487""> Bizhub 163","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/15"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Partially Damaged <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/100"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> ECR", ECR,"<a href=""https://mywebsite.com/manufacturers/201""> Konica Minolta",,,"Line on copy, replace the fusing unit",,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/676/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/676/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 677, OP-PHOTOCOPY-06,"<img src=""https://mywebsite.com/uploads/models/assetmodel-zCFJELwkN1xJmaWiD3.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-06"">", OP-PHOTOCOPY-06, A795021003924,"<a href=""https://mywebsite.com/models/486""> Bizhub 758","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/18"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Healty <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/201""> Konica Minolta",,,,,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/677/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/677/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 678, OP-PHOTOCOPY-07,"<img src=""https://mywebsite.com/uploads/models/assetmodel-xP8eCI065T6YaRWkag.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-07"">", OP-PHOTOCOPY-07,79673221,"<a href=""https://mywebsite.com/models/491""> Riso EZ 370 E","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/12"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Broken <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/202""> Riso",,,Light on 3 - Error A-05 - master blocked on left side,,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/678/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/678/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 679, OP-PHOTOCOPY-08,"<img src=""https://mywebsite.com/uploads/models/assetmodel-cBdzx8XAx2GCZehWRY.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-08"">", OP-PHOTOCOPY-08,76610883,"<a href=""https://mywebsite.com/models/490""> Riso EZ 371 E","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/18"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Healty <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/202""> Riso",,,,,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/679/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/679/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 680, OP-PHOTOCOPY-09,"<img src=""https://mywebsite.com/uploads/models/assetmodel-cBdzx8XAx2GCZehWRY.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-09"">", OP-PHOTOCOPY-09,76612124,"<a href=""https://mywebsite.com/models/490""> Riso EZ 371 E","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/18"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Healty <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/202""> Riso",,,,,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/680/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/680/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 681, OP-PHOTOCOPY-10,"<img src=""https://mywebsite.com/uploads/models/assetmodel-xP8eCI065T6YaRWkag.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-10"">", OP-PHOTOCOPY-10,76611546,"<a href=""https://mywebsite.com/models/491""> Riso EZ 370 E","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/12"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Broken <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/202""> Riso",,,LIGHT ON 6 - Error J08 - controllare tamburo,,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/681/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/681/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " 682, OP-PHOTOCOPY-11,"<img src=""https://mywebsite.com/uploads/models/assetmodel-4OJIGXM7WxDTQdxEhI.jpg"" style=""max-height: 50px; width: auto;"" class=""img-responsive"" alt=""OP-PHOTOCOPY-11"">", OP-PHOTOCOPY-11,42311944,"<a href=""https://mywebsite.com/models/495""> Riso SF 5350","<a href=""https://mywebsite.com/categories/198""> Printer","<a href=""https://mywebsite.com/statuslabels/18"" data-toggle=""tooltip"" title=""deployed""> <i class=""fa fa-circle text-blue""> Healty <label class=""label label-default"">Deployed ","<a href=""https://mywebsite.com/locations/32"" data-tooltip=""true"" title=""location""><i class=""fa fa-map-marker text-blue ""> PRINTSHOP", PRINTSHOP,"<a href=""https://mywebsite.com/manufacturers/202""> Riso",,,,,,,,,,,,,,,,,,,,,,Checkin,"<a href=""https://mywebsite.com/hardware/682/clone"" class=""btn btn-sm btn-info"" data-tooltip=""true"" title=""Clone Item""><i class=""fa fa-copy"" aria-hidden=""true""><span class=""sr-only"">Clone <a href=""https://mywebsite.com/hardware/682/edit"" class=""btn btn-sm btn-warning"" data-tooltip=""true"" title=""Update""><i class=""fa fa-pencil"" aria-hidden=""true""><span class=""sr-only"">Update <a class=""btn btn-danger btn-sm delete-asset disabled"" onclick=""return false;""><i class=""fa fa-trash""> " ,,,,,,,,,,,,0,,,,,,,,,,,,,,,,,,,,,

Snipe-IT Version

Version v5.3.2 - build 6508

Operating System

Windows Server 2016

Web Server

IIS

PHP Version

PHP Version 7.4.26

Operating System

Windows

Browser

Firefox

Version

94.0.2

Device

No response

Operating System

No response

Browser

No response

Version

No response

Error messages

No response

Additional context

No response

welcome[bot] commented 2 years ago

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

veljkostanar commented 2 years ago

I am also having this issue i click export and get fields like Model "<a href="http://assets.curric.cwsc.vic.edu.au/models/1"">Latatude 3350 it should just say Latatude 3350

veljkostanar commented 2 years ago

Just an update this issue only seems to impact export via CSV if you choose export Via "ms-Excel" you don't have the issue but you do have annoying duplication of images if you have any images in againts the asset