import_allowed_values

This API call imports a tab-delimited file of parent and child values into the ExtraView database. Unlike most API commands (but similar to the add_attachment command), this command is designed to be used within an HTML page.

SYNTAX

<form method="POST" http://www.myserver.com/evj/ExtraView/ev_api.action?
user_id=username
&password=password
&statevar=import_allowed_values
&file=filename
&area=area_id
&project=project_id
&parent=parent_dd_name
&child=child_dd_name
&enctype="multipart/form-data">
</form>

The form to be uploaded when prompted by the form must have the following tab-delimited format, where --> represents the tab character:

parent_value1 --> child_value1
parent_value1 --> child_value2
parent_value2 --> child_value3
parent_value2 --> child_value4

NOTES

area_id specifies the area_id into which the allowed values will be imported. You can use the Business Area list administration utility in the web interface to see the ID’s for all areas.

project_id specifies the project_id into which the allowed values will be imported. You can use the Project list administration utility in the web interface to see the ID’s for all projects.

parent_dd_name specifies the data dictionary name of the parent field which has the allowed value relationship with the specified child.

child_dd_name specifies the data dictionary name of the child field which has the allowed value relationship with the specified parent.

The values in both the parent and child allowed value lists must already exist to work with this command.

EXAMPLE

The following HTML file can be used as a simple template for this command:

<html>
  <body>
    <form method="post" action="http://www.mycompany.com/evj/ExtraView/ev_api.action?
      user_id=username&password=password&statevar=import_allowed_values&
      area_id=0&project_id=0&parent=IT_BUILDING&child=IT_BUILDING_FLOOR"
      enctype="multipart/form-data">
    <input type="file" name="file" id="file" size="1" value="" maxlength="256">
    <input type="submit" value="Upload Attachment(s)" class="menuButton"
      title="Click to process and upload the attachments you have selected">
    </form>
  </body>
</html>