http://forums.visokio.com/categories/support/p9/feed.rss Mon, 30 Oct 17 14:57:16 -0400 Support en-CA http://forums.visokio.com/discussion/2431/datetime-how-to-convert-unix-timestamps Tue, 17 Dec 2013 03:53:07 -0500 naruemon 2431@/discussions Even I did as suggested in below link:
http://www.visokio.com/dates-and-times

It could show datetime but still not valid:
Ex: Unix Timestamp 1387265894
Follow the link the result will be: Jan 17, 1970 8:21:05 AM
Actual value should be : Tue, 17 Dec 2013 07:38:14 GMT

Moreover, when followed the method as suggested in the link, in 'Field Organizer' the data type still be integer. So we could not use this value to do the calculate in any datetime functions.

Version: Omniscope 2.9 build 699.]]> http://forums.visokio.com/discussion/2404/links-images-videos-webpages-in-webtablecontenttile-viewss Mon, 18 Nov 2013 12:22:30 -0500 Focus_Media 2404@/discussions
We want show content of each file inside Omniscope (we try a Web view), but only .jpg are shown inside.
Other extensions (music & video) are opened in external application (Windows Media Player).

Is it possible show linked files (e.g. music & video files) inside Omniscope, in a Web view or other way?

Tia]]> http://forums.visokio.com/discussion/2424/details-popups-drill-down-disappears-after-creating-a-new-field Tue, 10 Dec 2013 08:31:27 -0500 johnr63 2424@/discussions http://forums.visokio.com/discussion/529/parameters-passing-values-between-files Tue, 30 Nov 2010 11:17:07 -0500 aknotts 529@/discussions
I have an IOK file with aggregated data in it (due to file size/RAM limits). I have created a local link to another Omniscope IOK file which contains the details that I might need to see. Is there a way to configure the local link to pass a query to the other Omniscope file e.g. [Vendor Name] = 'Boots'

If this isn't possible on the link is there a way to do it?

Am interested to know the answer for both v2.5 and also v2.6 (as most of my customers are on 2.5 at the moment).

Many thanks

Andy]]> http://forums.visokio.com/discussion/2272/datamanager-omniscope-2.8-date-format-errors Thu, 01 Aug 2013 11:35:30 -0400 acohen 2272@/discussions
Can this be corrected asap?]]> http://forums.visokio.com/discussion/1734/outputs-multiple-email-attachments-using-scheduler-xml-actionss Tue, 28 Aug 2012 09:30:31 -0400 ygulla 1734@/discussions
Can't seem to figure it out. If not is it possible to do otherwise?]]> http://forums.visokio.com/discussion/2406/installation-nsis-installer-switches Tue, 19 Nov 2013 08:02:36 -0500 JDSCEE 2406@/discussions
Looking to install Omniviewer on potentially 30 plus devices, some of which are remote, so we will be looking to do a silent administrative install. Moreover, because multiple users are looking to use it, we want it installed on C:\program files rather than the users local directory.

I read that the installer is based on NSIS - which as I understand it means that /S will install silently (which is fine), and /d=C:\program... will install to the specified directory. Unfortunately, the /D switch does not appear to be responding.]]> http://forums.visokio.com/discussion/2400/performance-importing-from-csv...any-memory-guideliness Fri, 08 Nov 2013 12:59:58 -0500 cmollo 2400@/discussions
I have read other posts about users processing more than 5.4 million records, so I think it is quite possible for Ominscope to process this large file I have, right?

I have also read http://www.visokio.com/kb/omniscope-memory-allocation.

My main question is: are there any guidelines on how much memory Omniscope needs as a function of records/fields. I realize this is probably one of those many "it depends" situations, but even rough guidelines (+/- 1 or 2 GB) would help.

If there are no guidelines, can I send you my .iok file (there are only 6 blocks: a File Source block, 3 Field Organizer blocks, a Record Filter block, and a Expand Values block) and a sample of the input file, which you can expand to about 5 million records (or I can ftp the whole file), and you can run it and let me know how much memory Omniscope uses?

