Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Extracting ODB data in excel/ascii format?

Extracting ODB data in excel/ascii format?

Extracting ODB data in excel/ascii format?


I was wondering if it is possible to extract data for a node set from the field/history output.
Your responses are appreciated.


RE: Extracting ODB data in excel/ascii format?

Yes, it is possible.

(i)To output to a ASCII:

In the Visualization Module
1. "Tools" Menu-> Create a Display Group based on the node set you are interested in.
2. "Report" Menu -> XY (for history output) or Field Output

For history output you need to create an XY Data before.

(ii)To output to Excel:
-The easiest way is to copy-paste from the report asii file and use the Excel Import Wizard, assuming you need to this once in a while. You also can copy-paste the XY Data directly from CAE. (XY Data Manager ->Edit-> Select the data in the table and Ctrl+C , then Ctrl+V in the Excel Sheet.)

-You can use ABAQUS Scripting Interface to program some code to output the data you need in .csv format (or using whatever text formatting you want).


RE: Extracting ODB data in excel/ascii format?

I am looking at the abaqus scripting option. could you site me an example for reading nodeset from the odb and saving it in csv format.

RE: Extracting ODB data in excel/ascii format?

There are examples in the

"Abaqus Scripting User's Manual."

For example, you can take a look at the section

"8.5.10 An example of reading field data from an output database"

....but instead of printing the info you can write it to a text file.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


eBook - The Future of Product Development is Here
Looking to make the design and manufacturing of your products more agile? For engineering and manufacturing organizations, the need for digital transformation of product development processes just became more urgent than ever so we wanted to share an eBook that will help you build a practical roadmap for your journey. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close