http://forums.visokio.com/discussions/tagged/DataManager_workspace/p1/feed.rss Mon, 30 Oct 17 13:17:42 -0400 Tagged with DataManager_workspace - Visokio Forums en-CA http://forums.visokio.com/discussion/3269/thousands-separator-formatting-commas-in-numbers Tue, 10 Oct 2017 05:49:51 -0400 Cheyam 3269@/discussions
Is there a way to stop Omniscope from putting commas in every single number field interpreted by every block in the application?

- I have an R block in which output_data contains a number of integer columns. When they are retrieved from the R dataframe and processed in Omni theyre all get given commas. There are too many fields of differing types to go in and manually remove the commas from each integer field.
- When you have integers over three digits and try merge with another field without commas in the numbers the ones with commas do not merge with the ones without commas.
- When I have this fairly simple formula:'=COUNTIF(A:A,A' & (CURRENTROW()+ 2) & ')' in a field organizer I am returned with =COUNTIF(A:A,A1,071). (I know its sloppy to inject excel formulae like this but bear with me)

If I asked colleagues of mine they would agree that the frustrations and issues caused by this feature are multiples of this. Is there any way this can be addressed? Commas in numbers is a display feature and shouldnt exist in the datamanager. A suitable solution would be to stop the application putting commas in all formulae by default.

Thank you,
Chey]]> http://forums.visokio.com/discussion/2933/datamanager-blocks-tab-customisation-pickremove-blocks-from-the-menu Fri, 15 May 2015 07:40:11 -0400 paola 2933@/discussions You can customise the menu appearance and select only the blocks that are relevant for your work/ remove the rest.

DataManager Tools>Other>Show/hide blocks (see image)

This same menu contains other styling and layout customisation options.

]]> http://forums.visokio.com/discussion/2854/import-connected-data-sources-moveds Wed, 25 Feb 2015 10:40:09 -0500 rng 2854@/discussions http://forums.visokio.com/discussion/1685

Error Message: "The external data source DataManager is not available. Make sure that the file has not been renamed, moved, or deleted. Check your network connection is working."

Any thoughts? Thanks in advance

-Rohan]]> http://forums.visokio.com/discussion/2850/datamanager-viewing-field-references-referenced-by- Thu, 19 Feb 2015 09:42:58 -0500 DominicChan 2850@/discussions
Like you can if you are in Field Manager in the actual report.

Would really like to clean up some massive report where the report writer queries a select * from many many tables. I can use the references/referenced by to see which field i need to keep.

Thanks]]> http://forums.visokio.com/discussion/2787/datamanager-grouping-blocks-in-datamanagers Mon, 15 Dec 2014 12:09:02 -0500 carlosmartinmari 2787@/discussions
I think it would be good for ourselves and for others to understand our DataManager views, if we could just group those fairly complicated blocks into one "black block".]]> http://forums.visokio.com/discussion/2560/activation-opening-page-missing-tasks-datamanager-dataexplorers Fri, 16 May 2014 06:50:55 -0400 MattBoxall 2560@/discussions
Having a problem where, although activated, the main page on a colleague's computer is not show the same as mine and they cannot access the Tasks, DataManager or DataExplorer from the launch page of Omniscope?

I was hoping to source if this was a bug or if there has been an error in setting up/ activation?

I have screen shots if needed.

Much thanks,

Matt]]> http://forums.visokio.com/discussion/2457/new-searchreplace-now-supports-regex-and-wildcards-2.9- Mon, 27 Jan 2014 08:02:11 -0500 victor 2457@/discussions


You can now use wildcards (* and ? ) in the "Search for" field for a simple, yet powerful, search/replace...or you can use full-fledged Regular Expressions (RegEx) which can read and even re-write almost any text string to bring out visual and filtering patterns implicit in raw unstructured data.

