27 November 2014

International Travellers Reward To Öland, The Home Of

Kate Kalmstrom has its headquarters on an island just off the Swedish sound-eastern coast: Öland.

My parents, Kate and Sigge, also have their permanent home here, so I will let Kate tell you more about Öland and the international reward recently given to "our" island.
Spring photo from Öland
Top 30 Islands in the World
Among all islands in the world, the well-known American travel magazine Condé Nast Traveler has chosen 30 that they especially recommend for a visit. I am amazed that our little island so far from the U.S. has been included in the list as number 20, right after the Maldives.

Öland is a paradise for the Kalmström family, but before learning about this reward I did not understand its international attraction.
Gettlinge grave-field
This is the Condé Nast Traveler motivation for recommending Öland as a premier island to visit.

Guard at Borgholm Castle "A vacation spot for Sweden’s royal family, this island in the Baltic Sea is a popular summer getaway for commoners, too. Here you’ll find pretty beaches, dramatic limestone outcroppings, fairy-tale forests, and hundreds of antique windmills. The whole southern portion of the island is a UNESCO World Heritage Site thanks to its well-preserved farming settlement.

Pro tip: Öland is brimming with historical sites, from the prehistoric standing stones at Gettlinge to the medieval ring fort of Eketorp. There’s also Borgholms slott, the ruins of a 12th-century castle ravaged by a 19th-century fire.

Getting there: Just off of mainland Sweden, the island is accessible by car or bus via the Öland Bridge."

More info about Öland
I could write a book about our beloved island, but instead I will finish this post with a few tips on further information about Öland. Wikipedia of course has an article, and the Öland tourist authorities have a site in English. If you search this blog for Öland or Oland, I am sure you will find some additional information too!
Adonis and windmill
Swedish grammar site
For many years I was a teacher of Swedish for immigrants, and I have written textbooks about my subject. These books were the base when the team created a website with rules and guidelines for Swedish grammar and word formation.

The grammar site has many pages, and there is a photo from a Swedish landscape on each of them. Not all of the photos are from Öland, but many are! You can also find some of the photos accompanied by Swedish music on the Swedish grammar playlist on YouTube.
Oland Swans
Öland seasons
The very best is of course to visit Öland! And if you visit several times it will never be the same, because Öland has something that most of the other island on the list do not have: distinct seasons.

The spring is beautiful with a multitude of wild flowers, and the autumn is mild thanks to the surrounding sea.

Oland winter photo The Öland summer is sunny, hectic and crowded, and if you like that you should come in July.

Or do you want solitude? Why not visit Öland in the winter and experience its hash and windy wildness?

Each season has its own magic on the island where we have the privilege to live and work.

Kate Kalmström
Sales and Marketing
Business Solutions

25 November 2014

SP Archive Handles SharePoint Survey Lists

SP Archive for SharePoint logotypeLast week we published a new SharePoint solution for customized archiving. We call it SP Archive, and it handles all kinds of SharePoint lists – including surveys.

SharePoint Survey
A SharePoint survey list enables you to create multiple choice, fill-in fields or rating questions that you want other team members to answer. The answers are of course given in the same list, and the survey list also helps you summarize the results.
SharePoint Survey app

SharePoint list limit
Surveys can be very useful, and often you want to store the results so that it is possible to review them later. However, the SharePoint list view limit of 5000 rows will eventually give you problems if you keep the data in SharePoint. The best option is to archive the surveys in a database.

Survey archive problem solved
Most lists can be archived to an Access database directly from SharePoint, but you cannot do that with surveys. SP Archive solves that issue, as the Solution can archive SharePoint surveys in the same way as all other lists.

Database choice
SP Archive gives a choice of Access and SQL Server database, which is an advantage even for lists where export to Access is possible. For big organizations with much data, the more powerful SQL Server database is a better option than Access.

SharePoint Archiving to Access or SQL Server database

Column choice
Another benefit of  SP Archive is the selection possibilities. This means that you can decide what parts of the list you want to archive. Maybe you don't need to keep all columns in the survey?

