Code

Re: Missing commas

Lawson — Wed, 21 Apr 2010 01:55:36 GMT

I figured it out with the following code:

DOMNodeList A1aaa = thisXDocument.DOM.selectNodes("/dfs:myFields/my:AcquisitionPlan/my:A1");

foreach (IXMLDOMNode node in A1aaa)

if (node.text.Length > 0)

{

string attachedFile = node.text;

Encoding _encoding = Encoding.Unicode;using (MemoryStream _memoryStream = new MemoryStream(Convert.FromBase64String(attachedFile)))

{

BinaryReader _theReader = new BinaryReader(_memoryStream);

byte[] _headerData = _theReader.ReadBytes(16);

int _fileSize = (int)_theReader.ReadUInt32(); int _attachmentNameLength = (int)_theReader.ReadUInt32() * 2;

byte[] _fileNameBytes = _theReader.ReadBytes(_attachmentNameLength);string fileNameA1a = _encoding.GetString(_fileNameBytes, 0, _attachmentNameLength - 2);

string appendText = fileNameA1a + Environment.NewLine;

File.AppendAllText(@newPathA1Output, appendText);

}

I am having a lot of trouble with this http://www.infopathdev.com/forums/t/15219.aspx right now.

Do you have any suggestions?

thanks

-Lawson

Re: Missing commas

Hilary Stoupa — Wed, 21 Apr 2010 01:15:33 GMT

Hey, Lawson:

Does this new variable need to be on a new line in the csv file? Or simply added to what you are already writing?

Re: Missing commas

Lawson — Mon, 19 Apr 2010 20:54:19 GMT

Hi Hilary,

I am trying to add to the output in this post.

I have another variable that needs to be added to the next line of the csv file.

Do you know how to do this?

-Thanks

Re: Missing commas

Lawson — Tue, 02 Mar 2010 23:35:06 GMT

Hilary,

Your code was exactly right. I replaced it, and it worked great.

Thanks,

You're Awesome!

My bulldog says the same.

-Lawson

Re: Missing commas

Hilary Stoupa — Tue, 02 Mar 2010 23:22:12 GMT

Hi:

Here is a link to MSDN documentation on joining strings in a string array with specified separator (String.Join method). Then, instead of using WriteAllLines, you could use the File.WriteAllText method?

So maybe something like:

string [] lines = { A1, B1, C1};
string allLines = String.Join(",", lines, 0, 3);
System.IO.File.WriteAllText(@"C:\Users\Lawson\Documents\output.csv", allLines);

So you know, I haven't tried to compile or run that, just typed it in, so it could have an error or two, but just wanted to give you the gist...

Missing commas

Lawson — Tue, 02 Mar 2010 21:55:35 GMT

I have an InfoPath form with three textboxes, one attachment, and one button. When an attachment is added and the button is pressed, a csv file is created with the contents of the textboxes and saved to a specified folder. My problem is with the csv file. I need a file that separates the contents of the text boxes by commas, but I get a csv file with no commas. I am using the following code.

IXMLDOMNode fileNameNode= thisXDocument.DOM.selectSingleNode("/my:myFields/my:field6");

String fileName = fileNameNode.text; if (fileName.Length > 0)

{

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

IXMLDOMNode B =thisXDocument.DOM.selectSingleNode("/my:myFields/my:field4");String B1 = B.text;

IXMLDOMNode C =thisXDocument.DOM.selectSingleNode("/my:myFields/my:field5");String C1 = C.text;

string[] lines = { A1, B1, C1,};System.IO.File.WriteAllLines(@"C:\Users\Lawson\Documents\output.csv", lines);

}

I have also added an example of the form to this post.

Does anybody have any suggestions for how to fix this?

Thanks

-Lawson