Spatial Manager™ for AutoCAD - FAQs: Import

Introduction

Objective of this section
- To learn how to define import processes and their parameters and manage coordinate transformations

Topics in this section
- Sources: data sources
- Import parameters: AutoCAD objects parameters, Fills, Labels, AutoCAD properties, XDATA / Extended Entity Data (EED) ("Standard" and "Professional" editions only), etc.
- Transforming the coordinates: source and target, last used coordinate systems, searching in the coordinate systems table and transformation parameters
- Reviewing and editing objects data
- Direct importing (SPMIMPORT)
- Batch importing
- Tasks: save and replay import processes, manage tasks
- Importing from the Command Line

Note: Some components in the images on this page (providers, names, windows look, etc.) may be slightly different from those that will appear on your computer

How can I Import spatial Features as AutoCAD Objects?

You can Import spatial Features as AutoCAD Objects into Spatial Manager™ for AutoCAD by using the contextual menu (mouse right-click) on any table or spatial file in the "Data sources" area of the "SpatialManager" palette. This will launch the "Import" wizard of the application. As you will see, you can import the table or the file in the current or a new drawing (see also "How to import directly into the current drawing?" below).

While running the "Import" wizard, you can select the Import parameters that match your needs:

Points and Centroids options. Here you can define the options for point type Features and for centroids of Polygons (if you choose any option to draw centroids in the Polygons options). This area will be disabled if the application "knows" there are no points or centroids to draw
- Import as AutoCAD Points
- Import as Blocks. This item will be disabled if there are no Block definitions in the drawing
  - Select a Block definition. You can select:
    - A Block Name in the drawing or
    - Choose the option "Use Field values for Name...", allowing you to select the Block definition to use for the point Features or Centroids depending on the value of a Field in the data table. If this value do not match any Name among the Block Names in the drawing, the application will use AutoCAD Points to import the corresponding point Features or Centroids. If you choose this option, the "Block options" window (see next paragraph) will be automatically opened allowing you to select the Field for the Block Names
  - Block options. Here you can choose the Field for the Block Names (see the previous paragraph), the correspondence between Fields (if any in the data source) and Block Attributes (if any in the Block definition), the option to use or not LUPREC for decimal places (see Notes below) and the Block Insertion parameters, such as the Rotation and the Scales, from values of Fields in the data source. This item will be disabled if there are no Attributes in the Block definition and there are no numeric Fields in the data source
    - Notes:
      - When Inserting, the Rotation of the Block References will consider the positive angles direction defined according to the value of the System Variable ANGDIR (Please, take a look to ANGDIR and UNITS in the AutoCAD Help)
      - You can choose that the value of the LUPREC variable (Length precision) be used or not for the number of decimal places when writing Attributes to a numerical field (Please, take a look to LUPREC and UNITS in the AutoCAD Help). This option also affects the numeric field Labels and can also be changed there (See Label options below)
Lines and Borders options. Here you can define the options for linear type Features and for borders of Polygons (if you choose any option to draw borders in the Polygons options). This area will be disabled if the application "knows" there are no lines or borders to draw
- Import as AutoCAD Polylines, Polylines 2D or Polylines 3D
- Insert Nodes (of Polylines) as AutoCAD Points
Polygons options. Here you can define the options for polygonal type Features. This area will be disabled if the application "knows" there are no polygons to draw
- Import Borders, Borders and Centroids, Centroids only, Polygons or Polygons and Centroids
  - There are two interesting options here (Polygons and Polygons and Centroids) which allow you to select MPolygons as the type of object to use. These options are available on all compatible Autodesk products (even on vanilla, plain or basic AutoCAD) (AutoCAD 2011 and upper). The MPolygons can be defined by multiple rings, even including holes, as a single AutoCAD object
- Fill areas using Hatches. This item will be disabled if you have chosen the option to import as "Only Centroids"
  - Hatch options. Here you can define the options for the Hatches such as Pattern, Angle and Scale (except for "Solid" pattern), Apply Transparency to the Hatch (whenever AutoCAD supports the Transparency property) and if the Hatch is Associative or not. Some of these parameters can be taken from Fields in the data source
