Make csv-import more flat

I am afraid that adding more import formats would still cost more than writing a simple python or whatever language you like script that would convert a csv/xls in a format you are proposing into a set of csv files/xls file you can paste into a schooltool import file.

thx Ignas!

Maybe it is a misunderstanding.

I'm talking about this form: http://localhost:7080/persons/csvimport.html

In the end it's only a further optional attribute namend "memberOf" I'm asking for.

So that the import would look like this:

jjones, Jimmy, Jones, group1
jbjones, Jim Bob, Jones, group2
howard, Howard, Jobs, group1

-baeus

Oh, I was thinking about schooltool xls import view that can actually
do what you are asking for, I mean I think you can just leave the
users and groups worksheets with information that you have
and import it through there.

On Mon, Nov 19, 2012 at 4:46 PM, baeus <<email address hidden>
> wrote:

> Question #214498 on SchoolTool changed:
> https://answers.launchpad.net/schooltool/+question/214498
>
> Status: Answered => Open
>
> baeus is still having a problem:
> thx Ignas!
>
> Maybe it is a misunderstanding.
>
> I'm talking about this form:
> http://localhost:7080/persons/csvimport.html
>
> In the end it's only a further optional attribute namend "memberOf" I'm
> asking for.
>
> So that the import would look like this:
>
> jjones, Jimmy, Jones, group1
> jbjones, Jim Bob, Jones, group2
> howard, Howard, Jobs, group1
>
> -baeus
>
> --
> You received this question notification because you are an answer
> contact for SchoolTool.
>

baeus,

We've essentially deprecated the CSV imports in favor of the .XLS import. We leave the CSV around because they still work and they're simple, but all our improvements are going into the spreadsheets.

I agree. csv-import is very simple and easy. I pasted 3000 persons at once without anything going wrong. Spreadsheet is by experience more adventure because of charset-problems.

I know that "groups"-sheet in xls. I exported all my existing 130 groups. Now I face the problem to place 3000 students to that groups. For thjs moment it seems I have to examine spreadsheet-scripting to check for every student the fitting group, insert lines after "Description"-cell, add a "Members"-Cell, add the students after a blank line.

Is that correct, or am I blind to blind to see a more comfortbale solution?

OK... I'll try not to fixate too much on the csv vs xls issue.

If you've got a specific charset problem with the spreadsheets, please let us know exactly what it is so we can try to address it.

What format do you start with for your group/section data? Is that being exported from something else?

We can look into adding what you want -- it makes sense but also adds some complications, e.g., you then have to create groups and thus years before people -- but we'd be doing it to the spreadsheets, not the csv.

--Tom

Spreadsheet is ok.

What about splitting the "groups"-sheet into two sheets?

First sheet called maybe "groupDefinitions"
The header may look like this: "Group Title";"Group_ID";"School Year";"Description"

Second sheet called maybe "groupMemberships" and probbably looks like this:
"Member";"GroupID"

-baeus

I've converted this to a bug.

Close an old question