Tagged with batch-publishing - Visokio Forums http://forums.visokio.com/discussions/tagged/batch-publishing/feed.rss Mon, 30 Oct 17 12:14:00 -0400 Tagged with batch-publishing - Visokio Forums en-CA Batch Publishing: Dynamic Content in Message Bodies (2.8+) http://forums.visokio.com/discussion/986/batch-publishing-dynamic-content-in-message-bodies-2.8- Tue, 13 Sep 2011 08:17:14 -0400 ddemarco 986@/discussions Data Manager: Exporting multiple *.iok files to *.xls http://forums.visokio.com/discussion/3261/data-manager-exporting-multiple-.iok-files-to-.xls Tue, 01 Aug 2017 07:36:58 -0400 tron05 3261@/discussions
My level of understanding Visokio is very basic. I have a limited use for visokio and am hoping a solution to the below stated problem exists. I use Visokio Omniscope 2.9 viewer.
Problem: A set of *.iok files are published to a folder. I need to export each of the .iok files to .xls and load the .xls files to a database.
Currently I go into each iok file and go through the general export process from File menu. I was wondering if there was a automated way to export all iok files to xls. Is it possible to automate the process with a batch script?
Thanks for any help!
]]>
Batch Output for Excel - Specify Starting Row/Column http://forums.visokio.com/discussion/3087/batch-output-for-excel-specify-starting-rowcolumn Wed, 03 Feb 2016 11:11:49 -0500 OliverB 3087@/discussions Last year we had a request to add some functionality to the batch config file so that when publishing to excel, we could use the Replace Data/Replace Worksheet/Overwrite data etc functionality that the individual data manager output blocks have . This was implemented and works very well.

http://forums.visokio.com/discussion/2862/batch-publishing-output-excel-using-template-filess

One other functionality that the data manager file output block has that doesn't appear to be available in the batch config files is to be able to specify a row or column to start inserting the data at. Would it be possible to add this functionality to the batch config file as well?
Thanks

Ollie.]]>
Batch export - Excel font settings http://forums.visokio.com/discussion/3215/batch-export-excel-font-settings Sat, 18 Feb 2017 13:25:38 -0500 enrico68 3215@/discussions I'd like to know if it's possible to create these files imposing a particular font (different from xlsx standard one).

This is because this automatically created xlsx files will be used to populate ppt documents passing specific data and these presentation will have to satisfy company defined standards.]]>
Dial View: Rendering Issue when Publishing Batch Output PDFs http://forums.visokio.com/discussion/2970/dial-view-rendering-issue-when-publishing-batch-output-pdfs Thu, 16 Jul 2015 08:59:27 -0400 OliverB 2970@/discussions I am having an issue when including a Dial view in a report that I use a batch output to export to PDFs. The dial looks good in omniscope, but the dial is often very small when published to PDF.

I believe that the issue may be caused by the dial animation when the tab opens. The screenshot happens before the dial has completely opened and therefore is captured only half open. Every now and again it does work, but most of the time it doesn't.

There doesn't seem to be an option to disable the dial view animation on tab open. I have tried changing two settings but this doesn't seem to have had an effect
1. Advanced>Performance>Use Open/Close Animation - Turned this off
2. Advanced>Miscellaneous>Web View Grab Screenshots Delay - Increased to 5 seconds and no improvement seen

Is there a way to remove the animations from the dial view, or force the batch output to wait for it to be fully opened before taking the screenshot?

My omniscope version is 2.9-[Hotfix_BatchPublishMethod] b1642

Thanks]]>
Idea: Personalised User Data based on Field Filters http://forums.visokio.com/discussion/2983/idea-personalised-user-data-based-on-field-filters Mon, 10 Aug 2015 08:30:22 -0400 OliverB 2983@/discussions
One of our clients is looking at the possibility of opening up access to Omniscope Mobile reports to a wider group of users. Their business is split into a number of different Business Areas, and every report has the ability to filter to just show data for a specified Business Area.

