The Rothline Perspective

Using the document library in SharePoint 2010

Apr 252012

The SharePoint 2010 document library in Microsoft Office365 is essentially a sophisticated Windows file folder.

In addition to being storage for documents the document library features include collaboration, check in/out, personalization, workflows, user permissions, and version history audit trails.

Similar to the Windows file folder the document library can hold various file types. The document library can and does block some file types for safety. The list of blocked file types can be modified in Central Administration but caution is strongly recommended.

Briefly, the procedure for using the SharePoint 2010 document library begins with Libraries in the left side navigation of SharePoint 2010. Left click on the link for Libraries.

Left click on the link for Libraries

The Libraries page will open. Next left click on Create.

Left click on Create

The Create dialog box appears. In the left side navigation under the heading of All Types left-click on Library.

The Create dialog box appears

Multiple icons will appear representing different types of a Library. In this example Document Library is selected.

The Library Options

Click on the More Options button to open the Name and Descrition page.

The Name and Description Page

In this example the document library is named DVD Collection and the Description is DVD Collection.

Provide a Name and Description

A Yes or No option is provided for Navigation. Select Yes to have a link appear in the left side navigation in SharePoint 2010 for the document library or select No to have no link.

A Yes or No option is provided for the Document Version History. Select Yes to have an audit trail of document changes or select No to not have the audit trail.

Document Template

Select an option from a drop down menu regarding the default document preference. If none then select None.

Click the Create button. Wait for processing and a moment later the document library is completed and ready for use.

The Document Library Appears

The Tasks List in SharePoint 2010

SharePoint No Responses »

Apr 182012

Office365 uses Microsoft SharePoint 2010.

The Tasks list provides a solution for teams that need to monitor and track important tasks.

Emails are automatically sent to assigned members when tasks are added, edited, or updated.

Tasks lists can be connected to Microsoft Outlook.

To create a Tasks list, click on the link in SharePoint that opens and displays the Lists page.

Click on the Create icon.

Select the Tasks List button.

Click the more options button.

Type a Name and a Description for the Tasks list.

Click on Create. Wait a moment for this to process.

The newly created Tasks list appears.

Using the Announcements List in SharePoint on Office365

SharePoint No Responses »

Apr 112012

Teams often need timely reports about organizational activities, events, and news.

The template for the Announcements List in SharePoint on Office365 can be used to deliver those reports.

The template is like a cookie cutter that is easily customized to meet the specific needs of a team.

The template for the Announcement List contains these columns:

Title
Body
Expires
Created By
Modified By

Title is a single line of text and is required. However, Title can be renamed.

Body is a multiple line of text.

Expires hold date and time information.

Created By and Modified By are Lookup lists that monitor which users created or modified an announcement.

Columns can be added or deleted as needed for the team.

4 elements a database developer already knows about SharePoint

SharePoint No Responses »

Apr 102012

SharePoint has become my new application obsession.

I have experience in database development: Microsoft Access, SQL Server, and MySQL.

I first started learning SharePoint 2007, moved to 2010, and I am currently using Office365, which contains SharePoint, Exchange, and Lync.

Anyway, for those of you who have a background in database development here are the four elements that you already know about SharePoint.

1. List

The List element in SharePoint is similar to the Table in a database. The List contains elements just like a table, but with some different names and features.

2. Items

Items in SharePoint are called records in a database Table. An item is one record (also called a row) of data.

3. Columns

A Column in SharePoint is called a field in a database. These Columns also have types similar to the Data Types in a database: text, number, currency, datetime, etc.

4. Views

Views are Views in SharePoint and SQL Server, but they are called Queries in Microsoft Access. Same basic concept, though. Views are used to filter data and to drill-down to data needed to make a report.

If you like working with databases, then you’ll like working with SharePoint.

I’ve read the book Beginning SharePoint 2010: Building Business Solutions with SharePoint and I have found this book to be a great resource for learning SharePoint Administration.

Web and warehouse work at Sunbelt Sports Sales

Portfolio No Responses »

Nov 282011

Sunbelt Sports Sales is now Bedlam Sports.

However, when I was employed there from May 2004 through April 2006 it was still Sunbelt Sports Sales.

While employed at Sunbelt Sports Sales I was assigned to transition the website from a static HTML site to a dynamic database driven site.

The static Sunbelt Sports site

I made a copy of the website and with that copy I determined which HTML tags contained the product information needed for a database.

Using find and replace in Notepad and then later Dreamweaver I transitioned the website copy into a large table with rows, columns, and table headings.

By running the website copy on a local machince I was able to copy and paste the values into an Excel spreadsheet.

Some minor corrections were made to the spreadsheet and then it was imported into an Access Database.

Once in a database the ASP code was written to retrieve and display the product information.

The dynamic Sunbelt Sports site

I designed and developed a Sunbelt BackOffice System that was used for inventory control.

As products were sold online the quanity of that product would be decremented from inventory.

As products arrived in the warehouse the staff could add the new amount into the system.

Anytime a product reached a quantity of zero it automatically stopped displaying on the website.

I also worked with the warehouse personnel to organize and mark shelf locations for staff to easily locate products still in the warehouse.

This system helped the company identify which products sold often and which did not, so that the purchasing department could adjust orders.

Website design for White Buffalo Environmental

Portfolio No Responses »

Nov 282011

White Buffalo Environmental, Inc.

When I learned that the President of White Buffalo Environmental, Inc. wanted to have a prescence on the Internet I submitted an application and a resume.

