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
A few days ago, got an email forwarded by co-worker regarding a new law effective in Georgia. Its name is Move-Over Law, which says drivers must move-over for emergency vehicles stopped on the side of the highway. The law is meant to keep officers AND traffic violators safe from crashes with passing cars.
Continue reading ‘Be aware: New Law in GA which can cause you $500 fine’
Related posts
Today got a call from a friend and was told that her computer might be virus infection since a new anti-virus software always prompted up and warned her everything. And this new anti-virus is named “XP Internet Security 2010″, but she said she never installed it before. Now she was scared since too many viruses found on her computer according to the ‘XP Internet Security 2010″ application warned. Based on what she said, I could tell she got a new malware infected instead of a lot of viruses.
Continue reading ‘How to remove XP Internet Security 2010 malware rogues’
Related posts
20" x 55" Running Treadbelt,
2.8 HP DURX Drive Motor,
iPod® Compatible Music Port
Costco price: $599.99
Shipping & Handling included
Continue reading ‘Reebok CrossWalk V 7.90 Folding Treadmill review’
Related posts
My daughter got this tiny media player as a Christmas present from one of my friends. It is a nice media player considered that it can play music, video and games with 1GB capacity on its price range (listed price $99 but Amazon.com is selling it for $21). And it has SpongeBob cartoon icon everywhere which kids like it from TV already. But of course, it is not perfect at least for me I could not connect it to my DELL computer at the first. Finally I got this issue resolved (will update later), and happy to recommend this device to you especially you have kids in house.
Continue reading ‘SpongeBob SquarePants: Npower Fusion™ 1GB Digital Media Player Review and MTP device driver issue resolved’
Related posts
Say you have a few hundreds WORD (*.doc and *.docx) files on your computer, and you need to convert them all into PDF format files. Yes, you can open them and then Save As into PDF in WORD 2007 one by one, or you can highlight all of them (provided they are in the same folder) and print them into PDF format. But you still need to click a few hundreds times mouse to answer Save As… questions within Word. Is there a way to automate it.
Hey, you might say I already mentioned this similar feature in my previous post (http://lichao.net/eblog/how-to-auto-find-and-replace-text-in-bulk-word-files-and-save-convert-to-other-format-with-script-201002475.html). But that script was mainly created for Find and Replace feature and there is a glitch in the PDF convert bonus feature. If you have Word 2007 installed on your machine, and that script will prompt you with READ-ONLY permission warning if your Word files are in 2003 version. But if you use that script on Word 2003 machine, the PDF convert feature will not work. So we need to create separate PDF convert scripts for Word 2003 and Word 2007.
Continue reading ‘How to use script auto-convert all WORD files into PDF with Office 2007′
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 used Microsoft Virtual PC, Sun VirtualBox, and VMware Desktop to play with Linux distro in virtual environment. Later on, I got rid of Microsoft VirtualPC due to its imperfection dealing with ubuntu, and am only using Sun VirutalBox at home and VMWare at work. Today, my co-work showed me how he installed VBoxAdditions in Virtual Box to improve the guest Linux OS screen resolution. I could not help thinking I should do the same in VMWare WorkStation by installing VMWare Tools .
But when I followed the install instruction to run “vmware-install.pl” in my guest Ubuntu virtual machine, I got “vmware-install.pl command not found” message. It took me a while to figure out the reason, and it was just a simple Super User permission issue but I thought it was because of PERL installation on ubuntu.
To save you all valuable time in the similar situation, I am sharing here with the detail steps to install VMWare Tools on Ubuntu Linux Guest OS in VMWare WorkStation (version is 5.5.9).
Continue reading ‘Install VMWare Tools on guest ubuntu linux virtual machine’
Related posts
I installed ubuntu 9.10 on one of my laptops with GNOME desktop environment, but unfortunately it worked very slow due to the limited memory of 256 MB. So I decided to switch to xfce desktop environment. After I installed xfce on top of GNOME then remove all package of gnome, I started to have some different issues as I had in the Ubuntu GNOME environment. Today I just wanted to talk about the flash player plug-in installation on Firefox issue here.
Continue reading ‘Install Adobe Flash player in Firefox on xubuntu’
Related posts
In my recent trip to China, I found out the paper book business is still very good. It is understandable, after all the audience pool is so huge and unlike the reading materials on the Internet you still need to pay money for the paper books.
When I mentioned e-book reader to some of my friends, they also said it would be popular too. Since it is very attractive from a huge capacity perspective. With it, you do not carry a heavy bag of books instead of packing a thin e-reader in the travel. But they said we could not see the immediate hit recently. 1), it still depends on a good hardware e-reader: multiple task (music, video etc), light and stylish; 2), not too many e-book available and the technology to protect intelligence rights, and others.
Continue reading ‘Are you ready for Amazon ebook reader Kindle?’
Related posts
Blog Comments