InfoPath Dev

Ok my first thought was to have the submit button look in my file where i have my users saving the xml file if they want to. But the submit has to be programmed if i wanted to add code. Correct?? So I went to the save button on the form. I have this

var myPathdelete = XDocument.DOM.selectSingleNode("/dfs:myFields/my:test");
	myPathdelete = new ActiveXObject("Scripting.FileSystemObject");
	XDocument.DeleteFile(myPathdelete);
	XDocument.UI.Alert("Deleted");

BUt there is no DeleteFile in XDocument . So what else can i do to look in that folder , see any old xml and delete all files left in there? Thanks.

You are correct that XDocument does not have any delete functionality.

My question is why you keep flopping around your myPathdelete variable? First you set it to a point to the node my:text, then you change it into an ActiveX Object, then you try to delete the ActiveX Object using a method that doesn't exist.

I think you were probably on the right track using the ActiveX Object... but you need to use the delete functionality of that ActiveX Object to do your work. This has nothing to do with XDocument... you are accessing the file system and doing your work there.

You need to research the FileSystemObject to use that to do what you are trying to do.

One thing to keep in mind is that your form will have to be full trust to use the FileSystemObject.

Greg Collins [InfoPath MVP]

yes it is a full trusted form. I will let you know what I find.

Has anyone tried using DeleteFile method and actually worked?
I tried deleting one of the xml infopath forms on sharepoint, but 'FileExists' method cant seems to be able to locate the file.

This is the code snippet I used:

var fso;
fso = new ActiveXObject("Scripting.FileSystemObject");
XDocument.UI.Alert("about to delete " + filespec);
if ( fso.FileExists(filespec) ) {
XDocument.UI.Alert("file found");
fso.DeleteFile(filespec);
XDocument.UI.Alert("file deleted");
}

where 'filespec' is the file location string to be deleted like 'http://sharepointlocation.com/Forms/libraryfolder/filename.xml'.

And my form template is fully trusted.

Help anyone?

No idea here.

You are not going to be able to delete files over HTTP regardless of what application you are using. Web servers (at least to my knowledge) are just not setup to do this.

Two ideas come to mind:

1 - Write your own little ASP page or something that will delete the file on the web server. This should only take a few lines of ASP code to make some kind of page that when you load uphttp://yourwebserver/folder/deleteFile.asp?file=_file_name_ in a browser the ASP script will delete it from the server.

2 - Use the SharePoint web services to interact with your form libraries. I have a HowTohttp://infopathdev.com/howto/tutorials/default.aspx?i=7bc880f391b84ea9b3b45c6fbecc07c6 that talks about adding SharePoint list items via InfoPath, and that might give you a few pointers on where to start looking.

Hope this helps, good luck!

hi Matt, thanks for the pointers :)

For idea #1:
- Sorry, but how to execute that ASP script from the infopath program?

And which way would impose less load on the client side, Matt?
Solution #1 or #2?