GeoLocation, for item in list of WSS 3.0 and SharePoint Server 2007

We have released as free this product developed for SharePoint Server 2007 and Wss 3.0. We not will give support from now in this product and only the customer that bought it will have support, then is your responsibility install and use this product in your environment.
With this product you can have contacts, companies, resources or each item in a list or document library associated in a map through latitude and longitude.

The features of the products are:

· Easy install and uninstall

· English and Spanish

· Configuration API of Google Maps

· Configuration of document libraries with the image to load in the map for each point

· Preview of maps

· Access the map in the item

Install and uninstall
A setup to install and uninstall the tool in SharePoint.

English and Spanish
This tool would install in tow language. English and Spanish
Configuration API of Google Maps
When we are configuring the field we need to accept the terms and conditions of Google Map to get the key for the api.

Configuration of document libraries with the image to load in the map for each point
After to accept the terms and conditions the next step is to set the default longitude and latitude for the map and select the library in SharePoint where are the images that we want use to create a point.

Preview of maps
When we are creating or editing an item in the list and we want to select a point in the map we can browse into the Google map or set directly the latitude and longitude of our point.

Access the map in the item
When we view the item of the list we could see our point loaded with the image selected.

Download

BDC Litle for WSS 3.0 and SharePoint Server 2007

We have released as free this product developed for SharePoint Server 2007 and Wss 3.0. We not will give support from now in this product and only the customer that bought it will have support, then is your responsibility install and use this product in your environment.
This product was created to have fields in lists or documents libraries connect to a Data Base SharePoint, especially in WSS 3.0 where BDC is not supported.

The features of the products are:

· Easy install and uninstall.

· Selects multiple columns

· Preview of the data.

· View of the data selected.

Install and uninstall
A setup to install and uninstall the tool in SharePoint.

Select multiple columns
In the creation of new field for a list or document library, we can set the query to the data base and we can select one or more columns to show in the field.

Preview of the data
When we are adding or editing a new item we can see the data saved in the database in a grid, select one row and save the new item.

View of the data selected
In the views of the lists or document libraries you have a custom view of the row selected for this item

Download

Tool To Configure Lists and Document Libraries

This tool is a new version of the tool developed for SharePoint 2007 to configure only document libraries in SharePoint where you could select one or more and setting the versioning configurations, here you can see the tool.

The version 2.0 was created to configure lists and document libraries where you can select one or more of them. The actual version has available the “Versioning” section and I’m working in the 2.1 version that will have the “Advanced Options” section.

The tool has been developed in two languages, English and Spanish. It taking the language configuration from the portal setting configuration, and then you can change the language trough SharePoint interface.

The installation process is easy only need install a WSP and active a feature in the site where you want use the tool. In the image 1 you can see the new option added after that the feature was activated.

[Image 1]

Selecting the new option menu you can see the main page of the tool as you can see in the image 2.

[Image 2]

The tool has been developed consuming the new UI system of SharePoint 2010, as you can see in image 2 the errors or notifications are showing in the Ribbon.

You need select the site where are the lists or documents. When the lists were loaded in the right zone you need select each pressing “Add” to load it in the bottom section. The lists or documents that were adding the bottom zone are ready to configure as you can see in image 3.

[Image 3]

Once all elements that we want configure in the bottom zone, you need select the option in the command ribbon to open the configuration section as you can see in the image 4.

[Image 4]

Remember, use the tool in production environment is your responsibility, not mine.

Download

MVP again, 2011

This year I received the award from Microsoft, MVP (my profile). Thank you very much.

Q&A with the SharePoint MVP Experts

Please join us on Wednesday June 22 at 1:00 pm GMT-3 to chat with MVPs from around the world

MSDN Online Chats: http://msdn.microsoft.com/en-us/events/aa497438.aspx

Chat Room: http://www.microsoft.com/communities/chats/chatrooms/msdn.aspx

