InfoPath Dev

Hello,

I have an IP 2003 form with C# code.

I have an event where I would like to read all of the file names from a speceific file folder and then write the file names to a csv file.

I am using the following code.

DirectoryInfo di = new DirectoryInfo(@"C:\Users\Lawson\Desktop\file\file1\");foreach (FileInfo fi in di.GetFiles())

{

Console.WriteLine(fi.Name);

}

Console.ReadLine();

string appendText = FileInfo;

File.AppendAllText(@"C:\Users\Lawson\Desktop\file\output.csv", appendText);

However, I cannot seem to get the file names into the csv document.

Does anybody have any suggestions?

Thanks,

-Lawson

Hi,

Lawson:

string appendText = FileInfo;

Here you use FileInfo like a variable, but you don't show us were you declare it. Here a sample of code to do what you need:

string MyfileInfo=string.Empty;

DirectoryInfo di = new DirectoryInfo(@"C:\Users\Lawson\Desktop\file\file1\");foreach (FileInfo fi in di.GetFiles())

{

MyfileInfo+=fi.Name;

}

File.AppendAllText(@"C:\Users\Lawson\Desktop\file\output.csv", MyfileInfo);

 

Hey, thank you for your help.

I tried using your code, but I get the following errors:

 Error 1 Invalid token 'foreach' in class, struct, or interface member declaration C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 112 17 Hash Test Form 10-22-2010
Error 2 ; expected C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 112 38 Hash Test Form 10-22-2010
Error 3 Invalid token '(' in class, struct, or interface member declaration C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 112 52 Hash Test Form 10-22-2010
Error 4 Invalid token '+=' in class, struct, or interface member declaration C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 116 27 Hash Test Form 10-22-2010
Error 5 Invalid token ';' in class, struct, or interface member declaration C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 116 36 Hash Test Form 10-22-2010
Error 6 A namespace does not directly contain members such as fields or methods C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 120 17 Hash Test Form 10-22-2010

Any suggestions?

 

 

Hi, I don't see any error in this codes are you sure you use C# ? try to zip you form with the codes and attach it. When you reply click on option and then atttach your file.

Hey, thanks for your help. I found a stray bracket in the code. Once I removed it, everything worked perfectly.

Thank you,

-Lawson

 

Now that I have the file names, I would also like to get a hash value for each document.

 I can get a hash value with the following code:

// Open a local file

IXMLDOMNode N = thisXDocument.DOM.selectSingleNode("/my:myFields/my:field1");

//Get the text

String HashDocument = N.text;

FileStream fs = new FileStream(HashDocument, FileMode.Open);

// Now generate a hash code for this file using MD5.

 

HashAlgorithm alg = HashAlgorithm.Create("MD5");byte[] fileHashValue = alg.ComputeHash(fs);

 

 

// Print out the generated hash code.

string HashOutput = (BitConverter.ToString(fileHashValue));thisXDocument.DOM.selectSingleNode("/my:myFields/my:group2/my:field5").text = HashOutput;

fs.Close();

 

I haven't tried to unify this with the other code yet.

Do you have any suggestions?

Thanks,

-Lawson

Hi, Lawson, sorry for the delay. What exactly you want to do?

Hey, no worries.

I would like to get the file names and corresponding hash values for each file, then I would like to place the names and hash values in a csv file.

I can get the file names and the file hash values with the above code.

Now I'm just trying to combine the two.

Thanks, -Lawson

 Ok, I elaborate it a little, I separate each file name by a semicolon";" and I delece the csv if it exist:

MD5CryptoServiceProvider hashMd5 = new MD5CryptoServiceProvider();

            string MyfileInfo = string.Empty;

            DirectoryInfo di = new DirectoryInfo(@"C:\Users\Lawson\Desktop\file\file1\");
            foreach (FileInfo fi in di.GetFiles())
            {
                byte[] passwordHash = hashMd5.ComputeHash(Encoding.Default.GetBytes(fi.Name));
                MyfileInfo += Convert.ToBase64String(passwordHash) + ";";
            }
            if (File.Exists(@"C:\Users\Lawson\Desktop\file\file1\output.csv"))
                File.Delete(@"C:\Users\Lawson\Desktop\file\file1\output.csv");
            File.AppendAllText(@"C:\Users\Lawson\Desktop\file\file1\output.csv", MyfileInfo);

I used your code in following way:

{

IXMLDOMNode A = thisXDocument.DOM.selectSingleNode("/my:myFields/my:field1");

//Get the text of the Contract Number node.

String Data1 = A.text;

IXMLDOMNode B = thisXDocument.DOM.selectSingleNode("/my:myFields/my:field2");

//Get the text of the Contract Number node.

String Data2 = B.text;

IXMLDOMNode C = thisXDocument.DOM.selectSingleNode("/my:myFields/my:field3");

//Get the text of the Contract Number node.

String Data3 = C.text;

 

string[] Datalines = { Data1, Data2, Data3 };

string allLines = String.Join(",", Datalines, 0, 3) + Environment.NewLine;

System.IO.File.WriteAllText(@"C:\Users\Lawson\Desktop\file\output.csv", allLines);

string MyfileInfo = string.Empty;

DirectoryInfo di = new DirectoryInfo(@"C:\Users\Lawson\Desktop\file\file1\");foreach (FileInfo fi in di.GetFiles())

{

byte[] passwordHash = hashMd5.ComputeHash(Encoding.Default.GetBytes(fi.Name));

MyfileInfo += Convert.ToBase64String(passwordHash) + Environment.NewLine;File.AppendAllText(@"C:\Users\Lawson\Desktop\file\file1\output.csv", MyfileInfo);

}

 

 

 

 

 

 

}

 

}

}

 

I get the following errors:

Error 1 The name 'hashMd5' does not exist in the current context C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 112 39 Hash Test Form 10-22-2010
Error 2 The name 'Encoding' does not exist in the current context C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 112 59 Hash Test Form 10-22-2010

Any Suggestions?

Have you add these namespaces?

using System.Security.Cryptography;
using System.Text;

I'm using the following namespaces:

using System;

using Microsoft.Office.Interop.InfoPath.SemiTrust;

using System.Collections.Generic;

using System.IO;

using System.Security;

using System.Runtime.InteropServices;

using System.Diagnostics.CodeAnalysis;

using System.Security.Cryptography;

using System.Text;

 

 

I still get the following error:

Error 1 The name 'hashMd5' does not exist in the current context C:\Users\Lawson\Documents\InfoPath Projects\Hash Test Form 10-22-2010\FormCode.cs 67 39 Hash Test Form 10-22-2010

 hi, you probably miss this line on my codes:

MD5CryptoServiceProvider hashMd5 = new MD5CryptoServiceProvider();