chart that shows items that are in two or more locations

Say you have

Item      Location     Amount

A          010            100

A          020              200

B          010               100

I would like to create a chart that shows only items that are in two or more locations

So

Item      Location     Amount

A          010            100

A          020              200

I have tried a dynamic dimension like

=if(aggr(count(distinct Location),Item) >1, Location, Null())

But its not quite what I need

#opensim Notes 2

So, now that I have it running, time to get it working with MySQL

Following this old guide, hopefully nothing drastic has changed.

https://opensimuser.wordpress.com/2010/03/04/updated-mysql-installation-guide/

I’m not sure of a recommended mysql version for say 0.8.1.0 Dev version that I’m playing with. And I see this bug

  • Windows x64 systems:  There is currently an unresolved bug_id=5294 found when running OpenSimulator with MySQL 5.5 on Windows x64 systems.

But we will see how mysql community 5.6.23 fares. I just went here and downloaded the MSI version.

So I did a custom install and install MySQL Server 5.6.23 X64 and MySQL Workbench 6.2.4 X64

Ok, next, next install. Now to create a DB. I used the Workbench, and the good ol CREATE DATABASE opensim.

Then I edit the StandaloneCommon.ini and comment out the SQLite line and uncomment the MySql lines

Ok, that was fairly painless. I also edited my Regions.ini to take advantage of the varregions! It worked pretty slick as well.

#Opensim notes 1

I have noticed that regions are kindof small so this tutorial looks very helpful in making a mega region.

http://www.sutor.com/c/2010/02/virtual-life-opensim-ubuntu-9-10/

I followed the instructions to create three more regions. Of course it failed at first (I didn’t increment the ports like instructed) after doing so the console asked me if I wanted to add it to my region. I of course answered yes.

I followed the instructions to create a mega region and they worked as well.

All I needed to do in the above configuration was to edit the OpenSim.ini file in the bin directory to include the line

#Opensim finding a UUID of an object

Give it a unique name and then in the opensim console type

show part name ‘the name’

it will show you the UUID

Ok, scratch that. In the singularity viewer go in to edit mode and then press the Copy Key button.

#OpenSim #OpenSimulator with Dispatcher

I recently started messing with OpenSim. Such a fascinating piece of software! My kids have gotten quite the kick as I have been building virtual worlds around them.

Next on my agenda was the ability to move\change\etc… objects externally somehow. That is where Dispatcher comes in.

So, I first needed to get dispatcher up and running.

You need the ‘master’ version from

https://github.com/opensim/opensim (Just download Zip)

Unzip it to say c:\Opensim-master

No, get a copy of Dispatcher from https://github.com/cmickeyb/dispatcher

Next, copy the two modules (folders named dispathcer and rcontrol) (Inside dispatcher-master\modules)

to

c:\Opensim-master\addon-modules

Install yourself a copy of Visual C# Express 2010

Run the c:\Opensim-master\runprebuild.bat

Double Click the c:\Opensim-master\OpenSim.sln

DispatcherModule should be at the top of your Solution Explorer

Build it.

If you are lucky your build will succeed :)

You should now have a Dispatcher.dll inside your C:\opensim-master\bin directory

You will need to do some configing before anything will work.

I just used the defaults in the Dispatcher.ini

You also need an OpenSim.ini (I used the config-include/Standalone.ini) and setup the

config-include/StandaloneCommon.ini

(I got my config from the binary package from http://opensimulator.org/wiki/Download)

To check that it is there,

run dispatcher stats (All lower case)

Qlikview resetting variables during reload, solution

From http://community.qlik.com/thread/39123

Re: Preventing variable reset on reload
Ryan O'SullivanApprentice

Hi,

I have come across a possible workaround that is working in my environment.

In the document properties/variables tab, for each of the user variables i have ticked the box for “Include in Bookmarks”. After several document reloads using publisher the variable values are being retained after each refresh. I was having a similar issue with Date variables changing back to defaults and now it appears fixed.

Note: You need to reload it a first time, then change your variables and reload again to see the changes is working.

Cheers!

Spud

Error 0x800F0A1 when installing Windows Server 2008 R2 SP1 on a Veeam Backup & Replication server, solution

So this is an interesting one. In order to install SP1 they want you to disable the automount. From what I know about the automount, with it on you could seriously screw up your VM environment. So this guy found a work around

http://forums.veeam.com/veeam-backup-replication-f2/automount-disabled-and-winserver-2008-sp1-intall-problem-t6612.html

My syntax differed from his

Windows 2008 R2 Service Pack 1 only needs temporay access to the system partition which is prevented with automount disabled.
I installed the service pack as follows: (Drive J can be any free drive letter not used).

1. At command promtp: Type “mountvol /? “(This will display help and will also list volumes). Identify system partition (will not have drive letter) ie: \\?\Volume{9be074ce-d55f-11df-83d7-806e6f6e6963}
2. Mount a temporary drive letter to the system partion “mountvol j:/ \\?\Volume{9be074ce-d55f-11df-83d7-806e6f6e6963}” (Enter your own system partition guid).
3. Run SP 1 update and restart.
4. Dismount temporary drive “mountvol j: /d”.
Done.

For me it was mountvol j: \\?\Volume{9be074ce-d55f-11df-83d7-806e6f6e6963} (Enter your own system partition guid).

Also, I found you could just open up computer management and assign a drive letter to the funky 100MB or so partition there and it appears to accomplish the same thing! tally ho

Follow

Get every new post delivered to your Inbox.

Join 244 other followers