I was hired and began work in April of 2006.

Until the domain WhiteBuffalo.com became available the company used WbeWeb.com.

The first website was designed and developed with Dreamweaver.

The Green color scheme has remained the same throughout the various versions.

The new logo was designed by by a third party and incorporated into the website design.

Rainwater story concept: Chapter 5 The Driver of Death

Fiction No Responses »

Sep 052011

Rainwater Chapter 5 Index Card Summary

This post is continued from Rainwater story concept: Chapter 4 The Last Frontier.

In this chapter, like many action and spy movies, the hero is chauffeured by a driver that is really an assasain hired to kill the hero.

This version shows the hero wearing glasses that has a GPS system. Rainwater can monitor where the driver is headed. This concept would have seemed far fetched a couple of decades ago.

Today, eyeglasses with GPS is not only plausible it’s already been invented. Japan informed that a prototpe was developed in 2010.

: Rainwater Chapter 5 Card 1

: Rainwater Chapter 5 Card 2

: Rainwater Chapter 5 Card 3

: Rainwater Chapter 5 Card 4

: Rainwater Chapter 5 Card 5

Rainwater story concept: Chapter 4 The Last Frontier

Fiction No Responses »

Aug 112011

This post is continued from Rainwater story concept: Chapter 3 The Assignment.

Rainwater Chapter 4 Description

In chapter three Rainwater received his investigation orders.

In chapter four Rainwater returns to his hotel room to gather his belongings and to checkout.

Bailee who appeared in chapter two is waiting for Rainwater to return. Bailee is a major character who will also appear in later chapters in the story.

Chapter four demonstrates that there is a romantic relationship between Rainwater and Bailee.

She has stripped down and wrapped a bear rug around her naked body.

When Rainwater enters the room she asks, “You’re not thinking of leaving before exploring the last frontier, are ya?”

Rainwater Chapter 4 Index Card 1

The Last Frontier is the state nickname of Alaska.

Rainwater responds, “No, I wouldn’t dream of leaving without first exploring.”

Rainwater Chapter 4 Index Card 2

Rainwater Chapter 4 Index Card 3

Movie Review: Rise of the Planet of the Apes

Movies No Responses »

Aug 052011

I give Rise of the Planet of the Apes a solid B.

After the miserable failure of the re-imagined Planet of the Apes in 2001 there was a lot at stake with attempting to reboot the beloved and classic Planet of the Apes franchise.

The movie Rise of the Planet of the Apes is not perfect, but in the Hollywood-infected world of reboots and remakes this movie is decent.

The proposed Return to the Planet of Apes would have been my preference. I prefer sequels over prequels, reboots, remakes, and reimaginings but one takes what one can get from the new Hollywood.

However, Rise is a smart and comprehensive story that covers a lot a ground. In two hours the story goes from being about a baby chimp being raised in a human home to an all out ape rebellion against human masters.

There are subtle and not so subtle tributes to the original 1968 film and a cameo by the late Charlton Heston.

In the original movie the character George Taylor, played by Charlton Heston, was caught in a world ruled by apes. Rise presents Caesar, an intelligent ape, that is betrayed and mistreated by human masters.

The best thing about this movie is the apes. They actually look like apes.

Rainwater story concept: Chapter 3 The Assignment

Fiction No Responses »

Aug 042011

This post is continued from Rainwater story concept: Chapter 2 Borealis Beach Club.

In chapter three Rainwater receives his investigation orders.

Rainwater Chapter 3 Index Card Summary

Rainwater received a text message telling him to go outside and get in a communications car.

Rainwater walks outside. A man yells to him, “Get in.”

Rainwater gets in the backseat and sits next to the man that yelled for him.

The man hands him an iPad.

Rainwater’s boss appears on the screen.

“You’re packed for a trip to Uganda,” the boss informs.

Rainwater Chapter 3 Index Card 1

The boss also explains that the assignment is to investigate a potential hate crime. Images of the crime scene and Hogan’s dead mutilated body began to appear on the iPad screen.

The boss explains that the first openly gay Senator from Oklahoma has been murdered.

“Investigating the death of a queer Senator. Are you serious?” Rainwater responds.

This statement by Rainwater is provided to show that he is not a bleeding heart liberal. Later the story will demonstrate that Rainwater is not a bloodless heart conservative either. Rainwater’s views are middle of the road. He neither approves nor disapproves of homosexuality nor gay marriage.

Rainwater Chapter 3 Index Card 2

The boss says, “The Cold War is over and Osama Bin Laden is dead. So investigate what we have to investigate.”

This line reflects the line that has been used in some TV and movies. “The cold war is over,” is often stated as a reason we Americans are doing something different in a TV or movie. I’ve added the phrase, “and Osama Bin Laden is dead” to reflect the newest change in American foreign events.

Rainwater Chapter 3 Index Card 3

Rainwater Chapter 3 Index Card 4

Rainwater Chapter 3 Index Card 5

Older Entries

The Rothline Perspective

Using the document library in SharePoint 2010

The Tasks List in SharePoint 2010

Using the Announcements List in SharePoint on Office365

4 elements a database developer already knows about SharePoint

Web and warehouse work at Sunbelt Sports Sales

Website design for White Buffalo Environmental

Rainwater story concept: Chapter 5 The Driver of Death

Rainwater story concept: Chapter 4 The Last Frontier

Movie Review: Rise of the Planet of the Apes

Rainwater story concept: Chapter 3 The Assignment

Categories

Archives

Links

Meta