Label options
- Label objects using field value. You can select any Field to create Text objects in AutoCAD in order to label the incoming objects by reading the text strings from this Field. Each Text object will go to the same layer of the labeled object. The Polygon labels will be placed at the Polygon Centroid position and the Polylines will be labeled according to a scheme that considers the lengths of the different segments ("smart" labeling")
  - Label options. You can define the Style, Height, Justification, Rotation and Rotation Units of the Text objects here. Some of these parameters can be taken from Fields in the data source. For linear objects you can also specify the separation in drawing units between labels to be repeated along the object. As added parameters, you can set the option to use or not LUPREC for decimal places (see Notes below) and configure if you want to insert the imported geometry and its Label or the Label only. Be careful: if you check this box you will only get the Labels (Text objects) but not the imported objects. This option may be interesting to Label drawings which already have graphic information or Background maps
  - Notes:
    - When Labeling, the Rotation of the Texts will consider the positive angles direction defined according to the value of the System Variable ANGDIR (Please, take a look to ANGDIR and UNITS in the AutoCAD Help)
    - You can choose that the value of the LUPREC variable (Length precision) be used or not for the number of decimal places when labeling objects using a numerical field (Please, take a look to LUPREC and UNITS in the AutoCAD Help). This option also affects the Attributes to numerical fields options writing process and can also be changed there (See Block options above)
    - Object data (EED/XDATA) are not attached to the Labels, even when the option "Import Features data as objects Extended Entity Data (EED)" is checked (see below)
General options
- Layer/Table name. This setting defines the target Layer name for the imported objects. You can select an existing Layer in the drawing or you can write the name to create a new Layer (the application will propose a suitable name that will depend on the data source)
  - Note that this is also the name of the data Table that will be used if you also import the objects data, which will be done if the source includes any data attached to the geometric elements and you select the option "Import Features data as objects Extended Entity Data (EED)" (see below)
  - If this setting is left blank, the target Layer will be the current Layer in the drawing. The used Table name (if any) will also be the name of the current Layer
  - As you can see in the next setting, the Layer name can be variable for each object but the Table name for the attached data will be unique for all the imported objects
- Use Field values for Layer. Here you can select any Field to define its value as the name of the Layer for the imported objects. If this value is null for any object, or the setting is left blank, the object will be drawn in the Layer selected in the previous setting
  - Note that this setting is only for the name of the target Layer but not for the Table name, if any (read above)
- Apply random colors to new Layers
- Use Field values for Object Elevation and/or Thickness
  - Take advantage of the Elevation values and use a Field to get the Z-coordinate of Points, Polylines or Polygons. Think about 3D Points, Contours, etc., coming from 2D Geometries. Combined with the Thickness value you can define, for example, buildings raising from an elevation and with a specific height
- Import as 2D Objects (Z coordinate of the geometry will be ignored). This option lets you "flatten" all the imported objects on the XY plane. Please note that if you have selected using the values in a field for the Elevations of the objects (see the previous paragraph), the XY plane will be placed at the corresponding object Elevation
- Import Features data as Objects Extended Entity Data (EED) ("Standard" and "Professional" editions only). If you choose this option, when you select Objects in the drawing, you will see the Objects EEDs (or XDATA) in the "Properties" area of the "SpatialManager" palette
  - Notes:
    - The fields whose value starts with "http" are automatically converted into active links
    - If the option "Insert only the labels and omit the objects" is checked (see above), this option is disabled so that an empty data table is not created
- Import only Features in the current view. This option lets you skip importing any objects outside the current drawing view
  - Notes:
    - "Outside" means that the whole bounding box of an object is outside the view
    - This option will be disabled when the importing process is performed using the palette contextual function "Import into a new drawing"

How can I define a Transformation of coordinates?

When you are Importing Features as AutoCAD Objects using Spatial Manager™ for AutoCAD, you will see that you can choose a Transformation of coordinates from the source Features to the objects in the drawing, in the "Import" wizard. This means that the application will calculate a geometric transformation between the source and the target data, which will depend on the chosen CRS for the source (incoming Features) and for the target (imported AutoCAD objects) data. You can choose the appropriate CRSs by clicking on "CRS catalog...", in the CRS dropdown list for the source or for the target data. In the CRS table you can:

Filter the CRSs by type (Geocentric, Projected, etc.)
Choose a CRS by clicking on its row in the table
Search CRSs by typing the search criteria in the "Search" box. You can type here as many words as you like separated by blanks. The application will find all the rows including all these words in any column of the table

After choosing a pair of valid CRS for a Transformation, you can choose the geographic Area to apply it to (the application will choose by default the most common Area for this Transformation)

If the application "knows", "guesses" or "can assume" the CRS of the source and/or the target (drawing) data, it will be chosen by default. You will be able to modify this choice except in cases where only one CRS is valid; for example, for a KML or a KMZ file the only valid choice is the CRS "WGS84 (SRID 4326)", because these types of file are always defined using this CRS

You can assign a CRS to the drawing, or modify it, using the command 'SPMSETCRS'. By executing this command you will access the CRS Catalog of the application, described in the previous lines. In this case the Type "Projected" will be selected by default because is the most common choice

When importing a table defined using a known CRS into a drawing without an assigned CRS, the CRS of the table is automatically assigned to the drawing
If you change the target CRS by choosing any CRS other than the drawing CRS, you will get a warning from the application but you can continue and perform the Transformation of coordinates if you want to

Notes:
- To unassign (undefine) the Coordinate System of the drawing, choose "Undefined CRS" (EPSG 0)
- As you will see, the CRS dropdown lists will include more and more CRSs as they have been previously chosen in other Transformation operations, so that you can choose your "last-used" CRSs directly from the dropdown list without having to access the CRS Catalog all the time. In addition, the CRS Catalog window shown when you execute 'SPMSETCRS' to assign a CRS to the drawing, or modify it, also includes a list of the "last-used" CRSs (if any) in the upper zone
- If the incoming data is defined using the CRS "WGS84 (SRID 4326)" and the drawing has not assigned any CRS, the transformation to the CRS "WGS 84 / Pseudo-Mercator (SRID 3857)" is selected by default to get a projected map instead of a flat representation of geodesic coordinates
- Coordinate Systems and Transformation details
- Coordinate Systems objects available in the current version

How can I speed up the starting Import process?

Sometimes, depending on the characteristics of the source, the initial reading of the data Fields may take a long time or even block the Importing process. Spatial Manager™ for AutoCAD performs this startup reading to allow you to choose certain options relating to this data on the next wizard window, such as the use of the field values to define the target Layers for the imported Objects. However you have a button available to "Skip" this step, which does not affect the imported Objects themselves but only certain options that may not be available in the Importing process

How can I speed up the Import wizard steps?

To speed up the process when you are importing, all the "Import" wizard windows in Spatial Manager™ for AutoCAD include the "Finish" button. By pressing this button, you will directly run the Import process. The wizard will assume the default values in each step to be omitted

]]

