Project

General

Profile

Segnalazione #107

Segnalazione #76: App user

Utenti: importazione da file CSV

Added by Christopher R. Gabriel almost 6 years ago. Updated almost 6 years ago.

Status:
Chiuso
Priority:
Normale
Assignee:
Start date:
12/12/2016
Due date:
% Done:

100%


Description

Importazione di utenti da file CSV, dove si forniscono gli estremi di parsing e la definizione delle colonne.

ALlego screenshot di applicazione gtk+

import_csv.png View (56.7 KB) Christopher R. Gabriel, 12/12/2016 01:38 PM

Associated revisions

Revision 5659ed08 (diff)
Added by Enrico Zini almost 6 years ago

Added javascript dependencies and initial test page. refs: #107

Revision 83dda0ee (diff)
Added by Enrico Zini almost 6 years ago

Redone with jQuery UI. refs: #107

Revision e26503da (diff)
Added by Enrico Zini almost 6 years ago

Use <th> to declare fields, preview csv contents. refs: #107

Revision 0f355586 (diff)
Added by Enrico Zini almost 6 years ago

Add extra padding <th> for extra columns in the CSV. refs: #107

Revision 38a7effd (diff)
Added by Enrico Zini almost 6 years ago

Applied feedback from Lynoure. refs: #107

Revision e1f6f65d
Added by Enrico Zini almost 6 years ago

Sync with master. refs: #107

Revision 563f081e (diff)
Added by Enrico Zini almost 6 years ago

Added interaction modules to jquery-ui. refs: #107

Revision 1d4b8bbb (diff)
Added by Enrico Zini almost 6 years ago

Use a callback to create padding THs. refs: #107

Revision 62d7feb0 (diff)
Added by Enrico Zini almost 6 years ago

Make the table headers sortable. refs: #107

Revision fe0552f1 (diff)
Added by Enrico Zini almost 6 years ago

Implemented drag/drop and swap of items on drop. refs: #107

Revision 68238a55 (diff)
Added by Enrico Zini almost 6 years ago

Highlight columns with classes. refs: #107

Revision c6e98983 (diff)
Added by Enrico Zini almost 6 years ago

Highlight while dragging, and allow to drop where one started. refs: #107

Revision c9e7589c (diff)
Added by Enrico Zini almost 6 years ago

Implemented striking over leading lines to be ignored. refs: #107

Revision b057f4f3 (diff)
Added by Enrico Zini almost 6 years ago

More table coloring examples. refs: #107

Revision 17c93a05 (diff)
Added by Enrico Zini almost 6 years ago

Implemented generation of parsed data. refs: #107

Revision a28ecc64 (diff)
Added by Enrico Zini almost 6 years ago

Added trigger to notify when there is data. refs: #107

Revision 7a8a9e3e (diff)
Added by Enrico Zini almost 6 years ago

Better validator for integers. refs: #107

Revision ec51f0ea (diff)
Added by Enrico Zini almost 6 years ago

Implemented initial field autodetect. refs: #107

Revision eade9a6a (diff)
Added by Enrico Zini almost 6 years ago

Do not try to read whole files for a preview. refs: #107

Revision bb4698e4 (diff)
Added by Enrico Zini almost 6 years ago

Tell papaparse to stop parsing at self.options.preview_rows. refs: #107

Revision a9928c97 (diff)
Added by Enrico Zini almost 6 years ago

Made a couple of method names more descriptive. refs: #107

Revision 15563282 (diff)
Added by Enrico Zini almost 6 years ago

Refactored without using jQuery UI interactions. refs: #107

Revision 82a4e70b (diff)
Added by Enrico Zini almost 6 years ago

Add options.drag_source_class to the element being dragged. refs: #107

Revision 0736d9ae (diff)
Added by Enrico Zini almost 6 years ago

Finalize dragging on dragend instead of drop, to deal well with dropping outside the intende targets. refs: #107

Revision 09b44d93 (diff)
Added by Enrico Zini almost 6 years ago

Allow to drop on the whole of table columns. refs: #107

Revision 01557bd1 (diff)
Added by Enrico Zini almost 6 years ago

Removed debugging prints. refs: #107

Revision 1b622a54 (diff)
Added by Enrico Zini almost 6 years ago

Export all the information gathered by the plugin. refs: #107

Revision 293f9d15 (diff)
Added by Enrico Zini almost 6 years ago

Renamed field.index to field.column and added a sample server-side implementation. refs: #107

Revision d82c2473 (diff)
Added by Enrico Zini almost 6 years ago

Also add first_row to the form. refs: #107

Revision d9f27028 (diff)
Added by Enrico Zini almost 6 years ago

Allow to unassign and reassign fields. refs: #107

Revision a8c3b122 (diff)
Added by Enrico Zini almost 6 years ago

Trigger changed event when unassigning columns. refs: #107

Revision 77cd7834 (diff)
Added by Enrico Zini almost 6 years ago

Removed debugging print. refs: #107

Revision aa743956
Added by Enrico Zini almost 6 years ago

Sync with master. refs: #107

Revision 5c9d05c9 (diff)
Added by Enrico Zini almost 6 years ago

Added interaction modules to jquery-ui. refs: #107

Revision 0071a1eb (diff)
Added by Enrico Zini almost 6 years ago

Use a callback to create padding THs. refs: #107

