Challenge:
Create a form in InfoPath 2007 and implement a SharePoint Workflow to it for approval processes. In each step, a Status field in the InfoPat form should be updated automatically according to the change of workflow task status. So a different view in the InfoPath can be opened based on the Status field in the form.
But after the InfoPath was published to the SharePoint (MOSS 2007 with InfoPath Form Services turned on) as Document Library and Content type, the Status field could not be displayed when “Set Field value in Current item” action was selected in the workflow design. Even it was promoted to be available in the SharePoint document library.
Continue reading ‘How to pass InfoPath form fields to SharePoint workflow but hide from Document Library item properties’
Related posts
Challenge:
As I indicated in my previous post, I needed to rename thousands Microsoft Word documents based on the updated old/new catalog ID pairs.
But that was just one part of my requirement. Since these Word DOC files have the old catalog IDs inside the content which need to be updated with new IDs as well. The methods of my previous post could only resolve the file name part but not the contents.
Unsuccessful trials
I started with some existing utilities I found on the Internet but they were not working as I hoped.
1), I tried the Useful File Utility along with its free plug-in “Batch Replacer for MS Word” (Useful File Utility is a shareware which can allow you to use 15 times for free, then $29 for a single user license). It looks promising as it indicated on its web page, but it failed on me with too many un-successful replaces in a few hundreds files.
2), I was impressed with this VBA macro I found on Internet named VBA Find and Replace. But it could not work well with the Find and Replace text list. I always get an error saying my name list is not valid.
After one night’s trying, I decided to write my own script to handle such automate job.
Continue reading ‘How to auto find and replace text in bulk Word files and save convert to other format with script’
Related posts
Challenge:
We have a few hundreds Microsoft Word documents with old catalog names as their file names. We need to rename them with these new catalog ID as their new file name. Good thing is that we already have these old/new catalog name pairs in an Excel worksheet.
To save the time of manually changing all file names, we come up two solutions/approaches to automate the process.
Continue reading ‘How to rename thousands Word documents file name in bulk based on an Excel list’
Related posts
I have never tried installing Ubuntu on the Microsoft Virtual PC before, I did successfully on VM ware though. If you don’t know what Ubuntu is, please Google it, basically it is a Linux operating system with pretty desktop features. In the Thanksgiving holiday, I used my DELL Dimension 4600i (Windows XP sp3) to explore this option which turned out a good experiment, even Microsoft officially says its Virtual PC does not support Ubuntu.
The following is what I used to install Ubuntu.
Virtual PC 2007, (get it here).
Ubuntu iso image, (get it here).
Continue reading ‘Install Ubuntu 9.10 on Microsoft Virtual PC 2007′
Related posts
Two weeks ago, my system disk toasted (damn western digital, got two hard disk failed from you) and I had to re-install the Windows XP on another spare hard disk to bring my computer life back. Glad I had my data on a different hard disk and backed-up everything to the external disk every week.
During the re-installation process, I thought it would be better if I record every application I had to install first to be productive and enjoyable before I sit down to do anything else. And, inspirited by the post from lifehack.org The first 10 free Apps to install on a new Windows PC, I decided to write this post.
Continue reading ‘Re-install these 20 free applications (categories) on my new Windows XP system’
Related posts
As I mentioned in my previous post Fixed the Outlook 2007 …issue, I would have to remove one of my .pst file to make the new upgraded Outlook 2007 run smoothly. But I really need the emails in that pst file.
So after my Outlook finally settled down, I tried to add that .pst file back to my Outlook 2007. But every time when I did the “Add new Data File…” from the Outlook 2007, the crash occurred again. And when I used the Control Panel — Mail option, I would have the following error message:
RUNDLL
An exception occurred wile trying to run "C:\WINDOWS\system32\shell32.dll,Control_RunDLL "C:\PROGRA~1\MICROS~2\Office12\MLCFG32.CPL",@0"
Continue reading ‘How to get back the troubled .pst file to Outlook 2007′
Related posts
As any other web site administrators, I care much about the site visit statistics and other marketing data from the web site visiting log. I used DeepMetrix LiveStats a few years ago, then upgraded to DeepMetrix .NET 8. But later the company DeepMetrix dropped the support on its products after Microsoft bought it. From there, I tried the online tools like Google Analytics including the Microsoft one based on DeepMetrix – Microsoft Ad-Central. They are good enough for my general use, but I still want a website log stats tool installed locally.
So I re-installed DeepMetrix older version of LiveStats 6.2 and newer one .NET 8. But the stupid DeepMetrix .NET only works for the Data Collection part, not the reporting part. And the LiveStats 6.2 was working fine before, and now it totally stopped working after the license domain name deepmetrix.com was gone.
Finally, I had a reason to stop trying, testing and wasting time on DeepMetrix. I moved on and decided to use AWStats which is a free open-source web log analyzer tool.
At first, I still had the concern about the disadvantage of parsing the log files vs. the site tracking scripts. But since I still can use the DeepMetrix Data Collection part, then I can use the AWStats tool to parse the pre-processed log files from DeepMetrix instead of the raw log files from IIS.
Continue reading ‘How to re-use DeepMetrix Livestats NET pre-processed log files for AWStats’
Related posts
This post is an updated to the previous post of mine about the Task List item manipulations. Apparently the method I described in the previous post works only for different task lists, not for the sub-folders which belong to the same task list moved from.
When I tried to move the list items into a sub-folder inside the same task list on Manage Content and Structure page, and got the error below
“An error was encountered performing this operation.
Attempt to move url(s): http://site/Lists/Tasks/1_.000; failed. Please try again
Continue reading ‘[Updated] How to move task list item into sub-folders on sharepoint’
Related posts
If you are hosting a SharePoint server on your own network within the same domain, you should be able to log onto the SharePoint team sites with your Windows credentials automatically in IE (Internet Explorer).
If not, just like it happened on some of my co-workers recently. The IE will ask you to enter Domain User Name and password whenever you hit the SharePoint team site or download documents from the SharePoint server. If you did not provide the correct logon credential, your IE browser screen will show the followings:
You are not authorized to view this page
You do not have permission to view this directory or page using the credentials that you supplied because your Web browser is sending a WWW-Authenticate header field that the Web server is not configured to accept.
Please try the following:
- Contact the Web site administrator if you believe you should be able to view this directory or page.
- Click the Refresh button to try again with different credentials.
HTTP Error 401.2 – Unauthorized: Access is denied due to server configuration.
That means the IE did not pass the user’s windows log in credentials automatically to the SharePoint sites based on the IE’s security settings.
Continue reading ‘How to log onto SharePoint server in IE and Firefox automatically without being asked Username and Password’
Related posts
Not like Document Library, the list in SharePoint does not have a Windows Explorer View which can allow you to easily move items around. This happened on me when i tried to move some created Task (action register) item to these newly added sub-folders. I could not easily found a way to do the moving like I did in other document library.
Almost gave up and tried to re-created all task items in the sub folders, i found out there is a work-around if you are the administrative on this SharePoint site.
Here is the How-to:
- Move mouse over to Site Actions.
- And click the Manage Site Content and Structure.
- On the Site Content and Structure window, you will see web page divided into two parts. The left part will have a tree-view of your site, and the right part will have item views. Now you start from the left side by expanding tree nodes and highlight the list document library you need to work on, and then you can:
- a. find each item you need to move, and click the drop down menu of each list item title, and select Move to…;
b. Or if you need to move multiple items, you can check the check boxes of each item, and click Actions menu and select Move… option.
- A new window will be opened, and you can choose the new destination from there.
Good luck.
Related posts
I have a hard disk with 120GB in size. And I did two partitions on it to make the first one as C: system drive and the second one as a Data drive. But later on I had a space issue on the C: due to too many programs installed. Then I tried to merge these two partitions in PowerQuest PartitionMagic 8.0, but failed with the following errors like:
Error 4 while executing Batch…. Error 4 Bad Argument/Parameter….
First, I guessed it was because my hard disk had some disk errors. So I did chkdsk DOS command to check and fix disk error on the hard disk I tried to merge. After that, I tried Merge again, but I still had the same error.
Continue reading ‘Problem with Partition Merge in PartitionMagic 8.0′
Related posts
Yesterday one user reported that when he tried to edit a Microsoft Project document that is stored in a document library of a Microsoft Windows SharePoint Services Web site, he received the following error messages with Office (Project) 2003 installed on his computer.
‘Edit Document’ requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater.
I found a Microsoft Knowledge base article and did what it told me to do by updating the SharePoint support, but could not be successful. Then I tried the method 3 to register the Owssupp.dll but get the following error.
DllUnregisterServer in Owssupp.dll failed….return Error code 0×80070716.
Continue reading ‘How to resolve “‘Edit Document’ requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater” error’
Related posts
[Updated on 2008-12] This post can be treated as one of the “how-to” serials on Outlook tips.
I know we can export Contacts from Outlook directly into .csv (Comma Delimited) files, but not the same case in Distribution list. That is understandable since Distribution lists are not creating any new Contacts, just grouping these existing contacts.
But I need to export these Contacts into different .csv files based on the Distribution Lists I already created before. So I had to do extra steps to make the export happen.
Step 1: Save Distribution List as Text file
Continue reading ‘How to export Outlook Distribution List to .csv file format’
Related posts
Blog Comments