The regular expression syntax and replacement patterns are the same as the ones used in the formula function REPLACEREGEX. For a complete reference of the RegEx syntax, visit http://www.regular-expressions.info/]]> 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/2384/performance-datamanager-flow-being-slowunresponsives-2.8 Wed, 23 Oct 2013 08:31:29 -0400 CRead 2384@/discussions
I'm not talking about the actual calculation of fields, or how long a file takes to refresh - but simple operations such as adding a field, expanding a block, bringing up the right click menu, selecting blocks.

It's not specific to one file, or one block type. It doesn't require a lot of blocks, although as block count goes up, responsiveness goes through the floor to an almost comic degree.

I'm not anywhere near RAM limits in most cases, the CPU is often nigh idle, and there's no disk thrashing.]]> http://forums.visokio.com/discussion/2296/integration-remote-operation-block-documentations Fri, 23 Aug 2013 10:25:07 -0400 cmollo 2296@/discussions
How do the upload and download aspects of the Remote Operation block work? What do the server parameters do... are they added to the URL as URL parameters (e.g., http://www.example.com/myop?param1=foo&param2=bar)?

Thanks,
Chris]]> http://forums.visokio.com/discussion/2274/idea-outputs-splitting-up-files-with-new-filter-output-blocks Wed, 07 Aug 2013 04:54:35 -0400 aknotts 2274@/discussions
I have a dataset which has a country field in it (about 50 countries). I basically filter my dataset (about 1m rows) per country and then create an IOK file for each country based upon a template. I use the batch block output in DataManager out had an idea for a new output block. It would basically combine a record filter and an output block. You would select one column to split the data by and it would create an one output file for as many items in that category that was split and create a file name based upon a mask (similar to the timestamp mask) and then append the split name to the end of the mask.

eg - Split by: [Source Country]
File mask: Country Detail File -
Template: Country Detail File Template.iok
Output Type: IOK/IOM

This would have less functionality than the batch output but would enable much quicker splitting of data files into multiple files.

If you think its a good idea, would be happy to discuss further

Andy]]> http://forums.visokio.com/discussion/1887/idea-datamanager-block-grouping-with-commentss Fri, 09 Nov 2012 03:07:43 -0500 aknotts 1887@/discussions
Thanks, P]]> http://forums.visokio.com/discussion/990/idea-datamanager-block-groupings-with-commentss Wed, 14 Sep 2011 11:13:41 -0400 eman 990@/discussions
For example:
Data connector (with options to change) -> 5 blocks -> 1 block where things need to be adjusted -> 5 blocks -> publish block

Here I could just group the 2 sets of 5 blocks to make things far simpler (5 block instead of 13) and it would be obvious which ones need to be changed.

Hope that makes sense!]]> http://forums.visokio.com/discussion/2234/sources-excel-error-communicating-with-applications Tue, 09 Jul 2013 06:36:07 -0400 LukeWhiteley 2234@/discussions We are trying to open local .xlsx files in a DataManager and are receiving the following errors:

2.7:
Invoke of: Open
Source: Microsoft Excel
Description: Unable to get the Open property of the Workbooks class

2.8:
Unable to get the open property of the workbook class.

We only get this error when trying to read from a local file or Google Drive, files from our network drives open without any problems. We suspect this may be down to having concurrent installations of both 2.7 and 2.8 that look at the same 'Visokio' folder (see attached).

Thanks,
Luke]]> http://forums.visokio.com/discussion/2189/layout-lost-datamanager-tabs Tue, 11 Jun 2013 09:46:12 -0400 Phillipa 2189@/discussions
I have checked the visible tab settings and manage tabs, but cannot find it. Is there any way of restoring it?

Phillipa]]> http://forums.visokio.com/discussion/2162/datamanager-blocks-display-blank-or-notess Wed, 22 May 2013 20:02:14 -0400 Alfonso 2162@/discussions
Picture1 : test environment.

Picture 2 : production environment.

Thanks in advance.

Alfonso]]> http://forums.visokio.com/discussion/2118/idea-datamanager-annotate-group-of-blockss Thu, 02 May 2013 16:56:37 -0400 cgamolo 2118@/discussions http://forums.visokio.com/discussion/1464/datamanager-data-file-output-2.8- Thu, 12 Apr 2012 11:56:32 -0400 chris 1464@/discussions http://forums.visokio.com/discussion/2120/idea-datamanager-copy-blocks-from-one-iok-to-anothers Thu, 02 May 2013 17:01:20 -0400 cgamolo 2120@/discussions 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.
]]> http://forums.visokio.com/discussion/2058/datamanager-resetting-display-delete-confirmations Mon, 18 Mar 2013 09:08:55 -0400 SteveP 2058@/discussions Thanks, Steve]]> http://forums.visokio.com/discussion/2056/datamanager-replacing-data-values Mon, 18 Mar 2013 06:42:01 -0400 grahamb 2056@/discussions http://forums.visokio.com/discussion/2010/datamanager-validate-data-block-curious-behaviours Fri, 08 Feb 2013 09:09:03 -0500 cmollo 2010@/discussions #6 is greater than 1. The validation then fails, as expected. See the following screenshot (or attached "ss3" file).



Questions:
1. I click the Update button on the Validate Data block, but the update does not seem to be successful... the Update button remains red and the Co2_improvement field of record #6 shows the old value. Why is this?
2. Is there a way to determine what rule(s) is failing and on what record(s)?
3. Why does the preview show "unavailable" for all records after record #10 (see following screenshot)? It would make sense if the preview showed "unavailable" for all records after record #5 (since record #6 is the record with the invalid data).



Thanks!
Chris
]]> http://forums.visokio.com/discussion/2018/idea-parameter-to-be-used-in-formulas-in-datamanagers Fri, 15 Feb 2013 04:57:43 -0500 bfromson1 2018@/discussions
Example - I have defined a parameter in DataManager which is used in a record filter as part of the data loading process. In one of my tabs, I want to display the value of this parameter as part of the narrative in a Content View, so I need to add a formula which just takes this parameter value...]]> http://forums.visokio.com/discussion/2005/datamanager-sorting-1000s-of-fieldscolumns-alphabeticallys Wed, 06 Feb 2013 11:13:44 -0500 davedunckley 2005@/discussions http://forums.visokio.com/discussion/1954/datamanager-database-import-block-sql-errors Tue, 18 Dec 2012 07:05:32 -0500 bfromson1 1954@/discussions
1) The query returned no records, as the SQL generated was looking for it to contain the text.

2) And while clicking between the "Configuration" "Filters" and "View SQL" tabs it has lost my field selections and gone back to select all

3) Minor UI issue, if you expand the View SQL box horizontally the text wrap extends out so that the SQL string extends across the available view. If you then make the view smaller horizontally it doesn't re-wrap the text but puts a scroll bar on the horizontal axis of box - minor problem, but what's wrong with perfection!]]> http://forums.visokio.com/discussion/1940/performance-datamanager-long-multi-block-flows-slows Sun, 09 Dec 2012 03:45:04 -0500 Mees 1940@/discussions
It uses up to 10GB RAM to open on a 20GB RAM 64bit server?

Question: does the number of DM blocks affect the iok files performance? Even when there is hardly any data in?

Thanks, A]]> http://forums.visokio.com/discussion/1909/datamanager-automatic-removal-of-excel-output-blockss Tue, 20 Nov 2012 16:24:00 -0500 benjamin 1909@/discussions
Every time I save and then re open the IOK file later, on the re-opening refresh the file always says it has removed these output blocks. Why is this and how do i stop it ? My version is Omniscope 2.7 stable release

Thanks, Ben
]]> http://forums.visokio.com/discussion/1888/datamanager-custom-sql-tab-review-wthout-refreshs Fri, 09 Nov 2012 07:09:31 -0500 bfromson1 1888@/discussions http://forums.visokio.com/discussion/1891/datamanager-error-on-line-1-premature-end-of-files Sun, 11 Nov 2012 10:14:31 -0500 Alexander 1891@/discussions