Strata import file types

To add to dgorsman, Civil 3D will natively open. It can also connect to various other formats and works back and forth with Navisworks and Infraworks with some other file formats. Too broad of a question really. We could sit here all day and add more extensions. A number of formats are supported, including AutoDesk ReCap for handling point cloud data from a number of different formats. Why don't you describe the work processes you need to follow?

There will undoubtedly be somebody here who does something similar enough to point out potential shortcomings. Most people import points as some sort of text file. You can have the fields in any order you want, with pretty much any delimiter separating them. Point data can also be imported from xml, dem and las files. Steve Please use the Accept as Solution or Kudo buttons when appropriate. Awood, Have I missed a trick here. How do you obtain Navisworks models back into Civil3d without an 3d export or is that what you meant.

You'd have to check for the specific data collector manufacturer. I think LAS files are exported layer states. Thank you, Alberto. Tags: None. Nick Cox. If the files use commas for separation and for decimal points, then you have a major problem as 1.

Starting more optimistically, if you look at any variable which destring refuses using Code:. Comment Post Cancel. Janko Fromme. Another dialog box appears for entering the attribute name and type as Drillhole or Strata. Drillhole attributes are user-defined fields that apply to the entire drillhole such as "Driller" or "Date Drilled". Strata attributes are user-defined fields for the strata such as "BTU". The Add Skip button makes the program skip that column when reading in the import text file.

The Avoid Duplicate Strata Names option will append a number to duplicate strata names within a drillhole if these strata names do not have bed names. The Add Only Key Strata applies to an import file that contains only key strata that have both elevation and thickness fields.

The program will then create the key strata and a non-key overburden strata. If no bed name is found in lower strata, then the program will look for a bed name in the higher strata. In this way, all the strata are assigned bed names. Otherwise only the strata with bed names from the import text file will have bed names in the drillholes.

The Strata on one row applies to text files where the entire drillhole is on one row. Each strata is identified by a unique name which is combined with the strata field name. This allows you to have multiple strata value fields such as thickness and name on the same row.

When you click the Add button to add the Strata Name, a dialog appears for entering the strata identifier. Without the Strata on one row option, you can only have one Strata Name per row. Bookstore Stata Journal Stata News. Contact us Hours of operation. Advanced search. Stata expects one matrix or table of data from one sheet, with at most one line of text at the start defining the contents of the columns. Also, see import excel for more information on importing Excel spreadsheets directly into Stata.

The problems mentioned in it are primarily with respect to text-based methods of importing data from Excel to Stata, such as copying and pasting and import delimited. One cell containing a nonnumeric character, such as a letter, within a column of data is enough for Stata to make that variable a string variable. It is often easiest to fix this in Excel.

Within Stata, suppose the problematic string variable is named foo. Here are three alternative ways to identify the rogue observations:. If appropriate, they can be replaced by missing, and then the variable as a whole can be converted to numeric by typing:. It also allows automatic conversion of percentage data. What appear to be purely numeric data in Excel are often treated by Stata as string variables because they include spaces.

People may inadvertently enter space characters in cells that are otherwise empty. Although Excel strips leading and trailing spaces from numeric entries, it does not trim spaces from character entries. One or more space characters by themselves constitute a valid character entry and are stored as such. Stata dutifully reads the entire column as a string variable. Excel has a search and replace capability that enables you to delete these stray spaces, or you can use a text-processing program or a text editor on the text file.

You can also use the solution in nonnumeric characters. Much of the formatting in Excel interferes with Stata's ability to interpret the data reasonably. Just before saving the data as a text file, make sure that all formatting is turned off, at least temporarily.

You can do this by highlighting the entire spreadsheet, selecting Format , then selecting Cells , and clicking General.

However, no solution solves all problems. Here is a cautionary tale. A text file included address data.