{"issues":[{"id":37180,"summary":"dsng\uc7a5\uc560","description":"ee","steps_to_reproduce":"ee","additional_information":"ee","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":98847,"name":"Kang Byeong Goo"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2026-05-24T03:46:40-04:00","updated_at":"2026-05-24T03:46:40-04:00"},{"id":36833,"summary":"Last survival - check 50lv m\u1edbi","description":"l\u1ed7i nh\u1eadn th\u01b0\u1edfng khi thua","steps_to_reproduce":"1. m\u1edf game\r\n2. ch\u01a1i thua sau khi b\u1ecb qu\u00e1i gi\u1ebft\r\n3. \u1ea5n v\u00e0o button reward","additional_information":"lv n\u00e0o c\u0169ng b\u1ecb","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":98042,"name":"jotum123"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2026-01-21T22:39:47-05:00","updated_at":"2026-02-10T14:39:58-05:00","attachments":[{"id":13866,"reporter":{"id":98042,"name":"jotum123"},"created_at":"2026-01-21T22:39:47-05:00","filename":"460521429_8323928487673805_3817241589369625496_n.jpg","size":338972,"content_type":"image\/jpeg; charset=binary"}]},{"id":36672,"summary":"abssaas","description":"aassas","steps_to_reproduce":"assaas","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":96848,"name":"satej.sawant"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":40,"name":"high","label":"high"},"severity":{"id":40,"name":"tweak","label":"tweak"},"reproducibility":{"id":30,"name":"sometimes","label":"sometimes"},"sticky":false,"created_at":"2025-11-09T06:08:07-05:00","updated_at":"2025-11-09T06:08:07-05:00"},{"id":35751,"summary":"The csv-import plugin is looking for a new maintainer","description":"Please post here or send a message to https:\/\/matrix.to\/#\/#mantisbt_mantisbt:gitter.im if you're interested in taking over.","additional_information":"https:\/\/github.com\/mantisbt-plugins\/csv-import","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":17784,"name":"dregad"},"status":{"id":30,"name":"acknowledged","label":"acknowledged","color":"#ffcd85"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":100,"name":"N\/A","label":"N\/A"},"sticky":true,"created_at":"2025-04-09T09:46:35-04:00","updated_at":"2025-10-30T00:28:11-04:00","notes":[{"id":70560,"reporter":{"id":96443,"name":"pleasejusttest"},"text":"dasdasd","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2025-10-14T01:12:42-04:00","updated_at":"2025-10-14T01:12:42-04:00"}]},{"id":34070,"summary":"Hide Import Issue Tab to users that is not allowed to Import Issues","description":"In our Mantis installation, the user with the Manager access level is not authorized to import issues, but the Import Issues tab is visible on the Manage page. Is there a way to hide this Tab from users with the Manager Access level? An error message is displayed when the Manager tries to access the Import Issue Tab. However, it is better if the Tab is only visible to the user authorized to use it, as they did in the Manage Plugin and Manage Custom Field Tab. ","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":76468,"name":"v.ocampo"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2024-03-14T04:33:15-04:00","updated_at":"2024-03-15T00:19:18-04:00","attachments":[{"id":12499,"reporter":{"id":76468,"name":"v.ocampo"},"created_at":"2024-03-14T04:33:15-04:00","filename":"Import Issue Tab.jpg","size":33580,"content_type":"image\/jpeg; charset=binary"},{"id":12500,"reporter":{"id":76468,"name":"v.ocampo"},"created_at":"2024-03-14T04:33:15-04:00","filename":"Import Issues Error Message.jpg","size":11183,"content_type":"image\/jpeg; charset=binary"}],"notes":[{"id":68661,"reporter":{"id":79739,"name":"admin_quy"},"text":"ewer","view_state":{"id":10,"name":"public","label":"public"},"attachments":[{"id":12523,"reporter":{"id":79739,"name":"admin_quy"},"created_at":"2024-03-15T00:19:18-04:00","filename":"\u1ea3nh 4.jpg","size":158689,"content_type":"image\/jpeg; charset=binary"}],"type":"note","created_at":"2024-03-15T00:19:18-04:00","updated_at":"2024-03-15T00:19:18-04:00"}]},{"id":33605,"summary":"Documentation on csv-import file needed","description":"CSV file column definitions are not provided for use with the csv-import plugin.\r\n\r\nWe are left to guess what columns the utility is looking for. ","steps_to_reproduce":"Install csv-import plugin\r\n\r\nGo to csv-import plugin tab.\r\n\r\nNo column definitions are provided. ","additional_information":"A similar plugin, import-users, offers basic column definitions on the import-users support page https:\/\/support.mantishub.com\/hc\/en-us\/articles\/209403206-Importing-Users-from-CSV  (attached screenshot)\r\n\r\nI spent 30 minutes unsuccessfully looking on the forums for something that should probably be readily available in the csv-import README file or corresponding support article: https:\/\/support.mantishub.com\/hc\/en-us\/articles\/203574989-Importing-Issues-from-Csv-Files .","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":71520,"name":"acoder2020"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":60,"name":"major","label":"major"},"reproducibility":{"id":100,"name":"N\/A","label":"N\/A"},"sticky":false,"created_at":"2024-02-05T16:47:05-05:00","updated_at":"2024-02-06T15:21:03-05:00","attachments":[{"id":12324,"reporter":{"id":71520,"name":"acoder2020"},"created_at":"2024-02-05T16:47:05-05:00","filename":"Screenshot from 2024-02-05 16-46-53.png","size":167874,"content_type":"image\/png; charset=binary"},{"id":12323,"reporter":{"id":71520,"name":"acoder2020"},"created_at":"2024-02-05T16:47:05-05:00","filename":"Screenshot from 2024-02-05 16-44-51.png","size":164393,"content_type":"image\/png; charset=binary"},{"id":12322,"reporter":{"id":71520,"name":"acoder2020"},"created_at":"2024-02-05T16:47:05-05:00","filename":"Screenshot from 2024-02-05 16-42-24.png","size":38350,"content_type":"image\/png; charset=binary"}],"notes":[{"id":68513,"reporter":{"id":11111,"name":"atrol"},"text":"Moved the issue to the right project\r\n\r\nSee https:\/\/github.com\/mantisbt-plugins\/csv-import\/blob\/master\/README.md#support","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2024-02-05T17:08:54-05:00","updated_at":"2024-02-05T17:08:54-05:00"},{"id":68515,"reporter":{"id":71520,"name":"acoder2020"},"text":"The note at the bottom says \"However, please note that this plugin is not actively supported by its original authors.\"\r\n\r\nIs any support being done on this plugin at all?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2024-02-06T09:15:36-05:00","updated_at":"2024-02-06T09:15:36-05:00"},{"id":68516,"reporter":{"id":11111,"name":"atrol"},"text":"> Is any support being done on this plugin at all?\r\n\r\nI don't expect it, as there is no code change since about 6 years.\r\nBut who knows.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2024-02-06T15:21:03-05:00","updated_at":"2024-02-06T15:21:03-05:00"}]},{"id":32348,"summary":"Missing columns and report","description":"Reports and columns are not available for different types of views","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":54155,"name":"Masihullah.ahmadi"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":60,"name":"major","label":"major"},"reproducibility":{"id":30,"name":"sometimes","label":"sometimes"},"sticky":false,"created_at":"2023-04-07T05:05:57-04:00","updated_at":"2023-04-07T05:05:57-04:00"},{"id":31805,"summary":"Error while importing the CSV file into mantis","description":"I got an error while importing the CSV file into mantis. Please can anyone help me to resolve it. I have shared the error message for your reference.\r\n\r\nSYSTEM WARNING\r\n\r\n'\"continue\" targeting switch is equivalent to \"break\". Did you mean to use \"continue 2\"?' in 'D:\\xampp\\htdocs\\mantis\\plugins\\Csv_import\\pages\\import_issues.php' line 300\r\n\r\nPlease use the \"Back\" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.","additional_information":"SYSTEM WARNING\r\n\r\n'\"continue\" targeting switch is equivalent to \"break\". Did you mean to use \"continue 2\"?' in 'D:\\xampp\\htdocs\\mantis\\plugins\\Csv_import\\pages\\import_issues.php' line 300\r\n\r\nPlease use the \"Back\" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":10834,"name":"balajiudm"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":60,"name":"immediate","label":"immediate"},"severity":{"id":80,"name":"block","label":"block"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2022-12-08T01:43:43-05:00","updated_at":"2023-03-17T03:54:53-04:00","attachments":[{"id":11208,"reporter":{"id":10834,"name":"balajiudm"},"created_at":"2022-12-08T01:43:43-05:00","filename":"image.png","size":150374,"content_type":"image\/png; charset=binary"}],"notes":[{"id":67508,"reporter":{"id":53949,"name":"seungbeomi"},"text":"iueiufjsklfdjkljdlkfjklsjfdkslklasjlkfjalsjf","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2023-03-17T03:54:37-04:00","updated_at":"2023-03-17T03:54:37-04:00"},{"id":67509,"reporter":{"id":53949,"name":"seungbeomi"},"text":"sjhadjkjkfsf","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2023-03-17T03:54:53-04:00","updated_at":"2023-03-17T03:54:53-04:00"}]},{"id":30971,"summary":"After import the search\/filter special characters not work","description":"UTF-8 import to database stored with html entities like &aacute;.\r\nWhen I want to search in the filter section with special characters, nothing find.\r\nIf I put the worth with like &aacute;, the search  works, and find the needed bug report.\r\n\r\nAlso I noticed, after editing the imported bug, the special html entities change to normal latin character, and the search works for that bug report.\r\n\r\nI suppose in the import_issues_inc.php have to fix something.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":52137,"name":"szollosi"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":80,"name":"block","label":"block"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2022-09-08T11:48:39-04:00","updated_at":"2022-09-08T11:51:38-04:00","notes":[{"id":66977,"reporter":{"id":52137,"name":"szollosi"},"text":"My version:\r\nMantisBT verzi\u00f3 \t2.25.4\r\nS\u00e9ma-verzi\u00f3 \t211\r\nPHP verzi\u00f3 \t7.4.30\r\nAdatb\u00e1zis-meghajt\u00f3 \tmysqli\r\nAdatb\u00e1zis verzi\u00f3, le\u00edr\u00e1s \t5.7.39, 5.7.39-log \r\n\r\nDatabase: utf8mb4_hungarian_ci","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2022-09-08T11:51:38-04:00","updated_at":"2022-09-08T11:51:38-04:00"}]},{"id":25122,"summary":"Internal Application error after CSV file import","description":"After importing CSV file, an \"Internal Application Error\" message is shown","steps_to_reproduce":"1. Upload a CSV file containing issues exported from Jira\n2. Assign CSV file fields to issue fields\n3. Start the import\n4. An \"Internal Application Error\" message is shown\n5. Page is redirected to the \"View Issues\" page\n6. The issues appear to be imported correctly","additional_information":"The following error shows in Apache error log:\n\n[Thu Dec 27 06:02:38.058343 2018] [:error] [pid 3365] [client 192.168.1.1:56250] Call to undefined function print_bracket_link()\\n\/mnt\/public_html\/iss\nues\/httpdocs\/plugin.php: 79: - - - - include()\\n, referer: http:\/\/issues.exergoit.se\/plugin.php?page=Csv_import\/import_issues_page_col_set","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":46591,"name":"nadir"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":60,"name":"major","label":"major"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2018-12-27T01:25:59-05:00","updated_at":"2022-08-10T11:35:11-04:00","attachments":[{"id":8259,"reporter":{"id":46591,"name":"nadir"},"created_at":"2018-12-27T01:25:59-05:00","filename":"Screenshot from 2018-12-27 11-00-08.png","size":104344,"content_type":"image\/png; charset=binary"}],"notes":[{"id":66881,"reporter":{"id":52994,"name":"Mark Reynolds"},"text":"Is this Issue still new and open?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2022-08-10T11:35:11-04:00","updated_at":"2022-08-10T11:35:11-04:00"}]},{"id":30817,"summary":"Import with custom fields with a value who have special character (ex: accent) don't work","description":"Is-it possible to import bug in csv file with a value who have special character (ex: accent) ?\r\n\r\nIt didn't work for me. It's ok with a value who didn't have special character.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":52948,"name":"Fabien_fr"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":60,"name":"major","label":"major"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2022-08-02T08:42:58-04:00","updated_at":"2022-08-02T08:42:58-04:00"},{"id":25878,"summary":"Summary field value cut-off for Japanese (non-latin) characters","description":"When importing issues, the summary field gets cutoff. When attempting this with Japanese, The summary field truncates after 16 Japanese characters. ","steps_to_reproduce":"import issues where the summary value is in Japanese and has more than 16 Japanese characters. ","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":43710,"name":"sandyj"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2019-06-20T12:39:17-04:00","updated_at":"2022-05-12T22:33:04-04:00","attachments":[{"id":8595,"reporter":{"id":47652,"name":"kotatoshi"},"created_at":"2019-06-20T21:14:16-04:00","filename":"mantishub_sample.csv","size":778,"content_type":"text\/plain; charset=utf-8"},{"id":8597,"reporter":{"id":47652,"name":"kotatoshi"},"created_at":"2019-06-20T21:43:52-04:00","filename":"mantishub_sample-2.csv","size":1596,"content_type":"text\/plain; charset=utf-8"}],"notes":[{"id":62280,"reporter":{"id":43710,"name":"sandyj"},"text":"could be related to this https:\/\/stackoverflow.com\/questions\/2236668\/file-get-contents-breaks-up-utf-8-characters","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-06-20T12:49:30-04:00","updated_at":"2019-06-20T12:49:30-04:00"},{"id":62281,"reporter":{"id":47652,"name":"kotatoshi"},"text":"Hi, \nI reported this problem to MantisHub support team and she created this issue.\nI upload the sample file with Japanese character in summary field.\nIt has three rows, and two of them have more than 16 Japanese characters.\nPlease tell me if you have any problem with it.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-06-20T21:14:16-04:00","updated_at":"2019-06-20T21:14:16-04:00"},{"id":62283,"reporter":{"id":47652,"name":"kotatoshi"},"text":"Sorry to post again, but will upload the modified file with custom field.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-06-20T21:43:52-04:00","updated_at":"2019-06-20T21:43:52-04:00"},{"id":66550,"reporter":{"id":43710,"name":"sandyj"},"text":"no idea       how that image ended up there           here is the correct one.      :?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[{"id":10463,"reporter":{"id":43710,"name":"sandyj"},"created_at":"2022-05-10T02:13:58-04:00","filename":"image.png","size":465231,"content_type":"image\/png; charset=binary"}],"type":"note","created_at":"2022-05-10T02:13:58-04:00","updated_at":"2022-05-10T02:13:58-04:00"},{"id":66574,"reporter":{"id":52576,"name":"kaledesign"},"text":"\u5df2\u89e3\u51b3","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2022-05-12T22:33:04-04:00","updated_at":"2022-05-12T22:33:04-04:00"}]},{"id":27805,"summary":"not working","description":"Hi,\nI uploaded plugin.  My version of mantis is below.\n\nSite Information\nMantisBT Version\t2.24.2\nSchema Version\t210\nPHP Version\t7.4.11\nDatabase Driver\tmysqli\nDatabase Version, Description\t10.4.14, 10.4.14-MariaDB\nSite Path\tC:\\xampp\\htdocs\\mantisbt\\\nCore Path\tC:\\xampp\\htdocs\\mantisbt\\core\\\nPlugin Path\tC:\\xampp\\htdocs\\mantisbt\\plugins\\\n\nWhen I install plugin I see like on attachment.\n","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":44218,"name":"e_kesaf"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2020-12-28T08:28:26-05:00","updated_at":"2020-12-28T08:28:26-05:00","attachments":[{"id":9450,"reporter":{"id":44218,"name":"e_kesaf"},"created_at":"2020-12-28T08:28:26-05:00","filename":"2.png","size":78686,"content_type":"image\/png; charset=binary"},{"id":9451,"reporter":{"id":44218,"name":"e_kesaf"},"created_at":"2020-12-28T08:28:26-05:00","filename":"1.png","size":183566,"content_type":"image\/png; charset=binary"}]},{"id":27188,"summary":"[CSV import] - plugin not available","description":"Hello,\r\n\r\nI'm currently on MantisBT Core 1.2.4. \r\nI have to import CSV file in a Mantis Project.\r\nLe plugin CSV Issues Importer v1.4.1 for Mantis 1.2.x are not available (https:\/\/github.com\/mantisbt-plugins\/csv-import\/archive\/master-1.2.x.zip).\r\nI've read this version isn't upgrade by Mantis BT but can I download this version of the plugin to install it on my Mannts BT ?\r\n\r\nI know the risk to install an old plugin.\r\n\r\nThanks for your help.\r\n\r\nregards,\r\n\r\nJ\u00e9r\u00f4me\r\n\r\n","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":37399,"name":"jerome.stevens"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2020-09-01T04:50:25-04:00","updated_at":"2020-09-01T04:50:32-04:00"},{"id":4220,"summary":"* Import new Issues from file","description":"I found some php file extensions for the possibility to import new issues from an external file. These feature is developed by cas@nuy.info, but works for me and me 0.19.a2 installation.\r\nIs someone interested in this extension?","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":5124,"name":"fusenigk"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2004-07-29T12:52:38-04:00","updated_at":"2020-07-30T03:24:00-04:00","attachments":[{"id":294,"reporter":{"id":0},"created_at":"2004-07-29T12:53:57-04:00","filename":"Mantis_import.zip","size":5283,"content_type":"application\/x-zip-compressed"},{"id":544,"reporter":{"id":0},"created_at":"2004-12-09T15:05:47-05:00","filename":"mantis_import_issues.zip","size":10585,"content_type":"application\/x-zip-compressed"},{"id":699,"reporter":{"id":0},"created_at":"2005-05-11T14:14:15-04:00","filename":"mantis_import_issues_v2.zip","size":11430,"content_type":"application\/x-zip-compressed"},{"id":876,"reporter":{"id":0},"created_at":"2005-11-04T10:29:56-05:00","filename":"mantis_import_issues_v3.zip","size":12033,"content_type":"application\/zip"},{"id":885,"reporter":{"id":0},"created_at":"2005-12-02T17:15:27-05:00","filename":"mantis_import_issues_v4.zip","size":12489,"content_type":"application\/zip"},{"id":891,"reporter":{"id":0},"created_at":"2005-12-18T06:13:45-05:00","filename":"mantis_import_issues_v5.zip","size":12599,"content_type":"application\/zip"},{"id":901,"reporter":{"id":0},"created_at":"2005-12-23T05:14:36-05:00","filename":"Mantis_import_issues_V3.1_effective.zip","size":12784,"content_type":"application\/zip"},{"id":909,"reporter":{"id":0},"created_at":"2006-01-05T07:14:02-05:00","filename":"mantis_import_issues_v6.zip","size":13690,"content_type":"application\/zip"},{"id":940,"reporter":{"id":0},"created_at":"2006-02-10T14:27:44-05:00","filename":"custom_strings_inc.zip","size":986,"content_type":"application\/zip"},{"id":963,"reporter":{"id":0},"created_at":"2006-03-03T12:48:45-05:00","filename":"mantis_import_issues_v6.1.zip","size":14255,"content_type":"application\/zip"},{"id":1071,"reporter":{"id":0},"created_at":"2006-08-04T03:59:49-04:00","filename":"mantis_import_issues_v6.1.1.zip","size":15008,"content_type":"application\/zip"},{"id":1114,"reporter":{"id":0},"created_at":"2006-09-21T18:38:06-04:00","filename":"mantis_import_issues_v6.1--reuploaded.zip","size":14255,"content_type":"application\/zip"},{"id":1281,"reporter":{"id":0},"created_at":"2007-03-26T12:51:52-04:00","filename":"mantis_import_issues_v7.zip","size":15059,"content_type":"application\/zip"},{"id":1322,"reporter":{"id":0},"created_at":"2007-05-21T10:15:43-04:00","filename":"import_issues.php","size":22471,"content_type":"text\/plain"},{"id":1881,"reporter":{"id":0},"created_at":"2008-07-04T09:20:03-04:00","filename":"csv_import-1.0.tgz","size":7213,"content_type":"application\/x-compressed"},{"id":1989,"reporter":{"id":0},"created_at":"2008-10-06T10:28:06-04:00","filename":"csv_import-1.0.1.zip","size":14981,"content_type":"application\/x-zip-compressed"},{"id":2158,"reporter":{"id":0},"created_at":"2009-03-16T06:36:34-04:00","filename":"Csv_import110.zip","size":11786,"content_type":"application\/x-zip-compressed"},{"id":2283,"reporter":{"id":0},"created_at":"2009-05-06T07:46:24-04:00","filename":"strings_german.txt","size":2140,"content_type":"text\/plain"},{"id":2336,"reporter":{"id":0},"created_at":"2009-06-03T16:33:38-04:00","filename":"csv_import-1.0a_mantis1.1.tgz","size":7276,"content_type":"application\/octet-stream"},{"id":2341,"reporter":{"id":0},"created_at":"2009-06-09T23:00:09-04:00","filename":"csv_import-1.0b_mantis1.1.tgz","size":7266,"content_type":"application\/octet-stream"},{"id":2881,"reporter":{"id":7780,"name":"cas"},"created_at":"2010-05-21T03:48:36-04:00","filename":"Csv_import.111.zip","size":11860,"content_type":"application\/x-zip-compressed"},{"id":2884,"reporter":{"id":7780,"name":"cas"},"created_at":"2010-05-27T08:18:13-04:00","filename":"Csv_import.112.zip","size":11629,"content_type":"application\/x-zip-compressed"},{"id":3095,"reporter":{"id":10406,"name":"sveyret"},"created_at":"2010-11-04T12:34:27-04:00","filename":"Csv_import.113.tgz","size":9716,"content_type":"application\/x-tgz"},{"id":3098,"reporter":{"id":10406,"name":"sveyret"},"created_at":"2010-11-05T04:52:34-04:00","filename":"Csv_import.114.tgz","size":10275,"content_type":"application\/x-tgz"},{"id":3112,"reporter":{"id":18734,"name":"lionheart33806"},"created_at":"2010-11-10T05:30:04-05:00","filename":"Csv_import.115.tar.gz","size":9766,"content_type":"application\/x-gzip"},{"id":3135,"reporter":{"id":18734,"name":"lionheart33806"},"created_at":"2010-11-16T06:00:27-05:00","filename":"Csv_import.120.tar.gz","size":10088,"content_type":"application\/x-gzip"},{"id":3483,"reporter":{"id":17265,"name":"andy778"},"created_at":"2011-08-11T11:56:17-04:00","filename":"0001-Utf8-support-and-Real-names.patch","size":3220,"content_type":"application\/octet-stream"}],"notes":[{"id":8375,"reporter":{"id":5496,"name":"gtomlin"},"text":"This is something that is an absolute prerequisite for me to migrate to Mantis. There's simply no way I can do so without keeping our existing bug history. \r\n\r\nI'm interested to see that this worked for 0.19.a2. I had to change it substantially to work with 0.19.0. Right now I'm playing with it to make it a little more flexible. I'll upload it when I'm done.\r\n\r\nUltimately I will want to add the capability to import old text as bugnotes as well.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-11-19T10:01:26-05:00","updated_at":"2004-11-19T10:01:26-05:00"},{"id":8465,"reporter":{"id":2854,"name":"jlatour"},"text":"Looks interesting, but it needs some work. It needs to adhere to coding standards and the logic needs to be moved to a core file. Perhaps this feature also needs to be expanded a bit (preview?).\r\n\r\nAnyone who wants to work on this?\r\n\r\nP.S. Did the author give permission to include this?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-12-01T03:33:48-05:00","updated_at":"2004-12-01T03:33:48-05:00"},{"id":8475,"reporter":{"id":5496,"name":"gtomlin"},"text":"I have almost completed a modified version of this program that will allow almost any field in an issue to be imported or defaulted or set to a constant value, and will submit it when I am done.\r\n\r\nI've sent a note to the author of the original program asking for his permission to submit it.\r\n\r\nThis is the only issue in the database that I could find that mentions coding standards, so I have to ask: where are the standards documented? Or alternatively, I can submit what I've done and someone can add\/change whatever is necessary for conformance.\r\n\r\nEdit: completed, waiting for original author's permission.\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-12-01T09:17:31-05:00","updated_at":"2004-12-01T13:12:47-05:00"},{"id":8487,"reporter":{"id":5496,"name":"gtomlin"},"text":"Received a note from Cas Nuy (the original author):\r\n\r\n\"Good news, ofcourse you can. Looking forward in checking it out.\r\n\r\nKind regards,\r\nCas\"\r\n\r\nAt this point, I can either attach the files I have or alter as required to comply with coding standards (which I would need access to). Which would the team prefer?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-12-01T16:35:57-05:00","updated_at":"2004-12-01T16:35:57-05:00"},{"id":8489,"reporter":{"id":5297,"name":"Matt_wc"},"text":"The coding standards are here: \r\n\r\nhttp:\/\/www.mantisbt.org\/guidelines.php\r\n\r\nThere is also a link to the more general PHP Standards. \r\n\r\nThis is great stuff gtomlin - keep it up! =)","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-12-01T19:27:05-05:00","updated_at":"2004-12-01T19:27:05-05:00"},{"id":8491,"reporter":{"id":2854,"name":"jlatour"},"text":"Please look at the coding standards first. Sounds good though!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-12-02T01:48:35-05:00","updated_at":"2004-12-02T01:48:35-05:00"},{"id":8494,"reporter":{"id":5496,"name":"gtomlin"},"text":"Note: the link to PHP coding standards on http:\/\/www.mantisbt.org\/guidelines.php is obsolete. It points to http:\/\/utvikler.start.no\/code\/php_coding_standard.html, which in turn redirects you to http:\/\/alltasks.net\/code\/php_coding_standard.html. This last page says the domain alltasks.net is expired.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-12-02T08:52:58-05:00","updated_at":"2004-12-02T08:52:58-05:00"},{"id":8566,"reporter":{"id":5496,"name":"gtomlin"},"text":"Updated version uploaded as mantis_import_issues.zip; I've tested this on 0.19.0 and 0.19.1. Anyone is welcome to use\/misuse\/abuse or modify it as they see fit. Have fun.\r\n\r\n(thanks to Cas Nuy for the original idea!)","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-12-09T15:08:49-05:00","updated_at":"2004-12-09T15:08:49-05:00"},{"id":8568,"reporter":{"id":2854,"name":"jlatour"},"text":"I moved it from 0.20.0 to 0.19.3, but it's too late for 0.19.2.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2004-12-09T15:49:06-05:00","updated_at":"2004-12-09T15:49:06-05:00"},{"id":8886,"reporter":{"id":5354,"name":"bclarke"},"text":"Great work on the patch. Had a question: Can this patch can handle importing into existing custom fields? I think that would be helpful if possible, especially when importing from another system.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-01-06T18:44:23-05:00","updated_at":"2005-01-06T18:44:23-05:00"},{"id":8889,"reporter":{"id":5496,"name":"gtomlin"},"text":"No it can't as it's presently written. To do this in a generalized fashion would require interrogating the custom field definitions in the database and then constructing the import page on the fly based on what custom fields are defined, and I just didn't have time to do that. For my own needs, if I put more work into this it would be to import external text as bugnotes.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-01-07T09:38:22-05:00","updated_at":"2005-01-07T09:38:22-05:00"},{"id":9552,"reporter":{"id":5793,"name":"annpatel"},"text":"Thanks for the patch... However, I am having some difficulty getting it to work. \r\nI get a successful import however, none of my data is properly imported... the summary and descriptions are coming up as empty\/null when the importing code is calling the create_bug method... in the end, i basically get a lot of blank entries created for project_id = 0 in my bug table.  Does any one have any ideas on what I am doing wrong ? \r\n\r\nThank you, \r\nAnn","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-03-15T19:46:28-05:00","updated_at":"2005-03-15T19:46:28-05:00"},{"id":9554,"reporter":{"id":5496,"name":"gtomlin"},"text":"Try commenting the lines that delete the temporary import table, and use phpmyadmin (or equivalent) to have a look at the data in that table. This should help to narrow down the problem.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-03-16T11:33:00-05:00","updated_at":"2005-03-16T11:33:00-05:00"},{"id":9556,"reporter":{"id":5793,"name":"annpatel"},"text":"Thanks for the info... Actually, I figured it out.  I had previously commented out the summary and description while I was debugging and for got to put them back in... my bad.  It works great!\r\n\r\nThanks again,\r\nAnn","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-03-16T14:24:42-05:00","updated_at":"2005-03-16T14:24:42-05:00"},{"id":9691,"reporter":{"id":5931,"name":"Scipion"},"text":"I tested gtomlin's contribution (mantis_import_issues.zip) under 0.19.2 it works fine. I have two small issues:\r\n1 - Fixed in Version field is imported in mantis_import table but not migrated to the system\r\n2 - Build field is imported in mantis_import table but not migrated to the system\r\n\r\nResults of investigation for item 2:\r\nI identified one potential bug in import_issues.php file (I am not an expert) and needs to be validated:\r\n\r\n# Set up build \r\nif($f_buildx == IMPORT_FROM_FILE) {\r\n#\t$t_build = $a_buildx[$i] ; (replace $a_buildx[$i] to $a_build[$i])\r\n\t$t_build = $a_build[$i] ;\r\n} else if ($f_buildx == IMPORT_USE_CONST_VALUE) {\r\n\t$t_build = $f_const_build;\r\n} else {\r\n$t_build = '' ;\r\n}\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-03-31T03:38:36-05:00","updated_at":"2005-03-31T03:39:46-05:00"},{"id":10071,"reporter":{"id":5496,"name":"gtomlin"},"text":"Sorry for the delay in getting back to this...bogged down with other work. \r\n\r\nScipion's suggested fix corrected the problem for the \"build\" field. and the \"fixed in version\" field problem has been fixed by using bug_set_field() after bug_create(), since bug_create() does not set fixed_in_version.\r\n\r\nBefore uploading the fixed files, I need some guidance from the team. In 1.0.0a(x), function print_manage_menu() in core\/html_api.php tests authority for each menu item before printing a link to it. What authority do you think should be tested for importing issues?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-05-10T15:51:43-04:00","updated_at":"2005-05-10T15:51:43-04:00"},{"id":10090,"reporter":{"id":5496,"name":"gtomlin"},"text":"Uploaded new version (mantis_import_issues_v2.zip). Tested on 0.19.0 and 1.0.0a1. Made an \"executive decision\" that import should require ADMINISTRATOR access.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-05-11T14:16:04-04:00","updated_at":"2005-05-11T14:16:04-04:00"},{"id":10264,"reporter":{"id":5496,"name":"gtomlin"},"text":"This issue is marked as a child of 0.20.0, which is obviously never going to be a real release as we're at 1.0.0a[n] now. It's still in feedback status but it's not apparent what that feedback might be. What do we need to do to get this one back on track?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-05-27T13:02:30-04:00","updated_at":"2005-05-27T13:02:30-04:00"},{"id":10322,"reporter":{"id":3081,"name":"vboctor"},"text":"gtomlin, I didn't run the script yet, but I like the idea of a configurable importer.\r\n\r\n- I wonder if this is a feature that is needed as part of the application vs. as part of the administration section (i.e. admin\/ folder).  Having it as part of the application is nice, but is it needed?\r\n\r\n- You should be able to use user_get_id_by_name() from user_api.php rather than defining your own methods.  Maybe this method wasn't implemented in 0.19.x.  If that is the case, then you script should use the standard API if the function exists.\r\n\r\n- When constructing the $t_column_list in import_issues.php consider creating an array of columns, then imploding the array into a string with the comma as the separator.  This will simplify your code.\r\n\r\n- Consider creating core\/import_api.php and move as much functionality to the api.\r\n\r\n- Use standard Mantis headers.\r\n\r\n- Use function( x ) rather than function(x).\r\n\r\n- Use $g_db_table_prefix and $g_db_table_suffix to name the table for the import.\r\n\r\n- Given that you are processing the file sequentially, is it really of use to import the file into a table?\r\n\r\n- Why do you read all issues in memory, then write all issues to the database.  Why don't read one issue, then write it, and so on.\r\n\r\n- You can add a menu option to the main menu using $g_main_menu_custom_options, we should probably implement a similar technique to add custom options to the manage menu.  Although if your patch gets integrated into Mantis, then we won't need it.\r\n\r\n- You can rename your custom_strings_inc.php to import_custom_strings_inc.php and require the users to include it from their custom_strings_inc.php or create a custom_strings_inc.php to include it from.  Same for custom_constants_inc.php.  This may simplify the updates for your patch, however, it is not needed if this becomes part of Mantis main distribution.\r\n\r\nMore to come later.  I will need to set it up and do some testing.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-06-01T11:10:10-04:00","updated_at":"2005-06-01T11:10:10-04:00"},{"id":10344,"reporter":{"id":6157,"name":"fredckp"},"text":"will like to confirm the data will be imported to the current project view?\r\nthanks.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-06-03T05:57:22-04:00","updated_at":"2005-06-03T05:57:22-04:00"},{"id":10358,"reporter":{"id":5496,"name":"gtomlin"},"text":"fredckp, issues will be imported into whatever project is the current project when  you start the import. If you are not in the desired project, switch before starting the import.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-06-03T19:46:50-04:00","updated_at":"2005-06-03T19:46:50-04:00"},{"id":10359,"reporter":{"id":5496,"name":"gtomlin"},"text":"Thanks for the feedback Victor...I'll incorporate the bulk of your suggestions. A few comments:\r\n\r\n- Should it be part of the application? I'd say so, since (a) you need to set up users, projects etc. before it is even reasonable to try importing issues, and (b) it could become necessary to import issues from another source at a later date long after the admin directory has been removed.\r\n\r\n- core\/import_api.php - I'll look into it. It's probably not important now but could be later if we start importing other things like users and projects.\r\n\r\n- As far as the points regarding use of a table and order of reading and writing are concerned, these are things that I didn't change from the original contribution that I picked up. As it turns out, though, it proved handy sometimes to have the imported data in a table to look at it with phpMyAdmin after an unsuccessful import.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-06-03T20:10:11-04:00","updated_at":"2005-06-03T20:10:11-04:00"},{"id":10406,"reporter":{"id":6172,"name":"jschrader"},"text":"There was a discussion about implementing this as an administrator task or as part of the application. I appreciate implementing as part of the application because I will need this feature frequently. We often get Excel Sheets from our customers; it would be nice to import these and this should be done by someone with manager rights.\r\n\r\nJust my humble opinion on that feature.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-06-08T06:21:25-04:00","updated_at":"2005-06-08T06:21:25-04:00"},{"id":10919,"reporter":{"id":6333,"name":"joostbaaij"},"text":"There are a couple of issues with this functionality. First of all, it doesn't work on the Safari browser (MAC OSX 10.4). But that might be a Safari thing, it does work with Firefox.\r\n\r\nThe more serious, showstopper bug though: it turns out that for recent versions of MySQL the LOAD DATA LOCAL INFILE was removed because of an apparent \"security issue\". After hours of searching I finally found the way to re-enable LOAD DATA LOCAL INFILE again.\r\n\r\nEdit the file core\/adodb\/drivers\/adodb-mysql.inc.php.\r\nIn it, find its own class definition. Change $clientflags like so:\r\nvar $clientFlags = 128;\r\n\r\nNow I was finally able to upload the file, but alas, MySQL did not find my uploadfile. So now I'm stuck.\r\n\r\nError message: File 'bugs.txt' not found","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-07-22T11:05:50-04:00","updated_at":"2005-07-22T11:05:50-04:00"},{"id":11518,"reporter":{"id":6604,"name":"vJack"},"text":"Hi joostbaaij, Were you able to find a solution to the file not being found? \r\nI was getting error: \"The used command is not allowed with this MySQL version\" (using MySQL 4.0.25-standard \/ PHP 4.3.11) \r\nI then changed to $clientflags=128 as you suggested and then got the same error you now have: \"File 'C:\/Import_Columns_2.csv' not found (Errcode: 2)\". If you have a solution please let me know. I'm using Mantis 1.0.0rc1 and import_issues_v2. Thanks!\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-10-20T15:04:33-04:00","updated_at":"2005-10-20T15:07:34-04:00"},{"id":11519,"reporter":{"id":6333,"name":"joostbaaij"},"text":"The only way it is going to work, is upload the file to the server (via ftp\/scp etc). It doesn't matter if you choose client\/server the importer always looks on the server. sadly enough.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-10-21T03:16:55-04:00","updated_at":"2005-10-21T03:16:55-04:00"},{"id":11521,"reporter":{"id":6608,"name":"dingdong"},"text":"joostbaaij, where exactly the file needs to be uploaded on the server? Directory?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-10-21T14:59:11-04:00","updated_at":"2005-10-21T14:59:11-04:00"},{"id":11522,"reporter":{"id":6604,"name":"vJack"},"text":"I have put the file on the server, in the same directory as Mantis, but can't get it to recognize the file. I click 'Start Import' and nothing happens, the page doesn't reload or anything. If I switch the path to a local drive 'C:\/..' then it responds with the 'Can't find file error'. If you have an example syntax for a server path that you've found works it would help a lot. \r\n\r\nMy next step is to manually import the records into the Mantis_Import table the tool created (using PhpMyAdmin), then comment out the LOAD FILE part of the script, and retry running the tool from that point. Any other ideas?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-10-21T16:52:29-04:00","updated_at":"2005-10-21T16:52:29-04:00"},{"id":11525,"reporter":{"id":5496,"name":"gtomlin"},"text":"There's not enough info in these recent posts to enable anyone to help.\r\n\r\nWhat is the actual file location? How exactly are you typing it on the import issues page? What platform are you running? What MySQL version? What PHP version? What Mantis version?\r\n\r\nFor LOAD DATA LOCAL security considerations, see:\r\nhttp:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/load-data-local.html\r\nThe ability or inability to use LOAD DATA LOCAL is in the installation's hands.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-10-24T10:44:18-04:00","updated_at":"2005-10-24T10:44:18-04:00"},{"id":11536,"reporter":{"id":6604,"name":"vJack"},"text":"Hi gtomlin, thank you for offering to help.\r\n\r\nThis is my setup:\r\nOS: Windows XP\r\nBrowser: IE 6.0 (Tried FireFox 1.0.7 too)\r\nMySQL: 4.0.25-standard \r\nPHP: 4.3.11\r\nMantis: 1.0.0rc1\r\nImport Tool: mantis_import_issues_v2.zip\r\nFile Location: Local PC drive\r\nActual File Path: 'C:\\Import_Columns_2.csv'\r\nTyping in form  : 'C:\/Import_Columns_2.csv'\r\n\r\nLocal Client Import Error Message:   \r\nImporting from: C:\/Import_Columns_2.txt\r\nImporting into project: Mantis Changes\r\nImporting columns: (reporter,summary,description)\r\nFile 'C:Import_Columns_2.txt' not found (Errcode: 2)\r\n\r\nI have never been able to import a file. Not from my local PC or from the server. When trying to load a file from the server the page stays as is after clicking 'start import'. It doesn't refresh or throw an error. Any help would be great, thank you!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-10-25T18:12:28-04:00","updated_at":"2005-10-25T18:12:28-04:00"},{"id":11545,"reporter":{"id":5496,"name":"gtomlin"},"text":"I tested both client and server imports successfully and only after doing so I noticed that you are specifying 'C:<b>\/<\/b>Import_Columns_2.<b>csv<\/b>' but the import is attempting to access 'C:Import_Columns_2.<b>txt<\/b>'. It looks to me like your system is doing something strange.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-10-26T11:49:39-04:00","updated_at":"2005-10-26T11:49:39-04:00"},{"id":11546,"reporter":{"id":6604,"name":"vJack"},"text":"Thank you for taking the time to test it. I'll keep digging to see what the problem might be.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-10-26T14:56:10-04:00","updated_at":"2005-10-26T14:56:10-04:00"},{"id":11595,"reporter":{"id":5496,"name":"gtomlin"},"text":"Updated version uploaded: mantis_import_issues_v3.zip. Addresses the following items in Victor's note 10322:\r\n\r\n- use user_get_id_by_name() from user_api.php rather than defining a custom method\r\n\r\n- simplified construction of column list.\r\n\r\n- Use standard Mantis headers.\r\n\r\n- Use function( x ) rather than function(x).\r\n\r\n- Use $g_db_table_prefix and $g_db_table_suffix to name the table for the import.\r\n\r\n- Process each issue as it is read from the temporary table rather than constructing arrays.\r\n\r\nAs I mentioned in my note 10359, it makes sense for the importer to be a part of the distribution, since it may be necessary to run it after the admin directory has been removed. Accordingly, I haven't done anything to the way the custom_constants_inc.php and constant_strings_inc.php files are updated.\r\n\r\nBTW, is there a syntax to generate a link to a bugnote (analogous to # and an issue number to generate a link to an issue)?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-11-04T10:42:07-05:00","updated_at":"2005-11-04T10:42:07-05:00"},{"id":11684,"reporter":{"id":3081,"name":"vboctor"},"text":"gtomlin,\r\n\r\nI've attached version 4 of the patch which includes the following:\r\n\r\n1. Fixes for some notices that were generated by the code.  Please turn notices ON to be able to see all errors in the code.\r\n\r\n2. Used db_* rather than mysql_*.\r\n\r\n3. Remove die_clean() since it was no longer used after using db_*.\r\n\r\n4. A couple of other minor issues (use file compare to make sure my fixes are correct).\r\n\r\nI'd recommend the following:\r\n\r\n1. Consider avoiding the use LOAD DATA INFILE since it seems to be disabled by default in MySQL.  I think it will be much easier to use, setup, and more portable if you upload the text file, process it via PHP, delete the upload temporary file.\r\n\r\n2. For the options of importing fields, it would be good to have an option for \"default (if not exists)\".  This means that script should import the value in the text file, only if it is valid; otherwise it should use the default specified.\r\n\r\nNote: Without changing MySQL settings, I could only get it to import a file from the server that is located in the database directory.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-02T17:25:37-05:00","updated_at":"2005-12-02T17:25:37-05:00"},{"id":11686,"reporter":{"id":3081,"name":"vboctor"},"text":"Error generated when importing a server based file on a MySQL 4.1.14-standard installed on Linux:\r\n\r\nDatabase query failed. Error received from database was #1045: Access denied for user 'username'@'localhost' (using password: YES) for the query: LOAD DATA INFILE \".\/testissues.txt\" REPLACE INTO TABLE mantis_import_issues_table FIELDS TERMINATED BY \";\" LINES TERMINATED BY \"\\r\\n\" (summary,description);\r\n\r\nImporting the file from the browser machine worked fine.  Is there a specific location on the server that the file should be placed?\r\n\r\nThe current situation is:\r\n- On my Windows box, I only got it working using the server based file.\r\n- On the Linux hosted environment, I only got it working using the user local file.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-03T06:45:08-05:00","updated_at":"2005-12-03T06:45:08-05:00"},{"id":11743,"reporter":{"id":6652,"name":"ag"},"text":"I just tested the mantis_import_issues_v4 on Mantis 1.0.0rc3 and the import worked without issue.  As a non-programmer I have 2 queries that would really help if anyone had an answer.\r\n\r\n1.  Has anyone tried importing data including original bug id numbers?  If you have managed this what code changes did you make?\r\n\r\n2.  Does anyone have an example of a custom field that they imported using this, what code changes did you need to make for this?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-08T08:19:58-05:00","updated_at":"2005-12-08T08:19:58-05:00"},{"id":11765,"reporter":{"id":3081,"name":"vboctor"},"text":"A couple of other comments:\r\n\r\n- When importing a file from a windows client, the \\ should not be replaced by \/.\r\n\r\n- Although the description field is not marked as mandatory, it is.  I have changed the script to use the summary for description, if description is empty.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-09T17:33:19-05:00","updated_at":"2005-12-09T17:33:19-05:00"},{"id":11779,"reporter":{"id":5496,"name":"gtomlin"},"text":"Victor, when you say that '\\' should not be changed to '\/' on a Windows client, what platform was MySQL running on? According to the MySQL 5.0 Reference Manual (see http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/load-data.html), \"Note that Windows pathnames are specified using forward slashes rather than backslashes. If you do use backslashes, you must double them.\" My tests were done with client and server both on Windows boxes, and my results were:\r\n- \\ - file not found\r\n- \\\\ - file not found\r\n- \/ - OK","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-12T10:16:36-05:00","updated_at":"2005-12-12T10:16:36-05:00"},{"id":11780,"reporter":{"id":6652,"name":"ag"},"text":"I read the \/ \\ comment and I thought I would share my experience.\r\n\r\nI used mantis_import_issues_v4 on Mantis 1.0.0rc3 on a WinXP machine running MySQL 4.1.11.  Importing a cvs file from c:\\ and I found it necessary to change the \\ to \/.\r\n\r\nIf someone could advise me how to import custom fields using this I would really appreciate it.  \r\nThanks AG","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-12T10:38:41-05:00","updated_at":"2005-12-12T10:38:41-05:00"},{"id":11781,"reporter":{"id":5496,"name":"gtomlin"},"text":"AG, this is just using bug_create(), which creates an issue without custom fields. To make this importer support custom fields would be a substantial project.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-12T11:13:13-05:00","updated_at":"2005-12-12T11:13:13-05:00"},{"id":11807,"reporter":{"id":3081,"name":"vboctor"},"text":"I've attached v5 which includes the following changes:\r\n\r\n1. Uploads the file to the server temporary directory, then imports it from there.\r\n2. Escapes the strings before using them in constructing SQL queries.  This is to avoid SQL injection attacks.\r\n\r\nThis will probably break the server-side files.  Do we really need to support such case?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-18T06:16:45-05:00","updated_at":"2005-12-18T06:16:45-05:00"},{"id":11825,"reporter":{"id":5496,"name":"gtomlin"},"text":"I had a look at your v5 files, and the approach should be fine. The important thing is that the facility works for all users in all environments. The user just needs to know where the file needs to be located when he\/she starts the process.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-21T10:17:33-05:00","updated_at":"2005-12-21T10:17:33-05:00"},{"id":11826,"reporter":{"id":2405,"name":"grangeway"},"text":"Isn't this something that it would be more sensible to use mantisconnect to do?\r\nI'm thinking a 'php client which talks to the webservice' before anyone says anything about c#.\r\n\r\nImporting Issues somewhat strikes me as something you'd do from a command line script, rather then a webpage - for example, I did start trying to use a c# client at work, to add issues to mantis based on the output of an xml file.... Personally, I'm thinking this sort of thing is something better done as a contributed script\/addon, then as a 'core feature'\r\n\r\nIn terms of a critical review of issues in v5:\r\n\r\n1. DROP TABLE IF EXISTS is mysql specific, and shouldn't be used.\r\n2. CREATE TABLE uses VARCHAR(32) etc - this should use ADODB's type's instead.\r\n3. Creating\/dropping tables should be done as part of the installation, not as part of the script.\r\n4. LOAD DATA INFILE \/ REPLACE INTO TABLE \/ FIELDS TERMINATED BY \/ LINES TERMINATED BY \/ LOAD DATA LOCAL INFILE is specific to mysql and shouldn't be used.\r\n5. why is the table even needed in the first place? If someone uploads a comma seperated file - why not open it on the server, and do the parsing there, rather then importing it into a database and retrieving it again?\r\n6. I think import_issues.php should call helper_begin_long_process();","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-22T04:37:50-05:00","updated_at":"2005-12-22T04:37:50-05:00"},{"id":11827,"reporter":{"id":6820,"name":"jblanchon"},"text":"While you were working on bug corrections, I developped the following features required at my work.\r\n\r\n- Import custom fields\r\n- Import \"status\" field\r\n- Import \"resolution\" field\r\n- Import \"date submitted\" field\r\n\r\nBecause some fields are set to default by bug_create, function bug_set_field is used to import extra fields (status, resolution, date submitted). A consequence is that the bug history is updated each time such a field is imported. Custom fields API, specially custom_field_set_value, is used to import custom fields values.\r\n\r\nUnfortunatly, this is based on V3 version and all modifications till V5 have to be merged. Does anyone want to perform this merge? I will attach this version as Mantis_Import_Issue_v3.1.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-22T05:18:42-05:00","updated_at":"2005-12-22T05:18:42-05:00"},{"id":11838,"reporter":{"id":6820,"name":"jblanchon"},"text":"Sorry, the archive V3.1 is just a copy of V3 :-( \r\nUse V3.1_effective instead.\r\n\r\nWhy a reporter can't delete its own attached file in this page?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2005-12-23T05:17:13-05:00","updated_at":"2005-12-23T05:17:13-05:00"},{"id":11871,"reporter":{"id":3081,"name":"vboctor"},"text":"Thanks jblanchon for your contribution.  I uploaded v6 which includes the following:\r\n\r\n- I merged your changes (v3.1).\r\n- Did some code cleanup.\r\n- Some changes towards Mantis standards.\r\n- Did some fixes relating to the importing of status, resolution, fixed in release.\r\n- I didn't do any testing relating to custom fields.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-01-05T07:18:35-05:00","updated_at":"2006-01-05T07:18:35-05:00"},{"id":11959,"reporter":{"id":6445,"name":"atomoid"},"text":"I'm trying to import the sample \"testissues.txt\" file as-is and I get: \r\n    APPLICATION ERROR #11\r\n    A necessary field '' was empty. Please recheck your inputs.\r\n\r\nSomebody (apparently) fixed the script so that you no longer have to modify the path on Windows systems (as i remember in older versions having to switch the slashes). Therefore, if you follow the now-misleading directions and painstakingly change all the backslashes, you will experience app error #11.\r\n\r\n...So I adjusted: \"custom_strings_inc.php\" at line 18: \"$s_import_instructions_2 = \"2. Specify the input file (Windows users change all \\\\ to \/ in file name) and its characteristics.\";\r\n\r\n... replacing this line 18 with:\r\n  \"$s_import_instructions_2 = \"2. Specify the input file and its characteristics (Some Windows users may need to change all '\\' to '\/' in pathname).\";\r\n\r\nI submit only the \"custom_strings_inc.php\" file since somebody should verify that the syntax above is not problematic on non-Windows systems (i'm not certain about the '\\' and '\/' part). Then it could be folded into the main distribution.\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-01-18T23:27:36-05:00","updated_at":"2006-02-10T14:25:59-05:00"},{"id":12043,"reporter":{"id":6986,"name":"mgfeller"},"text":"First, thanks for the great work!\r\n\r\nI have applied a few changes to import_issues.php and hope that they are usefull. The reason was that I could not import data, receiving application error 11. Basically, in the section that creates the bug entries from the temporary table, columns are now referenced by key instead of by index number, and the loop has been changed to a for loop. The PHP Version used in my environment is 4.4.2, and Mantis is 0.19.3. \r\n\r\nI don't know if I should supply a new version or if you, gtomlin, will incorporate my changes. Also, I'm not sure whether my changes will work in other versions of PHP etc. My changes are based on mantis_import_issues_v6.zip.\r\n\r\nPlease let me know how I can best submit my suggestions.\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-01-30T16:16:18-05:00","updated_at":"2006-01-30T16:18:02-05:00"},{"id":12044,"reporter":{"id":5496,"name":"gtomlin"},"text":"mgfeller, Victor and others have changed this script substantially since I last touched it (which was _v3). I don't presently have any time to work on this, and I wouldn't want everyone else waiting for me because the last note mentioned my user name!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-01-30T17:50:10-05:00","updated_at":"2006-01-30T17:50:10-05:00"},{"id":12268,"reporter":{"id":7129,"name":"MPA"},"text":"Using version 6!\r\n\r\nWhen I try to import a file I get this error message:\r\nAPPLICATION ERROR 11\r\n    A necessary field '' was empty. Please recheck your inputs.\r\n\r\nDoes it has to be txt file? I used a csv file.\r\n\r\nI put my file on the server in the root of my Mantis directory and still I'm getting this error message.\r\n\r\nWhat am I doing wrong??","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-03-02T10:54:12-05:00","updated_at":"2006-03-02T10:54:12-05:00"},{"id":12280,"reporter":{"id":6986,"name":"mgfeller"},"text":"MPA, try mantis_import_issues_v6.1.zip which incorporates my changes as well as custom_strings_inc.zip submitted by atomoid.\r\n\r\nmichael","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-03-03T12:51:21-05:00","updated_at":"2006-03-03T12:51:21-05:00"},{"id":12322,"reporter":{"id":7233,"name":"wade_albright"},"text":"I am using 6.1 with mantis 1.0.1. Not sure if that is supposed to be supported or not, but I get the:\r\n\r\n APPLICATION ERROR 11\r\n    A necessary field '' was empty. Please recheck your inputs.\r\n\r\nNo matter what I try when using the import page. I tried importing only the 2 required fields, and setting all the rest to either default or expclitly setting, same error as above.\r\n\r\nIs there a way to turn on some sort of logging besides \"a required field was empty?\" Maybe print out the name of the field that was empty? Or maybe that error message is just a red herring.\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-03-10T14:00:35-05:00","updated_at":"2006-03-10T14:04:27-05:00"},{"id":12323,"reporter":{"id":3081,"name":"vboctor"},"text":"wade_albright, do you have a custom field that is required when submitting a new issue?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-03-10T17:09:20-05:00","updated_at":"2006-03-10T17:09:20-05:00"},{"id":12324,"reporter":{"id":7233,"name":"wade_albright"},"text":"vboctor, no, not that i know of. i'm just using 1.0.1 out of the box.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-03-10T17:26:17-05:00","updated_at":"2006-03-10T17:26:17-05:00"},{"id":12332,"reporter":{"id":7129,"name":"MPA"},"text":"Using Mantis version 1.0.1 with import v6.1 gives me the following error;\r\n\r\nWith the import file on the server in the Mantis root folder;\r\nAPPLICATION ERROR #401 \r\nDatabase query failed. Error received from database was #1045: Access denied for user: 'parlitco@localhost' (Using password: YES) for the query: LOAD DATA INFILE \"\/tmp\/phpNnxdiN\" REPLACE INTO TABLE mantis_import_issues_table FIELDS TERMINATED BY \";\" LINES TERMINATED BY \"\\r\\n\" (reporter,priority,severity,reproducibility,status,resolution,category,view_state,summary,description,\r\ncustom_field_2,custom_field_5,custom_field_9,custom_field_3,custom_field_4,custom_field_8);\r\n \r\nIt seams that I don't have autorisation for de DB. This seems not correct. I'm sure that I'm using the correct name and password. But what about localhost? MySQL is running on the server at my provider. Maybe this has got something to do with it?\r\n \r\nAnd maybe someone can attach a demo import file which is working correctly, so I can check\/test this out?\r\n\r\nEDIT: dregad 2011-11-01 break long lines to avoid horizontal scrolling\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-03-14T04:45:27-05:00","updated_at":"2011-11-01T11:48:17-04:00"},{"id":12335,"reporter":{"id":6986,"name":"mgfeller"},"text":"I'm afraid I have tested mantis_import_issues_v6.1.zip only with Mantis 0.19.3. I hope to use Mantis 1.0.1. soon... and then maybe extend the error messages, if at all possible. The app err 11 usually meant (for me) that the parsing didn't work at all.\r\n\r\nAre field delimiter and end of line marker ok? Does your data make it into the temporary table (result of LOAD DATA INFILE ...)?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-03-14T06:29:58-05:00","updated_at":"2006-03-14T06:29:58-05:00"},{"id":12353,"reporter":{"id":7129,"name":"MPA"},"text":"Are field delimiter and end of line marker ok? Does your data make it into the temporary table (result of LOAD DATA INFILE ...)? \r\n\r\nYes, It seems that all other variables are ok. And no, the temporary table is not filled.\r\n\r\nI'm getting very close!\r\nI'm not sure if my import file is correct. Maybe someone can confirm this. In my import file i'm using the id's for the reporter, status, severity, view status, etc.\r\nLike this; 10;20;10;30;10;etc.\r\n\r\nIs it possible that someone can sent me a import example file, where every column is used, including which columns i have to set on 'import', 'default' or 'Set all to'?\r\nI would appriciate that very much.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-03-16T09:55:28-05:00","updated_at":"2006-03-16T09:55:28-05:00"},{"id":12738,"reporter":{"id":7479,"name":"arnov2"},"text":"I tried the 6.1 version on a system where the mysql server runs on a windows machine, and the apache\/php runs on a FreeBSD machine. I placed the import file on the windows machine, and checked the 'server based' checkbox.\r\nThis did not work. The gpc_get_file() function assumes that the file can be approached  from the php\/apache server, which was not the case. After changing file input to an ordinary text input, the script ran succesfully.\r\n\r\nUnchecking the 'server based' check box gave a lot of problems with MySQL rights. I  could not figure out how to handle this.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-04-27T09:20:04-04:00","updated_at":"2006-04-27T09:20:04-04:00"},{"id":12855,"reporter":{"id":7584,"name":"rudy"},"text":"I'm trying to use the 6.1 version on a windows system with easyphp installed. Im having the following error message: \r\n\r\nError 401: database query failed.\r\n\r\nI'm using a very simple file to test the import feature, i tried to manually launch the query \"load data infile...\" in the temporary table, it worked perfectly. Any idea where the problem comes from?\r\n\r\nBy the way i would need to do the import manually for some reasons, could anyone tell me how to build the queries i will need to do it?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-05-17T05:18:26-04:00","updated_at":"2006-05-17T05:18:26-04:00"},{"id":13116,"reporter":{"id":7664,"name":"ewyssa"},"text":"I use the \"issue import v6.1\" with Mantis V1.0.3. On the mysql server the \"local infile\" option is enabled. Still I get an error:\r\n<pre>Database query failed. Error received from database was #1148: The used command is not allowed with this MySQL version for the query: LOAD DATA LOCAL INFILE \"\/tmp\/php20HwUP\" REPLACE INTO TABLE mantis_import_issues_table FIELDS TERMINATED BY \";\" LINES TERMINATED BY \"\\r\\n\" (reporter,summary,description);<\/pre>\r\n\r\nHow can I avoid this and import an issue?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-07-19T10:46:37-04:00","updated_at":"2006-07-19T10:46:37-04:00"},{"id":13123,"reporter":{"id":7664,"name":"ewyssa"},"text":"Sorry I don't saw before but ~10919 solved the problem.\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-07-20T04:23:24-04:00","updated_at":"2006-07-20T04:28:48-04:00"},{"id":13188,"reporter":{"id":7692,"name":"mbernigaud"},"text":"The custom field date type where imported as String.\r\nI added few lines to convert the String date of the CSV to a real date type in the database:\r\n\r\n# August 2006 - mBernigaud : don't set empty date -->\r\nif ( $t_custom_field_value != '') {\r\n# August 2006 - mBernigaud : Convert string date to its internal value\t\t\tif ( $t_def['type'] == CUSTOM_FIELD_TYPE_DATE ) {\r\n   $t_custom_field_value = strtotime( $t_custom_field_value ) ;\r\n}\t\t\r\nif( !custom_field_set_value( $t_id, $t_bug_id, $t_custom_field_value ) ) {\r\n   echo '<p>' . lang_get( 'import_custom_field_failure' ) . $t_def['name'] . ' :   \r\n   ' . $t_summary . '<\/p >';\r\n   $t_error_count++;\r\n   $t_error = true;\r\n   }\r\n}\r\nThe v6.1.1 includes this fix\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-08-04T03:51:20-04:00","updated_at":"2006-08-04T04:04:45-04:00"},{"id":13370,"reporter":{"id":7767,"name":"carp3tshark"},"text":"I'm currently (9\/12\/2006), unable to download the files. They download to a 0k file. Not sure if this has to do with the recent domain change. Also, I'm hoping there are some instructions within the file about the installation and use. If not I plan to write some and will post them if desired by others.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-09-12T09:41:53-04:00","updated_at":"2006-09-12T09:41:53-04:00"},{"id":13372,"reporter":{"id":6445,"name":"atomoid"},"text":"carp3tshark ,\r\n\r\nThis probably ocurred when Mantis switched their nameserver or upgraded to 1.1a1\r\nA similar thing happened to me as noted in this forum post: http:\/\/forums.mantisbugtracker.com\/viewtopic.php?t=307\r\nI already sent a note to Victor.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-09-12T13:19:36-04:00","updated_at":"2006-09-12T13:19:36-04:00"},{"id":13426,"reporter":{"id":8196,"name":"jbatop"},"text":"Hello\r\n\r\nWhere are attached files ?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-09-21T16:11:46-04:00","updated_at":"2006-09-21T16:11:46-04:00"},{"id":13428,"reporter":{"id":6445,"name":"atomoid"},"text":"Since this hasnt been fixed yet, i uploaded the most recent version i had,\r\nwhich of course, isnt the most recent version.\r\n\r\nI titled it \"mantis_import_issues_v6.1--reuploaded.zip\" since it wouldnt let me upload a duplicate name, anyway there it is...\r\n\r\nin a pinch you can roll in the 6.1.1 fix noted in the post above: (0013188) mbernigaud\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-09-21T18:40:28-04:00","updated_at":"2006-09-21T18:44:32-04:00"},{"id":13725,"reporter":{"id":7488,"name":"hmackiernan"},"text":"Hello:\r\nI couldn't find this documented anywhere\r\nWhat is the expected value for Status in an import file?\r\nI've tried both the literal string\r\nNew\r\nand the numeric constant\r\n10\r\nand both seem to get munged to zero (0) on import.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-11-15T18:21:35-05:00","updated_at":"2006-11-15T18:21:35-05:00"},{"id":13839,"reporter":{"id":6246,"name":"ave"},"text":"I found a problem in the 'mantis_import_issues_v6.1--reuploaded.zip'.\r\n'View Status' is set to public even if I set 'Set all to' as private.\r\n\r\nIt was easy to fix.\r\nThe line 511 of import_issue.php\r\n\r\n} else if ( $f_buildx == IMPORT_USE_CONST_VALUE ) {\r\n\r\nshould be\r\n\r\n} else if ( $f_view_statex == IMPORT_USE_CONST_VALUE ) {","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-12-18T01:18:16-05:00","updated_at":"2006-12-18T01:18:16-05:00"},{"id":13847,"reporter":{"id":8305,"name":"RyanR"},"text":"Does anyone have a 1.1.0a2 patch for this feature? Also, will it eventually be easy to use the same php extension to export issues to a file as well?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-12-19T15:44:16-05:00","updated_at":"2006-12-19T15:44:16-05:00"},{"id":13876,"reporter":{"id":8657,"name":"midtoad"},"text":"I've tried a multiplicity of different combinations trying to get the csv importer to work.  It appears that it doesn't respect the order of the fields that I put in my csv file, based on what I can see from the error message. Here's my input file (containing 2 lines) which imports data for every single field in the 'import issues' page:\r\n\r\n\"reporter\";\"handler\";\"priority\";\"severity\";\"reproducibility\";\"status\";\"resolution\";\"category\";\"date_submitted\";\r\n\"os\";\"os_version\";\"platform\";\"version\";\"fixed_in_version\";\"build\";\"view_status\";\"summary\";\"description\";\r\n\"reproduce\";\"info\";\"custom_field_2\";\"custom_field_1\";\"custom_field_3\"\r\n\"svermeul\";\"svermeul\";low;\"minor\";\"always\";\"closed\";\"open\";\"go\";\"1998-07-16\";\r\n\"win\";\"xp\";\"win\";\"none\";\"tip\";\"0\";\"private\";\"Default numeric format seetting\";\"Description: test\";\r\n\"how to reproduce\";\"more info\";\"date closed\";\"bug\";\"19838\"\r\n\r\nand here are the columns the importer says it's importing:\r\n(reporter,handler,priority,severity,reproducibility,status,resolution,category,date_submitted,\r\nos,os_build,platform,version,fixed_in_version,build,view_state,summary,description,\r\nreproduce,info,custom_field_2,custom_field_3,custom_field_1)\r\n\r\nbut notice the error message:\r\n***error*** importing custom field PR_number : \"Default numeric format seetting\"\r\n\r\nit's complaining about the last field in the input file, but the data that it says it received for that field is actually from a field in the middle of the line.\r\n\r\nWould anyone have a sample record that actually works?  Please post it here for everyone to see or drop me a line at stewart 'at' midwinter 'dot' ca. \r\n\r\nthanks so much!\r\n\r\nEDIT: dregad 2011-11-01 break long lines to avoid horizontal scrolling\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-12-29T22:01:56-05:00","updated_at":"2011-11-01T11:50:47-04:00"},{"id":13877,"reporter":{"id":8657,"name":"midtoad"},"text":"BTW, I'm running Mantis 1.06 and mySQL 4.1.20.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2006-12-29T22:02:50-05:00","updated_at":"2006-12-29T22:02:50-05:00"},{"id":13886,"reporter":{"id":6246,"name":"ave"},"text":"midtoad, what happens if you remove double quotation marks for each fields?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2007-01-01T10:39:29-05:00","updated_at":"2007-01-01T10:39:29-05:00"},{"id":13928,"reporter":{"id":8657,"name":"midtoad"},"text":"removing the double quotations from all fields except those with commas in the text has no impact on the importer.  It still appears to process the fields in the wrong order. \r\n\r\nThis is a blocker issue for me. I can't use Mantis if I'm unable to import my existing issues.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2007-01-16T14:58:53-05:00","updated_at":"2007-01-16T14:58:53-05:00"},{"id":14248,"reporter":{"id":6246,"name":"ave"},"text":"I have attached 'mantis_import_issues_v7.zip' which allows you to import 'target version' introduced in 1.1.0.\r\nIt also contains fixes reported in ~13188 and ~13839.\r\n\r\nNotes:\r\n- The 'target version' is displayed only in mantis 1.1.0a1 or later.\r\n- The 'category' field is required in 1.1.0 (#7801).\r\n\r\nTested on:\r\n- Mac OS X 10.4.9 \/ MySQL 5.0.27 (utf-8) \/ Mantis 1.0.6\r\n- Mac OS X 10.4.9 \/ MySQL 5.0.27 (utf-8) \/ Mantis 1.1.0 (latest CVS)\r\n- Debian 3.1 \/ MySQL 5.0.27 (utf-8) \/ Mantis 1.1.0 (latest CVS)\r\n\r\n--\r\nmidtoad,\r\nSorry, I missed the point in my last comment.\r\nYou cannot specify the order of fields. See the usage section of the 'readme.txt'.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2007-03-26T12:54:34-04:00","updated_at":"2007-03-26T12:54:34-04:00"},{"id":14575,"reporter":{"id":8390,"name":"akocel"},"text":"I use v6.1 import function and have fixed in it a bug relative to custom fields of type date : their values need to be converted to php internally format by\r\nstrtotime function.\r\n\r\nSee import_issue.php uploaded 2007-05-21 10:15 (sorry I forgot to suffix it\r\nwith v6.1)","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2007-05-21T10:19:35-04:00","updated_at":"2007-05-21T10:19:35-04:00"},{"id":14674,"reporter":{"id":5594,"name":"deboutv"},"text":"Hi, \r\n\r\nI have written a plugin to import\/export data from\/to Mantis. Import supports only XML format at this time but other formats will be supported soon. \r\nhttp:\/\/deboutv.free.fr\/mantis\/plugin.php?plugin=importexport","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2007-06-05T04:01:42-04:00","updated_at":"2007-06-05T04:01:42-04:00"},{"id":18302,"reporter":{"id":10406,"name":"sveyret"},"text":"I added a new importer inspired by the one posted by ave. This one allow to import CSV files, where columns are in any order you want. It also can update issues, instead of creating them if you have a bug id column. And finally, it does not use the MySQL load data functionality (which was not working in my firm), but only Mantis PHP functions, and therefore is compatible with any supported database.\r\nSee csv_import-1.0.tgz\r\n\r\nHope this can help.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2008-07-04T09:23:41-04:00","updated_at":"2008-07-04T09:23:41-04:00"},{"id":18581,"reporter":{"id":10406,"name":"sveyret"},"text":"There is an error in the script I uploaded in import_issues.php at line 117. This line should be:\r\n\t$t_bug_exists = array_search( 'id', $f_columns ) !== false;","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2008-07-16T06:58:31-04:00","updated_at":"2008-07-16T06:58:31-04:00"},{"id":18623,"reporter":{"id":11123,"name":"Buga"},"text":"I just tested the Import but the import of custom fields dont work at all\r\nI am using mantis 1.1.1.\r\n\r\nAll other data is imported correctly.\r\nAny idea whats wrong?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2008-07-21T05:43:51-04:00","updated_at":"2008-07-21T05:43:51-04:00"},{"id":18627,"reporter":{"id":11123,"name":"Buga"},"text":"I found the problem...\r\nthere is a little bug in the import_issue.php\r\nat line 246 the custom fiels are retrieved but without a custom_\r\nThats why they cant be found later\r\n\r\nFor my needs I simply added a line\r\n# Look if this field is set\r\n$t_def = custom_field_get_definition( $t_id );\r\n$t_def['name']=\"custom_\".$t_def['name'];","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2008-07-21T10:08:32-04:00","updated_at":"2008-07-21T10:08:32-04:00"},{"id":19016,"reporter":{"id":3081,"name":"vboctor"},"text":"We should consider re-developing this patch as a plugin for Mantis 1.2.x.  I will look into it when I get a chance unless someone else beats me to it.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2008-08-04T09:42:18-04:00","updated_at":"2008-08-04T09:42:18-04:00"},{"id":19430,"reporter":{"id":12096,"name":"osterwaldi"},"text":"Is it possible to transform this tool that a note can be imported. Should have a note for this ID exist, a new note added.\r\nWould it be possible to the text separator ',' or ';' return to the options presented?\r\n\r\nGreeting\r\nosterwaldi\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2008-09-23T08:53:30-04:00","updated_at":"2008-09-23T09:17:45-04:00"},{"id":19499,"reporter":{"id":12151,"name":"uso"},"text":"I wanted to write something about the new file csv_import-1.0.1.zip,\r\nbut there occured an error in database_api.php as i tryed to send my text.\r\n\r\nThat is why the note I wrote was posted so often.\r\nI'm sorry about this, i have deleted all previous notes of mine with same content.\r\n\r\nuso\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2008-10-06T10:38:26-04:00","updated_at":"2008-10-06T11:30:59-04:00"},{"id":19500,"reporter":{"id":12151,"name":"uso"},"text":"I have done some little work on the CSV Import plugin.\r\nIt is now able to work as plugin for Mantis version > 1.2.0.\r\nAlso I've implemented some features, like automatically adding handlers,\r\nif they are listed in the CSV-File and do not exist in the database.\r\n\r\nI made changes to CSV Import 1.0 only for my company,\r\nintentionally it was not planned to release the changes.\r\nBut now I saw it helped me a lot, so I released it.\r\n\r\nI hope it will help somebody, too. But do not treat me if it does not. ;-)\r\n\r\n(I'm sorry to the developers, my coding style is not what it should be...)\r\n\r\nuso\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2008-10-06T11:06:07-04:00","updated_at":"2008-10-06T11:34:24-04:00"},{"id":20946,"reporter":{"id":13053,"name":"prabhurangan"},"text":"Dear Members,\r\n\r\nI am so confused in choosing the right version of mantis.\r\n\r\nI need import option in mantis 1.1.6, where the other plugins like myViewIssues,Hierarchy plugins are to be supported by this.....\r\n\r\nPlease do let me know, how to use and which one to use with mantis 1.1.6 to have the option to import in to CSV or XML format.\r\n\r\nIs there anyway by means of customization, we could use the import\/export plugin version 0.0.4 to use with mantis1.1.6\r\n\r\nRegards,\r\nPrabhu.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-02-26T04:24:15-05:00","updated_at":"2009-02-26T04:24:15-05:00"},{"id":21009,"reporter":{"id":12628,"name":"thungp"},"text":"I'm also looking for an import excel feature and wondering if 1.1.6 has it.\r\nI'd also like to suggest for consideration that an import feature keep this in mind.\r\n1.  Keep track of what was imported and check for duplication so we don't contaminate the core Mantis issues table with duplicate entries.\r\n2.  Take into consideration concepts like updating existing mantis issues if the imported data is an update to an existing issue based on some correlation field like say some unique ID from another system that Mantis is also tracking.\r\n3.  have an ability to determine what the default behavior is of certain fields such as status or category and whether or not an import where there is already an existin mantis issue on whether to update the field or let the existing field take precedence.   One thing which can complicate matters is to possible code Mantis to determine if it's fields have the concept of Null, where the person entering in the issue did not know the value of the field versus it was a default value. Should an update update a null value?  I think yes. Should an update update a defaulted value? It depends.  If the defaulted value has a value like Unknown I think it should update that value because it is equivalent to Null, however, if a field has a value of Resolved for example, I may not want this third party import updating what I may have painstankenly figured out and changed manually.\r\n\r\n4. This brings up the point of possibly having an intermediary view of potentially imported values where a test import could occur and a comparison view opens up showing a diff on the merge and allow a human to determine which field (either the existing mantis field or the imported field) should take precedence or the option of changing it all together.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-05T16:45:39-05:00","updated_at":"2009-03-05T16:45:39-05:00"},{"id":21051,"reporter":{"id":7780,"name":"cas"},"text":"Needed to import issues into 1.2 and adjusted this plugin to fit my needs.\r\nNow no more manual action, also added the due-date column to be imported.\r\nVersion 1.1.0 at your service!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-16T06:38:19-04:00","updated_at":"2009-03-16T06:38:19-04:00"},{"id":21052,"reporter":{"id":13053,"name":"prabhurangan"},"text":"@cas\r\n\r\nCas will this CSV import work with mantis 1.2.0a3, please let me know.  Already i have XML import contributed by you.  Now please let me know how to use this CSV import with the XML import.\r\n\r\nRegards,\r\nPrabhu","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-16T06:45:59-04:00","updated_at":"2009-03-16T06:45:59-04:00"},{"id":21060,"reporter":{"id":7780,"name":"cas"},"text":"The XML is not by me.\r\nThis one works with 1.2.0a3, no problems","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-16T13:32:05-04:00","updated_at":"2009-03-16T13:32:05-04:00"},{"id":21066,"reporter":{"id":13053,"name":"prabhurangan"},"text":"Oh yes, Reminder is by you......","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-16T23:43:01-04:00","updated_at":"2009-03-16T23:43:01-04:00"},{"id":21067,"reporter":{"id":13053,"name":"prabhurangan"},"text":"Dear All,\r\n\r\nI have an issue with XML import;  It is working fine in WINDOWS machine, but it throws some error in LINUX machine;  Any one faced this issue.  \r\nI would like to know where the imported files are kept by mantis, while importing issues.  Also Export feature is also not working in LINUX.  \r\n\r\nOr it would be a file permission in LINUX.\r\n\r\nError:\r\nError i faced is, The file could not be found at http:\/\/localhost\/mantis\/plugin.php=ImportExport\/Import-action\r\n\r\nRegards,\r\nPrabhu.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-16T23:48:52-04:00","updated_at":"2009-03-16T23:48:52-04:00"},{"id":21068,"reporter":{"id":13053,"name":"prabhurangan"},"text":"Dear All,\r\n\r\nI am facing this issue while trying to import issues using CSV Import:\r\n\r\nFatal error: Call to undefined function explode_enum_arr() in C:\\Documents and Settings\\prabhu_rangan\\workspace\\mylo\\plugins\\Csv_import\\pages\\import_issues.php on line 76\r\n\r\nPlease anyone let me know what is wrong with this.\r\n\r\nAlso which are the required fields to import CSV issues, to create new issues; like the attribute 'ID' should be specified '0'\r\n\r\nRegards,\r\nPrabhu","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-17T01:46:32-04:00","updated_at":"2009-03-17T01:46:32-04:00"},{"id":21069,"reporter":{"id":7780,"name":"cas"},"text":"Add the following code @ the end of import_issues_inc.php (before the closing tag):\r\n\t# --------------------\r\n\t# Given one num:value pair it will return both in an array\r\n\t# num will be first (element 0) value second (element 1)\r\n\tfunction explode_enum_arr( $p_enum_elem ) {\r\n\t\treturn explode( ':', $p_enum_elem );\r\n\t} \r\n\r\nHave updated my source also.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-17T03:22:23-04:00","updated_at":"2009-03-17T03:22:23-04:00"},{"id":21118,"reporter":{"id":13053,"name":"prabhurangan"},"text":"@cas\r\n\r\nI am facing this isssue, do i have to add a function same as to 'explode_enum_arr()'\r\n\r\nFatal error: Call to undefined function explode_enum_string() in C:\\Documents and Settings\\prabhu_rangan\\workspace\\mylo\\plugins\\Csv_import\\pages\\import_issues.php on line 73","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-20T05:29:11-04:00","updated_at":"2009-03-20T05:29:11-04:00"},{"id":21119,"reporter":{"id":13053,"name":"prabhurangan"},"text":"@cas \r\n\r\nSorry cas, its my mistake.\r\n\r\nNo issue","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-20T05:35:46-04:00","updated_at":"2009-03-20T05:35:46-04:00"},{"id":21120,"reporter":{"id":13053,"name":"prabhurangan"},"text":"@cas\r\n\r\nI have added a custom_field 'Deadline' and 'Est.' hours to my view issues and while importing issue to CSV, i need to import values to these two fields also, how shall i perform it.\r\n\r\nIn the '$g_all_fields' array i have mentioned my default columns for import, but after importing i could not see the values imported for these two fields.\r\n\r\nCan you please share your ideas","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-20T05:47:52-04:00","updated_at":"2009-03-20T05:47:52-04:00"},{"id":21122,"reporter":{"id":7780,"name":"cas"},"text":"Custom fields will show up in the list of available fiedls automatically.\r\nPlease do not change the code for this but ensure that the custom fields are connected to the project in which you are importinh.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-03-20T06:26:14-04:00","updated_at":"2009-03-20T06:26:14-04:00"},{"id":21410,"reporter":{"id":13434,"name":"nobswolf"},"text":"it should bring up some error messages if type or content of columns do not match\r\n\r\nin some cases like invalid values for category you do not get HTML at all\r\n\r\nin that respect also two feature requests:\r\n\r\n- create the entries in the column of the CSV as new possible values for that column\r\n\r\n- create a column of the CSV as new custom column\r\n\r\napart from that: a real good tool; it makes mantis a lot more usefull than it already is, great work, thanks\r\n\r\nBTW: does the CSV import has an own web page? maybe this plugin is enough of a project of its own so it should its own tracker","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-07T02:28:48-04:00","updated_at":"2009-04-07T02:28:48-04:00"},{"id":21413,"reporter":{"id":13434,"name":"nobswolf"},"text":"feature request:\r\n\r\nmatch automagically columns with same name\r\n\r\nadvantage: you could prepare the import in the application that generates the CSV without matching each column manually during the import\r\n\r\neven moving issues from one mantis system to another would be very easy that way","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-07T04:25:31-04:00","updated_at":"2009-04-07T04:25:31-04:00"},{"id":21414,"reporter":{"id":7780,"name":"cas"},"text":"Although I started this tool in the past, GTOMLIN took over. I then converted the latest code into a plugin sinci I was excercising plugin development and used 1.2.\r\nFor me this tool is good enough since one would only use it every now and then (at least that is my impression).\r\nBut if you (or someone else) would like to make this a continuous project, feel free to do so. The code is attached.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-07T05:07:13-04:00","updated_at":"2009-04-07T05:07:13-04:00"},{"id":21439,"reporter":{"id":11686,"name":"monotek"},"text":"Is this patch scheduled to find its way into the next release (1.2.x)?\r\n\r\nIs it possible to import files via linux shell?\r\n\r\nI dont want to login as admin to import csv files but would upload it via ftp to mantis temp directory. This file should get imported by a cronjob\/shellscribt.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-08T10:59:35-04:00","updated_at":"2009-04-08T10:59:35-04:00"},{"id":21457,"reporter":{"id":7780,"name":"cas"},"text":"It is not a patch but a plugin and it is available for 1.2\r\nThere is a xml import\/export which perhaps can be scheduled.\r\nThis plugin does not support it.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-09T16:03:07-04:00","updated_at":"2009-04-09T16:03:07-04:00"},{"id":21484,"reporter":{"id":13053,"name":"prabhurangan"},"text":"@cas\r\n\r\nIn this csv import plugin, while importing issues a default category named 'csv_imported' is created and if the category field is given empty or if it is missed out, the default category created is assigned.  Instead it would be nice to have a validation if the category field is left empty while importing issues.\r\n\r\nAs for now it looks odd to have a category named 'csv_imported' in the category table as it does not mean anything.\r\n\r\nPlease let me know your suggestions in this.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-13T04:35:13-04:00","updated_at":"2009-04-13T04:35:13-04:00"},{"id":21507,"reporter":{"id":12151,"name":"uso"},"text":"@prabhurangan\r\n\r\nat the time i've (re)written the plugin for version 1.2.x it was impossible to\r\nimport bugs without a category.\r\nthe project i have had consisted of a very large csv so i was to lazy to look through all the listed bugs in this csv and set the categroy where left blank.\r\n\r\nalso it was too much to collect it by the time of the import and then give an error to the importer, because then he\/she would have had to fix this by hand.\r\nthe goal was to import the issues and the user(s) which was\/were assigned to the bug(s) has\/have to collect und correct the the empty fields by him-\/herself.\r\n\r\nso i've decided to write a fallback to make it possible to import issues without category and collect them under \"csv_imported\" so the users have a place were they can look for their bugs and assign them correct.\r\n\r\nbest regards\r\nuso","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-14T05:32:03-04:00","updated_at":"2009-04-14T05:32:03-04:00"},{"id":21509,"reporter":{"id":13053,"name":"prabhurangan"},"text":"@uso\r\n\r\nYa i could understand.  As 'Category' is a mandatory field in 1.2.x while creating issues.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-14T05:58:57-04:00","updated_at":"2009-04-14T05:58:57-04:00"},{"id":21628,"reporter":{"id":13053,"name":"prabhurangan"},"text":"@cas\r\n\r\nI have a big issue, in DueDate Reminder notification:  It is working fine in windows; however if set it as a cron job in Liniux machine, it is not working.  Also i am not receiving emails.  When i checked it, we will be giving a syntax like \"*\/1440 *  *  *  * lynx  --dump  http:\/\/mantis.homepage.com\/plugin.php?page=Reminder\/bug_reminder_mail.php\"  and in this \"lynx\" is a text based browser and I installed it in linux machine, even now i am not receiving any emails.  If I execute the cron job, it shows me the \"login_page.php\" It shows the text content in that page.  But the notifications is not coming.\r\n\r\nPlease let me know your thoughts....","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-22T16:52:03-04:00","updated_at":"2009-04-22T16:52:03-04:00"},{"id":21632,"reporter":{"id":7780,"name":"cas"},"text":"You should really post under the correct issue. This is not about the reminder plugin.\r\nThe problem looks like an authorisation issue. I have no linux config available so cannot check.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-04-23T03:37:25-04:00","updated_at":"2009-04-23T03:37:25-04:00"},{"id":21782,"reporter":{"id":10581,"name":"jojow"},"text":"great job for this plugin!!!\r\nI've uploaded a german translation for the strings.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-05-06T07:48:46-04:00","updated_at":"2009-05-06T07:48:46-04:00"},{"id":21789,"reporter":{"id":13655,"name":"mantistestor"},"text":"Great plugin! But it doesnt work for me. I have a problem with importing a csv. Probably i used a wrong tabledefinition. does it exist a example-csv?\r\nthx,","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-05-07T08:28:38-04:00","updated_at":"2009-05-07T08:28:38-04:00"},{"id":21790,"reporter":{"id":12151,"name":"uso"},"text":"configure your mantis as you want (custom fields, etc.),\r\nadding some test case users, bogus bugs and so on...\r\n\r\nif you've done this, use native mantis EXport capabilities to\r\nexport your db to a csv.\r\n(dont forget to make the CSV columns fit to your needs.\r\n=> http:\/\/<your_mantis_sleeps_here>\/adm_config_report.php\r\nor even better \r\n=> http:\/\/<your_mantis_eats_here>\/manage_config_columns_page.php)\r\n\r\nthen open the csv and see ... .\r\n\r\nbest regards\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-05-07T08:54:09-04:00","updated_at":"2009-05-07T08:55:21-04:00"},{"id":22041,"reporter":{"id":13847,"name":"decep"},"text":"Uploaded csv_import-1.0a_mantis1.1.tgz.  Tested against Mantis 1.1.7\r\n\r\nChanges:\r\n * For some reason all dates were being converted to epoch when they need to be mysql formatted dates (removed all \"strtotime\" calls).\r\n * Comment #0018627\r\n * Typo on line 83 of import_issues.php\r\n\r\nChanges were made to csv_import-1.0.tgz which I believe is the last version compatible with Mantis 1.1.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-06-03T16:39:57-04:00","updated_at":"2009-06-03T16:39:57-04:00"},{"id":22068,"reporter":{"id":13847,"name":"decep"},"text":"I made a mistake in \"csv_import-1.0a_mantis1.1.tgz\" so do not download.  If somebody can delete, please do so.\r\n\r\n\"csv_import-1.0b_mantis1.1.tgz\" is the replacement.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-06-09T23:01:45-04:00","updated_at":"2009-06-09T23:01:45-04:00"},{"id":23629,"reporter":{"id":15364,"name":"squarebox"},"text":"using csv_import-1.0b_mantis1.1.tgz\r\n\r\nthe column detection is case-sensitive, i.e. if you have \"id\" instead of \"ID\" no columns will be detected","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2009-11-09T21:14:54-05:00","updated_at":"2009-11-09T21:14:54-05:00"},{"id":25105,"reporter":{"id":15745,"name":"vidalpj"},"text":"sorry.. but could someone provide an example csv? thanks..","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-04-12T10:21:04-04:00","updated_at":"2010-04-12T10:21:04-04:00"},{"id":25163,"reporter":{"id":17019,"name":"Fyb3roptik"},"text":"I get Issue 0 not found when I try to import. I am using Mantis 1.2.0 on a fresh install.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-04-20T10:58:13-04:00","updated_at":"2010-04-20T10:58:13-04:00"},{"id":25368,"reporter":{"id":17129,"name":"robertog"},"text":"Hi all, i'm experiencing the same problem posted by Fyb3roptik : csv file correctlyt read and values displayed,  however, starting rows importation in to the database,  data importing stops immediately displaying following error message : \r\n\"Message header = APPLICATION ERROR #1100\"\r\n\"Message  body = Issue 0 not found\" \r\ni'm trying to find out why; \r\nmy environment is : \r\nMantis version : 1.2.0\r\nSchema version : 182\r\nImporting patch version : thus belonging to uploaded folder : csv_import-1.0b_mantis1.1\r\nThanks in advance !\r\nRoberto","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-03T04:09:27-04:00","updated_at":"2010-05-03T04:09:27-04:00"},{"id":25372,"reporter":{"id":13847,"name":"decep"},"text":"It is rather confusing, but csv_import-1.0b_mantis1.1 is only for Mantis 1.1.x.  You will have to read through all of the comments to determine which versions are compatible with 1.2.x.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-03T12:58:33-04:00","updated_at":"2010-05-03T12:58:33-04:00"},{"id":25382,"reporter":{"id":16731,"name":"Andi3938"},"text":"So which version is compatible with mantisbt 1.2.0 and which with 1.2.1?\r\n\r\nI'd like to import about 200 issues from a excel spread sheet. I tried the xml import with no success. Even a reimport (xml export -> xml import) does not work (bug 0010794) and does not support custom fields (bug 0011876).\r\n\r\nThis plugin is my last hope. Or are there other ways (not manually) to import a bulk of issues?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-03T17:25:11-04:00","updated_at":"2010-05-03T17:25:11-04:00"},{"id":25534,"reporter":{"id":17265,"name":"andy778"},"text":"To get csv import to work under 1.2.x, what is the recommended way forward?\r\n- Port this to a plugin e.g plugins\/CsvImportExport\r\n- Should one extend plugins\/XmlImportExport for more formats similar to the import\/export plugin found from http:\/\/deboutv.free.fr\/mantis\/\r\n- ?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-18T15:14:40-04:00","updated_at":"2010-05-18T15:14:40-04:00"},{"id":25535,"reporter":{"id":7780,"name":"cas"},"text":"csv_import110.zip is for mantis 1.2.x","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-18T15:59:58-04:00","updated_at":"2010-05-18T15:59:58-04:00"},{"id":25571,"reporter":{"id":17320,"name":"junkmyfunk"},"text":"Installed csv_import110.zip as plugin in fresh install on Mantis 1.2.0, schema 183 and I'm also getting the error \"APPLICATION ERROR #1100 Issue 0 not found\" whenever I try to import. \r\n\r\nMy csv file is uploaded, the headers are automatically recognised and the drop-downs set to the corresponding columns but clicking import throws that error.\r\n\r\nAnyone got any ideas what causes this?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-20T12:11:51-04:00","updated_at":"2010-05-20T12:11:51-04:00"},{"id":25572,"reporter":{"id":7780,"name":"cas"},"text":"Found that I had version 1.11 on the shelf.\r\nPlease verify, if it gives problems, please attaced sample csv file to this issue so I can investigate.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-21T03:49:33-04:00","updated_at":"2010-05-21T03:49:33-04:00"},{"id":25580,"reporter":{"id":17320,"name":"junkmyfunk"},"text":"@cas\r\n\r\nFound a couple of issues with this: The \"APPLICATION ERROR #1100 Issue 0 not found\" is being triggered on line 261 of import_issues.php - when $t_default->description is used, the BugData class attempts to get the description from the DB but it doesn't have an id, since you're just using it to store default values. Setting a default description around line 220 avoids this issue.\r\n\r\nHowever, after doing this I'm getting Fatal error: Call to undefined function bug_create() on line 316\r\n\r\nI can also see a call to bug_update() which doesn't exist either.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-21T12:13:12-04:00","updated_at":"2010-05-21T12:13:12-04:00"},{"id":25582,"reporter":{"id":7780,"name":"cas"},"text":"send me the csv (or attach here) you use and I will fix the issues","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-21T13:37:01-04:00","updated_at":"2010-05-21T13:37:01-04:00"},{"id":25616,"reporter":{"id":7780,"name":"cas"},"text":"attached version 1.1.2 which handles reported issues.\r\nI also found that in your importfile some mandatory fields were not filled. That should be avoided since the import program will stop in those case.\r\nI have adjusted the importfile and saved again as csv (this time with semicolon as eperator). Next step clearly is to connect the columns to the proper fields.\r\nFinally it imported nicely.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-05-27T08:17:40-04:00","updated_at":"2010-05-27T08:17:40-04:00"},{"id":25755,"reporter":{"id":17486,"name":"kimkb"},"text":"Thanks for your cvs_import.\r\nEverything is good but exisiting issues cannot be updated.\r\nIssues always are created.\r\nThe cvs_import checks id columns well. \r\nCould you help me?\r\n(Mantis: Mantis 1.1.0rc1, csv_import-1.0b_mantis1.1.tgz)\r\ncvs file:\r\nID,Category,Status,Reproducibility,Severity,Summary,Description,Additional Information,Due Date,View Status\r\n114,SW,acknowledged,always,major,DB1 SRS Driver I\/F ? ?td>,DB1 SRS Chap 4.3 HW I\/F Driver I\/F ? ???.,,,public\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-06-08T05:02:39-04:00","updated_at":"2010-06-08T05:04:56-04:00"},{"id":25770,"reporter":{"id":17486,"name":"kimkb"},"text":"I found the solution to update the existing issues.\r\nThe CSV file must have all columns and order.\r\nIf you entered the exisiting issue id, the issue is updated.\r\nex)\r\nReporter (ID),Summary,Description,Steps To Reproduce,Additional Information,Category,Priority,Severity,Reproducibility,Date Submitted,Last Update,Assigned To (ID),Status,Resolution,OS,OS (Build),Platform,Version,Projection,ETA,Fixed in Version,Target Version,Build,View Status,ID\r\n,DB1 SRS Driver I\/F ? ?td>,DB1 SRS Chap 4.3 HW I\/F Driver I\/F ? ???.,,,SW,normal,minor,always,2010-06-08 15:19,2010-06-09 09:13,,acknowledged,open,,,,,none,none,,,,public,114","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-06-08T20:20:58-04:00","updated_at":"2010-06-08T20:20:58-04:00"},{"id":26106,"reporter":{"id":17823,"name":"kdcinfo"},"text":"The solution to updating existing issues does not work for me. I export a CSV to one file, make a minor change to the Excel file, export a second CSV file. I import file 1 no problem. Import file 2 and they're all new issues. No changes to the 'id' numbers at all.\r\n\r\nI'm trying to mess around too see what's what, and running into stuff like the \"$t_bug_exists\" variable coming back as 0 (my 'id' column is column 0 in the array) which evaluates to false when simply doing a boolean check on the varialbe (it as it does 4 times in the import_issues.php file). So I replaced the \"true\" condition to be ($t_bug_exists >= 0). No go :(","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-07-20T19:42:26-04:00","updated_at":"2010-07-20T19:42:26-04:00"},{"id":26107,"reporter":{"id":17823,"name":"kdcinfo"},"text":"Unless anyone else has done it, I'm also trying to create a Mapping Save feature. I've created a separate table with 4 columns (map_id, map_prj, map_cvs, map_mantis) to store the field mappings (saved per project). I'm doing this by trying to add a few new methods in the bug_api.php -> BugData Class.\r\n\r\nI'm sure there's a better place to store these by extending the class in another file, but don't know enough about classes. The new methods I'm creating are; create_map_def(), update_map_def(), and get_map_def(). Hoping that on the mapping page, I can default in any previously selected fields from the dropdowns so that subsequent runs won't require selecting them all again.\r\n\r\nAny input appreciated :)","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-07-20T19:43:28-04:00","updated_at":"2010-07-20T19:43:28-04:00"},{"id":26115,"reporter":{"id":17823,"name":"kdcinfo"},"text":"Just as an FYI to anyone who didn't already know ('cause it took me awhile to figure it out), this plugin, or at least the latest version of this plugin (112), is not compatible with Mantis 1.0.8, which is the version we're using in our office. \r\n\r\nI'm not sure which version of Mantis = which version of this plugin, but I do know that much. Just wanted to clear that up for anyone new coming into this.\r\n\r\n------------------------------------------------------------\r\nUPDATE:\r\n------------------------------------------------------------\r\n\r\nJust came across (or noticed rather):\r\n$this->requires   \t= array('MantisCore'       => '1.2.0',);\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-07-21T17:03:25-04:00","updated_at":"2010-07-21T18:05:21-04:00"},{"id":26117,"reporter":{"id":7780,"name":"cas"},"text":"The plugin system is only available as of version 1.2 so that also indicates the compatibility of the plugin.\r\nFor older versions, you need to use an earlier version (ie the last vesion before it becamne a plugin). Have a go at mantis_import_issues_v7","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-07-22T02:58:19-04:00","updated_at":"2010-07-22T02:58:19-04:00"},{"id":26713,"reporter":{"id":17784,"name":"dregad"},"text":"I tried this plug-in today, and after a few trials and errors, managed to successfully import a bunch of issues.\r\n\r\nMany thanks to all those who contributed to this !\r\n\r\nIf I may make a suggestion, it would be nice if the imported records, would be marked as such in the Issue History, i.e. the Change Column showing the name of the file as in the example below, or something similar.\r\n\r\nDate Modified      Username  \t  Field       Change \r\n2010-09-14 19:07   Administrator  New Issue   Imported from xyz.csv","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-09-14T13:40:31-04:00","updated_at":"2010-09-14T13:40:31-04:00"},{"id":26714,"reporter":{"id":17784,"name":"dregad"},"text":"I just noticed that when importing issues into a sub-project which is inheriting Categories from its parent, the plug-in seems unable to match the value in the CSV's column with the ID in mantis_category_table.\r\n\r\nIn Mantis, assume the following categories exist for sub-project:\r\n[ParentProject] Parent Category\r\nChild Category\r\n\r\nIn CSV, I tried the following values in the Category column, without success on import (i.e. always ending up with category = csv_imported)\r\na) Parent Category\r\nb) [ParentProject] Parent Category\r\nc) <ID of [ParentProject] Parent Category>\r\n\r\nI would expect the plug-in to be able to find a match with a).\r\n\r\nNote: I have not tested with global categories as I do not use them currently\r\n\r\nThis is on Mantis 1.2.1 by the way.\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-09-14T14:01:00-04:00","updated_at":"2010-09-16T09:23:00-04:00"},{"id":26972,"reporter":{"id":18464,"name":"m.vanhamme"},"text":"I tried to import a csv file. Mapped the fields. At the end of the import i get the following error:\r\n\r\nInvalid e-mail address\r\n\r\nBut there is no email address mapped.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-10-06T07:07:18-04:00","updated_at":"2010-10-06T07:07:18-04:00"},{"id":26989,"reporter":{"id":7780,"name":"cas"},"text":"Do you have by chance a mandatory customfield defined that would hold an email address?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-10-07T03:50:58-04:00","updated_at":"2010-10-07T03:50:58-04:00"},{"id":27249,"reporter":{"id":18734,"name":"lionheart33806"},"text":"Hi,\r\nI don't understand the regexp of read_csv_row function.\r\nWhy does it care about double quotes?\r\n\r\nIf I have a string like : abcd\"fzefz\"feizjfz\r\nPREG stops matching after the letter d (and ignore everything after it).\r\n\r\nShouldn't be like that :\r\n\/\\G(?:\\A|\\_SEPARATOR_)((?!\")[^\\_SEPARATOR_]+|(?:\"[^\"]*\")*)\/sm\r\n\r\ninstead of\r\n\/\\G(?:\\A|\\_SEPARATOR_)([^\"_SEPARATOR_]+|(?:\"[^\"]*\")*)\/sm\r\n\r\n?\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-04T11:32:16-04:00","updated_at":"2010-11-04T11:33:14-04:00"},{"id":27251,"reporter":{"id":10406,"name":"sveyret"},"text":"I added a new version of the plugin (1.1.3). I made two minor changes on it:\r\n* Made the strings and errors \"private\" as they should be in a plugin.\r\n* Added a french version of the strings.\r\n\r\nEnjoy!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-04T12:36:57-04:00","updated_at":"2010-11-04T12:36:57-04:00"},{"id":27260,"reporter":{"id":10406,"name":"sveyret"},"text":"@jojow\r\nEntschuldigung, I hadn't seen your file for german translation. I added it to the plugin and so uploaded version 1.1.4.\r\nIf you have time, please have a look at it to check that I didn't make any mistake. There also are a few new strings which are not translated (I kept english version for those as my german is not good enough)\u00a0!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-05T04:57:31-04:00","updated_at":"2010-11-05T04:57:31-04:00"},{"id":27323,"reporter":{"id":18734,"name":"lionheart33806"},"text":"1.1.5 version is my contribution.\r\n\r\nChangelog :\r\n* Code closer of mantis coding conventions\r\n* \"all projects\" categories reusable\r\n* Can import \"submitted date\" with DD\/MM\/YYYY format\r\n* Checkbox for alternative import because of double quotes\r\n* Added helper_begin_long_process() for very long imports","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-10T05:36:41-05:00","updated_at":"2010-11-10T05:36:41-05:00"},{"id":27327,"reporter":{"id":17265,"name":"andy778"},"text":"Wouldn't it be good to have this src in git or svn somewhere?\r\ne.g mantisforge\r\n\r\nin latest 1.1.5 the version number was 1.1.3 in Csv_import.php \r\n$this->version = '1.1.3';","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-10T08:50:07-05:00","updated_at":"2010-11-10T08:50:07-05:00"},{"id":27330,"reporter":{"id":18734,"name":"lionheart33806"},"text":"Sorry for the mistake ...\r\n\r\nGreat idea !\r\nBut who should create it ?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-10T09:47:12-05:00","updated_at":"2010-11-10T09:47:12-05:00"},{"id":27376,"reporter":{"id":18734,"name":"lionheart33806"},"text":"1.2.0 version is my new contribution.\r\n\r\nChangelog :\r\n* import_issues_page.php splitted to become import_issues_page_init.php and import_issues_page_col_set.php\r\n* Can create unknown categories\r\n* Little JS to use tab as separator","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-16T06:01:39-05:00","updated_at":"2010-11-16T06:01:39-05:00"},{"id":27388,"reporter":{"id":5082,"name":"TomR"},"text":"open_basedir restriction in effect. File() is not within the allowed path(s)\r\n\r\nI am getting an open_basedir restriction. However can not figure out which path should be defined. \r\n\r\nI define the $HOME of mantis installation, the upload path for the project, the general upload path from the config_inc.php.\r\n\r\nBut none of these are OK. Which path should be added?\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-16T18:09:49-05:00","updated_at":"2010-11-16T18:14:31-05:00"},{"id":27390,"reporter":{"id":7780,"name":"cas"},"text":"Do you have this statement in your config_inc.php:\r\n$g_path  = 'http:\/\/path_to_your_mantis_installation\/';\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-17T03:01:58-05:00","updated_at":"2010-11-17T03:03:15-05:00"},{"id":27391,"reporter":{"id":5082,"name":"TomR"},"text":"Hi Cas,\r\n\r\nnot initially. ( Using 1.2.3 ). But even when I put the absolute path in, same error occurs.\r\n\r\nBut l other default stuff of Mantis regarding uploading files is working. To which (sub)directory the functions tempnam() and move_uploaded_file() referring?\r\n\r\nSYSTEM WARNING: tempnam() [function.tempnam]: open_basedir restriction in effect. File() is not within the allowed path(s): (\/home\/proguide\/:\/home\/proguide\/domains\/proguideweb.nl\/public_html\/abs-pad\/upload:\/var\/www\/ctstestdocs:\/var\/www\/testtrackdocs:\/var\/www\/testwiki:\/var\/www\/devtrackdocs:\/var\/www\/devwiki:\/var\/www\/html\/jpgraph-3.0.6:\/usr\/local\/lib\/php\/:\/tmp:\/usr\/share\/fonts\/)\r\n\r\nSYSTEM WARNING: move_uploaded_file() [function.move-uploaded-file]: open_basedir restriction in effect. File() is not within the allowed path(s): (\/home\/proguide\/:\/home\/proguide\/domains\/proguideweb.nl\/public_html\/abs-pad\/upload:\/var\/www\/ctstestdocs:\/var\/www\/testtrackdocs:\/var\/www\/testwiki:\/var\/www\/devtrackdocs:\/var\/www\/devwiki:\/var\/www\/html\/jpgraph-3.0.6:\/usr\/local\/lib\/php\/:\/tmp:\/usr\/share\/fonts\/)","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-17T04:01:39-05:00","updated_at":"2010-11-17T04:01:39-05:00"},{"id":27395,"reporter":{"id":5082,"name":"TomR"},"text":"Problem is in line 112 from\r\nimport_issues_page_col_set.php\r\n\r\nChanged it into \r\n$t_file_name = tempnam( '.', 'tmp' );\r\n\r\nFunction does not seem to like an empty directory a first parameter. Can someone perhaps comment on that?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-17T04:47:27-05:00","updated_at":"2010-11-17T04:47:27-05:00"},{"id":27396,"reporter":{"id":5082,"name":"TomR"},"text":"How can you import in such a way that the due date is empty?\r\n\r\nDefault the due date is becoming the dat of today with time 00:00, this effectivly means that the item is after import overdue.\r\n\r\nImporting with column due date set to 1, will import it as due date set to 0, which lead to displaying it as 01\/01\/1970.\r\n\r\nThe due dat should have the value 1, not 0 ( zero ) to display it as empty. But how can I import the value '1'?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-17T04:54:56-05:00","updated_at":"2010-11-17T04:54:56-05:00"},{"id":27397,"reporter":{"id":5082,"name":"TomR"},"text":"OK, about the due date, also figured that out.\r\n\r\nI changed the default.\r\n\r\n#\t\t$t_default->due_date = date('Y-m-d');\r\n\t\t$t_default->due_date = 1;\r\n\r\nPerhaps it would be nice to make this configurable. Otherise make the default = 1, in my opinion this is more logical than assign a due date which is already overdue.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-17T05:09:22-05:00","updated_at":"2010-11-17T05:09:22-05:00"},{"id":27398,"reporter":{"id":18734,"name":"lionheart33806"},"text":"I created a github repository here : https:\/\/github.com\/lionheart33806\/Csv-import-4-MantisBT","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-17T05:24:40-05:00","updated_at":"2010-11-17T05:24:40-05:00"},{"id":27405,"reporter":{"id":18605,"name":"jmonin"},"text":"Thanks for that, lionheart33806!\r\nShall we start using the issues section instead of this bug, which seems quite inappropriate and hardly usable?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-17T11:13:28-05:00","updated_at":"2010-11-17T11:13:28-05:00"},{"id":27406,"reporter":{"id":17784,"name":"dregad"},"text":"Sounds like a great idea ! This page is totally unmanageable.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-17T12:55:26-05:00","updated_at":"2010-11-17T12:55:26-05:00"},{"id":27409,"reporter":{"id":18734,"name":"lionheart33806"},"text":"I'm agree to use issues section too.\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-18T03:25:56-05:00","updated_at":"2010-11-18T03:55:18-05:00"},{"id":27467,"reporter":{"id":18734,"name":"lionheart33806"},"text":"I've just release v1.3.0b on github (if you don't use git, just use \"Downloads\" button).\r\nPlease test it.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-24T05:40:34-05:00","updated_at":"2010-11-24T05:40:34-05:00"},{"id":27473,"reporter":{"id":5082,"name":"TomR"},"text":"Lionheart,\r\n\r\ncould you please comment on my remarks:\r\n\r\n~27395, ~27396 and ~27397","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-24T08:00:51-05:00","updated_at":"2010-11-24T08:00:51-05:00"},{"id":27475,"reporter":{"id":18734,"name":"lionheart33806"},"text":"Ok, try this source : https:\/\/github.com\/lionheart33806\/Csv-import-4-MantisBT\/commit\/515e2a299f2a2f55a07b6617e35fd798f3b075c0 (via \"Downloads\")\r\n\r\nPlease next time use \"Issues\" section of github\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2010-11-24T08:49:13-05:00","updated_at":"2010-11-24T08:50:34-05:00"},{"id":28067,"reporter":{"id":11111,"name":"atrol"},"text":"lionheart33806, are you aware that you can have an own project for this plugin at this instance of MantisBT tracker?\r\nHave a look at the project selection box, where user cas is the manager for the four plugin's","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-01-25T04:33:26-05:00","updated_at":"2011-01-25T04:33:26-05:00"},{"id":28069,"reporter":{"id":18734,"name":"lionheart33806"},"text":"Sorry my english is bad, i don't understand you ...\r\nAre you saying that I shouldn't create a githit repo ?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-01-25T04:52:03-05:00","updated_at":"2011-01-25T04:52:03-05:00"},{"id":28071,"reporter":{"id":11111,"name":"atrol"},"text":"I think the repo is Ok, but a better place for this would be http:\/\/git.mantisforge.org\r\n\r\nI was talking about issue tracking for the plugin.\r\nThis could be handled with an own project at www.mantisbt.org\/bugs\r\n\r\nHave a look at the project selection list, where you will find that there are projects for four plugins at the momement.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-01-25T05:00:51-05:00","updated_at":"2011-01-25T05:00:51-05:00"},{"id":28073,"reporter":{"id":18734,"name":"lionheart33806"},"text":"I get it now, thanks !\r\nI was looking for this before creating in github but I didn't found it ...\r\n\r\nI'll look it when I'll have more time !","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-01-25T05:23:47-05:00","updated_at":"2011-01-25T05:23:47-05:00"},{"id":28168,"reporter":{"id":13333,"name":"cor3huis"},"text":"THANK for moving you code to http:\/\/git.mantisforge.org !\r\n\r\nJust discovered your plug-in, need to try it a little more however found one glitch\r\n\r\nThe strings with \"Csv\" should be \"csv\" , mind the capital \"C\"\r\n\r\n$s_plugin_Csv_import_title = 'Mantis CSV Importer';\r\n$s_plugin_Csv_import_description = 'Import CSV files as Mantis issues';\r\n\r\nWhen I've added them to custom_strings_inc.php it worked.\r\n\r\n$s_plugin_csv_import_title = 'Mantis CSV Importer';\r\n $s_plugin_csv_import_description = 'Import CSV files as Mantis issues';","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-02-05T08:19:18-05:00","updated_at":"2011-02-05T08:19:18-05:00"},{"id":28255,"reporter":{"id":17265,"name":"andy778"},"text":"Where under http:\/\/git.mantisforge.org have you added this plugin, I tried looking for any plugin with cvs or import there but could not find any.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-02-18T05:24:04-05:00","updated_at":"2011-02-18T05:24:04-05:00"},{"id":28433,"reporter":{"id":17265,"name":"andy778"},"text":"We use this plugin to export\/import issues beween ms project and I need to fix a couple of things from the version found ~0027475 \r\n\r\n-When exporting CVS the files comes in UTF-8 but import expect e.g Latin1\r\n-Export takes Real Name but import expect username\r\n\r\nSo the question is these fixed alreday if yes in wich repos as I seams not be be able to find it under http:\/\/git.mantisforge.org and if no where should I commit the changes if I fix these?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-03-17T13:42:53-04:00","updated_at":"2011-03-17T13:42:53-04:00"},{"id":28440,"reporter":{"id":17445,"name":"AboeBakr"},"text":"Nice plugin! \r\nWould like to make some suggestions though:\r\n\r\n- when selecting multiple times 'ignore_column' the script failes due to the check for unique columns\r\n- first checking if the required fields are filled prevents importing half the list (e.g. 'description')","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-03-18T06:16:06-04:00","updated_at":"2011-03-18T06:16:06-04:00"},{"id":28500,"reporter":{"id":13333,"name":"cor3huis"},"text":"Get the latest version via Git https:\/\/github.com\/lionheart33806\/Csv-import-4-MantisBT\r\n\r\nFork it, change the defects, and ask the maintainer, to do a Pull request to get all fixes into the mater original branch.\r\n\r\nYou could then delete your fork","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-03-29T07:07:30-04:00","updated_at":"2011-03-29T07:07:30-04:00"},{"id":29044,"reporter":{"id":20553,"name":"Georges_"},"text":"I was not able to use this plugin. In the readme, the installation part says\r\n\"Installation instructions are the same as installing a plugin.\"\r\n\r\nI suggest to describe the full procedure installation in the readme because it's not easy to find the procedure on the net (essentially found instructions for old mantis versions with pluginmanager that is not compatible with new mantis any more).\r\n\r\nthank you.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-06-21T02:47:09-04:00","updated_at":"2011-06-21T02:47:09-04:00"},{"id":29156,"reporter":{"id":10406,"name":"sveyret"},"text":"@lionheart:\r\nWould you please host the plug-in to the now official plug-in place for Mantis which is:\r\nhttp:\/\/github.com\/mantisbt-plugins\/\r\nPlease contact John Reese (who has just created this organization) on the developer mailing list if you need help on this.\r\nA specific project for this plug-in should also be created in this Mantis as it is the case for some other plug-ins.\r\nI think that once done, this issue, which is getting longer and longer with all those comments, will have to be closed.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-07-13T04:27:04-04:00","updated_at":"2011-07-13T04:27:04-04:00"},{"id":29465,"reporter":{"id":17265,"name":"andy778"},"text":"Is the repos https:\/\/github.com\/lionheart33806\/Csv-import-4-MantisBT alive any more? Created a little patch for the mantis Csv plugin that  also can take real names and not only  user names and if the file contains a UTF-8 BOM characters it will expect the file to in utf-8 instead of Latin-1 \r\n\r\nI sent this patch file to lionheart33806 19.6.2011 but it seems to have gone out in space. However I have attached the patch here 0001-Utf8-support-and-Real-names.patch","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-08-11T11:58:58-04:00","updated_at":"2011-08-11T11:58:58-04:00"},{"id":29611,"reporter":{"id":21105,"name":"Rustan"},"text":"Hi Guys, I've found this plugin useful and I'm about to use it on our production environment. I have tested it on my local and it seems fine. However, it seems that it doesn't send emails for the uploaded entries. Do you think if it is possible that it can be tweaked to send emails for all the entries imported by this plugin? Just the same as submitting a single entry.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-08-31T23:35:30-04:00","updated_at":"2011-08-31T23:35:30-04:00"},{"id":29620,"reporter":{"id":21105,"name":"Rustan"},"text":"Sending emails for each of the bugs imported through this plugin.\r\n\r\nGuys, I was able to fix what I need and I just want to share this piece of idea. Actually , this is based on the bug_report.php included in the mantis core package. If you want to have an automated email sent for each of the new bugs imported by this plugin, just add these lines from bug_report.php to import_issue.php included in this plugin just before the # Result comment:\r\n\r\nhelper_call_custom_function( 'issue_create_notify', array( $t_bug_id ) );\r\nemail_new_bug( $t_bug_id );\r\n\r\n# Result\r\nif($t_error) {\r\n\t$t_failure_count++;\r\n}\r\nelse {\r\n\t$t_success_count++;\r\n}\r\n\r\nHope it helps!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-02T01:59:32-04:00","updated_at":"2011-09-02T01:59:32-04:00"},{"id":29697,"reporter":{"id":18734,"name":"lionheart33806"},"text":"I'm (a little) back !\r\n\r\nSorry, I didn't have time to work on the plugin.\r\n\r\nLet me a bit of time to see your notes.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-13T09:37:53-04:00","updated_at":"2011-09-13T09:37:53-04:00"},{"id":29703,"reporter":{"id":18734,"name":"lionheart33806"},"text":"@Rustan : Interesting idea ! I added it in github \"issues\".\r\n\r\n@andy778 : I can't find something (mail or github) about your patch :-\/\r\n\r\n@sveyret & Georges_ : It's on the way.\r\n\r\n@cor3huis : Is your plugin folder named \"csv_import\" ? Try \"Csv_import\".\r\n\r\n@AboeBakr : Can you be more \"clear\" about the 2nd problem ?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-14T03:18:23-04:00","updated_at":"2011-09-14T03:18:23-04:00"},{"id":29709,"reporter":{"id":17265,"name":"andy778"},"text":"@lionheart33806 the patch is also here as an attachment 0001-Utf8-support-and-Real-names.patch","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-14T09:58:15-04:00","updated_at":"2011-09-14T09:58:15-04:00"},{"id":29738,"reporter":{"id":21105,"name":"Rustan"},"text":"Guys, I encountered issue when trying to test in on our dev environment:\r\n\r\nSYSTEM WARNING: file_exists() [function.file-exists]: open_basedir restriction in effect. File(\/tmp\/D9R8wM) is not within the allowed path(s): \/data\/otherlocation\r\n\r\nWould you know where can I tweak this location? I think it points by default to \/tmp location and it is not where we upload temp files.\r\n\r\nYour help is very much appreciated.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-15T23:28:50-04:00","updated_at":"2011-09-15T23:28:50-04:00"},{"id":29740,"reporter":{"id":18734,"name":"lionheart33806"},"text":"Look at sys_get_temp_dir() (import_issues_inc.php, import_issues_page_col_set.php and http:\/\/php.net\/manual\/en\/function.sys-get-temp-dir.php)\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-16T03:18:24-04:00","updated_at":"2011-09-16T03:19:48-04:00"},{"id":29744,"reporter":{"id":21105,"name":"Rustan"},"text":"@lionheart33806 - it does not get inside the if condition:\r\n\r\nimport_issues_inc.php:\r\n\r\nif ( !function_exists('sys_get_temp_dir')) {\r\n\tfunction sys_get_temp_dir() {\r\n\t\tif( $temp = getenv('TMP') ) {\r\n\t\t\treturn $temp;\r\n\t\t}\r\n\t\tif( $temp = getenv('TEMP') ) {\r\n\t\t\treturn $temp;\r\n\t\t}\r\n\t\tif( $temp = getenv('TMPDIR') ) {\r\n\t\t\treturn $temp;\r\n\t\t}\r\n\t\t$temp = tempnam(__FILE__,'');\r\n\t\techo \"\\$temp: \".$temp.\"<br\/>\";\r\n\t\tif (file_exists($temp)) {\r\n\t\t\tunlink($temp);\r\n\t\t\treturn dirname($temp);\r\n\t\t}\r\n\t\treturn null;\r\n\t}\r\n}\r\necho \"\\$temp: \".$temp.\"<br\/>\";\r\necho realpath(sys_get_temp_dir());\r\n\r\nThe output of this one is:\r\n\r\n$temp:\r\n\/tmp\r\n\r\nCan i override the system temp directory to point to \/data\/otherlocation?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-16T05:17:33-04:00","updated_at":"2011-09-16T05:17:33-04:00"},{"id":29746,"reporter":{"id":17445,"name":"AboeBakr"},"text":"@lionheart33806\r\n\r\nregarding the second problem,\r\nsome fields, for example 'description' are required.\r\nWhen the csv has a row, where the column mapped to 'description' is empty,\r\nthe import will fail.\r\n\r\nthe problem is: it inserts all the entries up to the row with the missing description. \r\n\r\nas it is now, you have too look up at which point in the csv it goes amiss, \r\nthen remove all the rows above this point, save the csv and then restart the import.\r\n\r\nthe line at which it is failing is not reported as well, making this even more inconvenient.\r\n\r\nIf the csv would be scanned for these missing fields, you could either import all entries or none. And preferably report to the user at which row\/column there is a problem.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-16T06:26:24-04:00","updated_at":"2011-09-16T06:26:24-04:00"},{"id":29747,"reporter":{"id":17784,"name":"dregad"},"text":"@Rustan\r\nsys_get_temp_dir() as the name indicates, returns the system temp dir (which is not the same as the upload temp dir). I assume that you expect the plugin to use the location specified in upload_tmp_dir, but that won't work (see https:\/\/bugs.php.net\/bug.php?id=54710).\r\n\r\nTo work around the problem, assuming you're using apache, you could try to\r\n\r\n- modify your apache envvars file, to add: export TMPDIR=\/data\/otherlocation\r\n- modify your open_basedir to allow your system temp dir (there could be security implications there though), e.g. \/data\/otherlocation:\/tmp\r\n\r\nMaybe the plugin should be improved to check that the path returned by sys_get_temp_dir() is checked for accessibility prior to further processing.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-16T11:01:15-04:00","updated_at":"2011-09-16T11:01:15-04:00"},{"id":29804,"reporter":{"id":18734,"name":"lionheart33806"},"text":"The repository moved to https:\/\/github.com\/mantisbt-plugins\/csv-import\r\n\r\n@Rustan : please try latest tarball\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-19T09:23:42-04:00","updated_at":"2011-09-19T09:24:52-04:00"},{"id":29806,"reporter":{"id":21105,"name":"Rustan"},"text":"@dregad - thanks for the info, actually, i understand that it uses the system-defined temp dir but, as i have said, we have a defined temp location to write on such as \/data\/otherlocation. your suggestion can be done on the server side. can i change the location, say define the \/data\/otherlocation because i know that where i have write privilege?\r\n\r\n@lionheart33806 - thanks, ill try that.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-19T21:13:59-04:00","updated_at":"2011-09-19T21:13:59-04:00"},{"id":29808,"reporter":{"id":18734,"name":"lionheart33806"},"text":"My changes only try to prevent the warning message.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-09-20T02:26:01-04:00","updated_at":"2011-09-20T02:26:01-04:00"},{"id":29997,"reporter":{"id":21105,"name":"Rustan"},"text":"@lionheart33806 - thanks, it works. now, when i implemented this into our production, im having problem when i clicked the upload file button, here is the error:\r\n\r\n\r\nAPPLICATION ERROR #11 \r\nA necessary field \"\" was empty. Please recheck your inputs.\r\n \r\nPlease use the \"Back\" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-10-18T23:24:15-04:00","updated_at":"2011-10-18T23:24:15-04:00"},{"id":30001,"reporter":{"id":10406,"name":"sveyret"},"text":"The CsvImport project is now created in Mantis BT (see the project drop down at top right of this window). If you have any more problems concerning this plug-in, please open a new issue in the corresponding project.\r\nCan someone close this issue to prevent people from adding information?\r\nThank you.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-10-20T03:21:31-04:00","updated_at":"2011-10-20T03:21:31-04:00"},{"id":30136,"reporter":{"id":21601,"name":"PeterThoeny"},"text":"I am trying to import a csv file using the [ Import CSV file ] plugin link in the manage screen. I installed Csv_import.120.tar.gz\r\n\r\nI get the same error like m.vanhamme above: \"Invalid e-mail address\". There is no e-mail address in the csv file, in fact there is not even an @ sign. The source is actually a converted xml file from a mantisbt export, only with default fields. Fields as defined in the first line of the csv: ID, Reporter, Assigned To, Priority, Severity, Reproducibility, Product Version, Category, Date Submitted, OS, OS Version, Platform, View Status, Updated, Summary, Status, Resolution, Fixed in Version. (no space after comma in csv, added here for clarity)\r\n\r\nSuspecting that the converter is choking on certain content I tried to convert only the first 10 records of a 480 record csv file. Same result.\r\n\r\nThen I tried to import records 10-20. Now I get this: \"APPLICATION ERROR #11. A necessary field \"Description\" was empty. Please recheck your inputs.\" There is no Description field?\r\n\r\nI also tried to import the xml using the [ Import issues ] plugin link. This fails showing an empty screen with URL: https:\/\/example.com\/mantisbt\/plugin.php?page=XmlImportExport\/import_action - an no data imported.\r\n\r\nAny help in how to import data from another mantisbt is greatly appreciated, thank you.\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-11-01T01:09:03-04:00","updated_at":"2011-11-01T01:15:31-04:00"},{"id":30140,"reporter":{"id":17784,"name":"dregad"},"text":"Celebrity alert ! We've got the famous creator of TWiki in the house :-)\r\n\r\nHi Peter,\r\n\r\nI can't really help you with your question, hopefully lionheart33806 who maintains the plugin will have an answer for you. Nevertheless, I would suggest to get the latest source for the plug-in from Github [1], instead of the tarballs attached to this issue.\r\n\r\nDamien\r\n\r\n[1] https:\/\/github.com\/mantisbt-plugins\/csv-import","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-11-01T12:30:06-04:00","updated_at":"2011-11-01T12:30:06-04:00"},{"id":30141,"reporter":{"id":21601,"name":"PeterThoeny"},"text":"Thank you Damien. I installed the latest Mantis CSV Importer 1.3.0b from github.\r\n\r\nNow I get this error:\r\n\r\nAPPLICATION WARNING #300: String \"plugin_Csv_import_result_nothing_success_ct\" not found.\r\n\r\nWhen I omit the ID field I get again this error:\r\n\r\nAPPLICATION ERROR #1200: Invalid e-mail address.\r\n\r\nHmm...","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-11-01T14:44:19-04:00","updated_at":"2011-11-01T14:44:19-04:00"},{"id":30177,"reporter":{"id":21601,"name":"PeterThoeny"},"text":"Apparently the Description field is mandatory, so I added it. However, import still gave me the e-mail error.\r\n\r\nI did a brute force import: Wrote a script that uses curl to push the data record by record via http posts. Problem solved (with much more effort than it should be).\r\n\r\nThanks for your help anyway!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-11-04T13:32:14-04:00","updated_at":"2011-11-04T13:32:14-04:00"},{"id":30249,"reporter":{"id":21364,"name":"VeMag"},"text":"about 0004220:0030141 , if you try to import handler or reporter who doesn't exist in your mantisbt, then it will try to create it...\r\n\r\nbut function user_create() in user_api.php do \"email_ensure_valid(email)\" even if email is '', that's an \"Invalid e-mail address.\"\r\n\r\nso, don't import handler or reporter or write in plugins\\csv_import\\pages\\import_issues_inc.php :\r\nline 253:\r\n\tif( user_create( $t_username , $t_username, 'nomail@for.me' ) ) {\r\n\r\nNot good for security : password = username...","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-11-18T10:33:21-05:00","updated_at":"2011-11-18T10:33:21-05:00"},{"id":30322,"reporter":{"id":21917,"name":"belfar"},"text":"teste","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-11-23T18:39:39-05:00","updated_at":"2011-11-23T18:39:39-05:00"},{"id":30346,"reporter":{"id":21105,"name":"Rustan"},"text":"VeMag is correct. If you are trying to assign an entry to a user with invalid email address, it would give you an error of invalid email address. to fix this, you can disable the checking of valid email addresses of users being assigned to an entry.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-11-27T21:58:06-05:00","updated_at":"2011-11-27T21:58:06-05:00"},{"id":30361,"reporter":{"id":22041,"name":"andropoliss"},"text":"hI, FUNNY PROBLEM!","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2011-11-29T13:56:14-05:00","updated_at":"2011-11-29T13:56:14-05:00"},{"id":31829,"reporter":{"id":24534,"name":"keimpe@planet.nl"},"text":"When I import a CSV file everything goes well.\r\nIt generates new issues and all information for the standard mantis fields are filled in. \r\n\r\nExcept for the custom fields.\r\nIt reconizes the customfields, I can sellect them in the import tool.\r\nBut it just does not import the information for the custom fields.\r\n\r\nIs there something I forgot?\r\nDo I have to add somewere the custom fields I want to import?\r\n\r\nI've latest verion 1.3.0b, mantis 1.2.8.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2012-05-14T07:18:28-04:00","updated_at":"2012-05-14T07:18:28-04:00"},{"id":40775,"reporter":{"id":3081,"name":"vboctor"},"text":"Resolving this issue in favor of the version of the extension hosted in github and has been getting the recent fixes.\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T21:57:47-04:00","updated_at":"2014-06-09T21:57:47-04:00"}],"relationships":[{"id":1823,"type":{"id":4,"name":"has-duplicate","label":"has duplicate"},"issue":{"id":5161,"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":60,"name":"duplicate","label":"duplicate"},"summary":"Can I load an Excel sheet to populate a new project?","handler":{"id":4599,"name":"giallu"}}},{"id":2015,"type":{"id":4,"name":"has-duplicate","label":"has duplicate"},"issue":{"id":3732,"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":60,"name":"duplicate","label":"duplicate"},"summary":"Offline bug report","handler":{"id":2405,"name":"grangeway"}}},{"id":2848,"type":{"id":4,"name":"has-duplicate","label":"has duplicate"},"issue":{"id":12778,"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":60,"name":"duplicate","label":"duplicate"},"summary":"importing issues","handler":{"id":11111,"name":"atrol"}}},{"id":920,"type":{"id":3,"name":"child-of","label":"child of"},"issue":{"id":4181,"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":10,"name":"open","label":"open"},"summary":"Features in Mantis 1.1 release"}}],"tags":[{"id":4,"name":"patch"}]},{"id":25834,"summary":"Custom field import works incorrectly when there is more than one custom field","description":"When importing custom fields, the field definition used is always the definition of the last field ","steps_to_reproduce":"Import a csv with multiple custom fields","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":46019,"name":"teodor"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":60,"name":"major","label":"major"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2019-06-01T14:12:06-04:00","updated_at":"2020-05-01T18:51:21-04:00","notes":[{"id":62184,"reporter":{"id":46019,"name":"teodor"},"text":"PR: https:\/\/github.com\/mantisbt-plugins\/csv-import\/pull\/4","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-06-01T14:20:22-04:00","updated_at":"2019-06-01T14:20:22-04:00"},{"id":63805,"reporter":{"id":48929,"name":"BillSYLee"},"text":"123","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2020-03-29T22:35:33-04:00","updated_at":"2020-03-29T22:35:33-04:00"},{"id":63806,"reporter":{"id":48929,"name":"BillSYLee"},"text":"5651","view_state":{"id":10,"name":"public","label":"public"},"attachments":[{"id":9044,"reporter":{"id":48929,"name":"BillSYLee"},"created_at":"2020-03-29T22:37:21-04:00","filename":"Test.xlsx","size":8798,"content_type":"application\/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=binary"},{"id":9045,"reporter":{"id":48929,"name":"BillSYLee"},"created_at":"2020-03-29T22:37:21-04:00","filename":"logo \u65e5\u76db2019.png","size":100113,"content_type":"image\/png; charset=binary"},{"id":9046,"reporter":{"id":48929,"name":"BillSYLee"},"created_at":"2020-03-29T22:37:21-04:00","filename":"\u5eb7\u548c\u8b49\u5238.png","size":8089,"content_type":"image\/png; charset=binary"}],"type":"note","created_at":"2020-03-29T22:37:21-04:00","updated_at":"2020-03-29T22:37:21-04:00"},{"id":63945,"reporter":{"id":49093,"name":"mkemal"},"text":"TEST","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2020-05-01T18:51:21-04:00","updated_at":"2020-05-01T18:51:21-04:00"}]},{"id":25945,"summary":"Unable to upload CSV file from Mantis 1.2.19 to 2.21.1","description":"I am running Mantis 2.21.1 and PHP 7.1.26 on MS Server 2012R2 with IIS 8.5. I have a production Mantis which is on 1.2.19 and we need to export all of the issues from this version and import into 2.21.1. I have the import\/export tool loaded on the new server and when the issues are exported via excel or csv export from the old server I am able to see all of the information from the issues in the excel document (the file is saved in CSV format) but when I attempt to upload the csv file via the import tool I am unable to see any of the issues. I get various errors to include Internal application error or Application error #800 that username is already being used. Any help or pointers would be greatly appreciated as this is preventing testing and the ability to go to the latest version of Mantis.","additional_information":"This server is on a standalone network and I am unable to upload any documentation.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":47816,"name":"jglenn"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":60,"name":"major","label":"major"},"reproducibility":{"id":30,"name":"sometimes","label":"sometimes"},"sticky":false,"created_at":"2019-07-25T11:22:01-04:00","updated_at":"2019-08-29T23:02:30-04:00"},{"id":22293,"summary":"Cannot import from Csv Import Plugins if enumeration type","description":"tried to use the plugins import csv, but some how got error when the field in importing the value when the type \"enumeration \/ checkbox\" but if the type string with no issues. perhaps there are same issue happen and might help in the case.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":41977,"name":"budsmand"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"platform":"Linux","os":"Ubuntu","os_build":"14.01 LTS","sticky":false,"created_at":"2017-01-31T10:02:21-05:00","updated_at":"2019-06-20T21:42:07-04:00","attachments":[{"id":8596,"reporter":{"id":47652,"name":"kotatoshi"},"created_at":"2019-06-20T21:42:07-04:00","filename":"mantishub_sample.csv","size":1596,"content_type":"text\/plain; charset=utf-8"}],"notes":[{"id":62279,"reporter":{"id":43710,"name":"sandyj"},"text":"We\u2019ve seen this issue. though it occurs when the custom field of enumeration type is in another language (in our case japanese). An error message is returned and these fields are not populated. A work-around used was to :\r\n\r\n1. Change the Custom Field of enumeration type to a string field\r\n2. Clear out the Possible values,\r\n3. Perform import (import succeeds),\r\n4. Then change back Custom Field back to enum. field and add the possible values back.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-06-20T12:36:23-04:00","updated_at":"2019-06-20T12:36:23-04:00"},{"id":62282,"reporter":{"id":47652,"name":"kotatoshi"},"text":"Hello.\nHere is a sample fie with custom field value in Japanese.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-06-20T21:42:07-04:00","updated_at":"2019-06-20T21:42:07-04:00"}]},{"id":25874,"summary":"APPLICATION ERROR #401 when import bug","description":"I just installed CSV import plug-in and tried to import bug in CSV format. there are some custom fields that I tried to import too. I got error as below.\r\n\r\nDatabase query failed. Error received from database was #1406: Data too long for column 'new_value' at row 1 for the query: INSERT INTO mantis_bug_history_table\r\n( user_id, bug_id, date_modified, field_name, old_value, new_value, type )\r\nVALUES\r\n( ?, ?, ?, ?, ?, ?, ? ).\r\n\r\nPlease use the \"Back\" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":47644,"name":"tchuencharoen"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2019-06-19T11:24:37-04:00","updated_at":"2019-06-19T11:30:43-04:00"},{"id":25616,"summary":"APPLICATION WARNING #300","description":"Hi Team ,\r\n\r\nI am getting the following error when I click on manage plugins.\r\n\r\nAPPLICATION WARNING #300\r\n\r\nString \"plugin_Csv_Import_title\" not found. (in 'D:\\xampp\\htdocs\\Mantis\\core\\lang_api.php' line 306)\r\n\r\nPlease use the \"Back\" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.\r\n\r\nPlease assist me to resolve this error","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":46949,"name":"Pavithra"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":50,"name":"urgent","label":"urgent"},"severity":{"id":80,"name":"block","label":"block"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2019-03-18T06:00:42-04:00","updated_at":"2019-03-18T06:09:37-04:00","notes":[{"id":61682,"reporter":{"id":11111,"name":"atrol"},"text":"Moved to project Plugin - CsvImport","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-03-18T06:09:37-04:00","updated_at":"2019-03-18T06:09:37-04:00"}]},{"id":25559,"summary":"CSV Importer Plugin Installed in Mantis - But when try to import CSV file Mantis  Throwing Error as APPLICATION Error #11","description":"I am getting the below error A necessary field \"Summary\" was empty. Please recheck your inputs.Can anyone suggest how to proceed.\n\nI have mapped the summary column in import but still shows the error.\n\nI have installed the files from Github but still not able to import.\n\nAttached the php files for reference.\n\nThank You.","additional_information":"<?php\nclass Csv_importPlugin extends MantisPlugin\n{\n    function register() {\n        $this->name = plugin_lang_get( 'title' );\n        $this->description = plugin_lang_get( 'description' );\n\n        $this->version = '2.0.0';\n        $this->requires = array( 'MantisCore' => '2.0.0' );\n        $this->author = 'Bug 4220 Team';\n        $this->contact = 'https:\/\/github.com\/mantisbt-plugins\/csv-import\/';\n        $this->url = 'https:\/\/github.com\/mantisbt-plugins\/csv-import\/';\n        $this->page = 'config';\n    }\n\n    function config() {\n        return array(\n            'import_issues_threshold'   => MANAGER ,\n            );\n    }\n\n    function hooks() {\n        return array(\n            'EVENT_MENU_MANAGE' => 'csv_import_menu',\n        );\n    }\n\n    function csv_import_menu() {\n        return array(\n            '<a href=\"' . plugin_page( 'import_issues_page_init' ) . '\">' . plugin_lang_get( 'manage_issues_link' ) . '<\/a>',\n        );\n    }\n}","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":46949,"name":"Pavithra"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":50,"name":"urgent","label":"urgent"},"severity":{"id":80,"name":"block","label":"block"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2019-03-04T08:09:26-05:00","updated_at":"2019-03-04T08:27:43-05:00","attachments":[{"id":8457,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T08:09:26-05:00","filename":"Csv_import.php","size":845,"content_type":"text\/x-php; charset=us-ascii"},{"id":8458,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T08:09:26-05:00","filename":"config.php","size":1788,"content_type":"text\/x-php; charset=us-ascii"},{"id":8459,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T08:09:26-05:00","filename":"config_edit.php","size":314,"content_type":"text\/x-php; charset=us-ascii"},{"id":8460,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T08:09:26-05:00","filename":"import_issues.php","size":12261,"content_type":"text\/x-php; charset=us-ascii"},{"id":8461,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T08:09:26-05:00","filename":"import_issues_inc.php","size":8704,"content_type":"text\/x-php; charset=us-ascii"},{"id":8462,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T08:09:26-05:00","filename":"import_issues_page_col_set.php","size":9619,"content_type":"text\/x-php; charset=us-ascii"},{"id":8463,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T08:09:26-05:00","filename":"import_issues_page_init.php","size":5233,"content_type":"text\/x-php; charset=us-ascii"}]},{"id":25558,"summary":"Mantis - Import CSV File - Throwing Error as APPLICATION ERROR #11","description":"I am getting the below error A necessary field \"Summary\" was empty. Please recheck your inputs.Can anyone suggest how to proceed.\r\n\r\nI have mapped the summary column in import but still shows the error.\r\n\r\nPlease assist me in this.\r\n\r\n<?php\r\nclass Csv_importPlugin extends MantisPlugin\r\n{\r\n    function register() {\r\n        $this->name = plugin_lang_get( 'title' );\r\n        $this->description = plugin_lang_get( 'description' );\r\n\r\n        $this->version = '2.0.0';\r\n        $this->requires = array( 'MantisCore' => '2.0.0' );\r\n        $this->author = 'Bug 4220 Team';\r\n        $this->contact = 'https:\/\/github.com\/mantisbt-plugins\/csv-import\/';\r\n        $this->url = 'https:\/\/github.com\/mantisbt-plugins\/csv-import\/';\r\n        $this->page = 'config';\r\n    }\r\n\r\n    function config() {\r\n        return array(\r\n            'import_issues_threshold'   => MANAGER ,\r\n            );\r\n    }\r\n\r\n    function hooks() {\r\n        return array(\r\n            'EVENT_MENU_MANAGE' => 'csv_import_menu',\r\n        );\r\n    }\r\n\r\n    function csv_import_menu() {\r\n        return array(\r\n            '<a href=\"' . plugin_page( 'import_issues_page_init' ) . '\">' . plugin_lang_get( 'manage_issues_link' ) . '<\/a>',\r\n        );\r\n    }\r\n}","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":46949,"name":"Pavithra"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":50,"name":"urgent","label":"urgent"},"severity":{"id":80,"name":"block","label":"block"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2019-03-04T05:53:09-05:00","updated_at":"2019-03-04T05:56:48-05:00","attachments":[{"id":8450,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T05:54:08-05:00","filename":"Csv_import.php","size":845,"content_type":"text\/x-php; charset=us-ascii"},{"id":8452,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T05:55:13-05:00","filename":"config_edit.php","size":314,"content_type":"text\/x-php; charset=us-ascii"},{"id":8451,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T05:55:13-05:00","filename":"config.php","size":1788,"content_type":"text\/x-php; charset=us-ascii"},{"id":8453,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T05:55:13-05:00","filename":"import_issues.php","size":12261,"content_type":"text\/x-php; charset=us-ascii"},{"id":8454,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T05:55:13-05:00","filename":"import_issues_inc.php","size":8704,"content_type":"text\/x-php; charset=us-ascii"},{"id":8455,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T05:55:13-05:00","filename":"import_issues_page_col_set.php","size":9619,"content_type":"text\/x-php; charset=us-ascii"},{"id":8456,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-04T05:55:13-05:00","filename":"import_issues_page_init.php","size":5233,"content_type":"text\/x-php; charset=us-ascii"}],"notes":[{"id":61618,"reporter":{"id":46949,"name":"Pavithra"},"text":"I have downloaded all the latest files from GitHub but still it throws Error.\r\n\r\nPlease assist me how to proceed further on this.\r\n\r\nThank You","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-03-04T05:56:26-05:00","updated_at":"2019-03-04T05:56:26-05:00"}]},{"id":25541,"summary":"Import CSV File in Mantis","description":"APPLICATION ERROR #11\r\n\r\nA necessary field \"Summary\" was empty. Please recheck your inputs.\r\n\r\nPlease use the \"Back\" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.\r\nPrevious non-fatal errors occurred. Page contents follow.\r\nSYSTEM NOTICE: 'Undefined offset: 1' in 'D:\\xampp\\htdocs\\Mantis\\core\\classes\\BugFilterQuery.class.php' line 1359\r\nSYSTEM NOTICE: 'Undefined offset: 2' in 'D:\\xampp\\htdocs\\Mantis\\core\\classes\\BugFilterQuery.class.php' line 1359","additional_information":"I have mapped the summary field in summary column but still I get this error.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":46949,"name":"Pavithra"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":50,"name":"urgent","label":"urgent"},"severity":{"id":80,"name":"block","label":"block"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2019-03-02T04:34:30-05:00","updated_at":"2019-03-02T16:44:57-05:00","attachments":[{"id":8448,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-02T04:34:30-05:00","filename":"BugFilterQuery.class.php","size":61529,"content_type":"text\/x-php; charset=us-ascii"}]},{"id":25540,"summary":"SYSTEM WARNING -'\"continue\" targeting switch is equivalent to \"break\". Did you mean to use \"continue 2\"?' in 'D:\\xampp\\htdocs\\Ma","description":"When I try to import the Csv file into mantis it comes up with following error message.\r\n\r\nAttached the import_issues.php for reference.\r\n\r\nThank You","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":46949,"name":"Pavithra"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":50,"name":"urgent","label":"urgent"},"severity":{"id":80,"name":"block","label":"block"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2019-03-02T04:17:57-05:00","updated_at":"2019-03-02T16:43:42-05:00","attachments":[{"id":8447,"reporter":{"id":46949,"name":"Pavithra"},"created_at":"2019-03-02T04:17:57-05:00","filename":"import_issues.php","size":11855,"content_type":"text\/x-php; charset=us-ascii"}]},{"id":20061,"summary":"csv import doesn't import unicode characters correctly","description":"\u201cRealizar b\u00fasqueda y organizaci\u00f3n de versiones de c\u00f3digo e instalables de los desarrollos de RMS.\u201d\r\n\r\nbecomes\r\n\r\n\u201cRealizar b\u00c3\u00basqueda y organizaci\u00c3\u00b3n de versiones de c\u00c3\u00b3digo e instalables de los desarrollos de RMS.\u201d","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":33563,"name":"syncguru"},"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2015-08-29T18:14:32-04:00","updated_at":"2019-01-30T23:15:55-05:00","notes":[{"id":53527,"reporter":{"id":33563,"name":"syncguru"},"text":"Pull request: https:\/\/github.com\/mantisbt-plugins\/csv-import\/pull\/2\r\n\r\nImporting seems to get tripped by text like the following (potentially a file_get_contents() bug):\r\n\u201cRealizar b\u00fasqueda y organizaci\u00f3n de versiones .....\u201d\r\n\r\nThe fix for this is to convert special chars (non-html) to html entities prior to importing.\r\nThis fix is based on stackoverflow conversation: http:\/\/stackoverflow.com\/questions\/2236668\/file-get-contents-breaks-up-utf-8-characters","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2016-07-07T23:35:22-04:00","updated_at":"2016-07-07T23:35:22-04:00"},{"id":59795,"reporter":{"id":17784,"name":"dregad"},"text":"PR was merged on Jul 8, 2016","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-05-15T06:49:13-04:00","updated_at":"2018-05-15T06:49:13-04:00"},{"id":61341,"reporter":{"id":46852,"name":"devonrickman"},"text":"Importing seems to get tripped by text.\r\nhttps:\/\/www.just4dummies.com\/gmail-sign-up","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2019-01-30T23:15:55-05:00","updated_at":"2019-01-30T23:15:55-05:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":24428,"summary":"Enabling Mantis CSV Importer ver.1.4.0 on MantisBT ver.2.14.0","description":"Hi,\r\n\r\nAs for the subject compatibility matter, is there any workaround or another method to enable CSV import feature anything?\r\n\r\nKind regards,\r\nRyu","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":45140,"name":"Ryu"},"handler":{"id":17784,"name":"dregad"},"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":60,"name":"duplicate","label":"duplicate"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":10,"name":"feature","label":"feature"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2018-05-14T03:54:39-04:00","updated_at":"2018-10-02T05:26:12-04:00","notes":[{"id":59780,"reporter":{"id":17784,"name":"dregad"},"text":"The CSV plugin is not maintain by MantisBT core team. I'm moving your issue to the dedicated project, and closing it as duplicate of #0024178.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-05-14T04:10:42-04:00","updated_at":"2018-05-14T04:10:42-04:00"}],"relationships":[{"id":9412,"type":{"id":0,"name":"duplicate-of","label":"duplicate of"},"issue":{"id":24178,"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"summary":"Mantis CSV Importer 1.4.0 plugin can not be installed","handler":{"id":17784,"name":"dregad"}}}]},{"id":24744,"summary":"Separators inside column values in quotation marks causes failure to import","description":"If the separator is semi-colon, and one of the column values has a semi-colon, the column value is exported between quotation marks.  This correctly in Excel, but the import code thinks that there are incorrect number of columns rather than honoring the quotation marks around the value and not counting the separator.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2018-09-09T02:54:50-04:00","updated_at":"2018-09-09T02:54:50-04:00"},{"id":24595,"summary":"MantisBT Version:2.13.1 import Fail Please","description":"MantisBT Version:2.13.1\r\n\r\nPlugin: Import\/Export issues 2.13.1\r\n\r\nImporting file, please wait... Done\r\nProcessing cross-references for 0 issues... Done\r\n\r\nCSV File Format is\r\nproject_id\tReporter\tAssigned\tPriority\tSeverity\tReproducibility\tVersion\tCategory_id\tDate Submitted\tView_Status\tUpdated\tsummary\tdescription\tStatus\tResolution\r\n2\tyqcui\tyqcui\t20\t20\t70\t\t5\t2018\/7\/6\t10\t2018\/7\/6\tMOD \u5f00\u53d1\u529f\u80fd\u6807\u9898\t\u5f00\u53d1\u529f\u80fd\u8be6\u7ec6\u5185\u5bb9\t50\t10\r\n\r\n\r\nImporting file, please wait... Done\r\nProcessing cross-references for 0 issues... Done","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":44777,"name":"yqcui"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2018-07-08T22:50:32-04:00","updated_at":"2018-07-08T22:50:32-04:00"},{"id":21198,"summary":"Due Date field and customised date fields are not imported","description":"I am currently using the Mantis 1.2.19 version.\r\n When trying to import a CSV file into Mantis, the preview is OK, but after import:\r\n  - the core \"Due Date\" field always remains empty,\r\n  - the customised Date fields are always set to 01-01-1970\r\n\r\n(only the import into the core Date field \"Date Submitted\" is imported correctly)\r\n","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":39727,"name":"mantisiator"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":50,"name":"urgent","label":"urgent"},"severity":{"id":80,"name":"block","label":"block"},"reproducibility":{"id":10,"name":"always","label":"always"},"platform":"2.1.19","sticky":false,"created_at":"2016-07-05T03:53:15-04:00","updated_at":"2018-05-15T06:50:33-04:00","notes":[{"id":53919,"reporter":{"id":39727,"name":"mantisiator"},"text":"Hi,\r\n The problem has been identified in version 1.2.19\r\n Since then, a new brach has been created for the 1.3.x versions. Can you please indicate if any action has been undertaken on that point in that new branch ?\r\nThanks a lot in advance !","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2016-09-01T04:03:44-04:00","updated_at":"2016-09-01T04:03:44-04:00"},{"id":53920,"reporter":{"id":39727,"name":"mantisiator"},"text":"Hi,\r\n I finally found out the solution to the problem:\r\n The custom fields of Date type have to be imported in a specific format, ie number of seconds after 01-01-1970 in order to be imported properly.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2016-09-01T05:11:51-04:00","updated_at":"2016-09-01T05:11:51-04:00"},{"id":53921,"reporter":{"id":39727,"name":"mantisiator"},"text":"Hi,\r\n To be more precise, as complementary information if it can help in Excel, the following function is OK to have the number of seconds since 01\/01\/1970:\r\n\r\n`=(\"2009-02-13\"-\"1970-01-01\")*24*60*60`\n\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2016-09-01T07:53:20-04:00","updated_at":"2018-05-15T06:50:33-04:00"}]},{"id":19939,"summary":"I can\u00b4t export reports as CVS","description":"When I am trying to export to excel or CSV appears:  \r\n\r\n\"\"Corrupted file, it can\u00b4t  be open\"\"\r\n\r\nI\u00b4m trying for opening 3000 records\"\"\r\n\r\nI will apreciate your colaboration.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":38210,"name":"jcflorez17"},"handler":{"id":17784,"name":"dregad"},"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":40,"name":"unable to duplicate","label":"unable to reproduce"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":50,"name":"urgent","label":"urgent"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"platform":"Win","os":"Win2008","os_build":"Win2008R2","sticky":false,"created_at":"2015-07-16T19:01:00-04:00","updated_at":"2018-05-15T06:07:35-04:00","notes":[{"id":59793,"reporter":{"id":17784,"name":"dregad"},"text":"Considering this issue is 3 years old, I would assume it is no longer current so I'm closing it.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-05-15T06:07:35-04:00","updated_at":"2018-05-15T06:07:35-04:00"}]},{"id":24178,"summary":"Mantis CSV Importer 1.4.0 plugin can not be installed","description":"when trying to perform the installation of the Mantis CSV Importer 1.4.0 plugin does not allow it, the button is not installed","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":44965,"name":"Cirley Salazar"},"handler":{"id":17784,"name":"dregad"},"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":30,"name":"sometimes","label":"sometimes"},"sticky":false,"created_at":"2018-03-27T18:31:24-04:00","updated_at":"2018-05-15T06:05:54-04:00","notes":[{"id":59781,"reporter":{"id":17784,"name":"dregad"},"text":"I have not actually tested, but according to the plugin's [README](https:\/\/github.com\/mantisbt-plugins\/csv-import\/blob\/master\/README.md), you should be using the _modern-ui_ branch with MantisBT 2.x.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-05-14T04:16:19-04:00","updated_at":"2018-05-14T04:16:19-04:00"},{"id":59785,"reporter":{"id":17784,"name":"dregad"},"text":"I tagged a new 2.0.0 release that should work with Mantis 2.x.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-05-14T11:10:20-04:00","updated_at":"2018-05-14T11:10:20-04:00"}],"relationships":[{"id":9412,"type":{"id":4,"name":"has-duplicate","label":"has duplicate"},"issue":{"id":24428,"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":60,"name":"duplicate","label":"duplicate"},"summary":"Enabling Mantis CSV Importer ver.1.4.0 on MantisBT ver.2.14.0","handler":{"id":17784,"name":"dregad"}}},{"id":9415,"type":{"id":4,"name":"has-duplicate","label":"has duplicate"},"issue":{"id":22297,"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":60,"name":"duplicate","label":"duplicate"},"summary":"Unable to install csv_import plugin in the mantisbt 2.0.0 version","handler":{"id":17784,"name":"dregad"}}}]},{"id":22297,"summary":"Unable to install csv_import plugin in the mantisbt 2.0.0 version","description":"Dear I tried to install plugin \"csv_import 1.4.0 \" in the new mantisbt 2.0.0 but I ve no 'install\" button . \r\nI already see a ticket for this issue, so I follow instruction : reinstall mantis but still have the same pb.\r\nMy mantis version : 2.0.0 the official released one \r\nMySQL : 5.7 \r\nApache: 2.4\r\nBrowser : Firefox (I tried with IE too)","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":36458,"name":"lracape"},"handler":{"id":17784,"name":"dregad"},"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":60,"name":"duplicate","label":"duplicate"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2017-02-01T05:03:50-05:00","updated_at":"2018-05-15T06:05:54-04:00","notes":[{"id":55431,"reporter":{"id":11111,"name":"atrol"},"text":"Do you use branch modern-ui?\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import#compatibility","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-02-01T05:12:53-05:00","updated_at":"2017-02-01T05:12:53-05:00"},{"id":55432,"reporter":{"id":36458,"name":"lracape"},"text":"installing mantisbt 2.1.0 to make test but no results","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-02-01T05:23:24-05:00","updated_at":"2017-02-01T05:23:24-05:00"},{"id":55433,"reporter":{"id":36458,"name":"lracape"},"text":"yes I'm using branch modern-ui (does it mean last mantis bt version officially delivered in january ??)","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-02-01T05:24:28-05:00","updated_at":"2017-02-01T05:24:28-05:00"},{"id":55909,"reporter":{"id":11111,"name":"atrol"},"text":"> does it mean last mantis bt version officially delivered in january ??)\r\n\r\nno. the question was whether  you use branch modern-ui of the plugin https:\/\/github.com\/mantisbt-plugins\/csv-import\/tree\/modern-ui\r\n","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-03-05T14:33:10-05:00","updated_at":"2017-03-05T14:33:10-05:00"}],"relationships":[{"id":9415,"type":{"id":0,"name":"duplicate-of","label":"duplicate of"},"issue":{"id":24178,"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"summary":"Mantis CSV Importer 1.4.0 plugin can not be installed","handler":{"id":17784,"name":"dregad"}}}]},{"id":23849,"summary":"How to import new issues by CSV","description":"Hi,\r\n\r\nMantisBT Version :2.5.1\r\n\r\nPlugin: Import\/Export issues 2.5.1\r\n\r\nAfter installed this plugin, there is a function 'Import Issues'\r\n\r\nProblem:   I ca","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":44334,"name":"Amiz"},"handler":{"id":17784,"name":"dregad"},"status":{"id":80,"name":"resolved","label":"resolved","color":"#d2f5b0"},"resolution":{"id":70,"name":"not a bug","label":"no change required"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2018-01-18T02:27:19-05:00","updated_at":"2018-05-15T06:02:54-04:00","notes":[{"id":58587,"reporter":{"id":44334,"name":"Amiz"},"text":"It can be closed.\r\nI have found a method to import issues by CSV file.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-01-22T00:55:20-05:00","updated_at":"2018-01-22T00:55:20-05:00"}]},{"id":22597,"summary":"When import CSV to update issue, even if 'ID' is not marked as primary key, the issue can be updated","description":"When import CSV to update issue, even if column 'ID' is not marked as primary key, the issue can be updated. What is the meaning of column \"primary key\"?","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":42281,"name":"icoams"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2017-03-28T22:49:15-04:00","updated_at":"2018-01-19T01:22:46-05:00","notes":[{"id":56336,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-04-03T02:41:26-04:00","updated_at":"2017-04-03T02:41:26-04:00"},{"id":56686,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-04-24T02:18:31-04:00","updated_at":"2017-04-24T02:18:31-04:00"},{"id":56798,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-05-07T21:47:17-04:00","updated_at":"2017-05-07T21:47:17-04:00"},{"id":56854,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-05-14T21:45:23-04:00","updated_at":"2017-05-14T21:45:23-04:00"},{"id":56933,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-05-21T21:51:02-04:00","updated_at":"2017-05-21T21:51:02-04:00"},{"id":58554,"reporter":{"id":44334,"name":"Amiz"},"text":"@icoams\r\nCould you give me some advice of this plugin?\r\nI want to import some new issues by plugin?\r\n\r\nWhere can I download it?\r\n\r\nThanks very much","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-01-18T02:20:11-05:00","updated_at":"2018-01-18T02:20:11-05:00"},{"id":58561,"reporter":{"id":42281,"name":"icoams"},"text":"@Amiz\r\nCSV import plugin: https:\/\/github.com\/mantisbt-plugins\/csv-import\/\r\nSee readme.txt in folder doc for instruction on how to use it","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-01-18T22:26:59-05:00","updated_at":"2018-01-18T22:26:59-05:00"},{"id":58562,"reporter":{"id":44334,"name":"Amiz"},"text":"@icoams\r\nI have installed it , and it works fine.\r\nThank you very much. :)","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2018-01-19T01:22:46-05:00","updated_at":"2018-01-19T01:22:46-05:00"}]},{"id":23170,"summary":"Incorrect custom field reported when encountering import error using CSVImport plugin (modern-UI)","description":"When an error is found when importing data into custom fields in Mantis using the ImportCSV plug-in, the error message that is displayed reports the incorrect custom field. The actual field name at fault is extracted from the $t_def array that was populated in the 'default' case of the aColumn for-loop higher up. (line 290 in import_issues.php)\r\n\r\nHowever, the code that displays the error is in another loop that requires that the $t_def array be re-populated using the new loop's index of $t_id. (line 353)\r\n\r\nAdd :\r\n\r\n$t_def = custom_field_get_definition( $t_id );\r\n\r\nat line 346 (inside second loop) to repopulate the $t_def array with the correct values.","steps_to_reproduce":"The easiest way is to try and import data into an enumerated field, which is not the first custom field, that does not have the imported value in the enum list. ","additional_information":"In addition, it would be handy to know *what* the data is that's being rejected by the import.\r\nI've replaced the . ' <br \/>>' with    . ', value \"' . $t_value . '\"<br \/>'; on line 353","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":41538,"name":"MartinW"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2017-07-31T06:07:35-04:00","updated_at":"2017-07-31T06:14:23-04:00","notes":[{"id":57360,"reporter":{"id":11111,"name":"atrol"},"text":"Moved the issue to the right project.","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-07-31T06:14:23-04:00","updated_at":"2017-07-31T06:14:23-04:00"}]},{"id":22596,"summary":"When import CSV to insert new issue, issue will be created even if there are invalid values","description":"When import CSV to insert new issue, if there are invalid value(value which is unable to select in UI), the issue will be created without any warning.\r\nFor example, in csv file, enter \"N\/A\" for Reproducibility, but \"N\/A\" is unable to select in UI. The new issue will be created with Reproducibility equal to @100@.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":42281,"name":"icoams"},"status":{"id":10,"name":"new","label":"new","color":"#fcbdbd"},"resolution":{"id":10,"name":"open","label":"open"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":60,"name":"major","label":"major"},"reproducibility":{"id":10,"name":"always","label":"always"},"sticky":false,"created_at":"2017-03-28T22:47:20-04:00","updated_at":"2017-05-21T21:50:52-04:00","notes":[{"id":56335,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-04-03T02:41:09-04:00","updated_at":"2017-04-03T02:41:09-04:00"},{"id":56685,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-04-24T02:18:19-04:00","updated_at":"2017-04-24T02:18:19-04:00"},{"id":56799,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-05-07T21:47:50-04:00","updated_at":"2017-05-07T21:47:50-04:00"},{"id":56853,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-05-14T21:45:00-04:00","updated_at":"2017-05-14T21:45:00-04:00"},{"id":56932,"reporter":{"id":42281,"name":"icoams"},"text":"Hi, any update?","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2017-05-21T21:50:52-04:00","updated_at":"2017-05-21T21:50:52-04:00"}]},{"id":17543,"summary":"User names with invalid email characters and no email address trigger error","description":"If no email address field is being imported, the importer creates an email address out of user name.  If the user name contains spaces or some invalid characters for emails, then import process exists with invalid email address.\r\n\r\nSince users are created as disabled and hence won't be targeted by emails and since we create an invalid email address anyway, we should just create md5(username)@localhost as the email address rather than trying to sanitize all invalid characters.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-07-25T21:42:27-04:00","updated_at":"2017-04-01T00:14:15-04:00"},{"id":17542,"summary":"When unknown categories are not created, use default category","description":"When user doesn't select \"create unknown categories\" and an unknown category is found, use config value for 'default_category_for_moves' to default the category.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-07-25T21:38:07-04:00","updated_at":"2017-04-01T00:14:15-04:00"},{"id":17439,"summary":"Use \"General\" category instead of creating \"csv_import\"","description":"Default to \"General\" instead of creating a \"csv_import\" category when no category is specified.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-10T01:57:00-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40789,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/3d0515903c03e6fb45ee420719ba71fc2c47d6d3","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-10T04:07:41-04:00","updated_at":"2014-06-10T04:07:41-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17436,"summary":"Imported issues are being assigned to logged in user","description":"Imported issues that are not assigned are being assigned to logged in user.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-10T00:42:14-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40788,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix Checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/2de983da615d361e3262ecb53d8e8364bd1ea1b5","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-10T00:58:52-04:00","updated_at":"2014-06-10T00:58:52-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17435,"summary":"max_file_size lang string doesn't exist","description":"MantisBT v1.2.x has max_file_size while master has max_file_size_label.  In order to avoid hitting this incompatibility, define a string that is location to the extension.  Ideally, the string names won't change between 1.2.x and master.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:48:39-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40785,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/a9c97199bf77d00920ae77cb2a52e21370f1cb51","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:50:52-04:00","updated_at":"2014-06-09T22:50:52-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17434,"summary":"Fix config option typo \"import_issues_treshold\"","description":"import_issues_treshold should be import_issues_threshold in the csv import plugin.  This causes warnings.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:39:49-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40784,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/997fb5c1ef22ff866dc3ac893894848f9d0ef7dd","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:50:06-04:00","updated_at":"2014-06-09T22:50:06-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17433,"summary":"Matching category names should take inherited categories in consideration","description":"The Csv import plugin currently doesn't take inherited categories in consideration when matching categories.  If an inherited category is referenced it will create a new one that is specific to the project if create missing categories is checked.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:13:02-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40787,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/a9d4a42874f3581de3250199c0043ef6367719ff","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-10T00:58:02-04:00","updated_at":"2014-06-10T00:58:02-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17432,"summary":"Support backslash-N to encode new lines in csv files","description":"For string fields replace \\n with a new line as part of the import process.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:11:32-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40783,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/a039f0226aa8843b990be6db151d81ea2e4b1aac","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:11:53-04:00","updated_at":"2014-06-09T22:11:53-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17431,"summary":"User name transformations should only be used to find matches and not to add new users","description":"The plugin has a method that attempts to filter characters in usernames to see if they have matches.  The change should only stick if a match is found.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:10:05-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40782,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix Checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/7b50b62966b932fb701ef1ad7778bd75caf25a27","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:10:23-04:00","updated_at":"2014-06-09T22:10:23-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17430,"summary":"Email user name gets truncated","description":"The import process should retain the full email address when used as user names rather than truncating them.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:06:35-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40781,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix Checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/61a075a1c1ad115486293b9ab70140fd1e7dd024","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:06:59-04:00","updated_at":"2014-06-09T22:06:59-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17429,"summary":"Support case where csv has more fields than Mantis","description":"The import process errors out when csv has more fields than MantisBT.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:05:14-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40780,"reporter":{"id":3081,"name":"vboctor"},"text":"Checkin link:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/b9b5b93457bcfa4de7972d04e1d709cb34b612a1","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:05:34-04:00","updated_at":"2014-06-09T22:05:34-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17427,"summary":"By default import as new issues rather than match by ids.","description":"By default the import wizard should be setup to import as new issues and not match existing, since this is a common case and to avoid confusing errors.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:02:22-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40778,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/8b3288147d677d364dc2bc8418ef6916458bdcb6","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:02:40-04:00","updated_at":"2014-06-09T22:02:40-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17426,"summary":"Default to 'ignore_column' when column name doesn't match a known column","description":"At the moment it matches first available column.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T22:01:02-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40777,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/1f5800da759263b492d624bc9311c1e2f35ef8bd","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:01:22-04:00","updated_at":"2014-06-09T22:01:22-04:00"}],"tags":[{"id":213,"name":"mantishub"}]},{"id":17425,"summary":"Added users should have valid email addresses, random password, and disabled","description":"It is important to not create non-secure user accounts as part of the csv import.  Before this change an account was created with empty email, and user name as the password.  The change sets the email to a valid address, sets a random password, and creates the account as disabled.  Administrators can then go an re-enable \/ reset password if needed.","project":{"id":11,"name":"Plugin - CsvImport"},"category":{"id":1,"name":"General"},"reporter":{"id":3081,"name":"vboctor"},"handler":{"id":3081,"name":"vboctor"},"status":{"id":90,"name":"closed","label":"closed","color":"#c9ccc4"},"resolution":{"id":20,"name":"fixed","label":"fixed"},"view_state":{"id":10,"name":"public","label":"public"},"priority":{"id":30,"name":"normal","label":"normal"},"severity":{"id":50,"name":"minor","label":"minor"},"reproducibility":{"id":70,"name":"have not tried","label":"have not tried"},"sticky":false,"created_at":"2014-06-09T21:59:34-04:00","updated_at":"2017-04-01T00:14:15-04:00","notes":[{"id":40776,"reporter":{"id":3081,"name":"vboctor"},"text":"Fix checkin:\r\nhttps:\/\/github.com\/mantisbt-plugins\/csv-import\/commit\/52282890bb70838ee3c77130dc35122a8357a9bf","view_state":{"id":10,"name":"public","label":"public"},"attachments":[],"type":"note","created_at":"2014-06-09T22:00:07-04:00","updated_at":"2014-06-09T22:00:07-04:00"}],"tags":[{"id":213,"name":"mantishub"}]}]}