Invoking a PowerShell script in TQ Maestro or EDG

[Simon Opper]

Hi folks

I have a PowerShell script that pulls terms from a sharepoint site term store and dumps them to a csv. It would be great to invoke this or better sync it in some way with TQM and or EDG. E.g. invoke the script, then import the csv to a new or existing taxonomy.

The end game would be to also sync in a 2 way fashion, using an export of a central EDG taxonomy back to sharepoint via the sharepoint serializer already provided in EDG. But this is bound to be more complex and not my immediate priority.

Does anyone know if invoking a shell script would be possible within the environment?

Or suggestions on the best way to orchestrate if not entirely within TQ?

A set of ANT scripts would be my first guess based on prior experience.

Many thanks

Simon

[Holger Knublauch]

Hi Simon,

On 24/07/2019 13:30, Simon Opper wrote:
> Hi folks
>
> I have a PowerShell script that pulls terms from a sharepoint site term store and dumps them to a csv. It would be great to invoke this or better sync it in some way with TQM and or EDG. E.g. invoke the script, then import the csv to a new or existing taxonomy.
>
> The end game would be to also sync in a 2 way fashion, using an export of a central EDG taxonomy back to sharepoint via the sharepoint serializer already provided in EDG. But this is bound to be more complex and not my immediate priority.
>
> Does anyone know if invoking a shell script would be possible within the environment?

there is a SPARQL function smf:exec that can be used to trigger external
programs and scripts. You could call it from an SWP script that is
either triggered by a UI button (e.g. teamwork:ManagePlugin) or on a
regular basis through a scheduler:ScheduledJob. Open teamwork.ui.ttlx to
peek into these resources.

Maybe that helps?

Holger

[Simon Opper]

Morning Holger

Cold down here in Sydney ! Bet it's more pleasant up your way this morning :)

Thanks for the info. I'll explore that approach. Sounds the trick.

On a somewhat related line of question...

TBC ships with Javascript file editors ... and others ... xml and html.  In your graphql starwars example is a good combination of using javascript to script some fetch methods for web resources.

If I wanted to do the same type of scripts with another framework, e.g. .Net or C# which seem to be the flavour for SharePoint, can these editors be integrated with TBC ?  I'm guessing that these are more of an eclipse configuration rather than any specific relationship to TBC setup ? Is this right ?

Cheers

Simon

[Holger Knublauch]

TBC is based on Eclipse, and going to Help > Install New Software is the starting point to add features from 3rd parties. So yes, it should work in principle.

Note https://www.quora.com/How-do-I-install-eclipse-for-C-programming about concerns related to C# in particular.

Holger

--
You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/f92487db-a066-41a8-96ad-b31c0c3bb80f%40googlegroups.com.