Would entertaining hack of formula attribute be an option? ="this"&CHAR(10)&"that"
CHAR(13)? ----- Original Message ----- From: "general-requ...@developer.marklogic.com" <general-requ...@developer.marklogic.com> To: general@developer.marklogic.com Cc: Sent: Wednesday, February 22, 2012 9:48 AM Subject: General Digest, Vol 92, Issue 41 Send General mailing list submissions to general@developer.marklogic.com To subscribe or unsubscribe via the World Wide Web, visit http://developer.marklogic.com/mailman/listinfo/general or, via email, send a message with subject or body 'help' to general-requ...@developer.marklogic.com You can reach the person managing the list at general-ow...@developer.marklogic.com When replying, please edit your Subject line so it is more specific than "Re: Contents of General digest..." Today's Topics: 1. Passing Character Entities to Output (Betty Harvey) 2. Re: Passing Character Entities to Output (David Lee) 3. Re: Passing Character Entities to Output (Michael Blakeley) 4. Re: Passing Character Entities to Output (Betty Harvey) 5. Re: Passing Character Entities to Output (David Lee) 6. cpf pipeline question (Jakob Fix) 7. Re: cpf pipeline question (Pete Aven) ---------------------------------------------------------------------- Message: 1 Date: Tue, 21 Feb 2012 19:41:13 -0500 (EST) From: "Betty Harvey" <har...@eccnet.com> Subject: [MarkLogic Dev General] Passing Character Entities to Output To: "MarkLogic Developer Discussion" <general@developer.marklogic.com> Message-ID: <58268.207.168.47.25.1329871273.squir...@www.eccnet.com> Content-Type: text/plain;charset=iso-8859-1 I asked this question on the XQuery list and it looks like this can't be done in straight XQuery. I am asking this question here just in case there is a MarkLogic function that can be used. I need to pass a linefeed character to the output. I am creating Excel spreadsheets where I need a list on separate lines in a single cell. Excel recognizes the character entity for linefeeds. My output needs to look like this: <cell><data>hello big world</data></cell> The output I am getting is: <cell><data>hello big world</data></cell> I have tried several variations of: let $newline := " " let $newline := fn:concat("&", "#10;") etc. All having the same results, getting a linefeed instead of placing the actual character entity in the output. Are there any MarkLogic tricks to passing a character entity through without serializing it? TIA! Betty /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Betty Harvey | Phone: 410-787-9200 FAX: 9830 Electronic Commerce Connection, Inc. | har...@eccnet.com | Washington,DC XML Users Grp URL: http://www.eccnet.com | http://www.eccnet.com/xmlug /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ Member of XML Guild (www.xmlguild.org) ------------------------------ Message: 2 Date: Tue, 21 Feb 2012 16:46:03 -0800 From: David Lee <david....@marklogic.com> Subject: Re: [MarkLogic Dev General] Passing Character Entities to Output To: MarkLogic Developer Discussion <general@developer.marklogic.com> Message-ID: <eb42045a1f00224e93b82e949ec6675e16adc5f...@exchg-be.marklogic.com> Content-Type: text/plain; charset="us-ascii" did you try <cell><data>hello&#10;big&#10;world</data></cell> ----------------------------------------------------------------------------- David Lee Lead Engineer MarkLogic Corporation d...@marklogic.com Phone: +1 650-287-2531 Cell: +1 812-630-7622 www.marklogic.com This e-mail and any accompanying attachments are confidential. The information is intended solely for the use of the individual to whom it is addressed. Any review, disclosure, copying, distribution, or use of this e-mail communication by others is strictly prohibited. If you are not the intended recipient, please notify us immediately by returning this message to the sender and delete all copies. Thank you for your cooperation. > -----Original Message----- > From: general-boun...@developer.marklogic.com [mailto:general- > boun...@developer.marklogic.com] On Behalf Of Betty Harvey > Sent: Tuesday, February 21, 2012 7:41 PM > To: MarkLogic Developer Discussion > Subject: [MarkLogic Dev General] Passing Character Entities to Output > > I asked this question on the XQuery list and it looks like this can't be > done in straight XQuery. I am asking this question here just in case > there is a MarkLogic function that can be used. > > I need to pass a linefeed character to the output. I am creating Excel > spreadsheets where I need a list on separate lines in a single cell. > Excel recognizes the character entity for linefeeds. > > My output needs to look like this: > > <cell><data>hello big world</data></cell> > > The output I am getting is: > > <cell><data>hello > big > world</data></cell> > > I have tried several variations of: > > let $newline := " " > let $newline := fn:concat("&", "#10;") > > etc. All having the same results, getting a linefeed instead of placing > the actual character entity in the output. > > Are there any MarkLogic tricks to passing a character entity through > without serializing it? > > TIA! > > Betty > > > > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ > Betty Harvey | Phone: 410-787-9200 FAX: 9830 > Electronic Commerce Connection, Inc. | > har...@eccnet.com | Washington,DC XML Users Grp > URL: http://www.eccnet.com | http://www.eccnet.com/xmlug > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ > Member of XML Guild (www.xmlguild.org) > _______________________________________________ > General mailing list > General@developer.marklogic.com > http://developer.marklogic.com/mailman/listinfo/general ------------------------------ Message: 3 Date: Tue, 21 Feb 2012 16:59:16 -0800 From: Michael Blakeley <m...@blakeley.com> Subject: Re: [MarkLogic Dev General] Passing Character Entities to Output To: MarkLogic Developer Discussion <general@developer.marklogic.com> Message-ID: <3b7a43a0-11c8-4baa-b8db-5dfa09866...@blakeley.com> Content-Type: text/plain; charset=us-ascii Technically there is no difference: *means* codepoint 10 to any XML processor. A tool that only works when reading one or the other is broken. But you can configure your app server and set the "output sgml character entities" to "normal" - or anything other than "none". Then you should see this: <cell> <data>hello
big
world</data> </cell> I don't know if that's any better for your purposes, but at least it isn't the literal codepoint. -- Mike On 21 Feb 2012, at 16:41 , Betty Harvey wrote: > I asked this question on the XQuery list and it looks like this can't be > done in straight XQuery. I am asking this question here just in case > there is a MarkLogic function that can be used. > > I need to pass a linefeed character to the output. I am creating Excel > spreadsheets where I need a list on separate lines in a single cell. > Excel recognizes the character entity for linefeeds. > > My output needs to look like this: > > <cell><data>hello big world</data></cell> > > The output I am getting is: > > <cell><data>hello > big > world</data></cell> > > I have tried several variations of: > > let $newline := " " > let $newline := fn:concat("&", "#10;") > > etc. All having the same results, getting a linefeed instead of placing > the actual character entity in the output. > > Are there any MarkLogic tricks to passing a character entity through > without serializing it? > > TIA! > > Betty > > > > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ > Betty Harvey | Phone: 410-787-9200 FAX: 9830 > Electronic Commerce Connection, Inc. | > har...@eccnet.com | Washington,DC XML Users Grp > URL: http://www.eccnet.com | http://www.eccnet.com/xmlug > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ > Member of XML Guild (www.xmlguild.org) > _______________________________________________ > General mailing list > General@developer.marklogic.com > http://developer.marklogic.com/mailman/listinfo/general > ------------------------------ Message: 4 Date: Tue, 21 Feb 2012 21:10:11 -0500 (EST) From: "Betty Harvey" <har...@eccnet.com> Subject: Re: [MarkLogic Dev General] Passing Character Entities to Output To: "MarkLogic Developer Discussion" <general@developer.marklogic.com> Message-ID: <53226.207.168.47.25.1329876611.squir...@www.eccnet.com> Content-Type: text/plain;charset=iso-8859-1 Thanks Mike: I am afraid that won't work. The application is Microsoft Excel. I need linefeeds in a specific Cell to give a list values on individual lines in a single cell. Microsoft sees the binary line feed as just whitespace and treats it as whitespace and not a real linefeed. In order to get a linefeed into Excel in importing Excel 2003 XML the character entity is required. I guess I am stuck with either (1) having the text wrap which is really messy looking; or (2) post processing the resulting XML file. Thanks! Betty > Technically there is no difference: *means* codepoint 10 to any XML > processor. A tool that only works when reading one or the other is broken. > > But you can configure your app server and set the "output sgml character > entities" to "normal" - or anything other than "none". Then you should see > this: > > <cell> > <data>hello
big
world</data> > </cell> > > I don't know if that's any better for your purposes, but at least it isn't > the literal codepoint. > > -- Mike > > On 21 Feb 2012, at 16:41 , Betty Harvey wrote: > >> I asked this question on the XQuery list and it looks like this can't be >> done in straight XQuery. I am asking this question here just in case >> there is a MarkLogic function that can be used. >> >> I need to pass a linefeed character to the output. I am creating Excel >> spreadsheets where I need a list on separate lines in a single cell. >> Excel recognizes the character entity for linefeeds. >> >> My output needs to look like this: >> >> <cell><data>hello big world</data></cell> >> >> The output I am getting is: >> >> <cell><data>hello >> big >> world</data></cell> >> >> I have tried several variations of: >> >> let $newline := " " >> let $newline := fn:concat("&", "#10;") >> >> etc. All having the same results, getting a linefeed instead of placing >> the actual character entity in the output. >> >> Are there any MarkLogic tricks to passing a character entity through >> without serializing it? >> >> TIA! >> >> Betty >> >> >> >> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ >> Betty Harvey | Phone: 410-787-9200 FAX: 9830 >> Electronic Commerce Connection, Inc. | >> har...@eccnet.com | Washington,DC XML Users Grp >> URL: http://www.eccnet.com | http://www.eccnet.com/xmlug >> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ >> Member of XML Guild (www.xmlguild.org) >> _______________________________________________ >> General mailing list >> General@developer.marklogic.com >> http://developer.marklogic.com/mailman/listinfo/general >> > > _______________________________________________ > General mailing list > General@developer.marklogic.com > http://developer.marklogic.com/mailman/listinfo/general > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Betty Harvey | Phone: 410-787-9200 FAX: 9830 Electronic Commerce Connection, Inc. | har...@eccnet.com | Washington,DC XML Users Grp URL: http://www.eccnet.com | http://www.eccnet.com/xmlug /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ Member of XML Guild (www.xmlguild.org) ------------------------------ Message: 5 Date: Tue, 21 Feb 2012 18:18:14 -0800 From: David Lee <david....@marklogic.com> Subject: Re: [MarkLogic Dev General] Passing Character Entities to Output To: MarkLogic Developer Discussion <general@developer.marklogic.com> Message-ID: <eb42045a1f00224e93b82e949ec6675e16adc5f...@exchg-be.marklogic.com> Content-Type: text/plain; charset="us-ascii" Scratch my suggestion. I *finally* understand what your after and my suggestion wont do it ... sorry Doing a textual replace on the resultant XML might be your best bet. Especially if you output a unusal string instead of \n like "****REPLACE-ME-WITH-NL****" ----------------------------------------------------------------------------- David Lee Lead Engineer MarkLogic Corporation d...@marklogic.com Phone: +1 650-287-2531 Cell: +1 812-630-7622 www.marklogic.com This e-mail and any accompanying attachments are confidential. The information is intended solely for the use of the individual to whom it is addressed. Any review, disclosure, copying, distribution, or use of this e-mail communication by others is strictly prohibited. If you are not the intended recipient, please notify us immediately by returning this message to the sender and delete all copies. Thank you for your cooperation. > -----Original Message----- > From: general-boun...@developer.marklogic.com [mailto:general- > boun...@developer.marklogic.com] On Behalf Of David Lee > Sent: Tuesday, February 21, 2012 7:46 PM > To: MarkLogic Developer Discussion > Subject: Re: [MarkLogic Dev General] Passing Character Entities to Output > > did you try > > <cell><data>hello&#10;big&#10;world</data></cell> > > ----------------------------------------------------------------------------- > David Lee > Lead Engineer > MarkLogic Corporation > d...@marklogic.com > Phone: +1 650-287-2531 > Cell: +1 812-630-7622 > www.marklogic.com > > This e-mail and any accompanying attachments are confidential. The > information is intended solely for the use of the individual to whom it is > addressed. Any review, disclosure, copying, distribution, or use of this > e-mail > communication by others is strictly prohibited. If you are not the intended > recipient, please notify us immediately by returning this message to the > sender and delete all copies. Thank you for your cooperation. > > > > -----Original Message----- > > From: general-boun...@developer.marklogic.com [mailto:general- > > boun...@developer.marklogic.com] On Behalf Of Betty Harvey > > Sent: Tuesday, February 21, 2012 7:41 PM > > To: MarkLogic Developer Discussion > > Subject: [MarkLogic Dev General] Passing Character Entities to Output > > > > I asked this question on the XQuery list and it looks like this can't be > > done in straight XQuery. I am asking this question here just in case > > there is a MarkLogic function that can be used. > > > > I need to pass a linefeed character to the output. I am creating Excel > > spreadsheets where I need a list on separate lines in a single cell. > > Excel recognizes the character entity for linefeeds. > > > > My output needs to look like this: > > > > <cell><data>hello big world</data></cell> > > > > The output I am getting is: > > > > <cell><data>hello > > big > > world</data></cell> > > > > I have tried several variations of: > > > > let $newline := " " > > let $newline := fn:concat("&", "#10;") > > > > etc. All having the same results, getting a linefeed instead of placing > > the actual character entity in the output. > > > > Are there any MarkLogic tricks to passing a character entity through > > without serializing it? > > > > TIA! > > > > Betty > > > > > > > > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ > > Betty Harvey | Phone: 410-787-9200 FAX: 9830 > > Electronic Commerce Connection, Inc. | > > har...@eccnet.com | Washington,DC XML Users Grp > > URL: http://www.eccnet.com | http://www.eccnet.com/xmlug > > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ > > Member of XML Guild (www.xmlguild.org) > > _______________________________________________ > > General mailing list > > General@developer.marklogic.com > > http://developer.marklogic.com/mailman/listinfo/general > _______________________________________________ > General mailing list > General@developer.marklogic.com > http://developer.marklogic.com/mailman/listinfo/general ------------------------------ Message: 6 Date: Wed, 22 Feb 2012 15:36:55 +0100 From: Jakob Fix <jakob....@gmail.com> Subject: [MarkLogic Dev General] cpf pipeline question To: General Mark Logic Developer Discussion <general@developer.marklogic.com> Message-ID: <cacmjrh8ori4hmwu56mpojrcw4pssl5taks3_acdjlv5ux9a...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi, So i'm experimenting with the conversion option in MarkLogic (v5.0). CPF is installed and enabled, conversion is set to true. Import of docx and pptx is via WebDAV. However, conversion visibly doesn't take place. I set logging to "finest", so I see lots of "skipped" lines but no outright errors: 2012-02-22 15:31:17.416 Fine: TaskServer: Documents: on-any-property skipping /AuthoringGuide.docx Uploaded documents are visible via QC's "Explore", their type is "binary", and the properties don't show any errors, e.g.: <prop:properties xmlns:prop="http://marklogic.com/xdmp/property";> <cpf:processing-status xmlns:cpf="http://marklogic.com/cpf";>done</cpf:processing-status> <cpf:property-hash xmlns:cpf="http://marklogic.com/cpf";>d41d8cd98f00b204e9800998ecf8427e</cpf:property-hash> <cpf:last-updated xmlns:cpf="http://marklogic.com/cpf";>2012-02-22T15:23:04.949+01:00</cpf:last-updated> <cpf:state xmlns:cpf="http://marklogic.com/cpf";>http://marklogic.com/states/converted</cpf:state> <cpf:self xmlns:cpf="http://marklogic.com/cpf";>/AuthoringGuide.docx</cpf:self> <prop:last-modified>2012-02-22T15:23:04+01:00</prop:last-modified> </prop:properties> So, no _toc.xml file or _parts directory is created with XML inside. Could somebody please tell me what else to check? Thanks, Jakob. ------------------------------ Message: 7 Date: Wed, 22 Feb 2012 06:46:44 -0800 From: Pete Aven <pete.a...@marklogic.com> Subject: Re: [MarkLogic Dev General] cpf pipeline question To: MarkLogic Developer Discussion <general@developer.marklogic.com> Message-ID: <c9924d15b04672479b089f7d55ffc1322261d8f...@exchg-be.marklogic.com> Content-Type: text/plain; charset="us-ascii" Conversion is currently for Office 2003 documents and earlier. With 2007/2010 we work with the XML directly. The Office Open XML Extract pipeline will unzip the .docx and .pptx, and create the *_parts directory containing their XML components. Hope this helps, Pete -----Original Message----- From: general-boun...@developer.marklogic.com [mailto:general-boun...@developer.marklogic.com] On Behalf Of Jakob Fix Sent: Wednesday, February 22, 2012 9:37 AM To: General Mark Logic Developer Discussion Subject: [MarkLogic Dev General] cpf pipeline question Hi, So i'm experimenting with the conversion option in MarkLogic (v5.0). CPF is installed and enabled, conversion is set to true. Import of docx and pptx is via WebDAV. However, conversion visibly doesn't take place. I set logging to "finest", so I see lots of "skipped" lines but no outright errors: 2012-02-22 15:31:17.416 Fine: TaskServer: Documents: on-any-property skipping /AuthoringGuide.docx Uploaded documents are visible via QC's "Explore", their type is "binary", and the properties don't show any errors, e.g.: <prop:properties xmlns:prop="http://marklogic.com/xdmp/property";> <cpf:processing-status xmlns:cpf="http://marklogic.com/cpf";>done</cpf:processing-status> <cpf:property-hash xmlns:cpf="http://marklogic.com/cpf";>d41d8cd98f00b204e9800998ecf8427e</cpf:property-hash> <cpf:last-updated xmlns:cpf="http://marklogic.com/cpf";>2012-02-22T15:23:04.949+01:00</cpf:last-updated> <cpf:state xmlns:cpf="http://marklogic.com/cpf";>http://marklogic.com/states/converted</cpf:state> <cpf:self xmlns:cpf="http://marklogic.com/cpf";>/AuthoringGuide.docx</cpf:self> <prop:last-modified>2012-02-22T15:23:04+01:00</prop:last-modified> </prop:properties> So, no _toc.xml file or _parts directory is created with XML inside. Could somebody please tell me what else to check? Thanks, Jakob. _______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general ------------------------------ _______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general End of General Digest, Vol 92, Issue 41 *************************************** _______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general
