Tagged with templates - Visokio Forums http://forums.visokio.com/discussions/tagged/templates/feed.rss Mon, 30 Oct 17 15:00:21 -0400 Tagged with templates - Visokio Forums en-CA Idea: Batch Publishing: Optimising for high publishing volumes? http://forums.visokio.com/discussion/2954/idea-batch-publishing-optimising-for-high-publishing-volumess Wed, 10 Jun 2015 10:39:29 -0400 Alexander 2954@/discussions
We publish a lot of PDF files, but as the number of PDF files we have to generate is growing we are investigating the best way to publish 100+ PDF files.

When using a batch output to generate 100 PDF files, Omniscope opens the template file 100 times, that also means the data is loaded 100 times and 100 times a PDF is generated.

As the opening of the template file and loading of the data takes almost a minute per file, we would like to speed up the proces. If we could keep the template file open (with the data loaded) then omniscope could generate the same 100 pdf files is less time.

Is this yet possible or is there a good workaround?

Please advice!

Thanks!

Alexander
]]> Batch Publishing: Output Excel using template files? http://forums.visokio.com/discussion/2862/batch-publishing-output-excel-using-template-filess Mon, 09 Mar 2015 13:00:19 -0400 OliverB 2862@/discussions
I am trying to create a set of Excel reports, each containing multiple sheets. The reports need to be formatted in a certain way (i.e. date formats, header rows shading etc)

I can do this using the data file output in DataManager, just by writing to a blank Excel file that already exists and has formatting applied. However, I have about 100 Excel reports, each with 6 worksheets, so this method will be very time consuming to set up and maintain.

I have tried to set this up using a batch output. I am able to actually create the raw data files, but these do not have the formatting that I need. I have created a template Excel file (I've tried .xls and .xlsx) which has all of the formatting applied. However, when I point the batch config to this template file and set the "Preserve template formatting and formulas" to 'true', this does not have any effect?

I have also tried to create a file with the same name as the output, the same way as I would do this using DataManager, but this doesn't work either, the existing worksheets are just totally overwritten.

Is there a way for me to accomplish this without having to create this all manually in DataManager?]]> Export: Re-branding data exports from browser views http://forums.visokio.com/discussion/2482/export-re-branding-data-exports-from-browser-views Fri, 28 Feb 2014 08:06:48 -0500 richard 2482@/discussions
Attached is an example using the 'Bond Prices' demo file and a basic XLSX file as a template. Any exports generated from this IOK file will now be output as an XLSX using the same styling etc.

To use this example, unzip 'mobile.zip' and place it within your 'mobile' directory of the Omniscope Mobile Server deployment. (Note: You will need to enable exports for this to work - see links below).

  • Go to this post for instructions on how to enable exporting.
  • Go to this post for instructions on how to configure branding.


Setting up branded exports

To configure your own branded exports:
  1. Move your XLSX file into the 'branding.internal/mobile/app' folder related to the relevant IOK.
  2. Copy the 'export_view.xml' file to the same location.
  3. Edit the contents of the XML file using the instructions below.
  4. Run your IOK file using Omniscope Mobile Server and click the export button on any view.


Configuring the XML

<exportview templateFile="my_template.xlsx" worksheet="Data" column="2" row="5" includeHeaders="true" />

templateFile
Points to your XLSX file which must be inside the same 'branding.internal/mobile/app' folder.

worksheet
Name of the worksheet which will contain your export.

column/row
Column/row position where the data export will start.

includeHeaders
Whether or not to include a header row of field names.

]]> Outputs: Preserving category colours in 'published' file http://forums.visokio.com/discussion/1536/outputs-preserving-category-colours-in-published-file Tue, 08 May 2012 10:27:36 -0400 ChloeWalton 1536@/discussions
I have created an IOK file with defined category colours throughout using

Data > Manage fields > Options> Value colouring

However, when I publish this file in DataManager via an output block to another IOK file, using 'current configuration', all the colours return to default?

No data is changing, I am just user-locking the file.

How do I preserve the colour settings - any help would be great thanks

Chloe]]>