Hi,

you can try LOAD DATA INFILE .../PATH/ INTO TABLE command.

try this link.. http://lists.mysql.com/commits/44193 for importing
data from spreadsheet to mysql.

regards

hari

On Tue, Oct 7, 2008 at 10:26 AM, Jain, Shweta IN GGN SISL <
Shweta.Jain@siemens.com> wrote:

> Hi,
>
>
>
> I am unable to get the backend database access. Is it possible to import
> the data into bugzilla from front end
>
>
>
> Regards
>
> Shweta
>
>
>
> ________________________________
>
> From: Pankaj Mishra [mailto:PAMishra@mdsynergy.com]
> Sent: Monday, October 06, 2008 3:19 PM
> To: Jain, Shweta IN GGN SISL
> Subject: RE: Import records into Bugzilla
>
>
>
> Well then, Please follow the info in this webpage and most probably you
> ll be able to do it. However, if stuck please do reply:
>
>
>
> http://forums.mysql.com/read.php?79,1888,2313#msg-2313
>
>
>
> The steps are very simple just you need to know which table would you
> like the data to be imported to.
>
> ________________________________
>
> From: Jain, Shweta IN GGN SISL [mailto:Shweta.Jain@Siemens.com]
> Sent: Monday, October 06, 2008 2:11 PM
> To: Pankaj Mishra
> Subject: RE: Import records into Bugzilla
>
>
>
> MySQL 5.0
>
>
>
> ________________________________
>
> From: Pankaj Mishra [mailto:PAMishra@mdsynergy.com]
> Sent: Monday, October 06, 2008 11:24 AM
> To: Jain, Shweta IN GGN SISL
> Subject: RE: Import records into Bugzilla
>
>
>
> Can you tell me the name of the database that you r using.
>
>
>
> ________________________________
>
> From: Jain, Shweta IN GGN SISL [mailto:Shweta.Jain@Siemens.com]
> Sent: Mon 10/6/2008 11:22 AM
> To: Pankaj Mishra
> Subject: RE: Import records into Bugzilla
>
> Thanks for the reply Pankaj,
>
>
>
> I want to import CR data from an excel file to Bugzilla. Will you please
> tell me how to do that??
>
>
>
> Best
>
> Shweta
>
>
>
> ________________________________
>
> From: Pankaj Mishra [mailto:PAMishra@mdsynergy.com]
> Sent: Monday, October 06, 2008 11:14 AM
> To: Jain, Shweta IN GGN SISL
> Subject: RE: Import records into Bugzilla
>
>
>
> Hi shweta,
>
>
>
> There are two requirements as i think.
>
>
>
> 1> How to access the bugzilla database. - This may be done by going on
> the server and to see which database are u using. You may goto Program
> files and see the database installed (such as mySQL or MSSQL.)
>
> 2> The importing of the records. this may be easily done. However it
> depends on the type of records which you wish to import. There are
> various ways and there is no need to enter them manually.
>
>
>
> ________________________________
>
> From: support-bugzilla-bounces+pamishra=mdsynergy.com@lists.mozilla.org
> on behalf of Jain, Shweta IN GGN SISL
> Sent: Mon 10/6/2008 11:10 AM
> To: support-bugzilla@lists.mozilla.org
> Subject: Import records into Bugzilla
>
> Hi,
>
>
>
> I have a query regarding Bugzilla.
>
> Actually we are having a list of 500 records which needs to be put in
> Bugzilla. Is there any option in bugzilla where in we can import all the
> records rather than manually entering them one by one. Also pls let me
> know how to access the backend database of bugzilla?
>
> Will look forward to an early and prompt reply to my query will be
> appreciated.
>
>
>
> Thanks & Regards
>
> Shweta Jain
>
> Senior Systems Engineer
>
> Siemens Information Systems Limited.
>
> Ph : 284-6307
>
> Mobile : 9891706780
>
>
>
>
>
>
>
> Important notice:This e-mail and any attachment thereto contains
> corporate proprietary information. If you have received it by mistake,
> please notify us immediately by reply e-mail and delete this e-mail and
> its attachments from your system. Thank You.
> _______________________________________________
> support-bugzilla mailing list
> support-bugzilla@lists.mozilla.org
> https://lists.mozilla.org/listinfo/support-bugzilla
> PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you
> reply.
>
>
> Important notice:This e-mail and any attachment thereto contains
> corporate proprietary information. If you have received it by mistake,
> please notify us immediately by reply e-mail and delete this e-mail and
> its attachments from your system.
> Thank You.
>
>
> Important notice:This e-mail and any attachment thereto contains
> corporate proprietary information. If you have received it by mistake,
> please notify us immediately by reply e-mail and delete this e-mail and
> its attachments from your system.
> Thank You.
>
>
>
>
>
> Important notice:This e-mail and any attachment thereto contains corporate
> proprietary information. If you have received it by mistake, please notify
> us immediately by reply e-mail and delete this e-mail and its attachments
> from your system. Thank You.
> _______________________________________________
> support-bugzilla mailing list
> support-bugzilla@lists.mozilla.org
> https://lists.mozilla.org/listinfo/support-bugzilla
> PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you
> reply.
>