New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

File File Import Wizard fails when column count is inconsistent #3654

Open
amtwo opened this Issue Dec 28, 2018 · 0 comments

Comments

Projects
None yet
2 participants
@amtwo
Copy link

amtwo commented Dec 28, 2018

Issue Type: Bug

  1. Create a CSV file where the header row contains 5 columns of data, but the first 50+ rows have only 4 columns of data. At least one row at the end of the file should have all 5 columns fo data, matching the header.
  2. Use the Flat File Import Wizard to import the file. Notice on the Preview step that it samples the first 50 rows, and displays only 4 columns of data.
  3. Execute the import, and it will end with the error "Error inserting data into table." with no additional details.

The import fails because the wizard is attempting to import only the 4 columns, and when it gets to the row with 5 columns, it fails.

The wizard should at least be able to bubble up that the file has an inconsistent column count, so that I know the file is not properly formatted. Ideally, it would handle this gracefully, similar to the way the Import-Csv PowerShell cmdlet does, and successfully import the file, even with inconsistent column counts

Azure Data Studio version: azuredatastudio 1.2.4 (1ebfd02, 2018-11-02T21:50:52.634Z)
OS version: Windows_NT x64 10.0.17134

System Info
Item Value
CPUs Intel(R) Core(TM) i7-8650U CPU @ 1.90GHz (8 x 2112)
GPU Status 2d_canvas: enabled
checker_imaging: disabled_off
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: disabled_software
rasterization: enabled
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled
Memory (System) 15.93GB (2.59GB free)
Process Argv C:\Program Files\Azure Data Studio\azuredatastudio.exe
Screen Reader no
VM 50%

@abist abist added import bug labels Dec 29, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment