Is there any way to import records (i.e., CSV-type records) into phpBugTracker, so that I can convert bug records from another system for use by phpBugTracker?
Thanks......Vic Antillon
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
On the other hand, it is not that hard to create a script that inserts such records into the phpbt_bug table. I wrote one that uploaded about 3000 records from an old text based system. I imported the text into Excel, massaged the data, output as csv, then ran my script...
Let me know if you need the script. (Can I upload it somewhere?) WARNING: I have modified the phpbt_bug table (amongst others) quite a bit, so there will be fields that don't exist. Just use the script as a guide and please modify it before using it!!!!!!
Greg
SCRIPT BELOW
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I used Navicat at http://www.navicat.com, it allows you to import various types of files including CSV, tab and Excel files. You can download it for a months trial and there isn't any restriction on the number of records imported.
regards
DaveR
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
InternetMacros is a macro recorder for the web.
You can record your actions that you do on the internet explorer browser using this program.
I downloaded the trial version, recorded myself entering one bug, then modified the macro and wrote a Windows Script (which Internet Macros understands and works with well) to control data entry for 200 records.
This way, no matter what modifications you have made to YOUR phpBT, you can always use this macro to robotically enter your data.
The data was imported into excel, massaged, and then exported as a CSV file. It worked like a charm... 200 records of 7-8 fields each, completed in 15 minutes (not counting the 2 hours spent downloading, learning, scripting,testing, formatting the data).
Cheers,
Rangsarn
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is there any way to import records (i.e., CSV-type records) into phpBugTracker, so that I can convert bug records from another system for use by phpBugTracker?
Thanks......Vic Antillon
That functionality doesn't currently exist.
On the other hand, it is not that hard to create a script that inserts such records into the phpbt_bug table. I wrote one that uploaded about 3000 records from an old text based system. I imported the text into Excel, massaged the data, output as csv, then ran my script...
Let me know if you need the script. (Can I upload it somewhere?) WARNING: I have modified the phpbt_bug table (amongst others) quite a bit, so there will be fields that don't exist. Just use the script as a guide and please modify it before using it!!!!!!
Greg
SCRIPT BELOW
Hi,
I used Navicat at http://www.navicat.com, it allows you to import various types of files including CSV, tab and Excel files. You can download it for a months trial and there isn't any restriction on the number of records imported.
regards
DaveR
Take a look at Internet Macros at www.iopus.com.
InternetMacros is a macro recorder for the web.
You can record your actions that you do on the internet explorer browser using this program.
I downloaded the trial version, recorded myself entering one bug, then modified the macro and wrote a Windows Script (which Internet Macros understands and works with well) to control data entry for 200 records.
This way, no matter what modifications you have made to YOUR phpBT, you can always use this macro to robotically enter your data.
The data was imported into excel, massaged, and then exported as a CSV file. It worked like a charm... 200 records of 7-8 fields each, completed in 15 minutes (not counting the 2 hours spent downloading, learning, scripting,testing, formatting the data).
Cheers,
Rangsarn