The current users are all authorised to view data for the entire business. However, the users that they want to open the reports up to will only be authorised to see the data for the business area that they belong to. All access is currently via the Liferay Omniscope portlet. Has anyone done anything similar before, and what would be the best way to go about implementing this?]]>
Batch Output: Screenshot/PDF outputs in A4 portrait layout? http://forums.visokio.com/discussion/2962/batch-output-screenshotpdf-outputs-in-a4-portrait-layouts Tue, 30 Jun 2015 07:07:01 -0400 DominicChan 2962@/discussions
Please advise

Thanks]]>
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
]]>
Scheduler: PDF Batch date/time error? http://forums.visokio.com/discussion/2451/scheduler-pdf-batch-datetime-errors Wed, 22 Jan 2014 10:23:00 -0500 Alexander 2451@/discussions
I get an error in one of our schedulers. The error is "DUMP BUG HANDLER Header Foutrapport Message Unable to re-parse: time -262800000 s 196901 f yyyyww"

This causes the batch output to skip files that needed to be generated. All PDF files that need to be published in this tasks are skipped.

Please advise asap.

Thanks!
Alexander]]>
DataManager: Splitting datasets into multiple files/tabs? http://forums.visokio.com/discussion/2065/datamanager-splitting-datasets-into-multiple-filestabss Wed, 20 Mar 2013 05:14:09 -0400 grahamb 2065@/discussions
For instance, say there as an analysis breaking down sales territories by sales and customers. The user would first define a map (or chart, table, etc.) showing all sales people territories, with customer markers etc. They would then activate split file to auto group by sales person. They would then have the option to either auto generate new tabs - each showing a specific sales territory map and customers and analysis relating to that territory - and/or generate multi-page output, without needing further selection.
]]>
Outputs: Automated publishing of PDF to mobile devices? http://forums.visokio.com/discussion/353/outputs-automated-publishing-of-pdf-to-mobile-devicess Mon, 12 Jul 2010 15:52:36 -0400 KRIN 353@/discussions
Has anyone been able to do the same, with the same information in the report, but in a format which is friendly for Blackberrys and mobile devices?

Any advice would be greatly appreciated.]]>
Security: Restricting access for certain users? http://forums.visokio.com/discussion/1877/security-restricting-access-for-certain-userss Thu, 01 Nov 2012 00:55:34 -0400 shaji_o 1877@/discussions
When setting up logins to Omniscope Webstart, is there a way to apply universal filters for certain users so that the other agency can only access the data they are allowed to? or is the safest way to do this is to set up 2 separate Omniscope files? I'd prefer the first option as it requires less work from my end]]>
Licensing: File Security role-based group security? http://forums.visokio.com/discussion/1828/licensing-file-security-role-based-group-securitys Fri, 12 Oct 2012 05:42:26 -0400 ZhouNan 1828@/discussions
Many thanks!]]>
Batch Publishing: Preserve template formatting and formulas? http://forums.visokio.com/discussion/1814/batch-publishing-preserve-template-formatting-and-formulass Fri, 05 Oct 2012 05:28:40 -0400 Alexander 1814@/discussions
Preserve template formatting and formulas: Use only for Omniscope iok "File" output type.
If "true", when Template File has been set the formulas of any fields that already exist in the template file will be retained. You must ensure the published data has a field of the same name and type as the non-formula fields in the Template. If unselected or "true", all fields in the template file will be replaced entirely.
]]>
Outputs: formulas within re-published output IOK files? http://forums.visokio.com/discussion/1806/outputs-formulas-within-re-published-output-iok-filess Tue, 02 Oct 2012 08:29:39 -0400 ken 1806@/discussions
I then have a Bar/Line View in which I display this field. I aggregate by another field. In the aggregation I select to recalc the value of my new field using the formula - i.e. calculate the ratio of used amount/total amount for the aggregated values, and then display this in the view.

