Automate

Hi All

I'm wondering if anyone has created a report or can guide me in creating a report in Studio Manager that lists all of the current solutions in production along with a list of the field names contained within each of the solutions?

At the moment, we have a Microsoft Access database which needs constant updating with any new scripts we create which allows a user to enter a SAP field name (HERKL, EKGRP for example) and the database will display a list of all of the current solutions that are available to update that particular field. We are looking for a simpler solution for this and will be looking at a later date to have a live d=feed directly from Studio Manager into our new Microsoft Sharepoint for the team.

Any help or suggestions would be most welcome.

Thanks

Andy

------------------------------
Andy Lewis
QuidelOrtho
Quidelortho.com
------------------------------

Hi Andrew, 

Can you please clear what type of solutions you are referring to, is it Form Solutions, Excel Solutions or both,

Pulling such a report in Automate Evolve can be easy for Form Solutions as we just need to query the right table and check if the field is available in the FORMXML or not, for Transaction and Query Type solution this can be tricky as the data is stored in bytes rather than plane text.

I believe same should be feasible for Foundation as well.

Let me know more details on the Solution and I will give it a try.

Regards

Hi All

I'm wondering if anyone has created a report or can guide me in creating a report in Studio Manager that lists all of the current solutions in production along with a list of the field names contained within each of the solutions?

At the moment, we have a Microsoft Access database which needs constant updating with any new scripts we create which allows a user to enter a SAP field name (HERKL, EKGRP for example) and the database will display a list of all of the current solutions that are available to update that particular field. We are looking for a simpler solution for this and will be looking at a later date to have a live d=feed directly from Studio Manager into our new Microsoft Sharepoint for the team.

Any help or suggestions would be most welcome.

Thanks

Andy

------------------------------
Andy Lewis
QuidelOrtho
Quidelortho.com
------------------------------

Hi Hammad

Thanks for responding so quickly. 

The report that I'm looking for is to list all of the current winshuttle transaction scripts along with the fields that are contained within each one. This is so that a user can enter the SAP field name and the report will display all of the transactions scripts that contain this field.

Hope this makes more sense but please reach out to me if you have any other questions. ?

Andy

Hi Andrew, 

Can you please clear what type of solutions you are referring to, is it Form Solutions, Excel Solutions or both,

Pulling such a report in Automate Evolve can be easy for Form Solutions as we just need to query the right table and check if the field is available in the FORMXML or not, for Transaction and Query Type solution this can be tricky as the data is stored in bytes rather than plane text.

I believe same should be feasible for Foundation as well.

Let me know more details on the Solution and I will give it a try.

Regards

Hi All

I'm wondering if anyone has created a report or can guide me in creating a report in Studio Manager that lists all of the current solutions in production along with a list of the field names contained within each of the solutions?

At the moment, we have a Microsoft Access database which needs constant updating with any new scripts we create which allows a user to enter a SAP field name (HERKL, EKGRP for example) and the database will display a list of all of the current solutions that are available to update that particular field. We are looking for a simpler solution for this and will be looking at a later date to have a live d=feed directly from Studio Manager into our new Microsoft Sharepoint for the team.

Any help or suggestions would be most welcome.

Thanks

Andy

------------------------------
Andy Lewis
QuidelOrtho
Quidelortho.com
------------------------------

Hi Andrew,

Can also clear if you are using Foundation with Sharepoint  or Automate Evolve?

Regards

Hi Hammad

Thanks for responding so quickly. 

The report that I'm looking for is to list all of the current winshuttle transaction scripts along with the fields that are contained within each one. This is so that a user can enter the SAP field name and the report will display all of the transactions scripts that contain this field.

Hope this makes more sense but please reach out to me if you have any other questions. ?

Andy

Hi Andrew, 

Can you please clear what type of solutions you are referring to, is it Form Solutions, Excel Solutions or both,

Pulling such a report in Automate Evolve can be easy for Form Solutions as we just need to query the right table and check if the field is available in the FORMXML or not, for Transaction and Query Type solution this can be tricky as the data is stored in bytes rather than plane text.

I believe same should be feasible for Foundation as well.

Let me know more details on the Solution and I will give it a try.

Regards

Hi All

I'm wondering if anyone has created a report or can guide me in creating a report in Studio Manager that lists all of the current solutions in production along with a list of the field names contained within each of the solutions?

At the moment, we have a Microsoft Access database which needs constant updating with any new scripts we create which allows a user to enter a SAP field name (HERKL, EKGRP for example) and the database will display a list of all of the current solutions that are available to update that particular field. We are looking for a simpler solution for this and will be looking at a later date to have a live d=feed directly from Studio Manager into our new Microsoft Sharepoint for the team.

Any help or suggestions would be most welcome.

Thanks

Andy

------------------------------
Andy Lewis
QuidelOrtho
Quidelortho.com
------------------------------

Hi Hammad

We are using Studio Manager 20.2.8 (64 bit)

Thanks

Hi Andrew,

Can also clear if you are using Foundation with Sharepoint  or Automate Evolve?

Regards

Hi Hammad

Thanks for responding so quickly. 

The report that I'm looking for is to list all of the current winshuttle transaction scripts along with the fields that are contained within each one. This is so that a user can enter the SAP field name and the report will display all of the transactions scripts that contain this field.

Hope this makes more sense but please reach out to me if you have any other questions. ?

Andy

Hi Andrew, 

Can you please clear what type of solutions you are referring to, is it Form Solutions, Excel Solutions or both,

Pulling such a report in Automate Evolve can be easy for Form Solutions as we just need to query the right table and check if the field is available in the FORMXML or not, for Transaction and Query Type solution this can be tricky as the data is stored in bytes rather than plane text.

I believe same should be feasible for Foundation as well.

Let me know more details on the Solution and I will give it a try.

Regards

Hi All

I'm wondering if anyone has created a report or can guide me in creating a report in Studio Manager that lists all of the current solutions in production along with a list of the field names contained within each of the solutions?

At the moment, we have a Microsoft Access database which needs constant updating with any new scripts we create which allows a user to enter a SAP field name (HERKL, EKGRP for example) and the database will display a list of all of the current solutions that are available to update that particular field. We are looking for a simpler solution for this and will be looking at a later date to have a live d=feed directly from Studio Manager into our new Microsoft Sharepoint for the team.

Any help or suggestions would be most welcome.

Thanks

Andy

------------------------------
Andy Lewis
QuidelOrtho
Quidelortho.com
------------------------------