Can I see the data of the imported Features? ("Standard" and "Professional" editions only)

Yes, you can see the data of the imported Features in Spatial Manager™ for AutoCAD, because this data is also imported as EED (Extended Entity Data or XDATA) attached to the resulting Objects in the drawing. To see it, select an imported Object in AutoCAD and its data will be shown in the group "Data" of the "Properties" area in the "SpatialManager" palette

In addition to the XDATA / EED, you will see some other Object data, such as its Layer or its Bounding box, in other groups, such as "General" or "Geometry"

When selecting multiple Objects, you will see their common data here. All the data which is not equal for the selection, will be shown as "Various"

Note: Because of performance considerations, the number of objects selected for which their data are shown in the application palette is limited by the system variable PROPOBJLIMIT (AutoCAD 2012 and upper) or to 25000 (AutoCAD 2008 to 2011)

Alternatively, you can use the Spatial Manager™ for AutoCAD 'Data Grid' palette ("Professional" edition only) in order to view, edit, select, export, etc. the objects data in a table form

Learn more about the 'Data Grid' and all its features and functions

Can I modify the field values of the objects data? ("Standard" and "Professional" editions only)

Yes, you can directly edit a field value (XDATA / EED Direct data edition) for one or more objects in Spatial Manager™ for AutoCAD by selecting the object(s) in the drawing and typing the new value for this field in the "Properties" area of the "SpatialManager" palette. You can also delete the field content to get a null value in this field. To validate any modification, you need to press Enter or click on a different field

Note: Because of performance considerations, the number of objects selected for which their data are shown in the application palette is limited by the system variable PROPOBJLIMIT (AutoCAD 2012 and upper) or to 25000 (AutoCAD 2008 to 2011)

As you can read in the previous article, you can use the Spatial Manager™ for AutoCAD 'Data Grid' palette ("Professional" edition only) in order to view, edit, select, export, etc. the objects data in a table form

Learn more about the 'Data Grid' and all its features and functions

Can I modify the objects data structure? ("Standard" and "Professional" editions only)

Yes, you can Add, Modify or Delete fields in a table structure as well as Create, Restore, Edit, Rename and Delete data tables. Learn more about the "Data Structure Management"

How to import directly into the current drawing?

In addition to importing Features from the Palette, the 'SPMIMPORT' command of Spatial Manager™ for AutoCAD allows you to import the Features directly into the current drawing without having to open the application Palette. The displayed window is similar to the Data Sources section of the Palette and once the import source is selected, the "Import" wizard includes the same steps and parameters that have been detailed in the paragraphs above

Is there any way to import in one go the content of all the files from a folder (batch import)

Yes, Spatial Manager™ for AutoCAD provides this functionality through the contextual menu of the folders in the application palette

When executing "Import all" you can define some basic parameters:

