Import File Loader - Specify First and last Row No improvement

Description

i face the problem with import file when importing data from mobile scanner (cipherlab) trough csv by scheduler.

I need to specify to read First row, where valid data starting in csv, and do not process it.

example: my csv file including

example.csv
r1. string (do not want import)
r2. header (do not want import, just specify columns)
r3. data (i want to start import from this row)

i suggest to add to file loader format and import file loader.

Field1. First Row - Specify row number, where import starting
Field2. Last Row / Specify row number, where import stopping
Field3. Field Name Row - just describe file format.

business logic
1. user specify import loader format - set first row...etc.
2. user opens import file loader, selects the format. (first row loaded)
3. start import. (system starts data processing from first row until last row if specified, otherwise go at the file end.)

this could be running by scheduler too, then first row will be specified as parameter.

norbert

Environment

None

Activity

Show:
Norbert Bede
July 16, 2014, 6:05 PM
Edited

example file for testing
row1-header
row2, row12,row13 - do not import
row3 to row 12 want import

you can use import format in gardenworld Import Business Partners

Thomas Bayen
August 7, 2014, 3:48 PM

I created an import loader definition with a date and used a date format for that column. My CSV file contains a single header line. I am quite sure that this worked in older versions. The result was one single row with empty fields that was not imported at the end.

In the current version I get an error about "Unparseable date" and can not import the file without loading it and removing the first header line.

User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.152 Safari/537.36

Norbert Bede
August 22, 2020, 7:00 PM

lack of interest. 5 years

Assignee

Unassigned

Reporter

Norbert Bede

Tested By

None

Priority

Major
Configure