How do I produce a csv file from the xml on the bus

Replies to This Discussion

Permalink Reply by Michael Collins on January 30, 2014 at 10:13am

With Neuron 3.x, you should be able to use LINQ to XML to generate CVS output inside of a code step. Here's a blog post that shows an example: http://rasikjain.com/convert-xml-to-csv-using-linq-to-xml/

• ▶ Reply

Permalink Reply by Don Johnson on January 30, 2014 at 10:21am

Is there a way inside the code step to reference on of my Environment Variables?

• ▶ Reply

Permalink Reply by Michael Collins on January 30, 2014 at 10:23am

Yes. In v3, we exposed the environment variables to the context object that is passed into the code step. You can read your environment variables using the context.EnvironmentVariables dictionary.

• ▶ Reply

Permalink Reply by Don Johnson on January 30, 2014 at 10:27am

Can you give me an example of pulling out the environment variable for the environment I'm currently running in?

• ▶ Reply

Permalink Reply by Michael Collins on January 30, 2014 at 10:28am

var value = context.EnvironmentVariables["SomeVariable"];

• ▶ Reply

Permalink Reply by Don Johnson on January 30, 2014 at 10:30am

How do I tell it to pull for Development if I'm running Development instead of Production?

• ▶ Reply

Permalink Reply by Michael Collins on January 30, 2014 at 10:47am

It pulls from whatever the active deployment group is. If you're running Development, it will populate the EnvironmentVariables dictionary with the Development group's values.

• ▶ Reply

Permalink Reply by Don Johnson on January 30, 2014 at 12:14pm

Michael,

 

Thanks for the help.  Appreciate it and everything seems to working as shown. 

• ▶ Reply