Importing bugs into Bugzilla
We have a commercial bug db, which has been in use for past one year. There are quite a number of records in it. We have an option to export bug reports into excel and csv. Now we have plans to migrate to Bugzilla.
Was wondering if Bugzilla has any facility to import bug reports from an excel or csv files. If such a facility does not exist, does any one know the backend DB queries to insert records into Bugzilla.
Re: Importing bugs into Bugzilla
You can import from a csv file. Try using the below query
LOAD DATA LOCAL INFILE '/testsample.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(assigned_to, bug_severity, bug_status, component_id, everconfirmed, op_sys, priority, product_id, rep_platform, reporter, short_desc, version)