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
1
vote
1 answer

Aspen IP21 Tag Value querying with R

I wish to query(read) IP21 tag values using my R script. Is there a way to do that? The closest I have come is populating an excel sheet with the ASPEN add-in functionality and then reading the values in R. Is there a direct way to read the values…
NeelDeveloper
  • 139
  • 1
  • 15
1
vote
1 answer

Trying to modify a monthly report to a weekly. Aspen Sql

I am very new to SQL programming. I am trying to modify a monthly runtime report so that I can get the information on a weekly time interval. My code just outputs 0's when the starttime and endtime are in the same month. I can't figure out why.…
tigerfan2010
  • 13
  • 3
0
votes
1 answer

Percent symbol in Python requests causing query to not work

I am trying to query Aspen IP21 via the REST API using Python requests. My code works fine apart from when there is a LIKE statment in the SQL query which will have a % symbol in it. I have tried subsituting the % symbol with %25 but this seems…
Lee G
  • 3
  • 3
0
votes
1 answer

Aspentech infoplus 21 download R

I use an R code to download datas from Aspentech IP21 database. Is there a way to know if a tag is in "bad" status or in "good" status. It would be useful, otherwise I get 0 (zeros) when a variable is bad, but I don't know if it really is…
niccolo_guazz
  • 31
  • 3
0
votes
2 answers

Get multiple variable Aspentech infoplus 21

I am writing a script in order to connect to an Aspentech Infoplus 21 database server. When calling for a single TAG I do not record any problem import pandas as pd import pyodbc from datetime import datetime from datetime import timedelta #----…
niccolo_guazz
  • 31
  • 3
0
votes
1 answer

ASPEN SQL Script to compare two tags glossaries

What I want to do is bring up a list of all tags in a table (IP_AIDef and IP_DIDef) that contains "FDL" (fast data logged) in the 'name' along with their corresponding glossaries (ip_description). What I need to do is also bring up the…
El_Chivo
  • 1
  • 2
0
votes
0 answers

AspenTech InfoPlus 21 - How to select a NULL value?

I'm trying to select a null value on a IP21 Database like we do in Oracle databases or Sql Server, e.g: Oracle: SELECT NULL FROM DUAL Sql Server: SELECT NULL Anyone know how i can do this?
Diego
  • 1
  • 1
0
votes
1 answer

Coupling LCA with process simulation in brightway2

I would like to couple my Life Cycle Assessment (LCA) with process simulation made in Aspen. Basically, I would like for my program, created within Brightway2 framework, to take data from Aspen simulation (provided in JSON file) for Life Cycle…
Morphinka
  • 15
  • 2
0
votes
0 answers

How to query data from AspenONE IP21 Historian using Power BI?

I wish to do a PowerBI dashboard using data from IP21 historian. There is currently no automated export from IP21 and there are lots of tables to update manually. Thus I am wondering, is it possible to directly use IP21 as the data source in PowerBI…
majuro
  • 1
0
votes
2 answers

Aspen SQLPlus: Separating Columns by Name

Hey guys I'm fairly new to SQLplus and currently trying to separate values into their own column by their respective tag name. I've been able to pull columns that filter out every tag name except the ones requested, but I need to have each column…
Claythorne
  • 1
  • 1
0
votes
0 answers

Matlab data explorer app with ASPEN Sqlplus

Is there a way to use the data explorer app with Aspen sql plus on matlab2013b to join tables and import data? I can use it with a normal sql databasis, but when I try to use it with sqlplus it does not want to work. I can script code to import the…
Max Cogho
  • 1
  • 1
0
votes
5 answers

Post data to an Aspen IP21 Historian

I know that it is possible to send sensors data to Aspen IP21 by using CIM-IO connected to OPC-DA servers, but I would like to send the same kind of data by using another application (that we can build in any language) which will collect data from…
Tiago Machado
  • 1
  • 3
0
votes
0 answers

How to determine the type of input variable in a password protected Excel add-in?

I am currently trying to fit some kinetic parameters for a Chemical plant simulation project. My main software is Aspen Plus. While it is a great environment, it's parameter fitting capabilities are underwhelming, getting easily stuck in local…
Ottmar Schaub
  • 45
  • 6
0
votes
1 answer

How to execute calculation in excel with aspen plus custom model?

I'm using excel model to simulate membrane process. Due to many equations involved in the process, cubic equation solver has to be used. Every time I run aspen plus with different parameters, it does update the new values, but it won't solve when I…
cgybb
  • 59
  • 2
0
votes
1 answer

How can I create dynamic variable names without using a dictionary?

I am linking Excel with Aspen Hysys which allows me to import data from the second one. Hysys has a large hierarchy three of objects including the Stream object. The Stream object contains variables such Temperature, VaporFraction and so on and I…
user10526421
1
2
3