export to xls - no column data in file

More
10 years 2 months ago #4267 by joyrobinson
export to xls - no column data in file was created by joyrobinson
Hi..

I would like to export various columns to excel. I see the setting to do so, but 2 things happen. I get an error message at opening and my file has student names, but no data in it. Numbers does not give me an error, but there is still not data.

I am wondering is this because I use icons for scores (for example the Checkmark = 5pts). Please help me to export my columns out correctly, where the icons convert to its correct numerical value in excel.

Joy

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #4270 by bert
Replied by bert on topic export to xls - no column data in file
Hi Joy,
The icons in iDoceo will be exported as its description instead of its numeric value.
You'll find here the details on how to assign and include that text in the XLS file. The article is about attendance, but it will work the same with grade book data.

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #4286 by joyrobinson
Replied by joyrobinson on topic export to xls - no column data in file
Hi...

Yes, text would be fine. But it is not working.I followed those instructions and got the error message upon opening the file in Excel (2011 Mac). The message said that the file was corrupt (see attached image) . If I open it in Numbers I don't get an error, but there is still no data in the columns.

I tried for a couple of different classes and got the same results.

Suggestions?
Attachments:

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #4287 by bert
Replied by bert on topic export to xls - no column data in file
That is weird ... would you mind giving libreoffice.org a try?

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #4300 by joyrobinson
Replied by joyrobinson on topic export to xls - no column data in file
Hi..

I tried LibraOffice, the spreadsheet, I can open the file it gives no error, but it still does not have data in the columns. It again gives me the student names and headings for the columns, but the data is missing from each of the columns after that.

I have tried CSV and XLS exports from Idoceo. I have tried just a single column and the entire sheet. I tried just attendance or the other grade sheet I have. I get the same result for all, student names but no data in the columns.

Joy

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #4301 by bert
Replied by bert on topic export to xls - no column data in file
when you have a chance, and if you don't have any incovenient, send us a recent backup and we'll give it a look ASAP

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #4302 by joyrobinson
Replied by joyrobinson on topic export to xls - no column data in file
Hi..

What email address do I send the file to?

-Joy

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #4303 by bert
Replied by bert on topic export to xls - no column data in file
support@idoceo.net
Let me know which class and tab are you exporting toXLS so That I can focus on it

Please Log in or Create an account to join the conversation.