Q&A with the SharePoint MVP Experts

Please join us on Wednesday May 25th at 1:00 pm GMT-3 to chat with MVPs from around the world

MSDN Online Chats: http://msdn.microsoft.com/en-us/events/aa497438.aspx

Chat Room: http://www.microsoft.com/communities/chats/chatrooms/msdn.aspx

Internet Portal of Siderys in SharePoint 2010 online, Office 365 beta

Today we done the migration of our Internet Portal to the new Office 365 platform, over SharePoint 2010 online. We did a Master Page for SharePoint and we added some zones to add our WebParts. The work was very fast because "Office 365" has a fully SharePoint 2010 platform for us, it's great.

The best, is the capability to connect to our portal using SharePoint Designer 2010 to work there. It’s very important because in all developments of SharePoint is needed to add resources (images, CSS, JS and more) to create our design. Visit it here http://www.siderys.com/en/Pages/default.aspx

Tool to handle suggestions in search engine of SharePoint 2010

I’m back. I have been working with the search engine in a project few months ago and one of the functionalities that the customer wanted was the suggestions in the search engine. SharePoint 2010 added the suggestions in the search box in the portal as Google and other sites. The suggestions will be creating automatically using the searching in the portal and accessing to the result. When the users selected the same link several (more than 5 times) times, SharePoint saves the word used to search as "suggestion word" and one time per day (the default configuration of the job) runs the job "Prepare query suggestions" to put available all words or phrases saved. The only way to add more words to the suggestion feature is using a PowerShell script to add them and run the job manually or with the script. This tool was created to handle all words of suggestions in each Search Services Applications created in SharePoint 2010. Let's go to know the tool...
Once the WSP was installed in the central administration you can access to the tool in the menu "General Application Settings” as you can see in Image 1.

[Image 1]

In the section “General Application Settings” you can see the link (in the section “Siderys Tools”) to access the page created to administrate the suggestions. When you select it, you are going to the page, as you can see in image 2.

[Image 2]

In this page you have listed the suggestion to the default search service applications that was created in your SharePoint farm. The first thing that we are going to review is the ribbon commands created, as you can see in image 3.

[Image 3]

The first command “Search Applications Available” is used to select the “Search Service Application” where you are going to configure the suggestions. As you can see in image 4 this function will be opened in a modal popup of SharePoint 2010.

[Image 4]

In this new popup you must select one of the “search service applications” where you are going to configure yours suggestions words. In this example I’m using 2 search service applications created in my default search service in my farm. When you select one of them, the popup will be closed and your application will load the grid with the words saved.
The second command “Add new Suggestion” is used to add new words or phrases to the suggestion feature to the search services application selected. As you can see in image 5, function will be opened in another modal popup of SharePoint 2010.

[Image 5]

In this new popup, you need type the word or phrase that you want add and press the button “Ok” to confirm it. When you select the button, the popup will be closed and the word will be added in the suggestions and the component must reload all words.

The third command “Delete Suggestion” is used to delete a word or phrase in the suggestions, first, you need to select one of them using the button to the right in the grid as you can see in the image 6. After that you are going to press the option delete in the ribbon to delete the word. If you not select a word and press the button then you would see an error message in the ribbon as you can see in the image 7.

[Image 6]

[Image 7]

The last command “Run the Job” is used to run the job “Prepare query suggestions”. The job will be execute to the Search Service selected and will put all words available in the search box in the portal where the Search Service Application is configured (remember that the service applications are connected to the web application to use it) in the web application.

Ok, let’s go to use the suggestions in the search box in one of my portals. I have 2 portals created connected each with different Search Services Applications. In Image 8 you can see the suggestions listed for one of the services application and the image 9 the suggestions to the other services application.

[Image 8]

[Image 9]

Additionally the component notifies using the new system notifications incorporated by SharePoint 2010, as you can see in Image 10.

[Image 10]

