OK, now I have got my courses sorted so that I am setting an ID I find that I can only import 50!

Asked by Brian Lockwood on 2008-09-14

Below is the course file I want to import, I only end up with 50 Courses. I have over a thousand to import so I will paste here the first 200 and then the 50 I end up with.

13AR-Tu,Tutorial,Tutorial,13AR-Tu
13G-Hi,History,History,13G-Hi
13W-El,English Literature,English Literature,13W-El
13B-Gg,Geography,Geography,13B-Gg
13P-So,Sociology,Sociology,13P-So
13B-En,English,English,13B-En
13MV-Tu,Tutorial,Tutorial,13MV-Tu
13P-Hi,History,History,13P-Hi
13B-Bi2,Biology,Biology,13B-Bi2
13-Gs,General Studies,General Studies,13-Gs
13GW-Tu,Tutorial,Tutorial,13GW-Tu
13P-Ma,Mathematics,Mathematics,13P-Ma
13G-Ch,Chemistry,Chemistry,13G-Ch
13B-Bi1,Biology,Biology,13B-Bi1
13SG-Tu,Tutorial,Tutorial,13SG-Tu
13G-Ar1,Art,Art,13G-Ar1
12-13-Cr,Critical Thinking,Critical Thinking,12-13-Cr
13LO-Tu,Tutorial,Tutorial,13LO-Tu
13G-Md,Media Studies,Media Studies,13G-Md
13LW-Tu,Tutorial,Tutorial,13LW-Tu
13W-Ma,Mathematics,Mathematics,13W-Ma
13B-El,English Literature,English Literature,13B-El
13W-Ch1,Chemistry,Chemistry,13W-Ch1
13G-Ph,Physics,Physics,13G-Ph
13P-Ps,Psychology,Psychology,13P-Ps
13G-P&E,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,13G-P&E
13W-Ch2,Chemistry,Chemistry,13W-Ch2
13W-Fr,French,French,13W-Fr
13P-Md,Media Studies,Media Studies,13P-Md
13W-Pe,Physical Education,Physical Education,13W-Pe
13DL-Tu,Tutorial,Tutorial,13DL-Tu
13G-Pe,Physical Education,Physical Education,13G-Pe
13W-Go,Govt. & Politics,Govt. & Politics,13W-Go
13P-Eb,Econ+Bus,Econ+Bus,13P-Eb
13P-Dt,Design and Technology,Design and Technology,13P-Dt
13B-Ec,Economics,Economics,13B-Ec
12-13Pt,Performance Studies,Performance Studies,12-13Pt
13BL-Tu,Tutorial,Tutorial,13BL-Tu
13P-Mu,Music,Music,13P-Mu
13G-Ar2,Art,Art,13G-Ar2
13W-Th,Theatre Studies,Theatre Studies,13W-Th
13B-Ps,Psychology,Psychology,13B-Ps
13W-En,English,English,13W-En
13W-Cp,Computer Studies,Computer Studies,13W-Cp
13G-Gm,German,German,13G-Gm
11RW-En,English,English,11RW-En
11JG-Tu,Tutorial,Tutorial,11JG-Tu
11c-Rs2,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11c-Rs2
11B-Dr,Drama,Drama,11B-Dr
11P-Ap,Applied Art,Applied Art,11P-Ap
11G-Ap,Applied Art,Applied Art,11G-Ap
11LT-Dt1,Design and Technology,Design and Technology,11LT-Dt1
11H5-Ma,Mathematics,Mathematics,11H5-Ma
11c-Pe1,Physical Education,Physical Education,11c-Pe1
11S1P-Sc,Science,Science,11S1P-Sc
11JG-Ct,Citizenship,Citizenship,11JG-Ct
11CR-En,English,English,11CR-En
11SS-Tu,Tutorial,Tutorial,11SS-Tu
11c-Rs1,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11c-Rs1
11G-Bu,Business Studies,Business Studies,11G-Bu
11B-Et,Electronics,Electronics,11B-Et
11P-It,Information Technology,Information Technology,11P-It
11F1-Ma,Mathematics,Mathematics,11F1-Ma
11S3D-Sc,Science,Science,11S3D-Sc
11SC-Ct,Citizenship,Citizenship,11SC-Ct
11EJ-Tu,Tutorial,Tutorial,11EJ-Tu
11B-Gg2,Geography,Geography,11B-Gg2
11P-Bu,Business Studies,Business Studies,11P-Bu
11LT-DiDA,DiDA It,DiDA It,11LT-DiDA
11G-DiDA,DiDA It,DiDA It,11G-DiDA
11H3-Ma,Mathematics,Mathematics,11H3-Ma
11S2D-Sc,Science,Science,11S2D-Sc
11EJ-Ct,Citizenship,Citizenship,11EJ-Ct
11S5P-Sc,Science,Science,11S5P-Sc
11CL-En,English,English,11CL-En
11MP-Tu,Tutorial,Tutorial,11MP-Tu
11b-Rs3,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11b-Rs3
11B-Gp,Graphic Products,Graphic Products,11B-Gp
11P-Pe,Physical Education,Physical Education,11P-Pe
11LT-Cb,Combined Studies,Combined Studies,11LT-Cb
11G-Cb,Combined Studies,Combined Studies,11G-Cb
11b-Pe1,Physical Education,Physical Education,11b-Pe1
11MP-Ct,Citizenship,Citizenship,11MP-Ct
11RS-Tu,Tutorial,Tutorial,11RS-Tu
11S4P-Sc,Science,Science,11S4P-Sc
11RS-Ct,Citizenship,Citizenship,11RS-Ct
11MG-En,English,English,11MG-En
11SH-Tu,Tutorial,Tutorial,11SH-Tu
11c-Rs3,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11c-Rs3
11LT-Dt2,Design and Technology,Design and Technology,11LT-Dt2
11G-Pe,Physical Education,Physical Education,11G-Pe
11F5-Ma,Mathematics,Mathematics,11F5-Ma
11S1D-Sc,Science,Science,11S1D-Sc
11P-Gg1,Geography,Geography,11P-Gg1
11SH-Ct,Citizenship,Citizenship,11SH-Ct
11S4D-Sc,Science,Science,11S4D-Sc
11CI-En,English,English,11CI-En
11a-Rs3,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11a-Rs3
11B-Gg1,Geography,Geography,11B-Gg1
11a-Pe1,Physical Education,Physical Education,11a-Pe1
11LT-Gm2,German,German,11LT-Gm2
11G-Dr2,Drama,Drama,11G-Dr2
11B-Fn,Home Economics Food & Nutrition,Home Economics Food & Nutrition,11B-Fn
11c-Pe3,Physical Education,Physical Education,11c-Pe3
11HY-En,English,English,11HY-En
11b-Rs1,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11b-Rs1
11KH-Tu,Tutorial,Tutorial,11KH-Tu
11P-Gg2,Geography,Geography,11P-Gg2
11KH-Ct,Citizenship,Citizenship,11KH-Ct
11LT-Fr1,French,French,11LT-Fr1
11G-Hi,History,History,11G-Hi
11H2-Ma,Mathematics,Mathematics,11H2-Ma
11G-Dr1,Drama,Drama,11G-Dr1
11B-Bu,Business Studies,Business Studies,11B-Bu
11H4-Ma,Mathematics,Mathematics,11H4-Ma
11LT-Gm3,German,German,11LT-Gm3
11b-Pe3,Physical Education,Physical Education,11b-Pe3
11-GCSE Da,Dance,Dance,11-GCSE Da
11RB-En,English,English,11RB-En
11a-Rs1,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11a-Rs1
11JW-Tu,Tutorial,Tutorial,11JW-Tu
11B-It,Information Technology,Information Technology,11B-It
11H1-Ma,Mathematics,Mathematics,11H1-Ma
11a-Pe3,Physical Education,Physical Education,11a-Pe3
11JW-Ct,Citizenship,Citizenship,11JW-Ct
11LT-Fr2,French,French,11LT-Fr2
11c-Pe2,Physical Education,Physical Education,11c-Pe2
11LT-Gm1,German,German,11LT-Gm1
11a-Pe4,Physical Education,Physical Education,11a-Pe4
11FL2-Fr,French,French,11FL2-Fr
11B-Hi2,History,History,11B-Hi2
11FG-Ma,Mathematics,Mathematics,11FG-Ma
11LT-Tx,Textiles,Textiles,11LT-Tx
11c-Pe4,Physical Education,Physical Education,11c-Pe4
11LT-Fr3,French,French,11LT-Fr3
11P-Ar1,Art,Art,11P-Ar1
11B-Hi1,History,History,11B-Hi1
11b-Pe2,Physical Education,Physical Education,11b-Pe2
11FL2-Gm,German,German,11FL2-Gm
11G-Gg,Geography,Geography,11G-Gg
11P-Hi,History,History,11P-Hi
11a-Pe2,Physical Education,Physical Education,11a-Pe2
11S2P-Sc,Science,Science,11S2P-Sc
11LT-Gp,Graphic Products,Graphic Products,11LT-Gp
11G-Ar2,Art,Art,11G-Ar2
11b-Pe4,Physical Education,Physical Education,11b-Pe4
11G-It,Information Technology,Information Technology,11G-It
11P-Sc,Science,Science,11P-Sc
11S0-Sc,Science,Science,11S0-Sc
11GB-En,English,English,11GB-En
11b-Rs2,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11b-Rs2
11S3P-Sc,Science,Science,11S3P-Sc
11DI-En,English,English,11DI-En
11RR-Tu,Tutorial,Tutorial,11RR-Tu
11a-Rs2,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,11a-Rs2
11LT-Fn,Home Economics Food & Nutrition,Home Economics Food & Nutrition,11LT-Fn
11RR-Ct,Citizenship,Citizenship,11RR-Ct
11B-Tx,Textiles,Textiles,11B-Tx
11P-Dr,Drama,Drama,11P-Dr
11B-Dt,Design and Technology,Design and Technology,11B-Dt
11G-Ar1,Art,Art,11G-Ar1
11B-Mu,Music,Music,11B-Mu
11F6-Ma,Mathematics,Mathematics,11F6-Ma
11P-Ar2,Art,Art,11P-Ar2
11PF-Tu,Tutorial,Tutorial,11PF-Tu
11PF-Ct,Citizenship,Citizenship,11PF-Ct
11FB1-Ma,Mathematics,Mathematics,11FB1-Ma
9GB-Tu,Tutorial,Tutorial,9GB-Tu
9GB-Rs,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,9GB-Rs
9GB-Hi,History,History,9GB-Hi
9GB-Gg,Geography,Geography,9GB-Gg
9GB-Dr,Drama,Drama,9GB-Dr
9GB-Mu,Music,Music,9GB-Mu
9G-Pe1,Physical Education,Physical Education,9G-Pe1
9GB-Ct,Citizenship,Citizenship,9GB-Ct
9GB-En,English,English,9GB-En
9D3-He,Home Economics,Home Economics,9D3-He
9D3-Dt,Design and Technology,Design and Technology,9D3-Dt
9D3-It,Information Technology,Information Technology,9D3-It
9G-Gm2,German,German,9G-Gm2
9G-Pe2,Physical Education,Physical Education,9G-Pe2
9D2-He,Home Economics,Home Economics,9D2-He
9D2-Dt,Design and Technology,Design and Technology,9D2-Dt
9D2-It,Information Technology,Information Technology,9D2-It
9G-Gm3,German,German,9G-Gm3
9NJ-Dr,Drama,Drama,9NJ-Dr
9NJ-Gg,Geography,Geography,9NJ-Gg
9NJ-Hi,History,History,9NJ-Hi
9NJ-Rs,Religious Studies-Philosophy & Ethics,Religious Studies-Philosophy & Ethics,9NJ-Rs
9NJ-Tu,Tutorial,Tutorial,9NJ-Tu
9F-Pe1,Physical Education,Physical Education,9F-Pe1t
9Ma3,Mathematics,Mathematics,9Ma3
9NJ-Ct,Citizenship,Citizenship,9NJ-Ct
9NJ-En,English,English,9NJ-En
9F-Fr3a,French,French,9F-Fr3a
9A1-He,Home Economics,Home Economics,9A1-He
9A1-Dt,Design and Technology,Design and Technology,9A1-Dt
9A1-It,Information Technology,Information Technology,9A1-It
9NJ-Mu,Music,Music,9NJ-Mu
9GG-Mu,Music,Music,9GG-Mu

