Support http://forums.visokio.com/categories/support/p8/feed.rss Mon, 30 Oct 17 14:57:09 -0400 Support en-CA Export: Omniscope Integers being stored as Text in xlsx http://forums.visokio.com/discussion/2508/export-omniscope-integers-being-stored-as-text-in-xlsx Tue, 01 Apr 2014 04:54:47 -0400 Master_Chief 2508@/discussions
It is very annoying as it requires a manual text to columns in order to fix]]> Export: Error Saving Exported Excel File? http://forums.visokio.com/discussion/2509/export-error-saving-exported-excel-files Tue, 01 Apr 2014 04:56:08 -0400 Master_Chief 2509@/discussions An error occurred saving "visokio_temp_tempres8058354335559329865.xlsm":
Microsoft Office error
80010001 / Call was rejected by callee. A backup of the previous file was created at

Local\Temp\visokio_temp_tempres8058354335559329865 (backup).xlsm" A further error occurred restoring the backup: Cannot access file: The file you are trying to access is currently open in another program (such as Microsoft Excel). Please close these application(s) and try again.

Local\Temp\visokio_temp_tempres8058354335559329865.xlsm (The process cannot access the file because it is being used by another process)]]> Outputs: Publish to Excel - decimals converted to text? http://forums.visokio.com/discussion/1928/outputs-publish-to-excel-decimals-converted-to-texts Thu, 29 Nov 2012 10:37:37 -0500 Alexander 1928@/discussions
Can you help? Thanks!]]> Sources: Excel-Decimals imported as integers using Excel Reader? http://forums.visokio.com/discussion/2504/sources-excel-decimals-imported-as-integers-using-excel-readers Thu, 27 Mar 2014 08:04:09 -0400 Alexander 2504@/discussions
I am encoutering a bug in Omniscope. My source is a group of .xls files. In the configuration of the "Group Import" I have chosen the Omniscope reader option, as there is no Office installed on our server.

In the Excel files there are decimals, but Excel shows them as integers. Omniscope reads them as integers, instead of decimals.

When importing into the same Omniscope file on my local machine, I use the Excel direct reader option. Then the decimals are imported into the DataManager source block. Therefore, I assume that the problem is the Omniscope Reader. I am available for a screen share.

(Using 2.8 b.1235)

]]> Filtering: Record Filter looking for word with spaces? http://forums.visokio.com/discussion/2471/filtering-record-filter-looking-for-word-with-spacess Mon, 17 Feb 2014 05:40:18 -0500 Nemesis 2471@/discussions
I want to filter a list contains a word " CLO " i.e with blank SPACE in front and back but Visokio won't let me do it, it uses "CLO" without spaces as the only input. Is there any wildcard character to do this??

I have been searching this using below Excel forumla:

=IF(OR(ISNUMBER(SEARCH({" word1 "," word2 "," word3 "}," "&A1&" "))),"YES","NO")]]> Content View: Scripting - Get the screen size? http://forums.visokio.com/discussion/2495/content-view-scripting-get-the-screen-sizes Thu, 20 Mar 2014 07:41:15 -0400 Bart 2495@/discussions
Is there a way to get a screen size inside Content view with native browser settings enabled? I need to use those numbers to get the right size of my pictures. ]]> Content View: Scripting - Array of colours? http://forums.visokio.com/discussion/2494/content-view-scripting-array-of-colourss Thu, 13 Mar 2014 08:50:22 -0400 Bart 2494@/discussions
Is there a way to get all colours assigned to the field into array inside content view?

Bart
]]> Deployment: Custom JAR - Viewer JAR download? http://forums.visokio.com/discussion/2491/deployment-custom-jar-viewer-jar-downloads Mon, 10 Mar 2014 20:38:47 -0400 cmollo 2491@/discussions Where does the viewer JAR file get downloaded to on a Windows 7 system? I'm using Omniscope 2.8. Thanks!]]> Scheduler: Fields do not exist error? http://forums.visokio.com/discussion/2488/scheduler-fields-do-not-exist-errors Fri, 07 Mar 2014 09:32:09 -0500 SimonWiggins 2488@/discussions
Basically it seems to think there are fields missing when it comes to publish later in the flow.
Two of the fields aren't there as they are deleted further up in the flow however Keyword is a field present at the end.
There are no erroring formulas further up or warnings when run manually.

The error is pasted below:

Error publishing block "Data file output 9"

Detailed information

Invalid fields: Fields do not exist - cannot execute:

Date
Campaign name
Keyword


Is this a known bug or something I've failed to notice?
Any ideas/help would be appreciated.

