Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenRoads | OpenSite
  • Product Communities
OpenRoads | OpenSite
OpenRoads | OpenSite Wiki Text Import Wizard - Preview Doesn't appear correct from Excel
    • Sign In
    • -Road and Site Design - Wikis
      • +OpenRoads Designer
      • +OpenRoads ConceptStation
      • +OpenRail Designer
      • +OpenSite Designer
      • +OpenRoads Navigator Mobile App
      • +SS10/SS4/SS3 OpenRoads
      • +GEOPAK Native
      • -InRoads Native
        • +Bridge
        • +Data Acquisition
        • -Data Import And Export
          • Creating A LandXML File With InRoads
          • Data Collection For Digital Terrain Models Understanding And Evaluating The Options
          • Text Import Wizard - Preview Doesn't appear correct from Excel
          • Video: Import DEM
          • Video: Import LandXML Data
          • Video: Import Points From ASCII
          • Video: Import Surface Advanced
          • Video: Import Surface From Graphics
          • Video: InRoads 8.9 Text Import Wizard
          • Video: Text Import Wizard
        • +Drafting
        • +Drainage Design
        • +Geometry Design
        • +InRoads General Topics
        • InRoads Product Tutorials
        • +Installation/Start Up
        • +Knowledge Base - InRoads
        • LandXML Translator - Enable Cross Section
        • +Profiles, Cross Sections & Volumes
        • +Quantities
        • +Rail
        • +Reports
        • +Roadway Designer
        • +Site Modeler
        • +Surface Design
        • +Survey Tools
        • +Tools
        • Video: Export Alignment Points to Cogo
        • XIN is Blank - Preferences and Styles Lists are Empty
      • +MX Native
      • +OpenRoads SignCAD

     
     Questions about this article, topic, or product? Click here. 

    Text Import Wizard - Preview Doesn't appear correct from Excel

    Product(s): InRoads
    Version(s): 08.11.09+
    Area:  Text Import Wizard
    Original Author: Chris Key, Bentley Technical Support Group

     

    Question:

    When importing a file through the Text Import Wizard, the preview doesn't show the correct formatting and there is odd text appearing.  Cannot select multiple columns to bring in the information to a surface.

    Answer:

    This is occurring because the file format is not recognized.  In this situation, the file selected to import through the Text Import Wizard was a Microsoft Excel .xlsx format.  The text import wizard cannot read this specific format so the file must be exported from Excel as a Comma Separated Value (.CSV) or Text file (.TXT) file so the import wizard can read in the ASCII information. 

    • DTM
    • InRoads
    • comma separated value
    • wizard
    • Surface
    • CSV
    • txt
    • Share
    • History
    • More
    • Cancel
    • Chris Key Created by Bentley Colleague Chris Key
    • When: Mon, Apr 11 2016 2:17 PM
    • Chris Key Last revision by Bentley Colleague Chris Key
    • When: Mon, Apr 11 2016 2:21 PM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies