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 - steverumsby

Pages: [1]
I have a diagram script (Javascript) that creates a heatmap by colouring diagram objects based on a tag value. This isn't a simple diagram (containing a little over 60 objects), and the script runs in just under 20 seconds. However, if I comment out the "d.Update()" line in the code so the diagram object just doesn't get updated, the runtime drops to under 5 seconds. In other words, 15 seconds of the 20 second runtime is simply processing the diagram updates.

I'm wondering if there's a trick to make this happen more quickly? Can they be batched so they all happen at once? It is quite nice, maybe even hypnotic(!),  to see the elements changing colour one at a time but I'd happily give that up if I could make it all happen faster. Any suggestions?

This is EA 16.05 connecting via PCS 1.05 to an MSSQL DB. The connection to PCS is via a VPN (when I'm at home and not in the office) and that does affect the runtime somewhat. The times would all be much shorter with a proper wired network to the server, but I'm an home much of the time so VPN it is...


Automation Interface, Add-Ins and Tools / Can you use !INC in a scriptlet?
« on: September 07, 2022, 06:46:03 pm »
I have some diagram scripts (Javascript) that work quite nicely and (now) quickly enough that I thought it would be useful to convert them to scriptlets (EA 16). However, when I do that I get errors on the !INC lines of my code. Is it not possible to include library files into a scriplet? If true, that makes them a whole lot less useful. Or am I doing something wrong?


Bugs and Issues / Full project transfer omitting t_documents table?
« on: August 31, 2022, 12:07:40 am »
I'm running EA 16 with my project is stored in an MS SQL DB in an on-prem server, with the connection going through PCS.

I've developed a habit of using the "full project transfer via native XML" to create an offline copy on my laptop, both for backup purposes and to have easy access to the project (or rather a slightly out of date version of it) when I can't/don't want to fire up a VPN connection. After the export I import the files into a project in a local QEA file.

This has been working fine until this morning when I noticed the folder with the XML files was much smaller than last time. It turns out there is one DB table missing from the export - t_document. And sure enough, after importing the XML files into a new model everything is fine except that documents stored as internal artifacts are missing. The references to them in diagrams are still there, but the documents themselves are gone.

The last time this worked properly was just last week, and I haven't upgraded the EA client since - still running 1605. Last week, the XML file for the t_document table was just over 50MB. I'm sure more documents have been added since. Could there be a size threshold that prevents the export of that one table? If so, is that likely to apply to other tables if they get that big?

Has anyone else seen this? Any ideas what might be going on?


General Board / Error when posting to forum
« on: August 30, 2022, 06:37:09 pm »
Just got this message when trying to post a message in the "Bugs and issues" forum.

An Error Has Occurred!

CleanTalk: *** Forbidden. Please enable JavaScript. Message seems to be spam. ***

Any idea what's going on?


I have a script that updates the status field of task elements based on resource completion - when all of the resources are 100% complete, the task status becomes "Done". When these tasks are on a kanban diagram I really want the diagram to update based on the new status, but I can't find a way to do that. Am I missing something?

I'm currently doing this with a diagram script but might switch to a scriptlet to make it all automatic, assuming I can do the above.

Any suggestions?


Pages: [1]