I found I can rebuild the offending flow from scratch exactly as before and this seems to remove the error (although it appears from a different flow and publish block).
Obviously I want to avoid having to rebuild the entire report block by block.

I would assume the blocks retain a certain amount of past configuration information as if I change a flow higher up and then change it back later it remembers some aggregate settings etc.
Could this be the issue and is there a way of clearing past configurations?


Thanks

Simon]]> Pie View: how to display small values? http://forums.visokio.com/discussion/2383/pie-view-how-to-display-small-valuess Thu, 17 Oct 2013 10:31:31 -0400 Mees 2383@/discussions Thanks, A]]> Content View: Embedded images using "native browser"? http://forums.visokio.com/discussion/2484/content-view-embedded-images-using-native-browsers Mon, 03 Mar 2014 11:30:47 -0500 Bart 2484@/discussions
The support for embedded images in the Content View "native browser" hasn't been implemented.

Can we add support for them in there please? I did workaround for now as I have posted my pictures on the web and I am

using direct link,but this solutions is not ideal as it is not going to work offline.

Bart]]> Bar/Line & Graph View: Time Series with multiple lines http://forums.visokio.com/discussion/2480/barline-graph-view-time-series-with-multiple-lines Wed, 26 Feb 2014 06:16:02 -0500 Valentina 2480@/discussions
Can someone pls give me a quick guide of how to create a time series graph with multiple lines?
It seems that there a is an explanation in the website but it refers to the old version of Visokio so it's not very helpful.
Thanks in advance ]]> Export: Outputting a View in PDF - Scrolling Tab http://forums.visokio.com/discussion/2475/export-outputting-a-view-in-pdf-scrolling-tab Thu, 20 Feb 2014 14:59:34 -0500 scfitzge 2475@/discussions
I tried going to a 'Multi-Page Document' view but that isn't working for me ... it only shows the first two rows. Appreciate any help.]]> Styling: Icons in toolbars and check boxes in sidebar? http://forums.visokio.com/discussion/2476/styling-icons-in-toolbars-and-check-boxes-in-sidebars Fri, 21 Feb 2014 11:01:06 -0500 mmor 2476@/discussions Is it possible to change colours of icons in toolbars and check boxes in the sidebar filters?
Thanks.]]> Formulae: parameter/variable accessible to end user? http://forums.visokio.com/discussion/2472/formulae-parametervariable-accessible-to-end-users Tue, 18 Feb 2014 14:32:59 -0500 earheart 2472@/discussions
So I need a way to use a parameter in the formula field or prompt a user to change a variable. Any ideas?]]> Content View: Table Border behaviour? http://forums.visokio.com/discussion/2470/content-view-table-border-behaviours Mon, 17 Feb 2014 04:38:10 -0500 OO83 2470@/discussions I tried to insert a 3x3 table into a content view but I am not seeing the outline of the table. Any assistance will be appreciated.
I have attached a picture of what I am seeing.]]> Formulae: Preserving selected formulas downstream? http://forums.visokio.com/discussion/2462/formulae-preserving-selected-formulas-downstreams Tue, 04 Feb 2014 07:12:24 -0500 Master_Chief 2462@/discussions
Is there anyway to only preserve certain formulas downstream, I want to perform a formula on a aggregated field which is itself another formula. I realise this can be done through using two Field Organiser blocks, however I was hoping to keep things cleaner.

Thanks,

Chris]]> Venn View: Venn diagram help? http://forums.visokio.com/discussion/2460/venn-view-venn-diagram-helps Wed, 29 Jan 2014 11:01:57 -0500 zcacrgw 2460@/discussions
Ways in which this could work might be:
- Select all rows with company x where company x has a row using "roaming". But I can't see how.
- Do an aggregate in the data manager view which created a table with the right data. Unfortunately, I only seem to be able to get one dataset into Omniscope at a time. This seems like a crazy restriction so I guess I'm missing something.]]> Formulae: Turn off "common functions" filtering? http://forums.visokio.com/discussion/2461/formulae-turn-off-common-functions-filterings Wed, 29 Jan 2014 11:24:01 -0500 zcacrgw 2461@/discussions ]]> Sources: data file formats imported/supported? http://forums.visokio.com/discussion/2459/sources-data-file-formats-importedsupporteds Wed, 29 Jan 2014 06:44:56 -0500 rajesh225 2459@/discussions
and one more help how to convert the existing files(.xls) files to .iok/.ilf files.

