2STUDIO5 Qut Systems

17. 4. 2008

Re : Integration Studio “Error retrieving tables: The operation has timed out”

Posted on 25 February 2008 17:51 by Ivan Barroso

Hi Ivan, That´s because is there any inconsistency in DataTables or Permission failure. How are you trying to do that? DBLink or .Net?

Re : Integration Studio “Error retrieving tables: The operation has timed out”

Posted on 25 February 2008 18:11 by Ivan Soares

Hi, I’m directly connected to an Oracle data base. I get this error in certain schemas, like APPS, but in some of them I can get the tables list. Thanks Ivan Soares

Yearly calendar extended

Posted on 21 February 2008 17:07 by Rui Fonseca Pedro

Hi all, I was wondering if there's any way that allows me to have a full yearly calendar and the first trimester of the next year all displayed in the same page, for vacations schedulling purposes. I'm already using the YearlyCalendarSelectMultipleDates w...

Connecting Outsystems to DB2

Posted on 22 February 2008 11:32 by Francisco Neto

Hi, I'm trying to connect outsystems to a DB2 Database. I know that it isn't supported by Outsystems, but I'm trying to work around it, and I am looking for someone that had done this or that know how to do it. So, the actual problem is: I need to connect...

Re : Connecting Outsystems to DB2

Posted on 25 February 2008 17:47 by Ivan Barroso

See http://www.outsystems.net/DeveloperCommunity/ViewTopic.aspx?TopicId=2335

Set timer schedule to a specific date

Posted on 22 February 2008 16:45 by Ricardo Matos

Hi, I was wondering if there is a way to set a timer schedule to a specific date of the year? For instance, I want to set a timer to run in the November 1st. But next year I might want to run it on the 15th October. I'm thinking of this solution: - create...

Re : Set timer schedule to a specific date

Posted on 22 February 2008 17:13 by Fernando Sousa

Hello Ricardo, You could use the platform's system tables to set the Next_Run of a specific timer. 1. Go to Add/Remove References 2. Select the producer (System) 3. Add the Meta_Cyclic_Job and Cyclic_Job entities 4. Back to your action flow, you can use a...

How to define de TOP value into a VAR in AdvanceQuery

Posted on 25 February 2008 11:58 by Ivan Barroso

Hi, Need some help how do i use a variable in a TOP clause in SQL AdvanceQuery. I tried the above code, but i receive "can´t Create a Procedure": CREATE PROCEDURE GetNames @top INT AS BEGIN SET ROWCOUNT @top SELECT Name FROM TableUsers ORDER BY Name DESC ...

Re : How to define de TOP value into a VAR in AdvanceQuery

Posted on 25 February 2008 23:24 by Fernando Sousa

