Tagged with DataManager_workspace - Visokio Forums http://forums.visokio.com/discussions/tagged/DataManager_workspace/p3/feed.rss Mon, 30 Oct 17 13:21:46 -0400 Tagged with DataManager_workspace - Visokio Forums en-CA Join and Case sensitive http://forums.visokio.com/discussion/454/join-and-case-sensitive Tue, 19 Oct 2010 20:34:13 -0400 Mees 454@/discussions
My join in DM joins two fields whereby values are equal, except for the fact that in one file it is all lower caps and in the other it is both small caps and caps.
Example: "Omniscope" should join with "omniscope" and "omniScope"
I assumed I should use the functions Accent sensitive and Case sensitive in the Merge/Join block, but unfortunately this doesn't work like this.

Can you please advise?
Thanks
Arjan]]> Parameter Passing http://forums.visokio.com/discussion/445/parameter-passing Mon, 11 Oct 2010 17:06:46 -0400 bfromson 445@/discussions
It can sometimes be difficult to select a single record. If "show details" of a number of records from one of the charts then click to display a single record, that record is not selected. There is however a "Highlight" button at the top of the record - could there be a "publish" button as well?

Thanks]]> SQL Server 2008 http://forums.visokio.com/discussion/344/sql-server-2008 Thu, 01 Jul 2010 09:59:20 -0400 aknotts 344@/discussions
I'm running SQL Server 2008 R2 on a Windows 7 64-bit machine on which I have Omniscope 2.6 b300 installed. I also have MS Office Pro 2010 on this machine. I add a Database table to the pallette in datamanager I select SQL Server and then select SQL Server 2008. Then I complete the fields as required and try to connect and receive an error (see attached). I have tried with all SQL Server options and still cannot connect (jTDS etc). I have turned the firewall off on the machine, checked all the ports are still at their default of 1433 and still get an error. The only way I can connect to SQL Server is by downloading the SQL Server JDBC drivers using the JDBC (Advanced) option. The preferred route is obviously to use the SQL Server option rather than to install JDBC.

Can you confirm whether this is an issue or I need to change my config?

Thanks

Andy]]> Double read of database blocks http://forums.visokio.com/discussion/432/double-read-of-database-blocks Fri, 01 Oct 2010 15:13:12 -0400 Guy_Cuthbert 432@/discussions
1. Open a new DataManager
2. Add a Database block to the work area, next to the default Omniscope block
3. Configure the Database block to connect to my server (SQL Server, in this case) and define my query
4. Execute the query and load the data (takes 7-8 mins)

5. Link the Database block to the Omniscope block
6. Press Load... results in re-query and data load into Database block (another 7-8 mins) and then load the data into the Omniscope block (2-3 mins)

I can't see any reason for this?

Should I be limiting my access to the database by saving off a snapshot after step 4, adding an Input Switch and then using the snapshot until I want to hit the database again? Does this prevent a re-read?]]> Date Format - Field Organiser http://forums.visokio.com/discussion/404/date-format-field-organiser Tue, 31 Aug 2010 12:48:32 -0400 aknotts 404@/discussions
I have a CSV data source and have loaded it in using Data Manager. I have a date field and the format is dMMyyyy ie the dates can be 31082010 or 3092010 (data manager see ths original type as integer). I cannot set this as a date field in Field organiser with a format of dMMyyyy as it will not parse the shorter dates so I have created a formula which prepends a zero to the front of the date field so they are all 10 characters long. If I set this formula to be a Date/time I cannot alter the Date format (input) to map the format of my data therefore I have to use string manipulation functions to set it to the format dd-MMM-yyyy. Is there any better way to do this or do I have to do it long-hand using formulas?

Thanks]]> Batch Append mode for Excel data http://forums.visokio.com/discussion/334/batch-append-mode-for-excel-data Tue, 15 Jun 2010 10:36:47 -0400 Guy_Cuthbert 334@/discussions
In Data Manager, we have a File block and a Batch Append block. In the File block we can select to use Excel or not to read .XLS(X) files... but this option isn't present in the Batch Append block... which reader does Batch Append use? I ask because we have noticed that allowing the non-Excel reader to access the same file in concurrent operations (e.g. multiple File blocks reading from the same Excel file) can cause problems (looks like some kind of file locking?) - so we need to know whether we can read batches of Excel files reliably?

Incidentally, when opening a number of models I find that some File blocks are automatically opened and refreshed whereas others require me to go and press the Execute button within them (not change anything, just Execute). These non-loading bloacks all say "configuration incomplete", but pressing "Execute" is the only 'configuration change' that I make. Is this expected behaviour?

