search

jbenn313 / itsy-bitsy-spider

0 stars 0 forks source link

Data Extraction Necessity #8

Open pguasti opened 7 years ago

pguasti commented 7 years ago

Hello John,

In our daily basis we will budget lots of different requests with our partners. And we must be able to extract the following information in each one of the projects, somehow not to search individually: -requester -management -Operation

We want to be able to brief through the platform and start following closelly productivity of our partners...

Tks

jbenn313 commented 7 years ago

Hi Pietro:

We can add metadata properties e.g. itau-agency-requested and itau-solicitation-date at the project level and expose those properties in the project creation panel. In the Touch UI see Projects -> Create -> Projects -> Simple Project -> Next. Notice the Basic and Advanced tabs. On the Basic tab notice Title, Description, Start Date, etc. Through configuration we can change the tabs and the properties on each tab. We can make properties here required. This allows us to put the Itaú metadata that you describe on each project.

After the above is done, it is possible to write queries against the repository and select projects that have any values or combination of values in the metadata. It is unclear to me how the results of these queries would be used. I do not see an out-of-the box UI that can be used (and customized) for searching projects, filtering on project-level metadata, as we have for Assets. How do you envision consuming this data about partner projects? We could produce JSON very easily. Simple HTML would be a little more involved. Delivering a beleza UI would require substantial work.

This deserves further discussion...

JB

jbenn313 commented 7 years ago

We could provide a sevlet, something like: https://author-itau.adobecqms.net/service/parceiros-report?partner-name-sunset?start-date=2017-06-08

Opening that url would cause a csv file with report data to be downloaded.

Then you open the csv file in Excel and do analysis.

This would require writing custom code to implement the /service/parceiros-report servlet.