Hi Ivan, Have you tried to set an Advanced Query as: SELECT @Top Name FROM TableUsers ORDER BY Name DESC and set the Top parameter as Expand inline (http://community.outsystems.com/help/servicestudio/4.1/Default.htm#using_data/advanced_input_parameter_pro...

DataTable Object to RecordList Conversion

Posted on 25 February 2008 17:10 by Francisco Neto

Hi, I'm using a ODBC to connect to an outter Database using Integration Studio. This ODBC, is returning DataTables of type Object. How can I use this object types by converting the result to RecordLists? Any suggestions? Thank's in advance, Best Regards, ...

Re : DataTable Object to RecordList Conversion

Posted on 25 February 2008 17:46 by Ivan Barroso

Hi Francisco, Why ODBC is returning DataTables of type Object and not Record? A think is more easy to you if you have a output RecordList. Give you an example, hope it help...

Re : DataTable Object to RecordList Conversion

Posted on 25 February 2008 18:14 by Francisco Neto

I was trying (and hoping) to get an easy solution. But it makes sense. So, I have to create a class of type record, and fill it "by hand" through code, right? Doing so, I would have to create entities in Service Center to equal those Records to the entiti...

Re : DataTable Object to RecordList Conversion

Posted on 26 February 2008 9:56 by Ivan Barroso

Francisco, You don´t have to create entities en ServiceCenter.... In integration you must create structures that receives the data from your c# code, with the input variables, like Username and Passwd etc, and an output of type Record to load the data. Ho...

Re : DataTable Object to RecordList Conversion

Posted on 26 February 2008 11:18 by Francisco Neto

That is really helpfull. But I still have some doubts (sorry for asking all the details, but I'm trying to catch up). You are using a RLTAB_DADOSERecordList method that I suppose returns a record List, but what does it receives? What type? And, still with...

Re : DataTable Object to RecordList Conversion

Posted on 26 February 2008 12:11 by Ivan Barroso

Francisco, In integration you must define your input variables like string, int, record, or recordlist, etc, and you must have another Struct with de RecordList that will be your output, to be called by type recordlist.

Re : DataTable Object to RecordList Conversion

Posted on 27 February 2008 10:16 by Francisco Neto

I'm now starting to realize that I've been asking some foolish questions. I think I can figure the rest out for myself. Sorry for the "newbism" and thank's for the help

Problems with the EURO symbol

Posted on 26 February 2008 12:08 by Fernando Sousa

Hello, I'm having a problem with one eSpace: the € symbol present on my screens got replaced by the ¬ character. Has this problem occurred to anyone before? How do you fix it? I'm using Service Studio 4.0.1.84.

Re : Problems with the EURO symbol

Posted on 26 February 2008 14:56 by Carlos Cabral

Hello Fernando, Thank you for your feedback. This occurrence has already been identified, the correction to it will be available in next Service Studio 4.0 revision. In case you need further assistance, please contact OutSystems Technical Support at suppo...

Using EnterpriseManager with Integrated Authentication

Posted on 26 February 2008 17:06 by Daniel Lourenço

Hello Everyone, I'm trying to use integrated authentication in Enterprise Manager and I'm not being able to understand which configurations have to be done in order to do so. I have already changed the *IntegratedAuthentication_Login* Site Property to tru...

Re : Using EnterpriseManager with Integrated Authentication

Posted on 26 February 2008 17:22 by André Vieira

Hi Daniel, I've being waiting for the time to post about this for a while.... What you need to get Integrated Authentication is the following: - Set IntegratedAuthentication_Login to true as you have done - Set URL_Login to /EnterpriseManager/IntegratedAu...

Re : Using EnterpriseManager with Integrated Authentication

Posted on 27 February 2008 8:24 by Daniel Lourenço

Hi André, I tried your solution but unfortunately it did not work. I inspected the Enterprise source and it makes sense - the Login entry point goes directly to the Login page. Didn't you customize your Enterprise so that it worked? On the other hand, if ...

Frequently Asked Questions (FAQ) are available to the Community

Posted on 26 February 2008 17:33 by Jaime Fernandes Vasconcelos

Hi, From today on there's a new section in the Community for the Frequently Asked Questions (FAQ), about the OutSystems Platform, more specifically the Express Edition. You can reach them through the Community Home Page, in the Quick Links section. We bel...

Using EnterpriseManager integrated authentication in several domains

Posted on 27 February 2008 15:34 by Daniel Lourenço

Hi, I was investigating EnterpriseManager and it seems to me that it does not support managing users from different domains. In particular, it seems to me that users from different domains with the same username will be trated as the same EnterpriseManage...

Support for Excel 2007

Posted on 21 February 2008 9:19 by Rodrigo Sousa Coutinho

I'm very happy to announce that the OutSystems Platform now has support for the new Excel 2007 file format. The support was added in version 4.1.3.29+, and enables users to upload the new xslx Excel files. Downloaded Excel files continue to use Excel's 20...

Re : Support for Excel 2007

Posted on 21 February 2008 10:11 by Ana Santos

Hi Rodrigo, This'll be very helpful! I was hoping this feature would be available for version 4.0 too! Is this going happen? Or will we have to wait for the next upgrade to be able to use Excel 2007? Thanks!

Logs are not being showed in Service Center after 4.1 Server installation

Posted on 27 February 2008 11:37 by Carlos Cabral

Symptoms:

After installing OutSystems Platform Server version 4.1 there are no logs being showed in Service Center. Even though the Log Service is running, during startup the following error message is generated in System Event Viewer. "Generate Activ...

Stop a timer

Posted on 27 February 2008 16:18 by Ricardo Matos

Is there any way to stop a timer? I was running a timer in debug mode and I know its timeout is ignored in that mode. However, I stopped the debugger, closed browser page where the debug was running. The timer was (apparently) still running. The timer had...

Re : Stop a timer

Posted on 27 February 2008 16:53 by Fernando Sousa

Hello Ricardo, I once had a similar problem with an endless loop (the timer would wake itself indefinitely). I tried to disable the timer in service center but it kept running. I think what worked for me was republishing the eSpace current version. Maybe ...

Re : Stop a timer

Posted on 27 February 2008 17:44 by Ricardo Matos

I republished the current version, but it didn't work :| Thanks though

Create and using Views

Posted on 21 February 2008 11:01 by Fernando Sousa

Hello, Sometimes you start to have performance issues in database operations (locks, queries time out, too many records, etc.) in you applications and you have to re-think the database model. One approach could be having flags indicating that a record is ...

Multi-tenant and Debug/Run

Posted on 21 February 2008 11:43 by Fernando Sousa

Hello, Since it is not possible to use the Run and Debug options in multi-tenant eSpaces, these options/menus should be disabled when handling this king of eSpace. When you you click "Verify and Save", wait 5 or 10 minutes for the verification and saving ...

OutSystems Community Lounge Forums

Error trying to edit source code in Integration Studio

Posted on 22 February 2008 15:57 by Francisco Neto

Hi, In Integration Studio, when I try to edit the source code, the Visual Studio opens, but I keep getting this error, failling then to edit the refered code. I'm sending the error message attached. Does anyone know why this happens? Best Regards Francisc...

Re : Error trying to edit source code in Integration Studio

Posted on 25 February 2008 11:05 by Daniel Lourenço

This is just a wild guess, can't it be that you trying to open a VS2005 project in VS2003 ? Best Regards, Daniel Lourenço

Re : Error trying to edit source code in Integration Studio

Posted on 25 February 2008 11:16 by Francisco Neto

I´m running the MS VS 2005 version so, it shouldn't be. Nevertheless, thank's for the reply.

Re : Error trying to edit source code in Integration Studio

Posted on 25 February 2008 17:25 by Ivan Barroso

Hi Francisco, My recomendation is to delete the folder that as been created when you have been compiled de extension, and recompile it again.

Re : Error trying to edit source code in Integration Studio

Posted on 25 February 2008 17:33 by Francisco Neto

No, still doesn't work. It happens with all extensions even the ones created correctly by the community. Thank's

Re : Error trying to edit source code in Integration Studio

Posted on 26 February 2008 11:49 by Francisco Neto

I was lacking the C# compiler. Installed the pro version of Visual Studio, and works fine now! Thank's for your help.

Tip: Setting screen width in Enterprise Manager 4.1.4

Posted on 25 February 2008 9:40 by Pedro Gonçalves

Hi all, Have any of you required that a backoffice screen in Enterprise Manager automatically set its width? You may already know about goSetHeight javascript function which works the same for height and is integrated with Enterprise's Header webblock. Th...

Namespace name could not be found when publishing in Integration Studio

Posted on 27 February 2008 17:14 by Francisco Neto

Hi, In integration studio, I'm importing actions from a .DLL. So far, so good. The problems occurs when I try to publish the extension and it says the Namespace name could not be found. Is there any configuration needed? Thank's for the help, Francisco Ne...

You can choose how to be notified about new content by clicking on the link My Settings in the OutSystems Community website.

http://community.outsystems.com/help/servicestudio/4.1/Default.htm#using_data/advanced_input_parameter_properties.htm

The diagram below represents the eSpace life cycle.

In this diagram you can easily identify two different cycles for both single and multi-developer environments: the personal cycle and the team cycle. The personal cycle concerns the iterative process where the developer is designing the eSpace and running it in a Personal Area, protected from the rest of the developers. The team cycle, on the other hand, is the iterative process where all the developers collaborate to publish a single version of the eSpace, available to all developers and end-users.

If you are working in a single-developer environment you can also take advantage of both cycles, since you might want to experiment and evaluate the eSpace without interfering with the version that end-users are using, therefore running it in your Personal Area. There are performance benefits in the development process if you decide to run the eSpace in your Personal Area.

Personal cycle

The personal cycle allows each developer to design his/her own eSpace and experiment with it in their own Personal Area. The Personal Area is an area stored in the OutSystems Hub Server you are connected to and with reserved rights concerning its management.

The Personal cycle, fully supported by OutSystems Service Studio, is divided into the following steps:

Design the eSpace in your workspace. See how to Design the eSpace
Run the eSpace in your Personal Area. See how to Run the Personal Area
Collect the feedback from this personal test and do one of the following:
1. Return to step 1.
2. Publish your eSpace, making it available to all users, as explained below in the Team cycle.

Once you have run the eSpace in your Personal Area, you can test it. See Execute the eSpace in Personal Area.

Team cycle

The team cycle allows developers to publish eSpaces in the Publish Area, which is an area stored in the OutSystems Hub Server you are connected to, available for all developers and users.

The Team cycle, fully supported by OutSystems Service Studio, is divided into the following steps:

Design the eSpace in your workspace. If you are working in a multi-developer scenario, each developer will design components or parts of the application. See how to Design the eSpace
If you are working in a multi-developer scenario, aggregate the developer contributions in a single eSpace, using the Multi-developer tools provided by OutSystems Service Studio.
Publish the eSpace in the Publish Area. See 1-Click Publish.