All right stop! Collaborate and listen (Sharing Points)

August 11, 2008

File Locked by another using MOSS user pt 2

Filed under: MOSS, Office 2007 — Tags: , , — stephenmuller @ 2:44 am

I had put in a log entry for this a while ago but

  • It was for 2003
  • And it didnt work for me in this situation.

The situation was when I tried to edit a specific document I got the message box that another user had it opened for editing, no matter what I did even deleteing it and re-uploading it I still got the message.

What ended up working was simply to Check it out change something then check it back in and close and from then on it was fine!

Go figure maybe the check in/out removed some locking file?

July 17, 2008

Using the DIP and Quick Parts with Office Pt 2

Filed under: Infopath, MOSS, Office 2007, Sharepoint, Uncategorized — Tags: , , , — stephenmuller @ 3:52 am

Ok so in the last post i blabbed how to start to make some changes to the DIP to make a user friendly mechanism for users to edit and add metadata. Users dont like doing this so making it easy and friendly is advisable :).

That last action on the last post was to make a filtered drop down to make it simple for users to select the correct data from a lookup. As we know it is not possible to add filters to dropdowns in Sharepoint, there are 3rd parties that allow you to connect lookups in a master/child relationship in Sharepoint, I will link to them later. But his can easily be done in InfoPath by expanding on the steps that I have shown.

The next steps will be to make it prettyier (im not a designer as you will see) and to add the Quick Parts feature from Office 2007.

Finishing Touches

The next thing I want to do is add some text and a picture (thanks to Ishai on this as he pointed out a way to add an unbound picture to the DIP).

To add the picture I simply selected the Picture Icon on the toolbar.  I selected the picture and it inserted as per the image.

 

I guess the standard disclaimers need to be added here, be aware of the size of the image as it will impact the times of download.

This image would perhaps be your corporate logo or something more relevant than a Calvin & Hobbes picture.

Next is the layout and fonts. This is done simply by dragging and dropping and typing in the text and formatting it as per normal InfoPath functions.

I did this by using tables and my poor imagination. Note how I added tips for each field etc. After these changes are made click the Publish button and save and publish the document.

Now to test it, create a document library in a site, allow it to use content types and select the Project Overview document.

When the New Project Overview menu is selected the new document will appear, it looks kind of like this.

There thats all that. If you had problems please contact me, I made a lot of assumptions in the process so if I missed some key steps let me know.

Using the Quick Parts

Quick Parts is a feature in Word 2007. It allows a field to be added to the document that is linked to a document property or blocks of text called building blocks. We are only interested in the Document properties.

The feature is accessed from the Insert menu from Word 2007 as seen below

To demonstrate this keep the word document that you opened above.

Select the Quick Parts menu option then Document Property (note how all the fields are listed here including the SharePoint ones) I then selected Project Name, this drops a control onto the document as per below and then make a label for it.

 

I then created the Project Type and Project Manager, and formatted it a little nicer.

This image shows all the fields on the form as well as the dropdown for the Project Type.

There are a few thing to note. When the field is a lookup or list the field on the form will operate as a dropdown. You will also notice that it will use the value that has been selected in the DIP in the field, when you change the value in the field on the document the value in the DIP will also change. This shows that the two fields are linked.

This means that we can now add fields to a document template for the user to fill out and that will automatically populate the metadata for the document, so the users only need to fill the data in once. 

This document can now be saved as a template and uploaded back into the template for the content type so it can be used again and again.

Done….Did this make sense.

Summary

Ok in these two posts I hope I have shown how to make changes to The DIP to make a user friendly interface for users to add the additional metadata that they may need to add for a document. Smarts can be created with the fields to filter the data choices to the correct values. This is something that can only be done by 3rd party tools within SharePoint (or custom development).

By linking these fields into the actual document template via the Quick Parts we can save the user having to re-type the fields while still keeping a corporate template for the document.

All of this in my eyes is purely to assist the end user by making an easy and intuitive interface where they can quickly add the additional metadata for a document. Something I have said to many clients is that users are generaly happy to spend the time to add in more information than they are used to if it is easy AND there is a clear benefit to them ie, quicker access in locating that document or sharing it with other users. I think these tools can be used to help make that happen.

 

