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

Attachments

2

Activity

Show:

Norbert Bede August 22, 2020 at 7:00 PM

lack of interest. 5 years

Thomas Bayen August 7, 2014 at 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 July 16, 2014 at 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

Won't Fix

Details

Assignee

Reporter

Priority

Created July 14, 2014 at 9:33 AM
Updated October 2, 2020 at 4:14 PM
Resolved August 22, 2020 at 7:00 PM