How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Christine — Tue, 04 Sep 2007 05:50:07 GMT

Hi Pranab. Is this the only way to add the attachment file from Infopath 2007 to MOSS 2007? Any other alternatives? By the way, are we able to detach the attachment file from InfoPath 2007 and then add it into the MOSS 2007 library document?

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

tom — Mon, 01 Oct 2007 21:10:52 GMT

Hi Pranab,

This is a great! Now, I can use your code to detach a file to SharePoint. How would you handle zero to many attachements to be detached (Looping)?

Thanks a lot!

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

pranab — Mon, 01 Oct 2007 23:48:25 GMT

In this part of Code (XPathNavigator opnXN = docXN.SelectSingleNode("/my:myFields/my:fileup", this.NamespaceManager);) you are paasing the xpath of the file attachment field as a parameter of string type.

Now if you have 5 file attachment fields (fileup0 - fileup4) then use something like:

for (int i = 0; i < 5; i++)

{

string s = "/my:myFields/my:fileup";

s += i.ToString();

}

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

tom — Thu, 18 Oct 2007 22:58:12 GMT

Hi Pranab,

Thank you for the suggestion.

But I was thinking along the line of using repeating section for the file attachment.

I’ll not know how many files have been attached in advance.

My code will loop through to figure out zero to many files and detach it to differnt SharePoint sites depend on the content type of file.

Thanks a lot!

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

tom — Tue, 23 Oct 2007 18:08:01 GMT

Zero to many attachements to detach:

Here is looping code if anyone interested.....

XPathNavigator docXN = this.CreateNavigator();

XPathNavigator opnXN = docXN.SelectSingleNode("/my:myFields/my:file", this.NamespaceManager);

XPathNodeIterator xi = opnXN.Select("/my:myFields/my:file", NamespaceManager);

while (xi.MoveNext())

{

string s = xi.Current.Value;

byte[] attachmentNodeBytes = Convert.FromBase64String(s);

..........

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

tom — Thu, 25 Oct 2007 18:53:38 GMT

Hi Pranab,

Do you know how to delete attachement file with code?

Once I copied attachements to Sharepoint, I want to delete from the InfoPath form.

I've been trying with ExecuteAction(xFileAttachementRemove, string)method, but couldn't make it work.

Thanks a lot!

How to get Library Infopath form data to EditForm

Priyanga Darshana — Mon, 12 Nov 2007 07:47:44 GMT

Showing doument data in TaskForms

Hi,

This was an excellent demo.

I have a question. Following is the scenario.

I have developed a statemachine workflow for our company expense approval and it had being associated with a infopath form Library. Now users will going to upload Infopath forms (tempate is already set up for libaray). So, I want to extract some details from those uploading files to my Infopath Task forms to display it. (e.g. User1 enter the expense figure in infopath file and upload to form libaray assigning it to user2. When user2 view task he should be able to see the those expense figures in his Infopath Task form as well)

How to do it?

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Balaji Santosh — Fri, 22 Feb 2008 06:03:47 GMT

Hi Pranab,

This is gr8. I had a problem with attachments in infopath 2007 when i use in sharepoint 2007. when i upload the document in any format, its working well. When i download the same document, it is being converted to .aspx format(if .net is installed), otherwise .zip format. can you help me in this regard.

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Pepe — Wed, 04 Jun 2008 20:40:41 GMT

Hey,

I still have the base64 error when I am publishing the InfoPath form to my SharePoint Server. I made it full trust and everything but still doesnt work.

I would appreaciate any help!

Pepe

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Andy — Tue, 24 Jun 2008 22:14:35 GMT

How can I store the file with its name based on a form FIELD's value. I have a text Field called "FinalFile", so the file name should be value of "FinalFile" field, not the actual name of the attachment.

ex:

Actual name of attachment... good.doc

Value in FinalFile..... bad.doc

So it should be stored as bad.doc to the doc library.

Thanks

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Ipsita — Thu, 17 Jul 2008 14:13:04 GMT

Hi Pranab..whenever i attach a file in infopath and save the form in a form library in share point and then see the xml of that form...i get the attached document as binaries...can you suggest some way to convert the binaries back to its original format.

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Yash — Mon, 04 Aug 2008 23:26:16 GMT

Hi Pranab,

Nice article.

But I have a problem while retrieving the file attachment. I am submitting the file attachment as byte[] in SQL Server 2005 table. How can I assign the same byte[] in that file attachment field ?

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Suzanne — Tue, 26 Aug 2008 01:04:24 GMT

This is great! Thanks for posting.

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Robert Chyra — Tue, 09 Sep 2008 13:27:37 GMT

Hi,

I have problem with browser-enabled InfoPath form and InfoPath Forms Services - every time I loaded attachments do my form it is refresh to the client's browser (if I attach 6 MB file do forms, I see it is loading to server and finally data is loading back to the client's browser)

