I have a Drupal content type that includes Zip Codes (Postal Codes). An unlimited number of Zip Codes is allowed, and the Zip Codes are defined in the "Allowed Values List" in the field definition. I have many Zip Codes that I need to insert, and have them staged them and their relationship to nodes in a temporary database table.
I do the following insert to both "field_data_field_zip_codes" and "field_revision_field_zip_codes", but I still do not see the values in the online Content.
Has someone done this type of thing before, and know what I am missing? I looked at using "Feeds" but that module doesn't seem to support multi-value fields, just flat tables.
INSERT INTO field_revision_field_wp_zip_codes SELECT c.entity_type AS entity_type ,'wp_content_component' AS bundle ,0 AS deleted ,c.entity_id AS entity_id ,c.entity_id AS revision_id ,'und' AS language ,(@rownum:=@rownum+1) - 1 AS delta ,z.zip AS field_wp_zip_codes_value FROM field_data_field_wp_cc_id c INNER JOIN cc_zips z ON z.cc = c.field_wp_cc_id_value, (SELECT @rownum:=0) r WHERE z.cc = '1039' AND c.entity_id = '3699';