{"id":283855,"date":"2023-05-14T18:31:17","date_gmt":"2023-05-14T18:31:17","guid":{"rendered":"\/forum\/forums\/topic\/automating-extraction-of-tabular-data\/"},"modified":"2023-05-14T18:34:48","modified_gmt":"2023-05-14T18:34:48","slug":"automating-extraction-of-tabular-data","status":"closed","type":"topic","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/automating-extraction-of-tabular-data\/","title":{"rendered":"Automating extraction of tabular data"},"content":{"rendered":"

Greeting to everyone!<\/p>\n

I am currently working on a project in Ansys Student 2023, where I would need to make many iterations based on location of a certain part (let’s say a couple of thousand different locations). The model was drawn in SolidWorks and the x and y parameters for location were also imported and parameterized. Now I need to do a Modal analysis and Harmonic analysis. <\/p>\n

<\/a>
Figure 1: Imported parameters (currently only 3 for testing purposes).<\/span><\/p>\n

From harmonic analysis I would like to export a CSV (or similar) for the tabular data of Frequency response deformation for each design point. Currently I have spent the whole weekend trying to find a solution. <\/p>\n

<\/a>Figure 2: Tabular data I would like to export<\/span><\/p>\n

I found this (Figure 3) and it seems to work, BUT! It only works in Mechanical. If I update all design points it doesn’t generate the files:
https:\/\/blog.ozeninc.com\/resources\/using-python-to-export-tabular-data-from-within-ansys-mechanical
The reason is that this method only works with the Mechanical GUI:
\/forum\/forums\/topic\/tabular-data-extraction\/<\/p>\n

<\/a>Figure 3: The Python script, slightly modified to work.<\/span><\/p>\n

Now is there any way of doing this with Python? Or any other way of doing this? I have found APDL and VWRITE, but have no clue in this regard.<\/span><\/p>\n

*Disclamer: Total<\/span> Ansys beginner and basic Python knowledge.<\/span><\/p>\n

**Also: This seems like something that should be integrated.<\/span><\/p>\n","protected":false},"template":"","class_list":["post-283855","topic","type-topic","status-closed","hentry"],"aioseo_notices":[],"acf":[],"custom_fields":[{"0":{"_bbp_subscription":["284862","58821","292401"],"_bbp_author_ip":["23.39.172.6"]," _bbp_last_reply_id":["0"]," _bbp_likes_count":["0"],"_btv_view_count":["4046"],"_edit_lock":["1684089221:217963"],"_bbp_topic_status":["unanswered"],"_bbp_status":["publish"],"_bbp_topic_id":["283855"],"_bbp_forum_id":["27791"],"_bbp_engagement":["58821","284862","292401"],"_bbp_voice_count":["3"],"_bbp_reply_count":["5"],"_bbp_last_reply_id":["306587"],"_bbp_last_active_id":["306587"],"_bbp_last_active_time":["2023-09-13 09:06:02"]},"test":"mb0420student-uni-lj-si"}],"_links":{"self":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/283855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics"}],"about":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/283855\/revisions"}],"wp:attachment":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/media?parent=283855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}