Tuesday, February 28, 2012

The symbolic meaning of seventy times seven

I was looking for the meaning of the following scripture:
Matthew 18:21-22 (NKJV) - Then Peter came to Him and said, "Lord, how often shall my brother sin against me, and I forgive him? Up to seven times?" Jesus said to him, "I do not say to you, up to seven times, but up to seventy times seven.

The interesting thing about this verse is that Jesus is not saying that we should forgive 490 times or simply a lot of times for that matter. I came to understand recently that there is a very specific meaning when we look behind the symbolism of those numbers.

In the Bible, the number "7" symbolises completeness or a finished work, while the number "70" signifies 'perfect spiritual order carried out with all spiritual power and significance' (E.W.Bullinger, Number in Scripture, Its Supernatural Design and Spiritual Significance, 1921, p.235).

Therefore, 490, being the product of 70 x 7, signifies spiritual perfection of perfect order and completeness. Peter asked Jesus how often he should forgive someone and eagerly offered an answer to his own question. He thought that forgiving completely would suffice. But Jesus responded by saying that it wasn't good enough to just forgive completely but to forgive to the point of spiritual perfection!

Footnote:
http://www.biblebelievers.org.au/number17.htm#70

Tuesday, February 07, 2012

AutoNumbering in InfoPath forms when submitted to a SharePoint Library

You can accomplish this functionality as follows:





  1. In SharePoint, create a form library to submit your forms to.


  2. In InfoPath, create a new (browser-compatible) InfoPath form template.


  3. Add a Text Box control to the form template and name it autonumber.


  4. On the Tools menu, click Data Connections.


  5. On the Data Connections dialog box, click Add, and create a Receive data connection to the SharePoint library that you created in step 1. In step 5 of the data connection wizard, uncheck all fields and then check the ID field. In the last step of the data connection wizard, uncheck Automatically retrieve data when form is opened, name the data connection RetrieveIDs, and click Finish.


  6. On the Data Connections dialog box, click Add, and create a Submit data connection to the SharePoint library that you created in step 1. In step 3 of the data connection wizard, click the formula button behind the File name field.


  7. On the Insert Formula dialog box, type max( and then click Insert Field or Group.


  8. On the Select a Field or Group dialog box, select RetrieveIDs from the Data source drop-down list box, expand all the nodes, click ID, and then click OK.


  9. On the Insert Formula dialog box, type ) + 1 and click OK.


  10. On the Data Connection Wizard dialog box, the expression in the File name field should resemble: max(@ID) + 1


  11. On the Data Connection Wizard dialog box, click Next, name the data connection Main submit, and then click Finish.


  12. On the Data Connections dialog box, click Close.


  13. On the Tools menu, click Submit Options.


  14. On the Submit Options dialog box, check the Allow users to submit this form checkbox, select the Perform custom actions using rules option, click Advanced, select Close the form from the After submit drop-down list box, and then click Rules.


  15. On the Rules dialog box, click Add.


  16. On the Rule dialog box, add an Action that says: Query using data connection: RetrieveIDs


  17. On the Rule dialog box, add a second Action that says: Set a field's value: autonumber = max(@ID) + 1 Note: @ID is selected from the RetrieveIDs secondary data source in the same way you selected it in step 8.


  18. On the Rule dialog box, add a third Action that says: Submit using data connection: Main submit


  19. Click OK when closing all dialog boxes that are currently open.


  20. Publish the form template to the library you created in step 1.



You should now be able to fill out a form and submit it. The next available number in the form library will be automatically saved in the autonumber field of the form when the form is submitted and this number will also be used for the Name of the form. This solution works for both forms that are filled out through the InfoPath client application as well as those that are filled out through the browser.

Sunday, January 15, 2012

The Pledge (2001)

I stayed up late watching a suspense detective story directed by Sean Penn and had been released on film last 2001, that will be roughly 11 years ago. I was enticed by the story wanting to know who the killer of all those 8-year old girls killed across the surrounding places. I was also drawn by an all star cast of characters, Jack Nicholson, Benicio del Torro, Helen Mirren, Aaron Eckhart, Sam Sheppard, Robin Wright Penn, etc. It was a good movie but at the end, I never got the chance to see who the killer was which still leaves a big question mark in my head. This is really a good mind-boggling movie.

