[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] .docx Export
Dear John,
thanks again for assisting. I played around with ideas from the links
you provided and the ooffice documentation, but it seems I misunderstood
something fundamentally. Please see my simplified testing code attached.
As previously mentioned, the file saved on the server under $output
looks correct; I just can't get it handed over to the browser.
The export is called via the cgi/exportview url:
<form method="get" accept-charset="utf-8"
action="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmadoc-dev.bib.uni-mannheim.de%2Fcgi%2Fexportview&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2d6d4379623c4d6865e208d8296bfa9d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=u30LWvCQ22RTorHGqVgYxW92lZY1GwlRtEp%2FsJXhea0%3D&reserved=0";>
These are the called urls I see in the Firefox console:
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmadoc-dev.bib.uni-mannheim.de%2Fcgi%2Fexportview%3Fformat%3DOffice%26_action_export_redir%3DExportieren%26view%3Dpeople%26values%3DMueller%253D3ADennis%253D3A%253D3A&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2d6d4379623c4d6865e208d8296bfa9d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=NMYYi9GIvkb0P7ublwdG24nfBqwKotej%2FmZ6f9PMgpE%3D&reserved=0
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmadoc-dev.bib.uni-mannheim.de%2Fcgi%2Fexportview%2Fpeople%2FMueller%3D3ADennis%3D3A%3D3A%2FOffice%2FMueller%3D3ADennis%3D3A%3D3A.odt&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2d6d4379623c4d6865e208d8296bfa9d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=6DgHa0bga18eiNUbrldTk8MWcydvm7DubMj8eGU4RDw%3D&reserved=0
Many thanks and best regards
Dennis
Am 14.07.20 um 18:50 schrieb John Salter:
> Hi Dennis,
> Glad you made this work - hopefully the last part isn't too difficult to sort out!
>
> How are you calling the Export? Is it via the normal /cgi/export url, or another means?
>
> Have you got a 'mimetype' and a 'suffix' parameter set in your export plugin?
>
> Does the 'MultilineExcel' export plugin provide a useful example?
> - Setting up either the supplied filehandle, or a filehandle to a variable:
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprintsug%2Fmultiline_excel%2Fblob%2Fmaster%2Flib%2Fplugins%2FEPrints%2FPlugin%2FExport%2FMultilineExcel.pm%23L44-L58&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2d6d4379623c4d6865e208d8296bfa9d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=ydma%2F8tx2JqJv2gPvuJG5Dv7OgK8Yr6%2FobRHdR9aWRQ%3D&reserved=0
> - returning - either undef (if a filehandle was supplied) - or the variable:
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprintsug%2Fmultiline_excel%2Fblob%2Fmaster%2Flib%2Fplugins%2FEPrints%2FPlugin%2FExport%2FMultilineExcel.pm%23L93-L98&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2d6d4379623c4d6865e208d8296bfa9d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=EOfbNXjfI2%2BeHXKcNW6PA2VvFSzjL5H2sKvGd%2BhN7f4%3D&reserved=0
>
> If that doesn't help, let me know and I'll do some more thinking!
>
> Cheers,
> John
>
> -----Original Message-----
> From: eprints-tech-bounces at ecs.soton.ac.uk [mailto:eprints-tech-bounces at ecs.soton.ac.uk] On Behalf Of Dennis M?ller via Eprints-tech
> Sent: 14 July 2020 16:49
> To: John Salter <J.Salter at leeds.ac.uk>; eprints-tech at ecs.soton.ac.uk
> Subject: Re: [EP-tech] .docx Export
>
> Hi John,
>
> thanks for your quick answer. With your help, I could more or less do
> what I want with the document saving it to some path on the server.
>
> However, I'm struggling to find out how to return the actual document in
> my export plugin's "output_list" subroutine. Returning $oodoc or the
> file path doesn't work, obviously. Can you help me out once more, please?
>
> Cheers,
> Dennis
>
> Am 10.07.20 um 15:33 schrieb John Salter:
>> Hi Dennis,
>> I think you should be able to achieve this.
>> It's similar to the way the OpenOffice / Coversheets works.
>> That's normally configured to export as a PDF, but it first takes an OpenOffice document (your branded template), and replaces tags (like '##TITLE##') with rendered content.
>>
>> These are the tags:
>> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprintsug%2Fcoversheets%2Fblob%2Fmaster%2Fcfg%2Fcfg.d%2Fz_coversheet_tags.pl&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2d6d4379623c4d6865e208d8296bfa9d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=Lidhm9n1inJmREhjCw02m8HDSiTna4M9UDDybMhbf4s%3D&reserved=0
>> and this adds them to the OpenOffice document:
>> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprintsug%2Fcoversheets%2Fblob%2Fmaster%2Flib%2Fplugins%2FEPrints%2FPlugin%2FConvert%2FAddCoversheet.pm%23L114-L127&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2d6d4379623c4d6865e208d8296bfa9d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=FoxWeWA0rkxbfVadLISgQZTMbT4%2FInUPL7zmPK5nxQU%3D&reserved=0
>>
>> Does that help?
>>
>> There are probably other ways - possibly other perl modules that would allow a more direct approach - but the above stuff seems to work OK.
>> I'm using it with LibreOffice rather than OpenOffice if that's useful to know too.
>>
>> Cheers,
>> John
>>
>> -----Original Message-----
>> From: eprints-tech-bounces at ecs.soton.ac.uk [mailto:eprints-tech-bounces at ecs.soton.ac.uk] On Behalf Of Dennis M?ller via Eprints-tech
>> Sent: 10 July 2020 14:15
>> To: eprints-tech at ecs.soton.ac.uk
>> Subject: [EP-tech] .docx Export
>>
>> Hi everyone,
>>
>> we've had a user request for exporting views/searches as a .docx file
>> styled in our corporate design. Has anyone ever done something similar?
>>
>> Just for the file format, it might work to "wrap" a simple text export
>> in an exporter that has a
>> "application/vnd.openxmlformats-officedocument.wordprocessingml.document" mimetype,
>> but I don't see where I could slip in the design template along the way.
>>
>> I'd be glad to hear from your experiences. :)
>>
>> Best regards
>> Dennis
>>
>
--
Dennis M?ller, B.A.
Universit?t Mannheim
Universit?tsbibliothek
Digitale Bibliotheksdienste | Schloss Schneckenhof West | 68131 Mannheim
Tel: +49 621 181-3023
E-Mail: dennis.mueller at bib.uni-mannheim.de
Web: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.bib.uni-mannheim.de%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2d6d4379623c4d6865e208d8296bfa9d%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=yg12mHKDyPO8fZl8E17LGksgfhVaYSo2pWDwT1q3dDY%3D&reserved=0
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Office.pm
Type: application/x-perl
Size: 2611 bytes
Desc: not available
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20200716/07e97e77/attachment.bin