Create a layer for each File or Table
- You may want to mark this option for example when the information contained in each file or table is not homogenous
- You may want to unmark this option for example when you are importing the same class of objects split in a grid
- When the "Table" option is selected and there are several files to import, the name of the Layers will be formed by the File name and the corresponding Table name
Fill areas using Hatches
- This option will be applied to all the Polygonal objects imported from any file
Select a CRS for unreferenced sources
- Since the "Import all" process will transform the coordinates between the sources and the drawing when needed, you can select a CRS for those sources without a defined CRS (if any). You will find the following options:
  - Drawing CRS (if defined)
  - CRS defined in another source that has been included in the current "Import-all" process (if any)
  - Other CRS, which can be selected using the same ways as when you run any Import process. Please, take a look at this article
Working path
- Defines a location where the application will save any auxiliary files required throughout the Import-all process
  - For example, Raster image files created when importing images that need to be transformed (coordinate transformation, etc.)
  - If this parameter is left blank, the application will ask you where to save each auxiliary file when necessary

Note: When using this function, if the drawing is unreferenced the most suitable CRS will be automatically assigned to the drawing

Is there any way to import in one go the content of all schemas in a User Data Source (UDS) or all tables in a schema or file (advanced batch import)

Yes, Spatial Manager™ for AutoCAD provides a functionality similar to that of the previous section when it comes to batch importing all schemas from a data source or all tables in a schema or file

What are the Tasks? ("Professional" edition only)

The Tasks in Spatial Manager™ for AutoCAD are the way you can save any import process and its parameters, that have been designed to let you run, whenever you want, repetitive processes for import data tables in AutoCAD. You can access Tasks through the "Task manager" area in the "SpatialManager" palette

The processes of importing tables from files, servers or data stores in AutoCAD may be executed on a regular basis and sometimes these processes require the introduction of several more or less complex parameters of the source and the importing process itself, performing a coordinate transformation between the origin and target (drawing), etc. Spatial Manager™ for AutoCAD brings to you the concept of “Task”, that allows you to store all needed operations and parameters for any import process of spatial information. Once all necessary operations and parameters are saved as a Task, you can then run it from the Task Manager whenever you need

How can I create a new Task? ("Professional" edition only)

You can create new Tasks in Spatial Manager™ for AutoCAD using the "New task" button in the "Task manager", but you can also create a new Task when you are defining an import process because you will then run the same application wizard. Any of these methods lets you run the process immediately and/or save it as a Task at the end of the wizard

In the same way as when you define the import processes, you will need to enter all the parameters to access the origin data table, the import process parameters, the coordinate system transformation parameters (if any), the name of the Task and a description of the Task (optional). All this data is saved into the "Task manager" as a new Task, until you want to delete it

Note: be careful if you select the option "Import only Features in the current view" because it will be also stored as a parameter in the Task and, when the Task be executed, the drawing view may be different from the current view

How can I execute one or more Tasks? ("Professional" edition only)

You can select one or more Tasks in the "Task manager" of Spatial Manager™ for AutoCAD using the CTRL and/or SHIFT keys. To execute the selected Tasks, use the right-click menu over any of the Task names and click on "Execute" or use the "Execute" button

All the executed Tasks will run one by one and import the incoming objects in the current drawing

When executing the Task(s) you will see the window showing all the actions performed by the Task(s) and, if you want to, you can cancel any process before the end

Can I see the Properties of a Task? ("Professional" edition only)

Yes, you can see the Properties of the selected Task (only one) in the "Properties" area of the Spatial Manager™ for AutoCAD palette

Can I sort the Tasks in the "Task manager"? ("Professional" edition only)

You cannot change the relative positions of the Tasks in the "Task manager", but you can sort the Tasks in Spatial Manager™ for AutoCAD by selecting the "Sort" button as follows:

Group by source: you will see the Tasks grouped by their source data source
Plain list: you will see a list of all Tasks sorted by date of creation

Are there any other functions for the Tasks? ("Professional" edition only)

Yes, you can Delete and Rename the Tasks in Spatial Manager™ for AutoCAD using the right-click menu over the Task item (only one), in the "Task manager". You can also "Refresh" the Task list, using the "Refresh" button in the "Task manager", if you make changes to your data sources in the current work session

Can I run Importing processes in the Command Line?

Yes, Spatial Manager™ for AutoCAD includes the command '-SPMIMPORT' that allows you to execute any saved Task in the Command Line

The command syntax is -SPMIMPORT [Task name]

Since the parameter "Task name" support wildcards, you can process multiple Tasks simultaneously (batch processing) and use it in "AutoCAD Scripts"