Thanks in Advance ]]> Sources: Reading .rtf rich text files? http://forums.visokio.com/discussion/2456/sources-reading-.rtf-rich-text-filess Mon, 27 Jan 2014 06:38:32 -0500 daniel 2456@/discussions
image]]> Deployment: Java Web Start Issues with version 7 update 5? http://forums.visokio.com/discussion/2449/deployment-java-web-start-issues-with-version-7-update-5s Mon, 20 Jan 2014 06:24:53 -0500 aGurung 2449@/discussions
We have not been able to run the webstart jnlp file with Java update 51.
We can however run the webstart jnlp file with Java update 45 or lower.

Has anyone experienced any similar problems since the latest Java update?

Thanks in advance!]]> Scheduler: Service stopping randomly once per day? http://forums.visokio.com/discussion/2443/scheduler-service-stopping-randomly-once-per-days Wed, 15 Jan 2014 11:21:40 -0500 tamax 2443@/discussions
We are having a stability issue with the scheduler, it stops suddenly and randomly aproximately once per day and we need to restart the service manually.

Please find attached the wrapper.log file at the moment the service crashes and the same log file when I restart the service manually. There is a warning during start that might be the cause of the problem but I am not sure how to fix it.

We are using Visokio Server 2.8 1191]]> Filtering: Second level of selection subset? http://forums.visokio.com/discussion/2448/filtering-second-level-of-selection-subsets Thu, 16 Jan 2014 14:01:47 -0500 ksluder 2448@/discussions Appends: Matching columns with different names? http://forums.visokio.com/discussion/2444/appends-matching-columns-with-different-namess Wed, 15 Jan 2014 11:47:35 -0500 ksluder 2444@/discussions
Is there a way to select the matching columns?

There are work-arounds but I was hoping for a more straight forward solution.

Thanks,

Kevin]]> Bar/Line view: 1 field/ 2 measures, colour by measure http://forums.visokio.com/discussion/2440/barline-view-1-field-2-measures-colour-by-measure Tue, 14 Jan 2014 13:36:46 -0500 ksluder 2440@/discussions
I can't get any of the 'color' options to perform the coloring the so that the mean portion and the maximum portion have different colors.

Thanks for any suggestions. I am on day one of using Visokio.]]> Content View: Exporting HTML tables to an Excel file? http://forums.visokio.com/discussion/2442/content-view-exporting-html-tables-to-an-excel-files Wed, 15 Jan 2014 06:33:38 -0500 enrico68 2442@/discussions
This is what our 'internal customers' are requiring now.

Alternatively, we can consider the idea to export only data in a pre-formatted Excel template file. Notice, however, that some tables (as the second included in the attached file) have a vertical development with a variable number of rows.

If such an export option exists, is it possible to have any example on how to implement it?

Thanks]]> Aggregation: decimal number sum precision http://forums.visokio.com/discussion/2437/aggregation-decimal-number-sum-precision Wed, 08 Jan 2014 10:32:11 -0500 ygulla 2437@/discussions
It looks like when aggregating 2 decimal numbers with more than 7 digits the sum loses some precision in an unexpected manner:
e.g. in the attached example 100,000.51 + 0.11 = 100,000.6 (see “loss of precision” block)

The rest of the blocks just show some examples that work.
]]> Outputs: 'Cannot access file in use' message? http://forums.visokio.com/discussion/2267/outputs-cannot-access-file-in-use-messages Mon, 29 Jul 2013 15:10:11 -0400 KRIN 2267@/discussions
Since updating to the latest version, I’m experiencing a sporadic problem publishing reports. This issue has never occurred before the latest update.

When I publish certain reports, I’m getting an error indicating that the file is in use by another program (see below).

This is only happening for some reports and some of the time. The file in question is only accessible to Omniscope, so there is no chance another program, like Excel, is actually using it.

Publishing outputs has failed whether automated on a Scheduler or updated manually, and whether there are one or multiple viewers. However, it also sometimes works under all of those conditions, so I’ve so far been unable to identify a pattern other than that this has only occurred since the update.

This is impacting some real-time reports in production. Please confirm receipt and advise as soon as possible.

Thank you,

]]> Performance: Issue with saving temp files? http://forums.visokio.com/discussion/2423/performance-issue-with-saving-temp-filess Mon, 09 Dec 2013 06:56:26 -0500 tamax 2423@/discussions
We have a problem with a Visokio Server 2.8 (last build) installation. Temp files are generated in the temp folder and are never deleted, filling up the hard disk until being completly full and then preventing the visokio scheduler from working correctly.

There is no error in the server log file, files are published correctly, it is just that the temp iok file is not deleted..

Thanks,
Maxime]]>