Sample data: termTitle (required column) termStartdate (should be YYYY_MM_DD format) termEnddate (should be YYYY_MM_DD format) termNote courseTermTitle (required column) courseTitle (required column) courseLocation courseInstructor courseEmail courseWeb coursePhone courseOffice courseCredit courseNote eventTermTitle (required column) eventCourseTitle (required column) eventType (required column) eventDate (required column, should be YYYY_MM_DD format) eventStarttime (required column, should be HH_MM format) eventEndtime (should be HH_MM format) eventLocation eventNote These columns will be processed in three groups by the import program. The ones with "term" prefix will be used for term or semester, and the column with "course" and "event" prefix will be treated as course and event data. Please make sure to use only the titles listed above. If the column is not properly titled, all the values in the column will be ignored. Step 3) Rows Enter your term, course and event information from the second row. When entering the data, please make sure your data meet following format requirements. 1. Date format All the date values should be in "YYYY_MM_DD" format. (i.e. 2011_12_31, 2012_02_08, ...) 2. Time format All the time values should be in 24 hour "HH_MM" format. (i.e. 23_59, 09_00, 15_00, ...) 3. Match term titles The value in "courseTermTitle" and "eventTermTitle" column should match to the term title in "termTitle" column. Otherwise, Class Buddy cannot associate the course and event to the right term 4. Match course titles The value in "eventCourseTitle" column should match to the course title in "courseTitle" column. Like the term title, this is also critical to link the events to the right course 5. Match event type From v1.36, users are allowed to rename the event types in "Event type description" Setting. The value in "eventType" column should match to the type name defined in the Setting. For the previous versions, please use one of the following pre-defined value. "class, assignment, project, quiz, exam, meeting, lab, report, reading, exercise" 6. Include the required fields Make sure you include the required columns. If the required info is not provided, Class Buddy cannot know how to associate the provided info to existing term and course hierarchy Step 4) Save Save the spreadsheet. When saving file, make sure to save the spreadsheet as "csv" type. For this, use the "CSV (Comma delimited) (*.csv)" option in "Save as Type". Class Buddy cannot understand the default "xls" type. Step 5) SD card Now, you are done with Excel. Copy the file to SD card and go to Class Buddy Step 6) Import screen In import screen, you will see the list of folders and files in SD card. Folders have yellow folder icon in left, and CSV files has white import icon in right side. Press the csv file you just created in Excel. Then you will see the list of rows you have created. Step 7) Import Please make sure you don't see any errors in your spreadsheet. If there's error, please fix and restart the import. Until all the errors are fixed, "Import" button will not be enabled. Extra) Language encoding problem If your csv file includes non-English characters such as Asian two-byte character, you will have display problem. This problem is mostly caused by the language-encoding difference between Windows Excel and Android OS. If you are familiar with encoding, you may solve the problem using third party notepad application such as NotePad++ or EditPlus. These programs can convert "ASCII" in Excel CSV to "UTF-8" which is used by android OS. Otherwise, we recommend "Import from Google Docs" option instead of CSV import. |
Help >