Stack Overflow
Stack Overflow

Questions tagged [aspen]

The Aspentech applications covered here are Aspen InfoPlus.21(R), Aspen SQLplus(R),Desktop-ODBC, an Excel-Add-In and others, if requested.

Aspentech has a lot of products, here is the official page: http://www.aspentech.com/

We concentrate on the following products from the Manufacturing Execution Systems, where programming takes place:

  • Aspen InfoPlus.21(R) is a realtime database based on records and fileset-Repositories. The realtime aspect concentrates on recording trend data from a production and display this data. It is also possible to create custom records and operate it via an SQLplus-Interface. There are no transactions (BEGIN,ROLLBACK,COMMIT) in InfoPlus.21.
  • Aspen SQLplus(R) is a powerful query tool to operate on the InfoPlus.21 Database. All records and their defintions can be accessed as tables. Another powerful feature are database connections to other databases like Oracle or MS SQL-Server via ODBC.
  • The Desktop-ODBC can be installed on a client or gateway to access data on the InfoPlus.21 database with the syntax of Aspen SQLplus.
  • There is an Aspen Excel-Add-In to InfoPlus.21 and other products of the Manufacturing Execution Systems.
43 questions
11
votes
6 answers

AspenTech InfoPlus 21 - How to connect and query data

I will be given access to an AspenTech InfoPlus 21 endpoint, but the systems seems to be quite legacy and not very well (publicly) documented. I will need to query some data (i.e. explore what is in the database). I had a few questions regarding…
DaveTheAl
  • 1,995
  • 4
  • 35
  • 65
7
votes
4 answers

How can I run two instances of the iPhone simulator (Aspen) to try out the WiTap example?

Has anyone had any luck running two instances of the iPhone simulator to test network code between the two?
Andrew
3
votes
1 answer

JOIN performance vs. select in a loop

I am trying to explain a performance issue that puzzles me... I have 2 tables, A and B. Table A defines the objects: +----+--------------+ + ID + other_things + +----+--------------+ + 1 + ~~~~~~~~~~~~ + + 2 + ~~~~~~~~~~~~ + + 3 + ~~~~~~~~~~~~…
Maxime
  • 1,245
  • 2
  • 14
  • 24
2
votes
1 answer

com_error: (-2147352567, 'Exception occured', (10, 'AspenModeler', 'A string value was expected', None, 0, 0), None)

When I use aspen custom modeller in python, This error occurs. Here is the code: Application = win32.Dispatch('ACM Application 3700') ACMP = Application.OpenDocument(os.path.abspath("Distillationcolumn.acmf")) and the error is com_error:…
Yin
  • 21
  • 3
2
votes
2 answers

How to close a pop-up window from other application with python script

I am working in automate Aspen Plus simulation and post-processing of the results with Python. In order to do scale-up analysis, sensitivity studies and solving optimization problems; I have to iterate several times running the aspen…
Miguel García
  • 123
  • 9
2
votes
1 answer

How to query data from txt file into AspenTech IP21 Historian?

I have process data in this format in a txt file. testTag testTag2 10 18 6 15 7 15 9 19 Please help me to build a SQLPlus script so that after every 5 seconds one of these values orderly should update IP_INPUT_VALUE field of testTag &…
iskbaloch
  • 187
  • 11
2
votes
3 answers

How to query data from an AspenTech IP21 Historian using PHP?

Is it possible to query data from InfoPlus 21 (IP21) AspenTech using php? I am willing to create a php application that can access tags and historical data from AspenTech Historian. Is ODBC my answer? Even thinking that is, I am not quite sure how…
tburd
  • 71
  • 2
  • 9
1
vote
1 answer

get value and previous value in Aspen SQLPLUS query?

I am trying to get a value and the value just before using SQLPLUS in Aspen V8.8 query. I found on Oracle library the function "LAG" that seemed perfect to me. But I get errors when using this function below is my code : SELECT IP_TREND_VALUE,…
Makol76
  • 21
  • 3
1
vote
3 answers

AspenTech IP.21 Data Timezone

I am doing a simple query to retrieve data via ODBC and OdbcDataReader. However, I am not able to determine what the time zone of the data returned is. I have checked every doc and nothing tells me what it is (UTC or local). I tried to look for a…
Lance O
  • 53
  • 4
1
vote
0 answers

Establish connection between R and Aspen Plus

I am trying to establish a connection between R and Aspen Plus (a chemical process simulator). I have succeeded in making the connection between MATLAB and Aspen Plus…
Pedro Barbosa
  • 31
  • 2
1
vote
1 answer

How to use python and COM to list components in ASPEN Plus or a COM object in general?

Can someone please tell me how to list all the components in a stream using COM and Python? I have this output stream and its path in aspen plus variable explorer is: aspen.Tree.FindNode("\Data\Streams\COM1\Output\STR_MAIN\MASSFLMX\MIXED") …
gary_brown
  • 25
  • 6
1
vote
1 answer

How do I specify the internals of a column in HYSYS via Excel VBA Automation?

I've build a simulation template in Aspen HYSYS V9 and want to transfer the data for the column internals such as internal type, tray/packing type and end stage from an Excel sheet to HYSYS using VBA Automation. I have not found the internals in the…
M.Cherry
  • 11
  • 3
1
vote
0 answers

Aspen Plus: Execute command line through Fortran Calculator

I am working on a simulation which needs a calculator to call some Python models I made. My strategy is to use Fortran i/o functions to write export values, call Python programs through command prompt and read their outputs as import values from…
Miguel García
  • 123
  • 9
1
vote
1 answer

How can I select separate time intervals simultaneously in SQL query?

Below is a section of my SQL query. I want to select data from the time periods shown. I have many specific date ranges I need to include in the 'or' statement. How can I change my query to get this to work as expected. where and a1.TS…
Vince Miller
  • 190
  • 1
  • 2
  • 15
1
vote
1 answer

Creating CSV file using Aspen SQLplus

I have a query from IP21 data that I run at a set time each day using Aspen InfoPlus.21. I now want to use python to analyze this data daily. How can I edit my SQL query to write csv file instead of just the query.
Vince Miller
  • 190
  • 1
  • 2
  • 15
1
2 3