---
title: "Select Objects"
canonical: "https://docs.vaultspeed.com/space/VPD/3010297960/Select%20Objects"
format: markdown
---
> Macro (toc)

# Import Source Metadata

When you click on the name of a source, you will be redirected to the detailed menus of that source.

You are automatically redirected to the 'Select Object' menu:

![image](media://09f0d952-1159-4dfb-916f-80c1bd068b75)

Depending on the **Source Type**, a couple of buttons will be shown in the top right corner.

For Source Type File:

- Edit All
- Upload File(s)
- Update Selected Tables
- Get Objects
- Refresh


For Source Type Agent:

- Edit All
- Update Selected Tables
- Get Objects
- Refresh

For **source type ‘file’,** one or more files must be uploaded using the 'Upload Files' button.  
By pressing this button, the upload window opens.  Click the little folder icon to select the file(s) to be uploaded, and click on the 'Upload' button.  File format information can be found at [File Sources](https://vaultspeed.atlassian.net/wiki/spaces/VPD/pages/3011477649).

![image](media://31484751-6262-4919-bb24-adc1583a4581)

  
When the file structure is successfully loaded, the following message will be shown:

![image](media://fc979fb8-8a4e-4828-9b7c-605b086fd129)

The object names will NOT be shown in the object list yet, this will only happen after the next step.

For **both** **source types**, click the 'Get Objects' button.  This will submit a few tasks to retrieve the source metadata.  Track the progress of these tasks by pressing the 'tasks’ button in the bottom right corner.  3 Jobs should be completed successfully for sources of type 'agent'.  For sources of type 'file', you will see only the last task (import tables from source):

![image](media://6f6950e0-413e-4c8e-8455-e97f4e218997)

When the tasks are in status 'Done', refresh the object list by clicking the 'refresh' button.  The imported objects will appear in the list.

# Selecting Objects

By default, all imported objects will be considered as deselected (select flag is turned off).

Objects can be included by turning on the **Selected Flag** in a couple of ways:

- To easily include all the objects found, use the slider next to the **Selected Flag** in the header row.  This option will turn on the selected flag for all objects.  This can be combined with the search option to enable or disable a set of similarly named objects quickly.
- Turn on the selected flag for each object individually by using the edit option at the end of the line and then setting the individual sliders.
- Or set all rows in edit mode at once using the ‘Edit All’ button.

After you are done selecting the objects you want to select, don’t forget to click the ‘Save All’ button.

![image](media://2f3ea18f-6a6b-4d0b-ab95-233b58b096da)

Another possibility is to use a CSV file with a selection of the tables you want to include.  Click 'Update Selected Tables' and select the CSV file you want to upload.  This file should contain only the objects you want to select.  
The CSV file should have the following format: 

```
owner;table_name
MY_SCHEMA;MY_TABLE1
```

> ⚠️ the first row is considered the header row and will always be ignored.

## Existing Mapping option

The existing mapping option lets you map new objects onto existing objects.  This is really useful when certain objects get renamed on the source.  You just map the new name of the object to the already existing one in VaultSpeed and all settings will be taken over for that object.

Eg: the ‘customers’ object gets renamed to ‘clients’.  When you read in the metadata again with the ‘Get Objects’ button, you will see that the Exists in Source Flag for the customers object is turned off.  But you can edit the new object ‘clients' and map that to the existing object of customers.

![image](media://50919d37-feb8-409c-bad4-cd7afd7e7119)

when you create a new release for your source, you still see the ‘customers’ objects in there with all settings and changes you might have done to it, but with the indication that it now comes from the ‘clients’ object in the source.

![image](media://b4735ee1-579c-499e-b05e-dc28d83d8d31)

> ⚠️ Be aware that by default VaultSpeed will also look for the new source object name in the INI and CDC-layers for loading the data of that object.  If you are using Change Data Capture and your change data capture object names haven’t changed, make sure you use the parameter ‘USE_ORIGINAL_SOURCE_TABLE_NAME_FOR_INI_CDC_OBJECTS’ if you want VaultSpeed still to load from the original objects.

## Exists in Source Flag 

When an object is no longer available in the source metadata, it will be indicated using the Exists in source flag and red text color.

![image](media://04e41da2-53bf-4504-9491-eaa30454e94e)