Cinchoo ETL serialize Class to csv

Question

Trying to serialize class to csv, I am getting:

StationId,Data.Datetime_0,Data.Datetime_1

63,2021-05-04T11:00:00+02:00,

using the package:

public static string StationDetailsCallStringToCSV(StationDetailsCall station)
{
    var csv = new StringBuilder();

    using (var parser = new ChoCSVWriter<StationDetailsCall>(new StringWriter(csv)).WithFirstLineHeader().UseNestedKeyFormat(true))
    {
        parser.Write(station);
    }
    return csv.ToString();     
}

The Class (StationDetailsCall):

public class Channel
{
    [JsonProperty("id")]
    public int Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("alias")]
    public string Alias { get; set; }

    [JsonProperty("value")]
    public double Value { get; set; }

    [JsonProperty("status")]
    public int Status { get; set; }

    [JsonProperty("valid")]
    public bool Valid { get; set; }

    [JsonProperty("description")]
    public string Description { get; set; }
}

public class Datum
{
    [JsonProperty("datetime")]
    public string Datetime { get; set; }

    [JsonProperty("channels")]
    [Range(0, 3)]
    public Channel[] Channels { get; set; }
}

public class StationDetailsCall: Container
{      
    [JsonProperty("stationId")]
    public int StationId { get; set; }

    [JsonProperty("data")]
    [Range(0, 1)]
    public Datum[] Data { get; set; }
}

the problem is in the csv result, the array channels in class Datum doesn't get serialized

what am I doing wrong?

there was a bug in the library, pls take v1.2.1.16 and give it try. — Cinchoo, May 04 '21 at 20:23

score 2 · Accepted Answer · answered May 04 '21 at 11:37

You can convert data to json before converting it to csv and convert json data to csv.

StationDetailsCall station = new StationDetailsCall();
station.StationId = 1;
station.Data = new Datum[] { 
     new Datum() { Channels = new Channel[] { new Channel() { Id = 1, Name = "name1" }, new Channel() { Id = 2, Name = "name2" } }, Datetime = DateTime.Now.ToString() },
     new Datum() { Channels = new Channel[] { new Channel() { Id = 3, Name = "name3" }, new Channel() { Id = 4, Name = "name4" } }, Datetime = DateTime.Now.ToString() },
};
string result = StationDetailsCallStringToCSV(station);

StationDetailsCallStringToCSV method

public static string StationDetailsCallStringToCSV(StationDetailsCall station)
{
    var csv = new StringBuilder();
    string json = JsonConvert.SerializeObject(station);
    using (var r = ChoJSONReader.LoadText(json))
    {
        using (var w = new ChoCSVWriter(csv).WithFirstLineHeader().UseNestedKeyFormat(true).ThrowAndStopOnMissingField(false))
        {
           w.Write(r);
        }
    }
    Console.WriteLine(csv.ToString());
    return csv.ToString();
}

Cinchoo ETL serialize Class to csv

1 Answers1