Thanks! Chris
]]> http://forums.visokio.com/discussion/2403/performance-setting-memory-on-windows-8s Fri, 15 Nov 2013 06:05:56 -0500 daniel 2403@/discussions
http://www.visokio.com/kb/omniscope-memory-allocation]]> http://forums.visokio.com/discussion/2402/barline-view-conditional-colouring-overriding-for-layered-measuress Wed, 13 Nov 2013 10:04:36 -0500 TomRiggs 2402@/discussions http://forums.visokio.com/discussion/2398/analysis-dynamic-field-normalization-using-a-variables Wed, 06 Nov 2013 11:28:15 -0500 SteveMiller 2398@/discussions
I have a stock index data set that consists of the following attributes: portfolio, date, index. all told, about 18 years of daily index values for 20 portfolios. In Omniscope, I wanna choose a number of portfolios and a date range, then compare portfolio performance through the indexes. how can I dynamically create a normalized index variable that starts at one for each portfolio and date range selected? e.g. for each portfolio and date range, I wanna divide the index vector by the first value?

Thanks.]]> http://forums.visokio.com/discussion/2396/outputs-batch-pdf-pixel-density Tue, 05 Nov 2013 05:18:42 -0500 ygulla 2396@/discussions http://forums.visokio.com/discussion/2395/outputs-content-view-disappears-when-exporting-to-powerpoints Wed, 30 Oct 2013 12:53:25 -0400 Bart 2395@/discussions http://forums.visokio.com/discussion/2374/versions-2.7-to-2.8-server-transition-issue Mon, 14 Oct 2013 05:27:34 -0400 DominicChan 2374@/discussions
This makes the correctly grouped table in 2.7 to display incorrectly after being saved down through the server.

Can you advise if this can be rectified in later versions of 2.8?

Thanks
Dom]]> http://forums.visokio.com/discussion/2373/sources-timeout-on-email-attachments-feed....last-x-days-does-not-works Fri, 11 Oct 2013 09:48:42 -0400 Alexander 2373@/discussions
We use the email feed to automatically download attachements of emails that we receive via email.
In order to avoid unneccesary data load, I used the advanced setting "in the last 1 day". But this functionality does not seem to work. There are no emails selected, and without this advanced setting 4 emails are selected.

Hope you can help, thanks

Alexander]]> http://forums.visokio.com/discussion/2390/barline-view-display-values-instead-of-percentages-in-100-barss Tue, 29 Oct 2013 10:17:15 -0400 Bart 2390@/discussions http://forums.visokio.com/discussion/2386/scripting-copying-values-from-above-if-nulls Wed, 23 Oct 2013 12:17:19 -0400 SimonWiggins 2386@/discussions
I've been trying to find a way to automate copying values down from above if the row is null.
The problem I have is that you can't execute 'for' or 'while' loops in functions in the field organiser (short of scripting)

For example in a column I have:
[Fieldname]
Data1
null
null
null
Data2
null
null
etc..

(where the nulls are empty cells)

I know I can use something of the form:

IF([Fieldname]!=null,[Fieldname],
[Fieldname]=null,IF(
Cell([Fieldname],CURRENTROW()-1)!=null,Cell([Fieldname],CURRENTROW()-1),
Cell([Fieldname],CURRENTROW()-2)!=null,Cell([Fieldname],CURRENTROW()-2),
Cell([Fieldname],CURRENTROW()-3)!=null,Cell([Fieldname],CURRENTROW()-3),
Cell([Fieldname],CURRENTROW()-4)!=null,Cell([Fieldname],CURRENTROW()-4),
Cell([Fieldname],CURRENTROW()-5)!=null,Cell([Fieldname],CURRENTROW()-5),
"Error field may contain more than 6 empty rows"),"Error")

but the limitations of this are if the latest data is pulled in and has more than 6 nulls before a value is above then it will print the error. Obviously also it creates an unnecessary extra field and the old one needs to be deleted in a second Field Organiser. Obviously I could copy paste and edit it up to 100 or more but this isn't very elegant.