All works fine until I re-publish the Omniscope file below the blue box using a file Output block set to publish an IOK file. In the new, re-published IOK file, the display doesn't work? Surely formulas must survive the re-publishing process?]]>
Outputs: Sequencing work flow order? http://forums.visokio.com/discussion/1767/outputs-sequencing-work-flow-orders Tue, 18 Sep 2012 09:47:17 -0400 DominicChan 1767@/discussions
I am hoping to use Output blocks to output PDF, Excel and PowerPoint, from one single Omniscope file, and also use the output block "Email Output" to attach all these different file outputs in one single email to send to multiple emails.

Is there a way to make sure the file outputs are all completed first, before the "Email Output" is executed? To ensure all the e-mail attachments are the most recently refreshed and loaded ones?

Please let me know if this function is already built into Omniscope somewhere. - Thanks a lot -Dom ]]>
Security: File security options? http://forums.visokio.com/discussion/1754/security-file-security-optionss Mon, 10 Sep 2012 07:59:48 -0400 revlin 1754@/discussions
Anyone have any experience of this?

Also, does this relate to a standalone Omniscope file or a Server-based approach. I understand that a Server-based solution is possible with Omniscope although I have only ever used the Desktop Edition of Omniscope. Any feedback would be greatly appreciated.
]]>
Batch output of View images? http://forums.visokio.com/discussion/1493/batch-output-of-view-imagess Mon, 23 Apr 2012 10:19:51 -0400 vthiruv2 1493@/discussions Publish to mySQL error http://forums.visokio.com/discussion/1375/publish-to-mysql-error Fri, 09 Mar 2012 03:14:24 -0500 sherriff 1375@/discussions
Database Error

An error occurred connecting to or querying the database.

Data truncation: Incorrect time value: '1970-01-01' for column [ETA] at row 1

The receiving table has been setup in mySQL and the field [ETA] has been give the format TIME which expects hh:mm:ss
The data to be output is in the format: hh:mm:ss

The first row is 00:00:00

But we cannot figure out what might be the cause of the error.]]>
Problem with batch output http://forums.visokio.com/discussion/1430/problem-with-batch-output Wed, 28 Mar 2012 07:24:30 -0400 jim.ledger 1430@/discussions
I'm having problems with a batch output that used to work, but no longer does.
The problem appears to be in the string operator used in the filter rules...
I have two rows where output fails with the following message:

Row 1: Invalid choice of operation: does not equal
Row 2: Invalid choice of operation: does not equal

Below are the filter rules for Row 1 and Row 2, respectively, and I want the filter match to be 'All'

Row 1 : [Region]=[EMEA],[Agency]=[MyAgency],[Office]does not equal[Worldwide]
Row 2 : [SubRegion]starts with[UK],[Agency]=[MyAgency],[Office]does not equal[Worldwide]

I tested it also with DOES NOT CONTAIN, and that doesn't work either.

I'm using Omniscope Server Plus, with v2.7b build 299 installed.

Thanks,

Jim]]>
Batch Output to powerpoint in "append mode" rather than overwrite http://forums.visokio.com/discussion/1415/batch-output-to-powerpoint-in-append-mode-rather-than-overwrite Thu, 22 Mar 2012 15:08:55 -0400 ken 1415@/discussions
Each time it seems to overwrite the powerpoint and I need to be able to "append to the end" instead like you can when exporting to powerpoint not via the batch output.

How do I do this please?]]>
Security: How to share reports via Internet? http://forums.visokio.com/discussion/1209/security-how-to-share-reports-via-internets Fri, 13 Jan 2012 06:48:16 -0500 Kefsid 1209@/discussions
Is it possible?]]>
Batch Publishing: Adding Password protection? http://forums.visokio.com/discussion/1175/batch-publishing-adding-password-protections Tue, 20 Dec 2011 04:58:22 -0500 Kiddo29 1175@/discussions
I'm creating multiple IOK's from a batch file which I need password protected and domain locked.
For some reason, even when I specify the IOK templates password in the batch file I get the message:
"The password is not available".

Could you let me know where I'm going wrong?

Am i missing a column out in the batch file or is it just the password column needed? I checked that i had the correct password so that's not the problem. Also if I domain lock the template IOK's will that then filter down into the batch output iok's?

Thanks]]>