Synopsis:
It started with a discovery of the body of an 8-year old girl named Ginny in the snow by a boy who had his snow mobile malfunctioned. He saw a man leaving the area, scared and in a hurry. Jerry (Jack Nicholson) is a detective nearing his retirement. He only got a few days left from his office when this case struck him. When they informed the parents of the girl about the misfortune, the mother was devastated by the news. Jerry uttered his comforting words to the mother that he will find the killer, and he was asked to swear on the cross which he did. Meanwhile the police caught up the guy who was seen rushing to leave the scene of the crime. He was an American Indian guy who has a brain of a child and mentally incapacitated. Jerry’s partner (Aaron Eckhart), immediately spurs out a confession from the guy and whilst taking him on the cell, he grabbed the gun of the arresting officer and shoots himself. Everybody thought that the case is closed except for Jerry who is noticing something is not right. He investigates further and found out that there are two unsolved cases from the neighbouring towns that are suspiciously similar to his own. Further inquiries reached an older woman who had led him to the grandmother of the girl. He saw the dead girl’s drawing which depicts a tall man handling little porcupines and a black station wagon to which he kept as evidence. He had presented his findings to his colleagues to which they rebut. Jerry was too smart to realize that his colleagues may have him committed to investigate case. So he appears to be living a life of an old retired man. He calculated the place where the killer might struck again. He rented a cabin near the lake. When he saw an old gas station, he offered the owner an opportunity to sell it to him which he eventually gained. So he lived on the house at the back of the gas station and tends to the business as should be. He met and befriends a not-so-lucky-in-love waitress named Lory (Robin Wright Penn) in the restaurant bar. She had an 8-year-old daughter named Chrissy. When the waitress was battered by her husband, she sought comfort from Jerry. In turn, Jerry took them in his house with no commitments. Soon after, he had grown affection on Chrissy and Lori noticed it so she fell in love with him eventually. They had lived a good life but Jerry is still adamant to catch the killer so she warned Chrissy to tell him when she got the chance to meet the tall guy from Ginny’s drawing. One day, Chrissy revealed to Jerry that he had encountered the guy and he even gave him porcupine-like chocolates. The man told her not to tell her parents about the encounter but since Jerry is not related to her, she thought it would be OK without breaking her promise. Jerry immediately knew that this is the guy. Chrissy even asked Jerry if she could meet her on the big playground which he agrees as he was planning to catch the guy by using the girl as bait without the mother knowing all about it. Jerry immediately contacted his colleagues and they followed Chrissy on the big playground as she waits for the man in patient. The team is getting impatient as they wait for the killer and Jerry sense that something is not right again. They had their altercations on the situation to which they left Jerry to look after the girl instead and wait for the killer to show up. Meanwhile, the killer who was riding the black station wagon with a porcupine on the car mirror has all the intention to see and meet Chrissy but was caught by a car accident and burnt to death. Jerry’s team had run into the accident but the car and the person inside are beyond recognisable. When the mother learned Jerry is using the girl as bait to catch the killer, she got so furious and left him for good. Jerry lost his mind as what he thought as a perfect plan to catch the culprit has made him lost his good life. He never learned the mishap the killer had gone through.

Tuesday, January 10, 2012

Copying or Moving SharePoint Lists

Here are some helpful tips on how to copy or move SharePoint lists in MOSS 2007. There are two ways to accomplish this:


  1. By using list templates - This is only possible when you meet the following criteria: a) if the data you want to move/copy is less than 10MB; b) You must be a member of a site group with the Manage Lists right on the source site and on the destination site; and c:) The source site and the destination site must be based on the same site template

  2. By exporting a list to a spreadsheet

Copy or move a list by using a list template

First things first, make sure that the size of the list (if you will import the data as well) must not exceed 10MB, use the Site Settings > Site Administration > View Storage Space Allocations and filter with Document lists to check and locate the target list.

To create a list template, go to Documents and Lists and select the list. On the list, select Settings > List Settings and under Permissions and Management click on "Save list as template". Give it a name (filename and template name). Select the Include content check box to include the data. Hit OK. This will appear in your site collection list template gallery.

To view the site collection list template gallery, click on Site Actions > Site Settings > Modify All Site Settings. Under Galleries, select list templates.

If your sites are not in the same site collection, download the list template from the source site by clicking on the list and saving it on a network drive.

On the destination site open the list template gallery on the target site collection. In that page, click on upload and search for the list template you have saved earlier on a network drive.

To create a copy of the list, on the destination web site, click on Site Actions > Site Settings > Modify All Site Settings, under Site Administration click on Site libraries and lists. On that page select "Create New Content" and look for the list under Custom Lists.

For more information, please visit:
http://office.microsoft.com/en-us/windows-sharepoint-services-help/copying-or-moving-sharepoint-lists-HA001154562.aspx

Sunday, January 08, 2012

SharePoint Custom List with Custom Content Types and Custom Display Forms

I got stuck with having multiple content types having custom forms. I could not bind the content types other than the default one. I came accross with a solution on the internet which I would like to add here on my post for future reference (but I am hoping Microsoft will rectify this bug on their end):

http://joshmccarty.com/2011/02/sharepoint-custom-list-with-custom-content-types-and-custom-display-forms/comment-page-1/#comment-1166

The trick is to make the other content types as default before binding them in the list properties - supporting file. A cumbersome work but it paid off.

Thursday, January 05, 2012

SharePoint - The column name you have entered is already in use or reserved. Choose another name

When you’re creating columns either the Site Columns or the List Columns in SharePoint, suddenly it might show a message stating “The column name that you entered is already in use or reserved. Choose another name.” Here is the fix for this issue.

1. Goto Site Actions > Site Settings > Modify All Site Settings
2. Under Galleries, choose Site Content Type
3. Select the content type and choose the column
4. Edit the column in new window
5. On your browser address bar, type the following and enter:
javascript:g_FieldName={};alert('Successfully cleared forbidden columns');
6. Be sure you get the 'Successfully cleared forbidden columns' alert before proceeding, if not then something is wrong.
7. Change the column name and Hit OK

I sort of got frustrated with this as I could not return back the column name to its original settings but then thanks to this article as I was relieved from any trouble.

http://blog.weareon.net/fix-for-the-column-name-that-you-entered-is-already-in-use-or-reserved-choose-another-name/

Monday, January 02, 2012

Consider this scenarion in SharePoint webpart:
"An unexpected error occured"

To work around this issue, use one of the following methods:

Recover the broken Web site. To do this, use one of the following methods:
1. Access the Web Part Page Maintenance Web page by adding the ?contents=1 query parameter to the Windows SharePoint Services site URL. Verify the Web Part, and then click Delete or Close to remove the Web Part.
2. Visit the page library for the Windows SharePoint Services site. Typically, the URL for the page library is as follows:
http://SiteName/pages/forms/allitems.aspxOn the menu of the affected Web page, click Discard check out item, and then click Delete or Close.
3. Open the Windows SharePoint Services Web site by using SharePoint Designer. On the menu of the affected Web page, select the Web part, click Discard check out item, and then click Delete or Close.