How do you automatically export a list. Can the data be organized on excel? I'm making a project for 75,000 college students and i need to be able to export the data onto an excel sheet, and needs o be organized like this: NAME-COLLEGE-EMAIL-PHONE
Not like this:
NAME
COLLEGE
EMAIL
PHONE
NAME
COLLEGE
EMAIL
PHONE
HELP!!! I NEEDS TO BE DONE IN TWO DAYS
Offline
First of all, is all your data on the same list? If you have separate lists for all the categories (name, college...) and each person is assigned the same number on every list, you can individually import or copy-paste all your lists into excel, I believe. Well, after you export your lists from scratch (right-click, export).
Offline
Scratch currently can't automatically export. But what you can do, is have four lists: names, college, email, phone. Then have another list that you can name whatever you want and then using the the (join [] []) block you can do something like this:
when I receive [export v] set [i v] to [1] delete (all v) of [export v] repeat (length of [names v] ) add (join (item (i) of [names v] ) (join [-] (join (item (i) of [college v] ) (join [-] (join (item (i) of [email v] ) (join [-] (item (i) of [phone v] ))))))) to [export v] change [i v] by (1) endIt will take a while in Scratch, but after the script is finished, you can export the contents of the export list to a file and that should give you the format you need.
when I receive [export v] set [i v] to [1] delete (all v) of [export v] repeat (length of [names v] ) set [combine v] to (item (i) of [data v] ) change [i v] by (1) set [combine v] to (join (combine) (join [-] (item (i) of [data v] ))) change [i v] by (1) set [combine v] to (join (combine) (join [-] (item (i) of [data v] ))) change [i v] by (1) set [combine v] to (join (combine) (join [-] (item (i) of [data v] ))) add (combine) to [export v] change [i v] by (1) endAnd then export the same way.
Offline