i have an excel spreadsheet full of bugs/feature requests (about 1400 of them) with about 6 columns of data. i was wondering if anyone else has written a script or query that might be of assistance in importing- like plugging in id#, timestamp, etc...
thanks,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Unfortunetly, this is a very custom type of application. You have to format SQL queries, or at least auto HTTP posts, and then put in the values from your spreadsheet. The problem is there are many, many different fields, orders, variable types, foreign keys, speadsheet formats, etc. that have to be taken into account.
For now, you'll need to enter them manually or write a script yourself. Sorry.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Rather than going through the 'back door' by dumping data straight into the database, may I suggest this concept:
'use a robot that records/learn your data entry for one bug on YOUR phpBT system, then modify that recorded macro to read from a CSV (generated from excel) and run the macro in a loop until the data file of CSV entries is exhausted.' the robot will enter the data for you, without you having to know any sql etc... but, you must learn to tame the macro, recording, formatting data in excel to get just the right CSV data entry, and you must know some scripting.
if you like this idea, try InternetMacros at www.iopus.com.
I used the trial version and this method for 200 data entries of 7-8 fields each. It completed data entry in 2hrs15minutes (2 hours to download, format data, learn scripting, record tool, etc..., and 15 minutes for it to data enter all the records).
Good luck,
rangsarn
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i have an excel spreadsheet full of bugs/feature requests (about 1400 of them) with about 6 columns of data. i was wondering if anyone else has written a script or query that might be of assistance in importing- like plugging in id#, timestamp, etc...
thanks,
I have the same problem - has there been any solution offered for this? Has anyone written a script to import data from text file? Thanks
Paul
Unfortunetly, this is a very custom type of application. You have to format SQL queries, or at least auto HTTP posts, and then put in the values from your spreadsheet. The problem is there are many, many different fields, orders, variable types, foreign keys, speadsheet formats, etc. that have to be taken into account.
For now, you'll need to enter them manually or write a script yourself. Sorry.
Rather than going through the 'back door' by dumping data straight into the database, may I suggest this concept:
'use a robot that records/learn your data entry for one bug on YOUR phpBT system, then modify that recorded macro to read from a CSV (generated from excel) and run the macro in a loop until the data file of CSV entries is exhausted.' the robot will enter the data for you, without you having to know any sql etc... but, you must learn to tame the macro, recording, formatting data in excel to get just the right CSV data entry, and you must know some scripting.
if you like this idea, try InternetMacros at www.iopus.com.
I used the trial version and this method for 200 data entries of 7-8 fields each. It completed data entry in 2hrs15minutes (2 hours to download, format data, learn scripting, record tool, etc..., and 15 minutes for it to data enter all the records).
Good luck,
rangsarn