Heroku displays an error on importing:

Application Error
An error occurred in the application and your page could not be served. Please try again in a few moments.

If you are the application owner, check your logs for details.

Allo the user to delete uploaded files, need to check:

• what to do with the mappings
• also possible old imports ?

Implement an encoding switch and let user choose their encoding: utf8 , latin1, ISO/IEC 8859-1etc

The ruby csv parser fails when importing google contacts export because it has a UTF16 BOM in it.

We should strip all BOM, and if present autodetect the incoming encoding and convert it to utf-8

Failures:

1. SessionsController GET 'new' should redirect to app canvas url
   Failure/Error: response.body.should =="<script> top.location.href='#{sk_url('abc')}/app/csv-importer'</script>"
   expected: "<script> top.location.href='https://abc.dev.salesking.eu/app/csv-importer'</script>"
   got: "<script> top.location.href='https://abc.dev.salesking.eu/app/csv-import-local'</script>" (using ==)

   ./spec/controllers/sessions_controller_spec.rb:37:in `block (3 levels) in <top (required)>'

This is due to hard coded slug in assert.

Tiny top nav bar with links to:

• Imports
• Mappings
• Attachments

For better usability the import form should be split up into separate parts

1. upload a file
   • attachment_controller, attachments/new
   • show file contents and let user choose Quote character/ column sep
   • ajax csv parsing of file when user changes above e.g. show the parsed result in a table link in openOffice csv import
   • col_sep, quote_char should be moved from the import to the attachment model
2. Create mapping
   • maybe at mappings/new?attachment_id=ID
   • Choose an existing mapping OR create a new
   • Drag&Drop fields like now .. could also need improvement for special fields: date/enums(new ticket)
3. Create import
   • something like: imports/new?attachment_id=ID&mapping_id=ID
   • should we show the data before finally saving it? or is this part of the mapping form?

If CSV file couldn't be imported due to some exception (mainly MalformedCSVError), there will not be any proper message for users. It just shows unclear message 0 rows imported, though there are data in CSV.

the drop event is passing the wrong event.target so the receiving list element does not show the dropped field.
Seems to be a jQuery ui bug: http://bugs.jqueryui.com/ticket/7852

For enum fields the conversion seems to be broken: Herr=>male, Frau=>female

Show all attachments(uploaded csv files) for a user

Field Mappings are already saved in db. Now we should enable the ruse of those when creating a new import.

Maybe the division of upload and mapping could help in the click flow

we should be able to show existing mappings. Add a migration to add the company id to existing ones, so we dont show mappings of somebody else

There is a bug in ActiveResource which does not permit a delete request with our auth-header. So this ticket should also be done in sk-sdk

after uplaoding a file special chars in the preview are brocken.

When trying to create mapping for google.csv (Gmail contacts exported), got this error. Possible duplicate of isse #1

ArgumentError in Mappings#new

Showing /home/vijendra/Desktop/CSV-Import/app/views/mappings/new.html.haml where line #10 raised:

invalid byte sequence in UTF-8
Extracted source (around line #10):

7: %label= t('mappings.source_fields')
8: .input
9: %ul#source-fields
10: - @attachment.rows(1).first.each_with_index do |item, index|
11: %li.field{'data-name' => item, 'data-source' => index}= item
12: .clearfix
13: %p= t('mappings.dnd_info')
Rails.root: /home/vijendra/Desktop/CSV-Import