Thanks...]]> Cant get data manager http://forums.visokio.com/discussion/326/cant-get-data-manager Thu, 27 May 2010 18:25:59 -0400 peterg_at_aps 326@/discussions
If it is available for 32 bit only I understand these can now be installed side by side. Would I need to de-activate/ reactivate the license if I do that?

Thanks Peter]]> Field Organiser - thousand seperator issue http://forums.visokio.com/discussion/315/field-organiser-thousand-seperator-issue Wed, 19 May 2010 11:26:14 -0400 SteveP 315@/discussions
I can save the file, change the raw data, re-open the Omniscope file, and it is still all OK. But as soon as I go back to the DataManager tab, the changes to the integer fields are lost. All of the other field changes are still there (renames, calculations etc), but the integer fields have the thousand seperator option ticked again.

Any ideas? This is with build 262.

Thanks
Steve]]> Bar Chart options http://forums.visokio.com/discussion/299/bar-chart-options Wed, 28 Apr 2010 17:28:29 -0400 kmatrix999 299@/discussions
In 2.5 I used to have a side menu in bar chart view that enabled me to suppress the "other" option and to show all columns using a scroll bar (I often have up to 50 columns).

In 2.6 I cannot find this option any more. Where should I be looking?]]> Zones in graph view http://forums.visokio.com/discussion/300/zones-in-graph-view Wed, 28 Apr 2010 18:07:57 -0400 kmatrix999 300@/discussions
I know that I can use the cursor to navigate around the zones, but had you given any thought to being able to select any 1 of the zone views so that it automatically sizes to full screen and then be able to go back to the four zone view.]]> How to append the content of row 2 and header row http://forums.visokio.com/discussion/287/how-to-append-the-content-of-row-2-and-header-row Mon, 12 Apr 2010 17:41:24 -0400 Keesup 287@/discussions
Example Row 1: Velocity
Row 2: (in KM/Hour)

I want to create 1 header row of: Velocity (in KM/Hour)]]> Unable to launch 226 http://forums.visokio.com/discussion/283/unable-to-launch-226 Thu, 08 Apr 2010 07:19:17 -0400 emcelhatton@procurra 283@/discussions Retrieving SQL Server view and functions in DataManager http://forums.visokio.com/discussion/264/retrieving-sql-server-view-and-functions-in-datamanager Wed, 24 Mar 2010 11:24:09 -0400 gary 264@/discussions Security - setting password for file http://forums.visokio.com/discussion/255/security-setting-password-for-file Wed, 10 Mar 2010 21:21:30 -0500 emcelhatton@procurra 255@/discussions
I repeated the exercise and after entering the passowrd twice as usual, saved the file and then closed. This saved the password and on next opening, the password was required to access the file

Eugene
(Apologies if this is not the correct place for recording this discussion)]]> DataManager: apparently not working in v2.6b195 http://forums.visokio.com/discussion/253/datamanager-apparently-not-working-in-v2.6b195 Mon, 08 Mar 2010 10:24:44 -0500 Pascal 253@/discussions If i save tgus new, empty file and try to reopen it, i get a null pointer exception and the file closes after a message "application error".
When i open a v2.5 file using v2.6b195 build, the file works citrectly until i try to add a data manager tab, which results in the same error i described at the beggining of this post.
I'm in a train so i will send th error reports in 2 hours, as soon as u get an inteenet connection.]]> Record filter http://forums.visokio.com/discussion/221/record-filter Tue, 09 Feb 2010 15:49:18 -0500 rchristy 221@/discussions DataManager - case sensitive matching? http://forums.visokio.com/discussion/456/datamanager-case-sensitive-matchings Wed, 20 Oct 2010 11:05:51 -0400 SteveP 456@/discussions Thanks - Steve]]> DataManager: New launch parameters (2.8+) http://forums.visokio.com/discussion/1594/datamanager-new-launch-parameters-2.8- Tue, 12 Jun 2012 07:34:19 -0400 steve 1594@/discussions
  • File source: location path (2.8+)
  • URL source: URL address (2.8+)
  • Database block: database/instance/table names and host/port (2.8+); server-side filtering; within custom SQL
  • Access database: file path (2.8+)
  • Field organiser: default value, replace value
  • Record/field filters: match value
  • Input switch: input selection (accepts text, boolean, number)
  • Search/replace: search & replace values
  • List of values: the list itself


This means you can use a variety of mechanisms to dynamically update these form fields:
]]>