Subscribe subscription iconSP Archive is free for organizations who are already subscribing to a SharePoint Solution: HelpDesk OSP for Outlook and SharePoint, Kanban Task Manager for SharePoint or TimeCard for SharePoint. And if you are not a Subscriber already, you are welcome to subscribe to only SP Archive.

Try SP Archive download iconBut first you should try SP Archive. We allow a 30 days evaluation of the full product, and when you decide to use SP Archive no re-installation or re-configuration is necessary. You can just subscribe to SP Archive, register it and continue archiving SharePoint surveys and any other SharePoint lists.

Peter Kalmstrom
CEO and Systems Designer Business Solutions

20 November 2014

SharePoint Solution For Customized Archiving Released

SP Archive for SharePoint logotypeToday we have released a new SharePoint Solution – SP Archive. The application lets organizations archive SharePoint data in a customized way, to avoid problems with SharePoint list items limits, and as SP Archive saves the list items to a database it is also suitable for backup.

Jitu Patidar Senior Developer Jitu Patidar is our guest blogger today. He has been responsible for the development of SP Archive, and he will tell more about our new Solution.

Problem: SharePoint list limits
SharePoint lists have a limit of 5000 rows. When you exceed the list limit you will have problems, so some kind of archiving is necessary. That is why we have developed SP Archive. We wanted to give users of SharePoint Solutions a better archiving option than the workflow we had offered earlier.

Solution: Archive to database
When it comes to archiving, a database has considerable advantages to a SharePoint site. Databases are built to handle many items, while SharePoint in the first place is built for sharing.
SP Archive database choice
Because of the database benefits we decided to let the first version of our new Solution archive to Microsoft Access or SQL Server. Next version of SP Archive will give a possibility to archive to SharePoint lists also, for those who prefer that.

Customized Archiving
From the start we decided that SP Archive must let users decide exactly what items and fields should be archived, and the selection must be easy to make and change. We also wanted to give the possibility to use several databases with SP Archive, for example different databases for different lists or SharePoint sites.

We created a Settings dialog, where SharePoint sites and lists are added to SP Archive and an Archiving dialog where users select first SharePoint list, then fields and finally items to archive. The selection of items is simplified by numerous filtering options.

Excel reports
Excel 2013 iconWhen the selection is done, there is a possibility to export the selected items and fields to an Excel sheet. It gives a quick overview of the data you have exported. Attachments can be included in the archiving to the database, but they are not included in the Excel export.

Archive or backup
When you archive old or unused SharePoint list items to a database you probably don't want to keep them in SharePoint, because of the 5000 items list limit. But we have not developed SP Archive to automatically remove the archived items from SharePoint. Instead we give the option to either remove the items or keep them in SharePoint, and that way SP Archive may be used for backup of SharePoint list items too.

SP Archive remembers
We think people often want to archive items from the same list in the same way, and therefore we have made SP Archive remember the field selection and filter option choice. This way the archiving or backup will be very quick after the first time.

Small team
SP Archive is a comparatively small-scale solution, so we have only been two developers working actively with the development. Junior Developer Ankit Raghuvansi made much of the actual coding under my supervision. But the whole team has studied SP Archive, and their comments and enhancement suggestions have been very valuable. Thank you all!Kanban Task Manager for SharePoint logotype

Subscribe or get for free
If your organization already subscribe to a SharePoint solution, you don't have to start a new, separate subscription to SP Archive. HelpDesk OSP icon From today SP Archive will be included in your current subscription, so please contact us and we will send you a key.

Should your organization not be using a SharePoint Solution yet, TimeCard icon you are welcome to subscribe to SP Archive. Because even if we developed SP Archive for our subscribers, this solution is beneficial to all SharePoint users!

Try SP Archive! download icon Whether you are a Community Member or not, you are very welcome to download SP Archive and evaluate the solution for 30 days without any obligations. If you have questions, I am here to assist you together with my colleagues in the Support team.

Jitu Patidar
Senior Developer Business Solutions