24 February, 2010

Verfification error-An error occured during the signature verification.

Something to share about infopath forms functionality using digital signatures. Everybody knows as how to customized the infopath forms,using controlls on that as well as publishing forms on document libraries. The certificate works fine when I open the form in thick client and then sign it. If I try to digitally sign the browser enabled form (with same certificate), it fails with the following error message:

one or more digital signatures in this form could not be verified.To Modify parts of the form tat have been digitally signed, removed the associated signatures. click on a signature to view its details.

OR
There is a problem with this signature.
For the certificate to work with browser enabled forms, the certificate should have a trust chain. Without a chain of authority to tell the Operating System where this certificate came from, the computer will have no way to verify the authenticity of the certificate.

Please follow this steps to resolve this issue:

To Export the certificate (To be performed on the client machine where you have installed the certificate:

• On the machine where you have downloaded and installed the VeriSign Class 1 certificate go to Start├áRun and type certmgr.msc and press OK button to launch Certificate Manger console.
• Expand the Personal store,, you would see on child node of Personal store called Certificates.
• Click on the Certificates node.
• On the right hand side pane, locate certificate with your name issued by VeriSign Class 1 Individual Subscriber CA - G2.
• Right Click the certificate and select Export from All Tasks option to Launch certificate export Wizard and Click Next button.
• In the Export Private Key prompt, select “Yes, export the private key”
• In the Export File Format , Under Personal Information Exchange - PKCS #12 (.PFX), check “Include all certificates in the certification path if possible” and click Next
• Enter the password and click on the Next
• Click on Browse button and select the location where you want to export the certificate.
• Click on Finish to complete the Wizard.
To Import the Certificate.(To be performed on the SharePoint server
Copy the *.pfx file on the machine where your SharePoint server is Installed.
• Right click your PFX file and select “Install PFX” option to launch Certificate Import Wizard, click next to continue.
• Verify the location of your PFX file in “File to Import Screen” and click on Next
• Enter your password and click on Next.
• In the “Certificate Store” prompt, select “Place all certificates in the following store” and click on browse button.
• In the “Select Certificate Store”, select “Trusted Root Certification Authorities” and Click on OK.
• Click Finish to Complete the wizard.

I hope the above steps will helps you to resolve your issue,thanks !!

29 January, 2010

The converter failed to save the file

Computer running office 2007 try to open an excel file from SharePoint site for edit. Error: (Save as) The converter failed to save the file. However, if user start the Excel program before opening the file from SharePoint, no problem at all, no error message and file saving fine. 

The fix is to do the following:
- Open Word
- Click the Office button (Top-left in the window)
- Click Word Options
- Click Resources
- Click the Diagnose button
- Click through the wizard until it’s finished
- Close all browser windows

I hope the above information will helps u to resolve the issue!!

In case of any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues. Thank you.

Excel cannot open the file 'filename.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file

When you try to open a workbook that you receive in an e-mail message for review in Microsoft Office Excel 2007, the workbook does not open. Additionally, you receive the following error message:
Excel cannot open the file 'filename.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
This issue occurs only when you send a workbook for review. The workbook file is saved as an Excel binary workbook. However, the workbook has an .xlsx extension that is appended to the file.

To work around this issue, save the workbook as one of the following file formats before you send the workbook for review:
--Excel Binary Workbook (*.xlsb)
--Excel 97-2003 Workbook (*.xls)

26 January, 2010

The document information panel was unable to load. The document will continue to open. For more information, contact your sys admin.

I have a custom field type as a dropdownlist which displays the no. of users from the web site. Now I have a document library with this custom field type. When I tries to create a item it opens the MS Word instance and it gives a message as Document Information Panel is unable to load.

After lots of research and debugging the issue on my dev-env, i was able to resolve the issue.
The Steps taken for resolution:

1. Open this location- C:\Program Files\Microsoft Web Designer Tools\Office12\1033\IPEDINTL.DLL
2. copy IPEDINTL.DLL
3. paste it here- C:\Program Files\Microsoft Office\Office12\1033\IPEDINTL.DLL
4. Close all the applications that are presently open as well as all the browsers
5. Open the sharepoint site in a new browser and check the results !!

Please let me know in case of any issues.. Thanks !! I hope, the above steps will helps you to resolve your issue regarding the same !!

16 January, 2010

Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists

1. Install the excel 2007 add-in on your machine.

http://www.microsoft.com/downloads/details.aspx?FamilyId=25836E52-1892-4E17-AC08-5DF13CFC5295&displaylang=en

2. When you will start the setup then it will ask you where to install the data excetely, so please save at this location on your machine:
C:\Program Files\Microsoft Office\Office12\ADDINS

3. Open the excel sheet in which you have the data that you wants to synchronise in sharepoint.

4.Click the Microsoft Office Button, click Excel Options, and then click the Add-Ins tab.

5. Select Excel Add-ins in the Manage drop-down list and click Go.

6. In the Add-Ins dialog box, click Browse, navigate to the Excel 2007 SharePoint List Synchronizing Add-in, and then click OK.

7. In the Add-Ins dialog box, verify that the SynchronizeWSSandExcel option is selected and then click OK.


To add the add-in to a workbook

1. Save the workbook in the Excel 97-2003 (BIFF8) file format by clicking the Microsoft Office Button, pointing to Save As, and then clicking Excel 97-2003 Workbook.

2. Specify a file name, and then click Save.

To publish the table to a SharePoint list1. Highlight the table. The Table Tools label is displayed above the Design tab.

2. Click the Design tab.

3. In the SharePoint group, click Publish and allow Sync.

4. When you will click on click Publish and allow Sync. then all the data will be disappeared from the excel sheet and transferred to SharePoint List.

5.In the Export Table to SharePoint R/W List dialog box, in the Address text box, type in the page address onthe SharePoint site where you want to publish the list.



6. In the address, Please enter your site link without default.aspx

7. Type the name of the list that you want.

8.When you will click on Publish then the internal process will create a list by the name that you specified and all the data will be transferred to sharepoint site.

Note: When you will click on Publish then you will get some error message.. Dont worry abt that as the data has been transferred to sp-site.
If you have any questions or queries regarding the above procedure then please let me know..