InfoPath Dev

Hi, I am probably being a bit rude just outright asking this, but I simply lack the skill to make this myself and think it could be a generically useful thing?

I am relatively comfortable with VBA, but not with C, .Net etc.

My process is to get Infopath forms, and import them into MSAccess 2003 using the ImportXML VBA command.

File attachments are of course represented in the Base64 Code thingy (I did read through various posts, but got a bit lost). What I would like to do is run like a command line tool, passing the infopath form as an argument, and an output folder and have the Base64 attachments in the form convert and recreate themselves in the output folder. Maybe it might need some sort of 'xml label' reference for the commandline to find the right part of the infopath.xml file to 'convert'.

 Is this...something someone would consider creating? Being commandline I'm sure other people could then use for other programming/scripting tools also.

I plan to use the methods available in MSAccess to 1. run the commandline tool, and 2. then reference/link the files from the database table.

:-/ Here's hoping.

Skarn

Hey Skarn.

There is already a suite of webservices for doing what you describe with SQL or SQL Express.

It will submit documents to a database as XML and extract the data fields you want to relational tables for reporting or interfaces.

It also has a web service for querying tables dynamically.

It supports large file types, such as attachments, etc.

That may be an option for you.

Ok, I will *have* to investigate and learn about web services. However my workplace has an IT department that won't take on our project because it is too small scale for their big scale pay, and they have sole rights on webservices running on the network.

I was hoping to be able to come to some sort of 'local' solution (as I do with all our small needs in our team) using infopath forms that don't need security certificates (IT has sole rights on those also) and MSAccess which asks for rights on load and users can choose to allow it - which means I can then do 99.99% of what I need to in VBA.

 I'm able to run commandline executables locally stored, hence my hope that I could have this tool referenced by the access database to get the form file and extract the attachment.

 Is there nothing that can do this? I have found other tools online that decode base64 but they don't work on the infopath base64 string because of the 'filename, filedata' concatenation infopath is doing to the file attachment.

 Regards,

Skarn