No, don’t copy paste the Excel file’s contexts. Drag the xls file onto your Tinderbox window. You should get a note per student. If you’ve, followed the suggestions above, everything should arrive in the right place format. If you didn’t it should all import OK, but to you may have to do that same work, just after import.
Let us know if it imports OK. If it fail, please post link to a cut down version of the XLS file so we replicate the issue (noting my earlier point about possible personal/sensitive data therein).
I’m doing something wrong. I dragged the xls into the Tinderbox pain, but it still creates only one note. The column header is labeled $Name. I’m sure there’s something simple I keep neglecting to do. SIGH!
Carolivia
Oh dear, sorry to hear that. But I can’t see the the example file (as per above) . <hint>
One thought, you say you have an Excel column head called “$Name”. Sadly, by calling it “$Name”, not “Name” you are (inadvertently) asking Tinderbox to find the title of that column in an attribute called $Name that doesn’t exist.
Don’t feel bad. A convention in the forum is to refer to the names of attribute by using a $-predefined name. This is because many posters can’t or won’t look up method for mark-up in posts. So, usually, the context is enough to explain whether $Name means the value of attribute Name' or an attribute called ‘Name’. But much scope for confusion, no worries.
If any of your Excel file headers include a ‘$’ prefix, delete the ‘$$’ and try again. Even better `, upload a zip† of your XLS so be can see how it behaves.
†. If lost, sent me a forum direct message, ideally with a link to the file (in confidence) and I’ll try take a look. I quite appreciate the nature of looming deadlines.
One column called $Name. But even if it was called Name it won’t help as there is no data apart from 25 cells in column A from “OA” through “OZ”.
There is no student data I can see. My hunch is you are downloading a report from some admin system that is malfunctioning and not retunring any data (if this is the actual output). I’f suggest perhaps ringing departmental IT support (if anyone’s in on a Sunday) and ask if they can fix the report so it returns actual data.
The complete file imported perfectly when I imported it from numbers. I took the excel file, saved it in numbers, and then imported to Tinderbox. VICTORY!!
The problem may have been that I don’t know excel very well. I take the excel files sent to me by the administration and save the columns I actually need in Numbers. I do all of my work in Numbers.
Thank you everyone. The Tinderbox file is beautiful now.
Carolivia
