Opened 11 years ago

Closed 10 years ago

Last modified 10 years ago

#142 closed enhancement (wontfix)

Import participants from csv file

Reported by: anonymous Owned by: Stein Tore Erdal
Priority: major Milestone:
Component: FsComp Version:
Keywords: Cc:

Description

I suggest that the mechanism for uploading participants from a spreadsheet be changed. I would like to see the option to import the users from inside FSComp rather than push the users into FSComp from the spreadsheet. Using CSV as the file format rather than XLS would eliminate the need to have Excel and would make it easier to integrate with registration facilities on web sites.

At the moment if I want to capture registrations on a web site I then have to export the info to a csv file, then copy it into your spreadsheet (assuming I have Excel installed) then upload it to the FSComp database.

It would be much easier for me to export from my web site into a csv file and then open FSComp and go File > Import > Paticipants from CSV

Change History (2)

comment:1 Changed 10 years ago by Stein Tore Erdal

Resolution: wontfix
Status: newclosed

Trouble with CSV is that is not a fixed format that every program that produce so called CSV files follows.

Different programs produce different types of CSV files.

Same programs on pc's with different regional settings etc (speaking Windows here) produce different types of CSV files.

Just about impossible to foresee all variants.

Since the fsdb file is a simple xml file it is very simple to write xslt that will transform whatever into a valid fsdb file.

Stein-Tore

comment:2 Changed 10 years ago by anonymous

The answer to that problem is simple, just define what formatting you require.

All spreadsheets can be configured to use the required character encodings, separators etc. The columns can easily be reordered and headers specified as you require. Web sites set up by competition organisers can likewise be configured to generate a csv file to your specifications. But they can't generate an excel spreadsheet with your macros in it.

CSV files are not rocket science, in fact they are the lowest common denominator. Asking your users to write xslt transforms will likely only result in a blank stare in reply.

Please reconsider.

Thanks Wayne

Note: See TracTickets for help on using tickets.