[Bug 427] New: flat file import: support delimiters other than tab
GCD Tech Bugs
Web Browser: ---
Summary: flat file import: support delimiters other than tab
Product: GCD Online
Version: -.- future
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P3
Component: data entry
AssignedTo: gcd-...@googlegroups.com
ReportedBy: ad...@hellug.gr
Estimated Hours: 0.0
Since tabs are invisible, it's easy to make a mistake when creating a flat file
for import with an editor with no "view invisible characters" option.
It might be useful to allow using a different printable character that's
unlikely to appear in an actual index (e.g. |, @, ^).
It would be annoying having to select this delimiter whenever you upload a new
file, so how about allowing each indexer to configure this from their profile,
with tab as default?
--
Configure bugmail: http://dev.comics.org/bugs/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
GCD Tech Bugs
Jochen Garcke <gcd...@garcke.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |gcd...@garcke.de
AssignedTo|gcd-...@googlegroups.com |gcd...@garcke.de
Status|NEW |ASSIGNED
--- Comment #1 from Jochen Garcke <gcd...@garcke.de> 2010-12-20 22:04:14 PST ---
we should use the python csv-package to allow other style of imports, in
particular
" ", " "
as this is the most common
different separators like suggested are unusual and shouldn't be supported.
GCD Tech Bugs
Jochen Garcke <gcd...@garcke.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
AssignedTo|gcd...@garcke.de |gcd-...@googlegroups.com
Status|ASSIGNED |NEW
Summary|flat file import: support |flat file import: support
|delimiters other than tab |csv import
--- Comment #2 from Jochen Garcke <gcd...@garcke.de> 2010-12-20 22:43:49 PST ---
we should use
http://docs.python.org/library/csv.html
but for now I am not going to work on it after all...
GCD Tech Bugs
Jochen Garcke <gcd...@garcke.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|flat file import: support |flat file import: support
|csv import |csv/odf/xls import
--- Comment #3 from Jochen Garcke <gcd...@garcke.de> 2011-01-08 07:38:56 PST ---
there is also a python package to import odf (ISO standard OpenDocument format,
e.g used by OpenOffice)
http://code.google.com/p/py-odftools/
and a python package for Excel it seems exists as well
http://pypi.python.org/pypi/xlrd
Will be very low in my list of things to do. But if someone can figure out how
to use these to get a list of each row in the table read, the rest of the
actual import is easy and I can help with that.
If this happen it would also need some change in the upload ui to figure out
which file format it should be. Go by file extension ?
GCD Tech Bugs
Jochen Garcke <gcd...@garcke.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |722
GCD Tech Bugs
Jochen G. <gcd...@garcke.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
AssignedTo|gcd-...@googlegroups.com |gcd...@garcke.de
Status|NEW |ASSIGNED
Version|-.- future |0.6 kin-der-kids
GCD Tech Bugs
Jochen G. <gcd...@garcke.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution| |FIXED
--- Comment #4 from Jochen G. <gcd...@garcke.de> 2012-04-10 21:02:38 PST ---
http://reviews.comics.org/r/1001/