Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - roman104

Pages: [1]
1

Hi,
I am trying to collect data for 'project work evidence' process based on 'resource allocation' feature. I would like to record on with 'ProjectID' resources spent their time, by which 'ProjectActivities'. So I have added new Tag into special elements for collecting the timesheet records.
Values from resource allocation and tag values I would like to use as primary data in Pivot table.
Problem is, that 'My search' returns 'Tags name' and 'Tag value' as Column names, and I need special column for every 'Tag Value'. It is possible via sql command 'create table as select'... (see https://stackoverflow.com/questions/18637160/sql-create-columns-from-values-and-fill-with-other-column).
But it doesn't work for me. Maybe this sql command is not supported in EA at all?


My SQL search is:
 select t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE,
t_object.Object_ID,t_object.CreatedDate as CreatedDate,
t_objectresource.[Resource], t_objectresource.[Role], t_objectresource.DateStart, t_objectresource.DateEnd, Round(t_objectresource.[Time]/60) AS AllocatedHours,
(t_objectresource.[ExpectedHours]/60)As ExpectedHours, (t_objectresource.[ActualHours]/60)As ActualHours, t_objectresource.PercentComplete, t_object.Name, t_object.Alias, t_objectresource.Notes, p.property as Tag, p.value as TagValue
from t_objectresource, t_object
INNER JOIN t_objectproperties p
ON t_object.object_id = p.object_id
where t_object.Object_ID = t_objectresource.Object_ID
and p.Value LIKE '#WC#<Search Term>#WC#'


How to adopt this SQL statement in internal EA Search?


Thank You
Roman


2
Hi,
I am preparing presentation and I would like to trigger  different 'diagram filters' via hyperlinks located directly on diagram.
It could be possible to define the dynamic navigation over diagram.
I searched this feature in current hyperlink element in 'Hyperlink Type' EAcommand, or othe type.
Nothing found.
It could be similar type like Type Search, wher we could select 'Filter group' and 'Filter name'.
It would be great!
Thank You
Roman

3
Hi all,
During the lifecycle of MDG I was forced to change the name of Profile. The names of stereotype are still the same.
Side effect of this is, that all instances has lost references to correct stereotype in modified MDG in production model.
I can correct it in 2 clocks on every element impacted by this change.
Problem is , there is approximately 1000 affected elements.
I am looking for the way, how to automate this issue.
I have found element attribute FQStereotype, but it is R/O.
I could change the attribute in database directly, but I am afraid of side effects.
Do You have some ideas, how to automate this ?
Thank You very much
Roman

4
Hi ea friends,
I would really appreciate the new feature of hyperlink.
I am using 10ths of models in parallel.
I would like to have one navigation diagram with links to different repositories/models.

It should link to model repository (Eap/ODBC/Cloud Services).

Clicking on the link the new instance of EA client would be started.
I can do this via save model shortcut now.
but:
1. I have to have shortcuts on my local filesystem / how to share them among the team members?
2. If I drop the shortcut to diagram, I cannot edit it.

"Save as shortcut" is very useful but the same functionality would be better to realize via Hyperlink.
I would like to have one way to link to different objects = file, web, help, repository.
It would be consistent approach for navigation/links...

What do You think about this?
Have a nice modeling
Roman  :)

5
Hi EA Friends,
I am facing very strange Warning while working with MS SQL based Repository accessible via Sparx cloud services.
Screenshot is in attached pdf file.
I have never got this message with My SQL.
Do You have the same experience?
It seems to me, it is feature ...
Thank You
Have a nice modeling
Roman

https://agnicoli.mooo.com:9999/attachments/download/146/PCG_00176_20161122-Model%20Image%20cannot%20be%20imported%20while%20connected%20to%20the%20SQL%20server%20repository%20with%20Cloud%20Services.pdf

6
Hi EA friends,
I am trying to publish our model into joomla (EA13.007).
I am going step by step as in web instructions
https://www.youtube.com/watch?v=ygn0IkZhLyA&spfreload=5

from 15:00 minutes.
The results is error pop up message:
Database connection error
Reopening connection to database.
Details about components versions, and screenshots from error messages are in this link
https://agnicoli.mooo.com:9999/attachments/download/144/PCG_00099_20161109-SpraxForumContibution-Joomla%20Issue.pdf

Do You have the same experiences?
I haven't found in MySQL joomla scheme any changes.
I haven't found in joomla destination folder (C:\xampp\htdocs\eajoomla) any changes.
Is It documented which folders, which table are affected by EA joomla publishing?
Thank You in advance
Roman




7
Hi EA friends,
I am trying to publish our model into joomla (EA13.007).
I am going step by step as in web instructions
https://www.youtube.com/watch?v=ygn0IkZhLyA&spfreload=5

from 15:00 minutes.
The results is error pop up message:
Database connection error
Reopening connection to database.
Details about components versions, and screenshots from error messages are in this link
https://agnicoli.mooo.com:9999/attachments/download/144/PCG_00099_20161109-SpraxForumContibution-Joomla%20Issue.pdf

Do You have the same experiences?
I haven't found in MySQL joomla scheme any changes.
I haven't found in joomla destination folder (C:\xampp\htdocs\eajoomla) any changes.
Is It documented which folders, which table are affected by EA joomla publishing?
Thank You in advance
Roman




Pages: [1]