Over and out.

Using the DIP and Quick Parts with Office Pt 1

Filed under: Infopath, MOSS, Office 2007 — Tags: , , , , — stephenmuller @ 12:33 am

This will be a two part post as it may be long.

Last night I did a very quick and broad overview of using and modifying the Document Information Panel via Infopath for SharePoint. I got some interesting feedback and will be looking at it further. This is the first pass on using the DIP and also leveraging the Quick Parts features in Office to create a user friendly and intuitive form template for users. This will cover a process of creating a content type, modifying the DIP and changes to the word template.

Items for this project include

  • MOSS, I do not believe that you can edit the DIP via WSS (but I am waiting to be corrected on this).
  • InfoPath 2007
  • Office 2007

Im also making a bit of an assumption that you know your way a little around InfoPath as it just becomes long to describe, if you have any issues please email me.

Create the Content Type and Document Information Panel

I created a site level content type as shown below.

 

The Project Managers Metadata in the content type is a lookup to a contact list on this site (This is important later on). In this contact list I added a yes/no field called Project Manager. I will use this flag later on.

Edit the Document Information Panel

To edit the DIP select the Document Information Panel Settings link on the CT page.

I check the Always show Document Info….. Check box at the bottom of the screen to ensure it is always visibe to users.

To create a new DIP click the Create a new custom template link.  This will launch InfoPath for you to edit the DIP. Click the Finish button when the Data Source Wizard Appears (read it first :)). The InfoPath form should look like this

Note how all the custom metadata fields are auto-loaded in the form. You will also have access to all InfoPath functions. When you get a chance have a play with the functions, I will only utilise some and I am not an expert on all of them so if you find anything nifty like using activeX controls let me know.

The first thing I will do is limit the Project Managers field to only show the contacts that I have flagged as Project Managers, so users can only select the Project Managers. (This will use the flag in the contacts list as mentioned above).

To do this select the ensure that the Project Management field is available via opening up the Data Connections in the Tools menu and select the only Data Connection string in the list  and follow the bouncing ball to ensure that the Project Management field is checked, should be by default.

Side point: The Data Connections are used to connect to the Sharepoint lists that have been used in the lookup fields on metadata. The naming is yucky so if you have several lookups in your form then check the name by editing the properties of the dropdown of the field and checking the name of the list that is used. You can also add your own data connections to any other SharePoint lists that you have (great feature), or web services.

After you exit out of the Data Connections wizard select the Project Manager field on the InfoPath form then select Drop-Down List box Properties. In the Entries Field click the funny button next to it. Next expand the nodes in the yellow box and ensure the Contact fields are available but keep the folder above the fields selected (as seen in the image below), I actually had an issue here as the fields were not visible so I had to recheck the data connection, and then it worked.

The next task is to filter the data so click the Filter Data… button a third window will open, to add the filter select the Add Button. All these boxes you can see below.

In the Specify Filter Conditions dialog I selected the Project_Management field then is equal to and in the last drop down the value of 1 (not TRUE).

Click Ok on all the dialogs until you return to the Drop Down List box properties dialog. Ensure the Value and Display name are correct (displaying and storing a field that you wish to view and store). Click OK.

You can check how it all worked by clicking the Preview button on the InfoPath toolbar. If it works great if it does not email me….I may have explained to badly.

To save the form simply select the Publish option from the File Menu. It will prompt you for a physical location to save the file first (Maybe a centralised document library to store them all togeather). Then it wil publisht the form back to the content type just accept all the options in the publishing wizard. When done it is now saved and connected to the content type. You can now use it to your hearts content.

The next phase will be on the next post coming soon, which will talk about making the form pretty and using the Quick Parts…

March 5, 2008

Seperate Document Windows in Office 2007

Filed under: Uncategorized — Tags: — stephenmuller @ 4:10 am

This is call out for some help.

 I want to have two seperate word docs running side by side (I have a dual monitor) so I can copy and or compare the two. Before I could im sure in Office 2003. Now I cant in 2007..I want to…

I found a link that shows me how to have them as seperate icons in the task bar but they still run in an a single MDI.

Does this make sense and does anyone have a switch that I need to flick? Im sure it is simple. Help…..

Create a free website or blog at WordPress.com.