I need to create a taxonomy with an entry for every living language in the world (nearly 7,000, using ISO 639-3 codes: http://en.wikipedia.org/wiki/List_of_ISO_639-3_codes). Note that the ISO 639-3 code is stored as a custom field.
In light of this: what is the easiest way to create this list directly via MySQL using a PHP (or other) script?
I have attempted to directly create entries by inserting values directly into MySQL:
INSERT INTO taxonomy_term_data (vid, name, description, format) VALUES (2,"Ghotuo","<p><em>Africa</em></p>","filtered_html"); INSERT INTO field_data_field_iso_639_3 (entity_type, bundle, entity_id, revision_id, language, delta, field_iso_639_3_value) VALUES ("taxonomy_term", "language", 3, 3, "und", 0, "aaa"); INSERT INTO url_alias (source, alias, language) VALUES ("taxonomy/term/3", "language/ghotuo", "und");
I am obviously missing something, because this entry is not seen by Drupal in the "Languages" taxonomy.
I have looked at this question but am unsure how to set this up as a stand-alone PHP script (not incorporated into the site itself).
Any ideas how to programmatically create this taxonomy? TIA.