I know I can use the Custom Script block to write a JavaScript function and as such have been learning javascript but am having a hard time applying it to my problem.

My question is:
Is there an easy/elegant way of doing this in formulas that I have overlooked?
Or is it a case of using JavaScript to solve my problems?
Is it better done in a 'script' fomula or in a 'Custom script' block bearing in mind I want to do it for 3 columns and keep the rest of the data in line?

I've attached a sort of example of what I mean of some basic data and how I would and have solved it in the past but not copied the formula down long enough therefore it errors after 6 nulls.

Hopefully this makes some sort of sense to someone! Thanks in advance for absolutely any help!

Simon]]> http://forums.visokio.com/discussion/2224/refresh-maintaining-value-sort-ordersshapess Wed, 03 Jul 2013 06:28:01 -0400 Alfonso 2224@/discussions
I'm using Data > Manage Fields > {field options}> Value order colours & shapes

It works fine during a session, but when I do data refresh the order disappear, and also the colours and shapes settings, because new data comes in. (I'm using a cache deletion in the data refresh...)

Is there any method to maintain the order and marker shape settings I made before the refresh?.

Thanks in advance, Alfonso]]> http://forums.visokio.com/discussion/2382/freeze-vs-new-tab-settings Thu, 17 Oct 2013 08:51:58 -0400 Mees 2382@/discussions
The combination between Freezing fields and the setting Filter status on tab level, behaves not as we expected.
I have attached a screenshot. When creating a new tab with the settings as in the screenshot, the freeze settings in other tabs are ignored. In my opinion, the freeze option is to force Omniscope not to change the filter settings no matter what. This is not the case.

Can you please let us know if this is expected behavior or not?

Always happy to explain with screenshare.

A]]> http://forums.visokio.com/discussion/2297/barline-how-to-hide-the-rowcolumn-headers-in-2.8s Tue, 27 Aug 2013 09:30:57 -0400 CRead 2297@/discussions http://forums.visokio.com/discussion/2366/export-disabling-export-view-data-for-some-userss Mon, 07 Oct 2013 05:27:14 -0400 DominicChan 2366@/discussions
Can you advise if its possible to disable the "Export View Data" function for some users (either by making a different report or by Password rights)? We are getting a good handful of new end users, and we will like to make sure the new end-users dont get to export any data at all to Excel.

Is this possible? Please advise with some instructions.

Thanks a lot,
Dom ]]> http://forums.visokio.com/discussion/2362/slide-show-display-compressed-pictures-using-web-starts Fri, 04 Oct 2013 06:44:45 -0400 Mees 2362@/discussions
Can you please have a look?
Thank, Arjan]]> http://forums.visokio.com/discussion/2354/sidebar-pop-up-text-how-to-disable-tooltipss Fri, 27 Sep 2013 04:06:20 -0400 Mees 2354@/discussions
We recently noticed that DataExplorer contains legacy information regarding historic source files when hovering over a filter field in the filter panel. I can imagine this can be useful, but more in a DM development environment and not in DataExplorer where people are using data without knowing anything about the workflows underneath.

How can we disable this as in our case it is showing information we do not want to share.

Hope you can help
Thanks, Arjan]]> http://forums.visokio.com/discussion/2353/scheduler-chains-with-powerpoint-output-blockss Fri, 27 Sep 2013 03:54:25 -0400 rajeshbalu29 2353@/discussions We are facing issue in chains getting failed when any action contains Visokio file with PowerPoint output block in Visokio 2.7 Scheduler.

Note: when I run them manually from the Scheduler then it works perfectly without any errors.

Can anyone help me if we have missed any additional action to be added to get this published in time.

Regards
Rajesh B]]> http://forums.visokio.com/discussion/2317/tab-settings-bug-report Tue, 17 Sep 2013 09:51:29 -0400 bfromson1 2317@/discussions
Attached file has four tabs, first is datamanager, then two have single histogram and last has a chart.
Tabs 3 and 4 are grouped together in a group tab called group 5.

