private void ReadCsvPath(IList <K> list, IDictionary <K, V> dictionary)
{
_textFieldParser.CommentTokens = new[] { "#" };
_textFieldParser.SetDelimiters(",");
_textFieldParser.HasFieldsEnclosedInQuotes = true;
_textFieldParser.ReadLine();
while (!_textFieldParser.EndOfData)
{
var fields = _textFieldParser.ReadFields();
if (list == null && dictionary != null)
{
OnReadFields(dictionary, fields);
}
else if (dictionary == null && list != null)
{
OnReadFields(list, fields);
}
}
}
/// <summary>
/// Loads and parses a csv file.
/// </summary>
/// <returns>Task.</returns>
public async Task ParseCSVFile()
{
try
{
EnableControls = false;
OnStatusUpdated("Reading CSV file...");
Scrobbles.Clear();
using (ITextFieldParser parser = _parserFactory.CreateParser(CSVFilePath))
{
parser.SetDelimiters(Settings.Default.CSVDelimiters.Select(x => new string(x, 1)).ToArray());
string[] fields = null;
List <string> errors = new List <string>();
ObservableCollection <ParsedCSVScrobbleViewModel> parsedScrobbles = new ObservableCollection <ParsedCSVScrobbleViewModel>();
await Task.Run(() =>
{
while (!parser.EndOfData)
{
try
{
fields = parser.ReadFields();
string dateString = fields[Settings.Default.TimestampFieldIndex];
// check for 'now playing'
if (dateString == "" && ScrobbleMode == CSVScrobbleMode.Normal)
{
continue;
}
DateTime date = DateTime.Now;
if (!DateTime.TryParse(dateString, out date))
{
bool parsed = false;
// try different formats until succeeded
foreach (string format in _formats)
{
parsed = DateTime.TryParseExact(dateString, format, CultureInfo.CurrentCulture, DateTimeStyles.None, out date);
if (parsed)
{
break;
}
}
if (!parsed && ScrobbleMode == CSVScrobbleMode.Normal)
{
throw new Exception("Timestamp could not be parsed!");
}
}
// try to get optional parameters first
string album = fields.ElementAtOrDefault(Settings.Default.AlbumFieldIndex);
string albumArtist = fields.ElementAtOrDefault(Settings.Default.AlbumArtistFieldIndex);
string duration = fields.ElementAtOrDefault(Settings.Default.DurationFieldIndex);
TimeSpan time = TimeSpan.FromSeconds(Duration);
TimeSpan.TryParse(duration, out time);
DatedScrobble parsedScrobble = new DatedScrobble(date.AddSeconds(1), fields[Settings.Default.TrackFieldIndex],
fields[Settings.Default.ArtistFieldIndex], album,
albumArtist, time);
ParsedCSVScrobbleViewModel vm = new ParsedCSVScrobbleViewModel(parsedScrobble, ScrobbleMode);
vm.ToScrobbleChanged += ToScrobbleChanged;
parsedScrobbles.Add(vm);
}
catch (Exception ex)
{
string errorString = "CSV line number: " + parser.LineNumber + ",";
foreach (string s in fields)
{
errorString += s + ",";
}
errorString += ex.Message;
errors.Add(errorString);
}
}
});
if (errors.Count == 0)
{
OnStatusUpdated("Successfully parsed CSV file. Parsed " + parsedScrobbles.Count + " rows");
}
else
{
OnStatusUpdated("Partially parsed CSV file. " + errors.Count + " rows could not be parsed");
if (MessageBox.Show("Some rows could not be parsed. Do you want to save a text file with the rows that could not be parsed?", "Error parsing rows", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SaveFileDialog sfd = new SaveFileDialog()
{
Filter = "Text Files|*.txt"
};
if (sfd.ShowDialog() == DialogResult.OK)
{
File.WriteAllLines(sfd.FileName, errors.ToArray());
}
}
}
Scrobbles = parsedScrobbles;
}
}
catch (Exception ex)
{
Scrobbles.Clear();
OnStatusUpdated("Error parsing CSV file: " + ex.Message);
}
finally
{
EnableControls = true;
}
}