Oracle Migration Tool On Demand Guide > Migrating Picklist Values > Migrating Picklist Values >

Extracting a Single Picklist Field

To extract a single picklist field for an object, complete the steps in the following procedure.

To extract a single picklist field

1. Prepare an input XML file as follows:

   <data:PicklistSet xmlns:data="urn:/crmondemand/xml/picklist/query">
     <data:ObjectName>ObjectName</data:ObjectName>
        <data:ListOfPicklists>
           <data:Picklist>
             <data:Name>PickListName</data:Name>
           </data:Picklist>
        </data:ListOfPicklists>
   </data:PicklistSet>

   where:

   • ObjectName is the name of the object, for example, Account.
   • PickListName is the name of the picklist that you want to extract.
2. Run the Oracle Migration Tool On Demand client as follows:

   migrationtool -u UserID -s ServerURL Read Picklist InputXMLFilePath

   For example, if your input XML file is named MyAccountPicklist.xml:

   migrationtool -u UserID -s ServerURL Read Picklist "C:\My Files\MyAccountPicklist.xml"