Stack Overflow
Stack Overflow

Questions tagged [lumenworks]

24 questions
6
votes
2 answers

Lumenworks Csv reader To read columns with same Names Or avoid ` An item with the same key has already been added`

I wanted to know if there is any way to make CSV reader read all the columns in the CSV (which will have same column names). I get a An item with the same key has already been added error. I want this to work because my logic is to make a array of…
Rajshekar Reddy
  • 18,647
  • 3
  • 40
  • 59
6
votes
1 answer

Lumenworks Fast CsvReader - Exception error reading tab delimit file due to quote character

I'm using Lumenworks Fast CsvReader and the exception error occurred while reading the Kelley Blue Book's file: The CSV appears to be corrupt near record '1281' field '5 at position '1169' The file is tab delimited. In there I found double quotes…
fletchsod
  • 3,560
  • 7
  • 39
  • 65
4
votes
1 answer

SqlBulkCopy Azure DataTable faster than Streaming

I need a worker role that takes a txt file from a Blob and bulk it into an Azure Sql table. I'm using the SqlBulkCopy provided by LumenWorks.Framework.IO, I've created 2 version of the worker role: 1) read the entire file, load it into a DataTable,…
Simone
  • 332
  • 4
  • 16
4
votes
1 answer

Reading csv having double quotes with lumenwork csv reader

I'm reading a csv file using the Lumenworks csv reader. Below is an example record "001-0000265-003"|"Some detail"|"detal1"|"detail2"|"detal3"|"detail4"|"detail5"|"detail6" I've created a class with below constructor to read this file using (var…
Isuru Siriwardana
  • 547
  • 5
  • 17
4
votes
2 answers

Extract whole row/line using Lumenworks CSV Parser

How do I read the whole row while using LumenWorks CVS parser? So far am only able to read entry by entry but not the whole row. i.e. if a row is a,b,c,d,e,f, am able to pluck out each individual alphabet. However, I want to be able to read the…
lukik
  • 3,919
  • 6
  • 46
  • 89
3
votes
1 answer

Is this valid CSV escaping? Lumenworks throws an exception but other parsers seem to work

I'm updating a legacy system that parses CSVs. I decided to use the LumenWorks csv library. It struggles on records like this: "Cats","123","A","B","Mittens","1","2","3","1950",""PROBLEM IS HERE"","Some street","Fishtown","","AB13DF","United…
NibblyPig
  • 51,118
  • 72
  • 200
  • 356
2
votes
1 answer

How to bypass comma , double quote using Lumenworks

I am fetching data from a database in csv format.i.e http://iapp250.dev.sx.com:5011/a.csv?select[>date]from employee But some columns in the table contains comma and double quotes and after reading the csv it becomes comma separated string.As a …
Chirag
  • 31
  • 2
  • 5
2
votes
2 answers

Process a CSV file starting at a predetermined line/row using LumenWorks parser

I am using LumenWorks awesome CSV reader to process CSV files. Some files have over 1 million records. What I want is to process the file in sections. E.g. I want to process 100,000 records first, validate the data and then send this records over…
lukik
  • 3,919
  • 6
  • 46
  • 89
1
vote
1 answer

Error: 'FileId' field header not found. Parameter name: name

I am new to CsvHelper, my apologies if I have missed something in the documentation. I have a CSV file with 200 off columns. Typically there would be close to 65000 rows. Importing these rows into a SQL Database Table was fine, until I added a new…
user12177894
  • 13
  • 2
1
vote
0 answers

C# LumenWorks CSV Reader: Throwing Error for the fields where the headers does not exits?

I am Using LumenWorks CsvReader for processing the CSV file. Currently i am doing validations for the CSV file where i need to throw error if the Header is empty for a field. Example = Below is CSV file contents Header 1,Header 2,Header 3 ,Header…
Akshay Vijapur
  • 310
  • 4
  • 16
1
vote
1 answer

Why can the object be indexed like an array?

In all the examples I see on the CsvReader(link), after reading a record, it is possible to index the CsvReader object itself to retrieve a field's value. For example: using (CsvReader csv = new CsvReader(new StreamReader("data.csv"),…
Old Geezer
  • 14,854
  • 31
  • 111
  • 198
1
vote
0 answers

How to get Lumenworks CsvReader to correctly parse data with unescaped double quotes and commas from a CSV file

I am trying to parse a CSV file using Lumenworks CsvReader. Each data point is wrapped in double quotes, however, some values contain unescaped double quotes within the data, and other values contain commas within the data. The issue I am facing is…
Sentient Entities
  • 341
  • 4
  • 11
0
votes
1 answer

Why is lumenworks returning quotes around a field for a perfectly ordinary CSV file?

I have used lumenworks CSV reader several times before and have never seen this issue. I have a simple CSV file: "1","001333","Test Company","","123 Test St","","Eland","NS","58601","USA","","","","","Company 1","","123 Destination…
lopass
  • 158
  • 10
0
votes
1 answer

Problem not recognizing $router variable in lumen

I am creating modules in a modular way. But there is a problem in defining the new route, and that is that the $router variable does not recognize in the new route. But if used this way, the problem will be solved: $this->app->router->get() But I…
Behrooz Valikhani
  • 75
  • 8
0
votes
0 answers

LumenWorks.CsvReader: How to read Decimal using invariant culture?

I am reading CSV files using LumenWorks.CsvReader. It works fine when I do not try to prescribe a Decimal type column like this: cols = new List { new Column { Name="client", Type=typeof(string) }, new Column { Name="gross_sell",…
pepr
  • 20,112
  • 15
  • 76
  • 139
1
2