Re: Not able to import xml file
Dave Miller <[email protected]> Mon, 02 Sep 2024 14:39:07 -0400
| Newsgroups | gmane.comp.mozilla.devel.webtools |
|---|---|
| Message-ID | <[email protected]> |
--===============2213581167047390259==
Content-Type: multipart/alternative;
boundary=----9J9QFJ1I2FIFLG8ZBR1GPKFTOF66TK
Content-Transfer-Encoding: 7bit
------9J9QFJ1I2FIFLG8ZBR1GPKFTOF66TK
Content-Type: text/plain;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
Just saving as XML won't work as you need to have the fields in a specific =
format within the XML file=2E The uninitialized variables when running the =
script are indicating fields that it couldn't find in the file you fed it=
=2E=20
Probably the easiest way to do this is to export an existing bug from Bugz=
illa in XML (there should be a link at the bottom of the show_bug page for =
that) and then edit that file to replace the fields with the values you wan=
t to import, then feed *that* to the import script=2E
If you'll be doing this for a lot of bugs, you'll definitely be best off w=
riting a script to create XML files based on what you discover above out of=
the data you have=2E
On September 2, 2024 4:26:00 AM EDT, Praveen Kumar Bansal <praveen=2Ebansa=
l@puresoftware=2Ecom> wrote:
>Hi Team,
>
>Is there any way I can import csv file directly in Bugzilla=2E I anyway c=
reated =2Exml file by creating csv and then converting to xml using option =
XML Spreadsheet 2003 as you see in screenshot below=2E I have updated colum=
n names and also did data massing in csv before conversion=2E Please check=
my issue below screenshot=2E
>
>[cid:image001=2Epng@01DAFD3F=2E610C8B70]
>
>Getting below issues=2E Is it mandatory that I use option from above scre=
enshot as csv to xml using XML Data=2E Was avoiding this route as tricking =
asking more details around mapping etc=2E
>
>[cid:image002=2Epng@01DAFD3F=2ED7258BE0]
>
>Thanks and Regards,
>Praveen Bansal
>
--=20
Sent from my Android phone with K-9 Mail=2E Please excuse my brevity=2E
------9J9QFJ1I2FIFLG8ZBR1GPKFTOF66TK
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas=2Emicrosoft=2Ecom/office/2004/12/omml" xmlns=3D"h=
ttp://www=2Ew3=2Eorg/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii=
">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
=2Eshape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Aptos;}
/* Style Definitions */
p=2EMsoNormal, li=2EMsoNormal, div=2EMsoNormal
{margin:0cm;
font-size:12=2E0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span=2EEmailStyle17
{mso-style-type:personal-compose;
font-family:"Verdana",sans-serif;
color:#002060;
font-weight:normal;
font-style:normal;}
=2EMsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612=2E0pt 792=2E0pt;
margin:72=2E0pt 72=2E0pt 72=2E0pt 72=2E0pt;}
div=2EWordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-IN" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap=
:break-word"><div dir=3D"auto">Just saving as XML won't work as you need to=
have the fields in a specific format within the XML file=2E The uninitiali=
zed variables when running the script are indicating fields that it couldn'=
t find in the file you fed it=2E <br><br>Probably the easiest way to do thi=
s is to export an existing bug from Bugzilla in XML (there should be a link=
at the bottom of the show_bug page for that) and then edit that file to re=
place the fields with the values you want to import, then feed *that* to th=
e import script=2E<br><br>If you'll be doing this for a lot of bugs, you'll=
definitely be best off writing a script to create XML files based on what =
you discover above out of the data you have=2E</div><br><br><div class=3D"g=
mail_quote"><div dir=3D"auto">On September 2, 2024 4:26:00 AM EDT, Praveen =
Kumar Bansal <praveen=2Ebansal@puresoftware=2Ecom> wrote:</div><block=
quote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0=2E8ex; border-le=
ft: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060">Hi Team,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060">Is there any way I can import csv =
file directly in Bugzilla=2E I anyway created =2Exml file by creating csv a=
nd then converting to xml using option XML Spreadsheet
2003 as you see in screenshot below=2E I have updated column names and al=
so did data massing in csv before conversion=2E Please check my issue=
below screenshot=2E<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060"><img width=3D"275" height=3D"291" =
style=3D"width:2=2E8645in;height:3=2E0312in" id=3D"_x0000_i1026" src=3D"cid=
:image001=2Epng@01DAFD3F=2E610C8B70"></span><span style=3D"font-size:10=2E0=
pt;font-family:"Verdana",sans-serif;color:#002060"><o:p></o:p></s=
pan></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060">Getting below issues=2E Is it mand=
atory that I use option from above screenshot as csv to xml using XML Data=
=2E Was avoiding this route as tricking asking more details
around mapping etc=2E<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060"><img width=3D"775" height=3D"292" =
style=3D"width:8=2E0729in;height:3=2E0416in" id=3D"Picture_x0020_2" src=3D"=
cid:image002=2Epng@01DAFD3F=2ED7258BE0"></span><span style=3D"font-size:10=
=2E0pt;font-family:"Verdana",sans-serif;color:#002060"><o:p></o:p=
></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060">Thanks and Regards,<o:p></o:p></sp=
an></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10=2E0pt;font-family:"=
;Verdana",sans-serif;color:#002060">Praveen Bansal<o:p></o:p></span></=
p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
</blockquote></div><div dir=3D"auto"><div class=3D'k9mail-signature'>-- <b=
r>Sent from my Android phone with K-9 Mail=2E Please excuse my brevity=2E</=
div></div></body>
</html>
------9J9QFJ1I2FIFLG8ZBR1GPKFTOF66TK--
--===============2213581167047390259==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
support-list mailing list
[email protected]
https://lists.bugzilla.org/listinfo/support-list
--===============2213581167047390259==--