- Thank you received: 0
 
export to xls - no column data in file
- joyrobinson
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        
			
    
						11 years 9 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
		    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
- bert
 - 
				
				
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 749
 
			
    
						11 years 9 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.
		    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.
- joyrobinson
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 0
 
			
    
						11 years 9 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?
		    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?
- bert
 - 
				
				
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 749
 
			
    
						11 years 9 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?        
		    - joyrobinson
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 0
 
			
    
						11 years 9 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
		    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
- bert
 - 
				
				
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 749
 
			
    
						11 years 9 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        
		    - joyrobinson
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 0
 
			
    
						11 years 9 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
		    What email address do I send the file to?
-Joy
- bert
 - 
				
				
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 749
 
			
    
						11 years 9 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
		    Let me know which class and tab are you exporting toXLS so That I can focus on it