The ones I end up with are

10G-iM
11-GCSE Da
11B-Bu
11B-Dt
11B-Et
11B-Mu
11B-Tx
11DI-En
11FB1-Ma
11FL2-Gm
11G-Ap
11G-Cb
11G-DiDA
11G-Gg
11G-It
11LT-Fn
11LT-Fr3
11LT-Gp
11P-Ar2
11P-Dr
11P-Hi
11PF-Ct
11S3P-Sc
11a-Rs2
11b-Pe4
12-13-Cr
12-13-Mt
12-13Pt
13-Gs
13-Py
13AR-Tu
13B-Bi1
13B-Ec
13B-El
13B-Ps
13G-Ph
13P-Eb
13P-MaFm
13P-Md
13P-So
13W-Ch2
13W-Cp
13W-Go
13W-Th
7A2-He
9F-ExEn1
OuArts
OuLang
OuMaths
OuSci

Question information

Language:
English Edit question
Status:
Solved
For:
SchoolTool Edit question
Assignee:
No assignee Edit question
Solved by:
Ignas Mikalajūnas
Solved:
2008-09-15
Last query:
2008-09-15
Last reply:
2008-09-15
Brian Lockwood (brianlockwood) said : #1

I needed to add the extra two columns in order to get an id. Because when I import my 22000 sections, I need all the courses to have an id otherwise the courses are not found. The id is described as optional in the import but if you are importing ALL tghe contents of a database then your courses need an id or the section import fails.

I have so far managed to get all my persons in!

Tom Hoffman (tom-hoffman) said : #2

So... did you get the courses and sections in?

Best Ignas Mikalajūnas (ignas) said : #3

The problem it seems is that you are providing 4 columns while the
form expects 3...

Title, Description, ID

your ID column has the description repeated in it...

If you would just remove the third column - the csv data should import
properly, at least it does so on my machine.

Ignas

Brian Lockwood (brianlockwood) said : #4

Oops! I will get on with that. Sorry Ignas!

Brian Lockwood (brianlockwood) said : #5

Thanks Ignas Mikalajūnas, that solved my question.

Tom Hoffman (tom-hoffman) said : #6

Lesson for me: look for the obvious solutions first...