Importing Data from Excel | Tidal Migrations

Easily import your Excel spreadsheets into Tidal Migrations

Tidal Migration’s importer will guide you through mapping your columns to our fields, create your own fields and even make associations between dependencies if you have captured these.

You can import your Excel spreadsheets into Tidal Migrations by visiting:

https://your_subdomain.tidalmg.com/#/discover/import

Preparing

You should import your data in the following order:

Virtualization Clusters
Servers
Database Instances
Applications

This order is especially important if you are planning to import dependencies for your Databases and Applications. Ie. If your Application has a dependency on a server, you need to have that server imported first for the dependency to be imported correctly.

Note: You can always update a dependency after importing too.

You should have one sheet or file per type of record.

There are several default columns included for each record type, however if you have additional information you can add fields for a record and also track those. If this is the case you should do this before you import your data.

Importing your data

Select the data type you wish to import.

Select the sheet in your file that you want to import data from.

Map the columns of your sheet to the fields from the drop down. If you have a column that is not present as a field and you want to import it, you can add that field.

Click submit to import the data.

Tip: The Tags option can be used to generate multiple tags and associate them with the record. You can use this track any type of categorical data. Additionally you can search and filter for records based on tags. Multiple tags can be associated based on one column of data, they are parsed and split on any commas (,)

Importing Virtualization Clusters

Tidal Migration uses the following fields to map a virtualization cluster to other resources: Hypervisor Technology, Servers. For this field, you must select the property that the column will correspond to, generally this is Name.

Importing Servers

Tidal Migrations uses the following fields to map a server to other resources: FQDN, IP Addresses, Database Instances, Environment, Cluster. For these fields, you must select the property that the column will correspond to, generally this is Name.

Importing Databases

Tidal Migrations uses the following fields to map a database instance to other resources: Servers and Environment. For these fields, you must select the property that the column will correspond to, generally this is Name.

Importing Applications

Tidal Migrations uses the following fields to map an application to other resources: Servers, Database Instances, Environment, Customers. For these fields, you must select the property that the column will correspond to, generally this is Name.