Revision 915c6882 (diff)
Added by Enrico Zini almost 6 years ago

Make the table headers sortable. refs: #107

Revision 72c3deb3 (diff)
Added by Enrico Zini almost 6 years ago

Implemented drag/drop and swap of items on drop. refs: #107

Revision 000790dd (diff)
Added by Enrico Zini almost 6 years ago

Highlight columns with classes. refs: #107

Revision 35cb134e (diff)
Added by Enrico Zini almost 6 years ago

Highlight while dragging, and allow to drop where one started. refs: #107

Revision 464f8819 (diff)
Added by Enrico Zini almost 6 years ago

Implemented striking over leading lines to be ignored. refs: #107

Revision 454ad1c5 (diff)
Added by Enrico Zini almost 6 years ago

More table coloring examples. refs: #107

Revision 28cc6f73 (diff)
Added by Enrico Zini almost 6 years ago

Implemented generation of parsed data. refs: #107

Revision 624d2e56 (diff)
Added by Enrico Zini almost 6 years ago

Added trigger to notify when there is data. refs: #107

Revision bafc9ff8 (diff)
Added by Enrico Zini almost 6 years ago

Better validator for integers. refs: #107

Revision 525429df (diff)
Added by Enrico Zini almost 6 years ago

Implemented initial field autodetect. refs: #107

Revision 320b2321 (diff)
Added by Enrico Zini almost 6 years ago

Do not try to read whole files for a preview. refs: #107

Revision 40fa3117 (diff)
Added by Enrico Zini almost 6 years ago

Tell papaparse to stop parsing at self.options.preview_rows. refs: #107

Revision d93f6b04 (diff)
Added by Enrico Zini almost 6 years ago

Made a couple of method names more descriptive. refs: #107

Revision 0faae8d3 (diff)
Added by Enrico Zini almost 6 years ago

Refactored without using jQuery UI interactions. refs: #107

Revision 08276fae (diff)
Added by Enrico Zini almost 6 years ago

Add options.drag_source_class to the element being dragged. refs: #107

Revision 17f6eb53 (diff)
Added by Enrico Zini almost 6 years ago

Finalize dragging on dragend instead of drop, to deal well with dropping outside the intende targets. refs: #107

Revision c9061d1e (diff)
Added by Enrico Zini almost 6 years ago

Allow to drop on the whole of table columns. refs: #107

Revision 26343eb0 (diff)
Added by Enrico Zini almost 6 years ago

Removed debugging prints. refs: #107

Revision 8e55adc2 (diff)
Added by Enrico Zini almost 6 years ago

Export all the information gathered by the plugin. refs: #107

Revision a5504dee (diff)
Added by Enrico Zini almost 6 years ago

Renamed field.index to field.column and added a sample server-side implementation. refs: #107

Revision a92c2ddd (diff)
Added by Enrico Zini almost 6 years ago

Also add first_row to the form. refs: #107

Revision 44d0e272 (diff)
Added by Enrico Zini almost 6 years ago

Allow to unassign and reassign fields. refs: #107

Revision d98117f4 (diff)
Added by Enrico Zini almost 6 years ago

Trigger changed event when unassigning columns. refs: #107

Revision 319b3a20 (diff)
Added by Enrico Zini almost 6 years ago

Removed debugging print. refs: #107

Revision db449144 (diff)
Added by Enrico Zini almost 6 years ago

Added csv import form. refs: #107

Revision 1df3e438 (diff)
Added by Enrico Zini almost 6 years ago

Styled a bit, thanks to Christopher. refs: #107

Revision 0466513f (diff)
Added by Enrico Zini almost 6 years ago

Deal with CSVs with a small number of rows and/or columns. refs: #107

Revision 46169e98 (diff)
Added by Enrico Zini almost 6 years ago

Implemented parsing and validation of CSV server-side. refs: #107

Revision 75b147bd (diff)
Added by Enrico Zini almost 6 years ago

Import users. refs: #107

Revision f1fa057b (diff)
Added by Enrico Zini almost 6 years ago

Removed test CSV import. refs: #107

Revision 9a557cc5 (diff)
Added by Enrico Zini almost 6 years ago

Removed another test piece. refs: #107

Revision 58902492
Added by Enrico Zini almost 6 years ago

Implemented CSV import. Fixes #107

Revision a3b1cd84
Added by Enrico Zini almost 6 years ago

Implemented CSV import. Fixes #107

History

#1 Updated by Christopher R. Gabriel almost 6 years ago

  • Assignee set to Enrico Zini

Come discusso:

  • creiamo singola libreria javascript che legge il file
  • questa viene usata nei template che forniranno la mappa dei campi interessanti e la url della vista che ricevera' i dati
  • il javascript chiedera' i dettagli del csv (comma o semicolon separated, etc) e mostrera' una anteprima del parsing
  • sempre il javascript chiedera' il mapping tra i campi del csv e quelli indicati come richiesti.

http://mounirmesselmeni.github.io/2012/11/20/reading-csv-file-with-javascript-and-html5-file-api/

#2 Updated by Anonymous almost 6 years ago

  • Status changed from Nuovo to Risolto
  • % Done changed from 0 to 100

#3 Updated by Enrico Zini almost 6 years ago

  • Status changed from Risolto to Chiuso

Also available in: Atom PDF