C# Discussion Boards - CodeProject

4-Jan-13 0:10

Maybe I'm just having a blonde moment but

I am trying to convert a Winforms application from XP to Windows 7 which uses Log4Net.

<configuration>
  <configSections>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net"/>
  </configSections>

  <log4net>
    <appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
      <file value="{0}.log"/>
      <appendToFile value="true"/>
      <rollingStyle value="Size"/>
      <maxSizeRollBackups value="5"/>
      <maximumFileSize value="100kb"/>
      <staticLogFileName value="true"/>
      <layout type="Oak.Common.Logger.MyPatternMatch">
        <conversionPattern value="%date [%thread] %level %logger - %message%newline"/>
      </layout>
    </appender>
    <root>
      <level value="ALL"></level>
      <appender-ref ref="RollingLogFileAppender"/>
    </root>
  </log4net>

I dynamically create a log file location using the following code

string Path = Environment.GetFolderPath(System.Environment.SpecialFolder.ApplicationData)  + @"\Windows7Log4NetLogs\" + DateTime.Today.ToString("ddMMyyyy");
Logmanager.ChangeLogFile(Path);

Which creates the file successfully but when I try to send in a piece of text to the file nothing gets written and I am stumped I have tried different SpecialFolder options but it still doesn't write anything to the log file. Below is the code that I use for logging.

public class Logmanager
{
    private static readonly Lazy<Logmanager> instance = new Lazy<Logmanager>(() => new Logmanager());

    private Logmanager() { }

    public static Logmanager Instance
    {
        get { return instance.Value; }
    }

    public ILog Logger(string LoggerName)
    {
        return log4net.LogManager.GetLogger(LoggerName);
    }


    /// <summary>
    /// This allows you to specify the log file name.
    /// </summary>
    public static void ChangeLogFile(string filename)
    {
        log4net.Repository.ILoggerRepository RootRep;
        RootRep = LogManager.GetRepository(Assembly.GetCallingAssembly());

        XmlElement section = ConfigurationManager.GetSection("log4net") as XmlElement;
        XPathNavigator navigator = section.CreateNavigator();
        XPathNodeIterator nodes = navigator.Select("appender/file");

        foreach (XPathNavigator appender in nodes)
        {
            appender.MoveToAttribute("value", string.Empty);
            appender.SetValue(string.Format(appender.Value, filename));
        }

        IXmlRepositoryConfigurator xmlCon = RootRep as IXmlRepositoryConfigurator;
        xmlCon.Configure(section);
    }
}

EDIT:

I have also tried to write an ordinary text file to the same directory using a StreamWriter and that works, so I don't think that it is a permissions issue.

Anyone got any ideas or pointers for me.

Thanks
Simon

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

modified 4-Jan-13 9:57am.

Brisingr Aerowing4-Jan-13 9:15

4-Jan-13 9:15

Can log4net find the layout type you defined? I know absolutely nil about log4net (I use NLog), so I am not sure what happens then.

Bob Dole
The internet is a great way to get on the net.

2.0.82.7292 SP6a

Brisingr Aerowing4-Jan-13 9:23

4-Jan-13 9:23

From Google, I figure you need to add the assembly name to the layout type so log4net can find it.

Bob Dole
The internet is a great way to get on the net.

2.0.82.7292 SP6a

jschell4-Jan-13 13:55

4-Jan-13 13:55

Zac Greve wrote:
From Google, I figure you need to add the assembly name to the layout type so log4net can find it.

That would only be true if you created a custom layout.

Brisingr Aerowing4-Jan-13 13:59

4-Jan-13 13:59

And from the namespace used, he did.

Bob Dole
The internet is a great way to get on the net.

2.0.82.7292 SP6a

jschell6-Jan-13 4:44

6-Jan-13 4:44

Zac Greve wrote:
And from the namespace used, he did.

Yes, sorry you are correct.

Simon_Whale5-Jan-13 13:04

5-Jan-13 13:04

I am using a custom layout that is correct, the references that code uses are there as I loaded log4net through Nuget.

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Brisingr Aerowing5-Jan-13 13:21

5-Jan-13 13:21

No, add the name of the assembly with the custom layout to the end of the layout namespace thing. e.g.

XML

<layout type="My.Cool.Namespace.And.Sub.Namespace.And.Sub.Sub.Namespace.Layouts.MyLayout, MyAssembly">
<!-- ............ -->
</layout>

(Not that I use that many namespace, nor should you, I just am sorta hyper right now. *Bounces off another wall, "BONK"*)

Bob Dole
The internet is a great way to get on the net.

2.0.82.7292 SP6a

Simon_Whale6-Jan-13 2:02

6-Jan-13 2:02

The logger code and Custom Pattern Code are in the same assembly, The app config is in WinForms project. This code worked / works on XP but I have recently upgraded my works machine to Windows 7.

I think when I get to work on Monday that I'll give the NLog a go.

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Brisingr Aerowing6-Jan-13 7:01

6-Jan-13 7:01

Look here.[^]

The second example should help you.

Bob Dole
The internet is a great way to get on the net.

2.0.82.7292 SP6a

jschell4-Jan-13 14:01

4-Jan-13 14:01

Presumably it works if you do NOT call ChangeLogFile?

Why don't you just add the path to your the log4net config file rather than attempting to do it dynamically?

Presumably you call ChangeLogFie BEFORE you instantiate or reference any files that uses logging?

Simon_Whale6-Jan-13 2:04

6-Jan-13 2:04

I do a dynamic log file name so that I can separate the logging by day.

The logger creates the file that I need each time, but when I try to write entries too it, nothing appears and no error messages are generated about the logger.

