ERTE 1.2 released

Filed Under (ERTE, Flash, JavaScript, SharePoint) by Boris Gomiunik on 06-05-2009

Thanks Michael for pointing the issue out. I’ve finally caught up on some work that needed to be done on ERTE and now the new version is available for download. The updates are as follows:

  • Fix for IE8,
  • wrapped the thing in a function so you can run it on custom event
  • added support for _spBodyOnLoadFunctionNames array if it exists
  • set the button image location in a variable
  • added French language supprt. Thanks Slash71
  • isolated so it inserts only the <embed… </embed> part of code (to help bypass some limitations on truncated announcements views, if the embed code has <object,…></object>.

Curently there are only 3 languages supported – English, Slovenian and French. If you have 5 minutes of time, you also could contribute to this project. All you need to do is translate one line of text and send it to me. Maybe you can even post it as a comment so you’ll be recognized :)

Download the latest version from CodePlex site

Oznake ponudnika Technorati: ,,,,

Quickly filter a List/Document Library View using URL

Filed Under (Flash, JavaScript, SharePoint) by Boris Gomiunik on 27-02-2008

This one’s very useful when you’re having a lot of items in a list or document library and you need a quick filter.

If you’ll select the filter field it can happen that it will load for a long time. So lately I’m using URL. Suppose you have a long list of contacts and you need to find a contact named Boris.

In the AllItems.aspx – view of the page, add parameters

?FilterField1=[Field Name]&FilterValue1=[Value]

You can add more filterfield and filtervalue parameters to apply filters to more fields (FilterField2, FilterValue2, …)

The only trick is to know the Field Name like it’s saved in SharePoint. You can see this in the list settings page (click on a column name and check URL) or just make a manual filter for the first time.

In my case to find a contact with First Name Boris, I’d go to

http://[site_URL]/lists/contacts/AllItems.aspx?FilterField1=FirstName&FilterValue1=Boris