Open tab quantity split and it shows a stacked bar chart
Now click Tab 5 and it changes tab titles to show the two tabs in it and displays the company split simple bar chart.

Go to menu item Tab
Select Tab settings>
Then Tab bar>
Then Each tab bar visibility

Level 1 and level 2 are ticked

Click "Apply to all tabs"

Then click anywhere on chart to make menu go away

Then go back to qty split tab and it has turned into the same chart as the company split.

I was just trying to get the tab/sub tab headings to be same on each sheet but it has changed all the chart details as well.
]]> http://forums.visokio.com/discussion/2352/filtering-resizing-width-of-side-toolbar-filter-devicess Wed, 25 Sep 2013 07:13:07 -0400 mmor 2352@/discussions I know that if I hover with the mouse a tooltip appears, but it could be annoying having to wait.

Can you make this toolbar resizable like the other views?]]> http://forums.visokio.com/discussion/2350/scripting-storing-data-in-2-dimensional-arrays Wed, 18 Sep 2013 11:00:18 -0400 acdewinter 2350@/discussions
Edit: I've managed to figure out how to construct the dataTable to read data in from a for loop for 2 different array's of data and then plot it out on the scatter plot. The next step will be to link the Omniscope data into the arrays and see if it still works. Being able to do this will greatly increase the flexibility of what can be done on the front-end of the data explorer.

I've posted below the updated code that just demonstrates reading in a simple amount of data via a for-loop.:

function drawChart() {
var EventArray = [1000,1500];
var EventValueArray = [2000,2500];
var data = new google.visualization.DataTable();
data.addColumn('number','Test1');
data.addColumn('number','Test2');
for (var i=0;i<2;i++) {<br />data.addRows([[EventValueArray[i],EventArray[i]]]);
}
var options = {
title: 'Age vs. Weight comparison',
hAxis: {title: 'Age', minValue: 0, maxValue: 6000},
vAxis: {title: 'Weight', minValue: 0, maxValue: 6000},
legend: 'none'
};

var chart = new google.visualization.ScatterChart(document.getElementById('chart_div'));
chart.draw(data, options);
}

------------------

I will be playing around a bit more and then posting an update if I figure out where in the code to link up the Omniscope scripting calculations into the chart DataTable.]]> http://forums.visokio.com/discussion/2348/barline-view-rendering-issues Wed, 18 Sep 2013 07:58:53 -0400 mrseansmith 2348@/discussions
When opening a tab with a bar chart view the labels cut off the bottom of the bars. Changing windows size or opening the tools will cause the bar chart to update and re-render the chart correctly.

However this is causing a real issue for me when I try to export to PDF as several of the charts are cut off at the bottom by the labels as per the attached image in the final PDF.]]> http://forums.visokio.com/discussion/2349/aggregation-category-data-and-multiple-selectionss Wed, 18 Sep 2013 10:59:29 -0400 mmor 2349@/discussions I have created a file which is the result of a one-to-many merging process. The merged data looks like:
Italy,5,Rome,10
Italy,5,Milan,8
Italy,5,Naples,7
UK,6,London,15
UK,6,York,4
UK,6,Bath,3

I want to create a Table view that sums data at the "country" level.
For example, in a Map view I want to select UK and show in my table:
6 (UK value) ,22 (the sum of 15,4 and 3).

But if I select both UK and Italy, I want my table to show:
11 (6 + 5), 47 (all cities added).

At the moment, if I create my aggregate at the "country" level, in my table I have 2 entries:
5, 25
6, 22

While if I don't aggregate at the country level, my table shows:
33 (6*3 + 5*3), 47.

What am I doing wrong?
Thanks]]> http://forums.visokio.com/discussion/2226/barline-view-line-selectionfiltering-on-double-clicks Wed, 03 Jul 2013 06:40:19 -0400 Alfonso 2226@/discussions
Is there any way to avoid the line double-clicks from filtering in graphic charts?

Thanks in advance, Alfonso]]>