the annoying thing is that this worked like a charm in XP now I moved it too Windows 7 it stops Frown | :(

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

jschell6-Jan-13 4:45

C# Equivalent of a Vlookup

6-Jan-13 4:45

Simon_Whale wrote:
I do a dynamic log file name so that I can separate the logging by day.

That doesn't answer my question.

Member 97041533-Jan-13 22:00

Member 9704153

3-Jan-13 22:00

I have a datatable with a column of values, and I need to source a corresponding value from another datatable. Durrently, I'm doing this :-

string SuppRef = null;
if (DtSet.Tables.Contains("tblAccounts"))
{
    foreach (DataRow row in dtMain.Rows)
    {
        if (row[1].ToString() == "")
        {
            SuppRef = row[5].ToString();
            foreach (DataRow r in DtSet.Tables["tblAccounts"].Rows)
            {
                if (r[0].ToString() == SuppRef)
                {
                    row[1] = r[1].ToString();
                }
            }
        }
    }
}

So, where a value is missing from column 1, I search for the value in column 5 in the second datatable, and return the corresponding value.
I was wondering is there was an alternative way to approach this, maybe something similar to Excel's Vlookup or Find?
Thanks in advance.

Re: C# Equivalent of a Vlookup

nainakarri4-Jan-13 0:55

nainakarri

4-Jan-13 0:55

Hi
Can you please elaborate exactly how you want the result with an example.

Regards
Naina

Naina

Re: C# Equivalent of a Vlookup

Member 97041534-Jan-13 1:38

Member 9704153

4-Jan-13 1:38

I'm not sure if this is what you mean, but what I'm doing is :-

Before

dtMain
Col 1 Col 5
null 1111

tblAccounts
Col 0 Col 1
1111 2222

After

dtMain
Col 1 Col 5
2222 1111

tblAccounts
Col 0 Col 1
1111 2222

Re: C# Equivalent of a Vlookup

nainakarri4-Jan-13 20:22

nainakarri

4-Jan-13 20:22

Hi
Just try this code

foreach (DataRow row in dt.Rows)
           {
               int colcount = dt.Columns.Count;
               for(int i = 0; i<colcount; i++)
               {
                   if ((row[i] == null || row[i].ToString() == ""))
                   {
                       foreach (DataRow row1 in dt1.Rows)
                       {
                           row[i] = row1[i].ToString();
                       }
                   }
               }
           }

dt is datatable1 and dt1 is datatable2

Regards
Naina

Naina

XML Mapping to CSV

RickSharp3-Jan-13 11:32

RickSharp

3-Jan-13 11:32

Hello,

I have a fixed XML table thats coming from a Web Service.

XML

<Loan>
<Name>JOHNSON, DANIEL R.</Name>
<Number>BMRES-550</Number>
<BankName>Bank of America</BankName>
<ClosingNo>123456</ClosingNo>
<FundsToSendAmt>49,7560.8600</FundsToSendAmt>
</Loan>

I need to convert the XML data to CSV. The data to be converted has commas. So the below method doesn't work:

using (StreamWriter writer = File.CreateText("C:\\username\\password\\Desktop\\Export.csv"))
        {
            DataSet ds = new DataSet();
            ds.ReadXml(XmlReader.Create(new StringReader(myWebreference.GetWebServiceMethod("username", "password1", "Export", "Parameter4", DateTime.Today, DateTime.Today, ""))));

            writer.WriteLine(string.Join(",", ds.Tables["Loan"].Columns.Cast<DataColumn>().Select(col => col.ColumnName).ToArray()));
            foreach (DataRow row in ds.Tables["Loan"].Rows)
            {
                writer.WriteLine(string.Join(",", row.ItemArray.Cast<string>().ToArray()));

            }
        }

David C# Hobbyist.3-Jan-13 11:58

David C# Hobbyist.

3-Jan-13 11:58

Why not convert comma's to something that wont be in your data like ~ ?

Frazzle the name say's it all

Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.
John F. Woods

RickSharp3-Jan-13 13:01

RickSharp

3-Jan-13 13:01

Actually this might be more what I'm looking for:

public class WireEntry
{
    public String Name { get; set; }
    public String Number { get; set; }
    public String BankName { get; set; }
    public String ClosingNo { get; set; }

    public WireEntry()
    {
    }
}


foreach (DataRow row in ds.Tables["Loan"].Rows)
        {

            // Enter into result set

            WireEntry newEntry = new WireEntry();
            newEntry.Name = row["Name"].ToString();
            newEntry.Number = row["Number"].ToString();
            newEntry.BankName = row["BankName"].ToString();

            result.Add(newEntry);

        }

        return result;

David C# Hobbyist.3-Jan-13 13:17

David C# Hobbyist.

3-Jan-13 13:17

Maybe I am wrong but you still need to strip out the comma's from the incoming data. Or possibly I didn't understand your task.

I was thinking string.Replace(",","comma");

Frazzle the name say's it all

Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.
John F. Woods

PIEBALDconsult3-Jan-13 14:07

PIEBALDconsult

3-Jan-13 14:07

What do you do with the CSV when you're done? Why use CSV?

0) Use a different delimiter (Good).
1) Wrap the values in quotes (better).
2) I'd prefer to save the XML and then use XSLT to form the CSV.

RickSharp4-Jan-13 6:05

RickSharp

4-Jan-13 6:05

Actually thats a good question. Because I'm not really wanting the end file to be a CSV file. The end file should be in FedWire Format.

http://www.frbservices.org/campaigns/remittance/files/fedwire_funds_format_reference_guide.pdf[^]

I just figured it would be easier to get to my end result with a CSV file to work with.
Basically I'm taking that Web Service. Iterating through the tables. Then ultimately spitting out a file in that format.

{1015} blah blah blah {1870} blah blah blah