Tuesday, March 4, 2014

Attending ThoughtWorks Hang out today

I had the good fortune to attend the ThoughtWorks technology Radar presentation this morning ..  Reviewing the Radar gave me some ideas for new technologies on the horizon, but most importantly which technologies and frameworks that I can safely ignore for a few more months.

It’s well worth a review… http://www.thoughtworks.com/radar/#/

Thursday, February 20, 2014

Primavera filter error

Today an old issue raised it head… When creating a filter on the a specific field caused an error is displayed to the User.

clip_image002

This issue addressed with a Primavera HotFix file that was released from Oracle for P6 SP 3.

Copy the file: PM.EXE hotfix file which you can download from the support site, over the existing PM.EXE file on the client PC. This can usually be located in the “C:\Program Files (x86)\Oracle\Primavera P6\Project Management” folder.

Tuesday, February 11, 2014

List of Items in Business Objects

Today one of the Users asked if it was possible to update the list of items that appear in a query list….

clip_image002

For example, the list above shows all months in 2014 .. they only want to see dates in 2013 and 2014.

You can do this using Information Designer.

1) Open the Universe

2) Select the “Parameters List of Values option”

clip_image004

3) Edit the existing list or create a new one.

clip_image006

4) Edit the Query and change the name

clip_image008

5) Add the additional values you want in the list and click OK.

6) clip_image010

7) Next ensure that the filter/field in the Universe is associated with the correct list

8) Click on “Business Layer” and the field; then click “Advanced”

clip_image012

9) Publish the Universe.

Thursday, January 30, 2014

CHM file is blank when opened

Today I was downloading some API documentation which was in CHM format.  The problem is the files where blank when I opened them!

image

The solution was simple…. Just right click on the file in windows Explorer and click the “Unblock” button on the General tab.

image

Now when you open the file the document information is shown.

image

Thursday, January 16, 2014

Running an SSRS report against SharePoint

One of the things that comes up again and again is having the ability to run reports against SharePoint Lists. You create the report like you would any other using Visual Studio and deploy it to your sever.

You set the report to run against a list and as a specific user.

Click on the down arrow and selecting the “Manage option”

clip_image002

In the DataSource Tab ensure you are using a custom data source selected with the details set such as URL and Username and Password.

clip_image004

Click “Test Connection” and it will confirm that everything is working correctly

Tuesday, January 14, 2014

Nintex workflow Inline functions

Found a handy post that lists all the Nintex workflow inline functions. http://connect.nintex.com/forums/permalink/4119/4892/ShowThread.aspx

Sunday, January 12, 2014

Compressing PDF files with Nitro PDF

Today I had a problem getting a file sent to to a client. The issue was that the PDF was running to 32Mb in size and the email limits where stoping transport. The solution was to "Optimise" the document.

Open the doc in Nitro PDF; select File / Optimize

clip_image002

Select "Web" and click "Optimize" button .. simple. After a few seconds you end up with a file just under 6Mb!