To download the tool enters here.

Fabián Imaz

Siderys achieves Microsoft Competency "Independent Software Vendor (ISV)"

Siderys has achieved a new competition, "Independent Software Vendor (ISV) within the "Program for Microsoft business partners". Siderys adds a new recognition and is positioning itself as a market leader in the development of business solutions using Microsoft technology.

Tool to administrate thesaurus and replacements in SharePoint Server 2007

This tool can configure (create, edit or delete) synonyms and replacements in SharePoint 2007 and you can download from CodePex.
After to start I want to share with you some comments about the tool:

1) This tool is the first version, was tested in a small farm and installation with one server.

2) The UI as in English only but you can use in different languages.

3) The user logged must be an administrator because the tool will try stop and start the search services, “OSearch”.

4) Take care. The installation and use of this tool is your responsibility.

Once the tool was installed in the farm you need enter the Shared Services Provider, as we can see in image 1 and select the link “thesaurus”.

[Image 1]

In image 2 we can see the homepage, this page will be used to configure the synonyms in SharePoint 2007.

[Image 2]

The first thing to do is to understand how to work the thesaurus file in SharePoint 2007. In the following link Techent you can see a large description about this feature.
As you can see in the article, there are a lot of files, one for each language supported by SharePoint 2007. The tool will load the files by the language configured in the regional settings of the portal. For this example, we are going to work with the file “tsenu.xml” because my SSP is configured as “English USA”. In image 3 we can see all languages supported by the tool loaded in a selector.

[Image 3]

All files installed by SharePoint has an example commented. If you never change the original configuration the tool would be load this example.
The usability of the tool is simple. The first list will be used as administrative list “Name Synonym” and will be load with all synonyms registered in the file. If we want edit one of the synonym, we must select one of them in the first list and the second list “Synonyms” will be load with all words associated.
To create one synonym you can enter the word in the text box above the list “Name Synonym” and press the button (green icon) to save it. The tool loaded the new word in both lists and after we must enter the words of the synonym in the second list. For example, if we want to register synonyms to the term “Internet Explorer” we are going to do the following steps:

1) Add the term “Internet Explorer” in the first list.

2) Add “IE” in the second list

3) Add “IE7” in the second list

4) Add “IE8” in the second list

5) Add “IE9” in the second list

We are adding words (Synonyms) for the term “Internet Explorer”. This mean that when the user searching using one of the word added, the search engine will return result where there is some of these words in the index.
The tool asks you if you want to save the changes did in the configuration, as you can see in image 4. If you confirm the changes, the tool will save the file and restart the search services “OSearch”.

[Image 4]

When you confirm the changes, the tool show the operation page, as you can see in image 5 because as I commented before the services will be recycled.

[Image 5]

The last thing that you can do with the tool is add replacements words as we can see in image 6.

[Image 6]

In this page we must do the same task did in the synonym section. The first task is creating our replacement and after that adds the patterns and substitutions terms. In article of TechNet you can see a large description about the replacement feature of search engine of SharePoint 2007.
Basically, this feature is used to create a terms of substitutions for one or more words “pattern”. For example, you have technical words in the content of the index, as “WinNT”, “Win2k” y “Win7” but the users don’t know it and we want to add other search terms (substitution word) to be used by the user. We must do the following steps:

1) Add “Windows” in the list pattern

2) Add “Windows Server” in the list pattern

3) Add “Windows 7” in the list pattern

The next steps are:

1) Add “WinNT” in the list substitution

2) Add “Win2k” in the list substitution

3) Add “Win7” in the list substitution

Once the change was saved and recycled the service, the user could search using the term “Windows”. The search engine returns all contents that have some of the words added in the substitution list.
To install the tool you must edit the .bat file and change the URL of the Shared Service Provider of SharePoint Server 2007..

To download the tool enters here.

In the next month this tool are available to SharePoint 2010.

Fabián Imaz