I’m always browsing a document library with filtering by specific document type. So I’ve created a simple script. Just add a Content Editor Webpart to your homepage, edit its source and add the following code (just update the url to your document library (docLibUrl):

<script type="text/javascript">
function docLib(dropdown) {
  var vtype = dropdown.options[dropdown.selectedIndex].value;
  var docLibUrl = "/Shared Documents/Forms/AllItems.aspx";
  var filterField = "DocIcon"
  if (vtype != ‘Select’) {
    document.location=docLibUrl+"?FilterField1="+filterField+"&FilterValue1="+vtype;
  }
}
</script>
<select style="margin:10px; 0px;" id="DocumentTypes" onchange="docLib(this)">
<option value="Select">Select document type</option>
<option value="Select">– Office 2007 –</option>
<option value="docx">Word 2007</option>
<option value="xlsx">Excel 2007</option>
<option value="pptx">PowerPoint 2007</option>
<option value="Select">– Office 2003 –</option>
<option value="doc">Word 2003</option>
<option value="xls">Excel 2003</option>
<option value="ppt">PowerPoint 2003</option>
<option value="Select">– Other –</option>
<option value="pdf">Acrobat (PDF)</option>
</select>

Oznake ponudnika Technorati: ,

Adding Flash animation in SharePoint Blog and other lists pt. 2

Filed Under (Flash, JavaScript, SharePoint) by Boris Gomiunik on 27-02-2008

This post continues the topic from my first part about embedding Flash videos in SharePoint Blogs where we’ve learned how to embed one Flash animation or video (or have a lot of work for publishing each flash).  The problem arises if we want to embed more videos and have them displayed automatically.

Since SharePoint is very strict about filtering a LOT of the code out, I’ve devised a way of passing all the parameters needed for swf object through ID. And how to recognize divs for the swfobject? Using CSS class name.

Here’s what we need to do:

1. Have te swfobject.js uploaded to the site.

2. Add the following javascript at the end of the page (or in a Content editor webpart below the posts or list items:

<script type="text/javascript" src="swfobject.js"></script>

<script type="text/javascript">

function embedFlashes() {
    var myLayers = document.getElementsByTagName(‘div’);
    if (myLayers.length>0) {
        var myFlashes = new Array()
        for (i=1; i<myLayers.length; i++) {
            if (myLayers[i].className == ‘flashcontent’) {
                myFlashes.push(myLayers[i].id)
            }
        }
        var so = new Array()
        for (j=0; j<myFlashes.length; j++) {
            tempParam = myFlashes[j].split(‘::’)
            so[j] = new SWFObject(tempParam[0], tempParam[1], tempParam[2], tempParam[3], tempParam[4], tempParam[5]);
            for (p=6; p<tempParam.length; p++) {
                detail = tempParam[p].split(‘=’)
                so[j].addVariable(detail[0], detail[1])
            }
            so[j].write(myFlashes[j])
        }
    }
}

embedFlashes()
</script>

3. Now in the content you need to edit the HTML code of the body and insert the layers in the following format (note – input parameters are separated by double colon.:

<div class="flashcontent" id="[url_of_swf_file]::[unique_id]::[width]::[height]::[minimum_flash_version]::[background_color]::[flashvar1=flashvar1_value]::[flashvar2=flashvar2_value]…">[Alternate_content]</div>

Let’s reuse the sample from previous post and some color coding. To embed

<object width="425" height="355"><param name="movie" value="http://www.youtube.com/v/Z2yNzw00mpA&rel=1"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/Z2yNzw00mpA&rel=1" type="application/x-shockwave-flash" wmode="transparent" width="425" height="355"></embed></object>

Insert the following html to the blog post body:

<div class="flashcontent" id="http://www.youtube.com/v/Z2yNzw00mpA&rel=1::video01::425::355::8::#FFFFFF">Please view this post on my website to display the video.</div>

The rest of parameters are made up – video ID is video1, it requires flash 8 and background color is #FFFFFF – white. Let’s do another sample with flashvars – the same video on MSN Video. The Embed code is:

<embed

src="http://images.video.msn.com/flash/soapbox1_1.swf" quality="high" width="432" height="364" base="http://images.video.msn.com" type="application/x-shockwave-flash"
allowFullScreen="true" allowScriptAccess="always" pluginspage="http://macromedia.com/go/getflashplayer" flashvars="c=v&v=d41e1dfd-919b-4d57-89c9-736f9c75db14&ifs=true&fr=msnvideo&mkt=en-US&brand="></embed>

To embed this video you’d use the following HTML code:
 

<div class="flashcontent" id="http://images.video.msn.com/flash/soapbox1_1.swf::MSNVideo01::432::364::8::#FFFFFF::c=v::v=d41e1dfd-919b-4d57-89c9-736f9c75db14::ifs=true::fr=msnvideo::mkt=en-US::brand=">Please view this post on my website to display the video.</div>

And the result:

 

Yeee, working!

Technorati tags: SharePoint JavaScript Flash SharePoint Blog

Unable to create SharePoint list from Excel (import spreadsheet)

Filed Under (Flash, Web design) by Boris Gomiunik on 09-07-2007

If you’re trying to import spreadsheet to create a SharePoint list in SharePoint 3.0 you can receive some errors. This especially occurs if you’re using Excel 2003.

Thanks to Matjaž from Portorož, there is a resolution to this problem: update office 2003 to at least SP2 and the problem will go away.

"Cannot connect to the configuration database" and SharePoint

Filed Under (Computer, Flash, Software, windows vista) by Boris Gomiunik on 04-05-2007

Today I’ve received another of the cases when SharePoint (v2) couldn’t connect to the configuration database. This can be a common problem but it’s not so horrible to solve it.

The reason for this is that SharePoint lost the connection to the database.

Reasons may be the following:

  • SQL or WMSDE database may not be running

  • IIS may be running in IIS 5.0 isolation mode
  • The account for connecting to SQL or WMSDE might be gone or with changed password
  • update – SQL Server Embedded Edition might not be running (check services) – Thanks, deanoc (see the comments)

The solution to these is on the following link:

http://support.microsoft.com/kb/823287/en-us

But I’ve found another reason that could be. Simple: The SQL is running, credentials are also ok and IIS isn’t in the 5.0 isolation mode. The problem may occur if sharepoint simply can’t find the database. Reasons for this may be many: the database has moved, dns has changed, … In my case was the later. By changing the DNS server in the network we’ve had to add one more record manually to point to the correct one and the sites started to work.

Blog easier

Filed Under (Flash, Free tools, Web design) by Boris Gomiunik on 15-02-2007

Even though all of the blog providers enable very easy posting to blog, I still prefer to do it offline. One option is already presented – with Word 2007, which really simplifies the posting and work with pictures.

Another good program for blogging is Windows Live Writer. And I’m using this one. Why this one? Because it has some really neat features, a lot of plugins available, etc. A nice thing is that it can also ping the servers for you, so you don’t have to do it manually. Below is a list of ping servers I’ve found. In writer you enter those under Tools –> Preferences –> Ping servers:

http://1470.net/api/ping
http://api.feedster.com/ping
http://api.feedster.com/ping.php
http://api.moreover.com/ping
http://api.moreover.com/RPC2
http://api.my.yahoo.com/RPC2
http://api.my.yahoo.com/rss/ping
http://bblog.com/ping.php
http://bitacoras.net/ping
http://blogdb.jp/xmlrpc
http://blog.goo.ne.jp/XMLRPC
http://blogmatcher.com/u.php
http://bulkfeeds.net/rpc
http://coreblog.org/ping/
http://mod-pubsub.org/kn_apps/blogchatt
http://ping.amagle.com/
http://ping.bitacoras.com
http://ping.bloggers.jp/rpc/
http://ping.blogmura.jp/rpc/
http://ping.blo.gs/
http://ping.cocolog-nifty.com/xmlrpc
http://pinger.blogflux.com/rpc/
http://ping.exblog.jp/xmlrpc
http://ping.feedburner.com
http://ping.myblog.jp
http://pingqueue.com/rpc/
http://ping.blogg.de/
http://ping.rootblog.com/rpc.php
http://ping.syndic8.com/xmlrpc.php
http://ping.weblogalot.com/rpc.php
http://ping.weblogs.se/
http://rcs.datashed.net/RPC2/
http://rpc.blogbuzzmachine.com/RPC2
http://rpc.blogrolling.com/pinger/
http://rpc.britblog.com/
http://rpc.icerocket.com:10080/
http://rpc.newsgator.com/
http://rpc.pingomatic.com/
http://rpc.tailrank.com/feedburner/RPC2
http://rpc.technorati.com/rpc/ping
http://rpc.weblogs.com/RPC2
http://rpc.wpkeys.com/
http://services.newsgator.com/ngws/xmlrpcping.aspx
http://signup.alerts.msn.com/alerts-PREP/submitPingExtended.doz
http://topicexchange.com/RPC2
http://trackback.bakeinu.jp/bakeping.php
http://www.a2b.cc/setloc/bp.a2b
http://www.bitacoles.net/ping.php
http://www.blogdigger.com/RPC2
http://www.blogoole.com/ping/
http://www.blogoon.net/ping/
http://www.blogpeople.net/servlet/weblogUpdates
http://www.blogroots.com/tb_populi.blog?id=1
http://www.blogshares.com/rpc.php
http://www.blogsnow.com/ping
http://www.blogstreet.com/xrbin/xmlrpc.cgi
http://www.holycowdude.com/rpc/ping/
http://www.lasermemory.com/lsrpc/
http://www.imblogs.net/ping/
http://www.mod-pubsub.org/kn_apps/blogchatter/ping.php
http://www.newsisfree.com/RPCCloud
http://www.newsisfree.com/xmlrpctest.php
http://www.popdex.com/addsite.php
http://www.snipsnap.org/RPC2
http://www.weblogues.com/RPC/
http://xmlrpc.blogg.de
http://xping.pubsub.com/ping/

What would be also very neat is that it would be able to post to SharePoint (so I could use it also for my other blog). Other thing is that it could have those neat effects for pictures and save pictures also to SharePoint Library.

On the other hand Word is missing the auto ping functionality, editing the code, etc. So: Word team and Writer team: please get together and exchange knowlege :)

Technorati tags: , ,

SharePoint Document Library showing only folders and top-level items…

Filed Under (Flash, Web design) by Boris Gomiunik on 02-02-2007

Today I was moving the videos for our e-learning portal Piflar to the new Windows SharePoint Services. And after moving videos for couple of hours – all one by one, not to break the links in data views, I start on working on the data view to display the videos. And I get terrified! The data view is showing only the folders I’ve created and videos that were in the main folder. So after first shock I’ve discovered what to do:

1. After inserting the data source click on the name of the data source in the Data Source Details pane to open the properties dialog.

  1. After inserting the data source click on the name of the data source in the Data Source Details pane to open the properties dialog.

  2. In the Item and folder scope dropdown select value RecursiveAll.

 

And all my data is back! Happy SharePointing :)

50 coolest websites

Filed Under (Flash, JavaScript, Web design) by Boris Gomiunik on 05-01-2007

Time.com announced 50 coolest websites. So if you’re up for becoming the candidate for the next year, check and compare yourself to them. It’s a good starting point :) .

Update to previous post – offline active content

Filed Under (Flash, JavaScript, Web design) by Boris Gomiunik on 29-12-2006

If you’ll be making the offline version of a website and you’re thinking to include the active content like Flash or JavaScript (or both) you can surely use the Mark of the Web, which I’ve described in the previous post.

There is a catch though. You can’t make the mark of the web for pictures. So if you’ll be linking from your web pages directly to some images it won’t work! The Internet Explorer security will block it.

The only way I could link “directly” to the image was to put the image into an empty page, equip the page with “mark of the web” comment and then link to that page.

If anyone knows a better way to resolve this, I’d be more than happy to read about it. You can let me know in the comments.

Expand – Colapse with more than just clicking on + / – in a data view web part

Filed Under (Flash) by Boris Gomiunik on 28-10-2006

SharePoint and FrontPage have a very nice functionality of grouping the data in a list data view according to selected group. What in my opinion can be improved, is that you expand or colapse the group with a click on the whole cell rather than targeting that small plus or minus sign in front of a group name.

Not to reinvent hot water again: this is already discovered so let me point it out:

http://dev.collutions.com/blog/Pages/Grouping.aspx

Thanks, Jim Duncan!

ads
ads
ads