Categories in export from database
Atle Enersen via opencms-dev <[email protected]> Sat, 8 Nov 2025 02:43:46 +0000
| Newsgroups | gmane.comp.cms.opencms.devel |
|---|---|
| Message-ID | <VI1PR10MB20632F80BBCC4D1AE2627384A9C0A@VI1PR10MB2063.EURPRD10.PROD.OUTLOOK.COM> |
--===============7298315557455768461==
Content-Language: en-US
Content-Type: multipart/alternative;
boundary="_000_VI1PR10MB20632F80BBCC4D1AE2627384A9C0AVI1PR10MB2063EURP_"
--_000_VI1PR10MB20632F80BBCC4D1AE2627384A9C0AVI1PR10MB2063EURP_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello.
Our installation is in production state, thanks for all the help so far. Si=
te/OpenCms (19) runds like a charm :-)
Now, we are trying (with success) to export data via the database interface=
in Launchpad. It works, but we have some questions...
1. It says in the XML exported:
<Categories>
<!--Categories are read dynamically-->
</Categories>
How are we supposed to get this dynamically in some way? We almost always h=
ave at least two catgories on our content objects, sometimes more.
2. How do we extract date/time the object was first published? In import we=
need to manipulate creation date/time as we shall load some thousand artic=
les into the system. We have these three fields, but those we have implemen=
ted in the XSD ourselves:
<DatePublish>1761962594574</DatePublish>
<DateVisible>1761962594575</DateVisible>
<DateUnpublish>1761962594575</DateUnpublish>
1. When importing, does the system assign filenames in the VFS?
1. When importing, are there some way to when import is done choose whic=
h objects that should go into the db and those we want to kick out (for sos=
me reason), or must all selection happen befor import?
1. How do we rollback a failure? Should we delay people from publishing,=
dump database, do the import, check. I all is ok, go on living; if all fai=
l, roll back dump?
As allways, thanks :-)
Best regards/Vennlig hilsen, Atle Enersen
--
Tel.: +47 48 06 31 71
--_000_VI1PR10MB20632F80BBCC4D1AE2627384A9C0AVI1PR10MB2063EURP_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of=
fice/2004/12/omml" xmlns=3D"http://www.w3.org/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)">
<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:Aptos;
panose-1:2 11 0 4 2 2 2 2 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:12.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:12.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span.EpostStil17
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
p.p1, li.p1, div.p1
{mso-style-name:p1;
margin:0cm;
background:white;
font-size:9.0pt;
font-family:Menlo;
color:#9B2393;}
p.p2, li.p2, div.p2
{mso-style-name:p2;
margin:0cm;
background:white;
font-size:9.0pt;
font-family:Menlo;
color:#5D6C79;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.s1
{mso-style-name:s1;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1239827346;
mso-list-type:hybrid;
mso-list-template-ids:-212563100 68419599 68419609 68419611 68419599 68419=
609 68419611 68419599 68419609 68419611;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1469858768;
mso-list-type:hybrid;
mso-list-template-ids:959620996 68419599 68419609 68419611 68419599 684196=
09 68419611 68419599 68419609 68419611;}
@list l1:level1
{mso-level-start-at:3;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style>
</head>
<body lang=3D"NO-BOK" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap=
:break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Our installation is in production state, thanks for =
all the help so far. Site/OpenCms (19) runds like a charm :-)<o:p></o:p></p=
>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Now, we are trying (with success) to export data via=
the database interface in Launchpad. It works, but we have some questions.=
..<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<ol style=3D"margin-top:0cm" start=3D"1" type=3D"1">
<li class=3D"MsoListParagraph" style=3D"margin-left:0cm;mso-list:l0 level1 =
lfo1">It says in the XML exported:<o:p></o:p></li></ol>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"p1"><span class=3D"apple-converted-space"> </span>=
<b><Categories></b><o:p></o:p></p>
<p class=3D"p2"><span class=3D"apple-converted-space"> =
</span><!--Categories are read dynamically--><o:p></o:p></p>
<p class=3D"p1"><span class=3D"apple-converted-space"> </span>=
<b></Categories></b><o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">How are we supposed to get this dynamically in some =
way? We almost always have at least two catgories on our content objects, s=
ometimes more.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"p1" style=3D"text-indent:35.4pt"><span style=3D"font-size:12.0p=
t;font-family:"Aptos",sans-serif;color:black">2. How do we extrac=
t date/time the object was first published? In import we need to manipulate=
creation date/time as we shall load some thousand
articles into the system. We have these three fields, but those we have im=
plemented in the XSD ourselves:<br>
<br>
</span><span class=3D"apple-converted-space"> </span><b><Da=
tePublish></b><span class=3D"s1">1761962594574</span><b></DatePublish=
></b><o:p></o:p></p>
<p class=3D"p1"><span class=3D"apple-converted-space"> </span>=
<b><DateVisible></b><span class=3D"s1">1761962594575</span><b></Da=
teVisible></b><o:p></o:p></p>
<p class=3D"p1"><span class=3D"apple-converted-space"> </span>=
<b><DateUnpublish></b><span class=3D"s1">1761962594575</span><b></=
DateUnpublish></b><o:p></o:p></p>
<p class=3D"MsoListParagraph"><o:p> </o:p></p>
<ol style=3D"margin-top:0cm" start=3D"3" type=3D"1">
<li class=3D"MsoListParagraph" style=3D"margin-left:0cm;mso-list:l1 level1 =
lfo2">When importing, does the system assign filenames in the VFS?<o:p></o:=
p></li></ol>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<ol style=3D"margin-top:0cm" start=3D"4" type=3D"1">
<li class=3D"MsoListParagraph" style=3D"margin-left:0cm;mso-list:l1 level1 =
lfo2">When importing, are there some way to when import is done choose whic=
h objects that should go into the db and those we want to kick out (for sos=
me reason), or must all selection happen
befor import? <o:p></o:p></li></ol>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<ol style=3D"margin-top:0cm" start=3D"5" type=3D"1">
<li class=3D"MsoListParagraph" style=3D"margin-left:0cm;mso-list:l1 level1 =
lfo2">How do we rollback a failure? Should we delay people from publishing,=
dump database, do the import, check. I all is ok, go on living; if all fai=
l, roll back dump?<o:p></o:p></li></ol>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">As allways, thanks :-)<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"mso-ligatures:none;mso-fareast-langua=
ge:NO-BOK">Best regards/Vennlig hilsen, Atle Enersen<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-ligatures:none;mso-fareast-langua=
ge:NO-BOK">-- <o:p></o:p></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"mso-ligatures:none">Tel.: +47 48 06 3=
1 71<o:p></o:p></span></p>
</div>
</div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
--_000_VI1PR10MB20632F80BBCC4D1AE2627384A9C0AVI1PR10MB2063EURP_--
--===============7298315557455768461==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KVGhpcyBtYWls
IGlzIHNlbnQgdG8geW91IGZyb20gdGhlIG9wZW5jbXMtZGV2IG1haWxpbmcgbGlzdApUbyBjaGFu
Z2UgeW91ciBsaXN0IG9wdGlvbnMsIG9yIHRvIHVuc3Vic2NyaWJlIGZyb20gdGhlIGxpc3QsIHBs
ZWFzZSB2aXNpdApodHRwczovL2xpc3RzLm9wZW5jbXMub3JnL21haWxtYW4vbGlzdGluZm8vb3Bl
bmNtcy1kZXYKCgoK
--===============7298315557455768461==--