Jump to content

External References


Ann
 Share

Recommended Posts

Afternoon All

Hope you are all safe and well.

We have our Hornbill Project Manager linked/integrated with Project Online.  I am trying to create a report that shows the Hornbill Project Manager Task ID and the Project Online ID/reference.  I am using the table 'Project Tasks' and there is the column titled 'External Reference (h_project_project_tasks.h_external_reference), however when I run the report this field is empty and data is not populating in it.  Do I need to link this to another table please that may contact the external data please?  And if so which table please?  Thank you.

Kind Regards

Ann

Link to comment
Share on other sites

Hi @Ann,

That totally depends on whether the people doing the integration work are actually populating the project task with that (external reference) information.

If the integrators are not populating the external reference field, but another field instead, then that other field needs to be reported on.

If the integrators are populating the descriptive text with the reference, then reporting won't work (easily), so they might want to think of populating the external reference field instead.

Link to comment
Share on other sites

Afternoon @SamS

Hope you are well.  Thank you so much for your help, I will check this with the third party.  Thank you.

Hope you have a lovely evening.

Kind Regards

Ann

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...