Merged XML file creating errors

Going to depend what errors they are? I see it's not all the same errors on all the learners (because 558 doesn't divide neatly by 74), so could be all sorts of things...

Are any (all?) of the apps in the other file doing some AEB or something? Multiple learner records with same NI/ULN would cause an error I think? Or are they maybe using the same kind of learner ref numbering system, so you've got "duplicate" learner refs in the two files?

Hi Steveh,

Thanks for the response.

The errors all relate to the file for 74 apprenticeship learners and the error codes are a combination of R68 and R124. For some learners there are more R68 errors than others. 

R124 = The learner must not have overlapping programme aims
R68= The learner must not have more than one Apprenticeship Financial Record with the same Apprenticeship financial type, code and date

These errors do not come up when the file is uploaded individually and they have different learners on that course. They also have unique learner reference numbers that are different to the ones we use on our Skills Bootcamp courses.

Ah, looks like you're going to have to look at the raw xml (you can open it in notepad) to see what it's doing... Looks like something has gone wrong in the merge if those errors weren't showing in the App only file. Not to ask the daftest question, but you didn't add the App file twice before merging did you?

The number of R68s would change depending on the number of financial records (so, eg a learner with TNP1, TNP2 and three PMR records would have more errors than one with just TNP1 and TNP2 because more records).

Hi Henry

Yes, have used it in the past (by which I mean, when we first moved to xml from the flat file because I am *very* old!!!), generally find the current file is fine in boring old notepad, possibly because EBS exports it with linebreaks in!

Hi all,

Thanks for the input.

I opened the XML file in notepad but not sure I have the know how to decipher it!

I will raise on that link you sent Henry - thank you

Hi all,

Update on this one.

I found out that I had all the learners in my ILR submission tool (for both courses) and needed to exclude the apprenticeship learners before exporting to stop the aims being duplicated when I merged the two files (I know you said something like this Steveh).

So should be fine going forwards.

Thanks

James

Ahaaaaaaa, so, um, why do you need to merge? Just make one file out of LET for all of it? FIS can totally deal with all the different funding streams at once...