And the worst: if I click button SAVE (standard button generated with InfoPath Forms Services) and write the name of my form and click OK, everything happens again (data is loading back to the client's browser)

What should I do to prevent loading back data from server to client's browser??

Regards,

Robert

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Rahul — Thu, 11 Sep 2008 10:33:45 GMT

Hi Pranab,

Actually, Iam getting error "URL could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application."

Any Idea?

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Hannah — Thu, 25 Sep 2008 19:45:44 GMT

Hi Pranab

I am getting the error "The Web application at http://mossdev01/Record%20Update%20Attachments/usability.doc could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.".

My SiteURL is set as above to:

string SiteURL = "http://mossdev01/Record%20Update%20Attachments/" + fileName;

The form is successfully submitted to the form library but the attachment fails on the line:

SPWeb site = new SPSite(SiteURL).OpenWeb();

Have you come accross this before?

Cheers

Hannah

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Hannah — Fri, 26 Sep 2008 14:20:58 GMT

I have managed to get this working now - i was developing on one server and running it on another - have now installed InfoPath on the same server as the form library and it it running ok.

Have aded in Tom's update looping through to add multiple attachments.

One question - has anyone added in functionality to enable exisiting documents in the doc library to be overwritten? Not sure if this should be a code thing or a setting in the form or even the doc library??

Many thanks

Hannah

Reassign task in workflow if an error occurs

Nitin — Thu, 23 Oct 2008 13:33:03 GMT

This is a typical workflow process where review is happening between two persons (Person "A" and Person "B").A Task has assigned to Person "A" for Review and after this Review, there is a set of code to be executed. Hence forth Task for Person "B" would be created. In this Scenario, when error occurs (while executing the set of code), how can I Reassign the Task to the Same Person.

Scenario 1:

Now in a typical scenario, this happened that, when the set of code (Lets say, adding the user details to a Database and database connection fails) is executed and some error had occurred. Prior to that, the Workflow completed the Task for Person "A" and created the Task for Person "B".

In other words, when the Person A’s Task is Erroneous, we should Reassign the Task to the same person rather creating Task for Person "B".

But the WWF Framework for Sequential Workflow is designed in such a way that it is forward only and the desired scenario is to sustain the status of Task till next level unless it is error free. I am really looking for some Activities using that I can reassign the Task to the same person when there is Review Error.

Is there any typical activity to handle the flow of Custom workflow to previous level, case when error occurs?

Also looking for suggestion on the Error Handling part for WWF.

Make people picker field(Activex Control) Mandatory in Infopath form

Nitin — Thu, 23 Oct 2008 13:34:59 GMT

Infopath form contains a Contact Selector Activex Control referring to Manager Name. I need to make this field as mandatory. When it comes to default controls (Like TextBox, CheckBox, RadioButton etc.), using Data Validation I can make the field Mandatory,. But this Contact Selector control does not support Data Validation.

The other way around I tried with VSTA coding. I set a value of contact Selector to one more textbox and used Data Validation to that Textbox. But this Scenario is working fine till the InfoPath form is Browser rendered. When I make the form rendered as browser, this code is not working.

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

ashishkanoongo — Fri, 02 Jan 2009 23:36:11 GMT

Hello Pranab

I am working in different sceherio. My infopath library is email enabled. I want to check whenever any email received for that form library. I want to delete attachment and add another xml file which I generated using an xslt file and transform. I just tested with itemadded event and update title field as below, but how do I delete attchment. I want to make sure it should delete only those attachment whenever item received thru email. Please advise

public class EmailReceiver : SPItemEventReceiver

{

public override void ItemAdded(SPItemEventProperties properties)

{

//SPListItem item = null;

try

{

this.DisableEventFiring();

properties.ListItem["Title"] = "Tested by AK Item";

properties.ListItem.Update();

this.EnableEventFiring();

}

catch (Exception ex)

{

//item["Title"] = ex.ToString();

EventLog.WriteEntry("Error", ex.ToString());

}

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

helen — Thu, 08 Jan 2009 07:21:46 GMT

Hi,The code shows me some error message

System.IndexOutOfRangeException

Index was outside the bounds of the array.

at InfoPathTest.FormCode.CTRL3_5_Clicked(Object sender, ClickedEventArgs e)

at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)

at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

why its so please help me

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Harit — Fri, 09 Jan 2009 09:40:08 GMT

I executed the code i get the following error can u please say y that happens

Invalid character in a Base-64 string.

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Sunil — Wed, 11 Mar 2009 20:08:37 GMT

I have an infopath form that is web enabled. I have a file attachment control on my form. Is there a limit on the file size that can be uploaded and if so, are there any workarounds ? I know that sharepoint 2007 itself has a 50MB default file size limit, but, that can be changed by going into CA. Anything similar in infopath ?

thanks for your help.

Sunil

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Avijit Das — Fri, 05 Jun 2009 19:00:16 GMT

Hi Pranab,

I would like to know what happens with the file attachment control after we detach the attachments to a document library. The options are:

1. Keep it as it is. In this case, anyway the attachments are embedded in the Form's XML. So, the Form really does not become lightweight.

2. Replace the attachment control with hyperlink (not sure if this is possible) and then bring back if I am trying to edit the Form.

Looking ahead for your response.

Regards,

Avi

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

Selva — Thu, 02 Jul 2009 13:21:15 GMT

I had created the VSTA code what you are mentioned above but

byte[] attachmentNodeBytes = Convert.FromBase64String(opnXN.ToString());

Here i am getting error like object reference

pls let me know

Thanks

selva

re: How to Add the Attachment from an InfoPath 2007 Form to a SharePoint 2007 (MOSS/WSS) Document Library

uday patel — Fri, 25 Sep 2009 23:53:02 GMT

Hi Pranab,

Thank you very much in advance.

Its really urgent for us so any help greatly appreciated.

Question is : How to delete the Infopath Form attachments Once its been copied over to another document library? Can you please provide me any source code as i have tried deleteself() and executeaction method but nothing seems tobe worked on my code.

Thanks

Uday Patel