Not All Contacts showing in Worker Personal Contact Entity Export

(0) Share

Report

Posted on by Jon Hacking

When exporting the Worker Personal Contact Entity using the data management tool, not all records are being shown.

I have tried exporting from different company databases in case it was that, but get the same result set each time.

Any help welcome

Thanks,

Jon

I have the same question (0)

All responses (18)

Answers (1)

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

Hi Jon,

Did you try to export Party contacts? If you do that then you will get all records

Some of the data of Worker Personal Contact is coming from Party contacts.

Was this reply helpful? Yes No
Jon Hacking 40 on at

Like (0)

Report

Thanks Parag, Party Contacts gives me the Party Number and Email/Phone Numbers but not the names of the contacts, or what staff member the contact belongs to. Is there any other entities that this is related to?

Was this reply helpful? Yes No
Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

Hi Jon,

Can you please check the Global address book V2? This entity should have all the required information

Was this reply helpful? Yes No
Jon Hacking 40 on at

Like (0)

Report

Thanks Parag, This gives me the contact information but not who the contact is related to. Unless there is something there I can't see. Is there a field for that?

Was this reply helpful? Yes No
Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

Hi,

There is one entity "Worker contacts" which gives you party id and personnel number but in the end, It should work with "Worker personal contact person". Above I mentioned several entities, This can be a workaround.

Was this reply helpful? Yes No
Jon Hacking 40 on at

Like (0)

Report

Sorry Parag, I still don't understand the workaround.

From the above mentioned Entities:

Worker Personal Contact Person - gives me all correct fields but is missing records

Global Address Book V2 - gives me all records but has no link between Contact and Staff

Party Contacts - gives me the Phone/Email Details of All contacts but no name and no link between contact and staff

Worker Contacts - gives me the Phone/Email Details of All Staff but no link to Emergency Contacts

Was this reply helpful? Yes No
Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

You are correct. The above entities are still missing some information except "Worker Personal Contact Person" but It is missing some records.

Was this reply helpful? Yes No
Jon Hacking 40 on at

Like (0)

Report

OK, Is there any reason why records would be missing from the Worker Personal Contact Person entity if they are present in the others? If you view the forms in the front end all the information is correctly related, so I would assume the records aren't orphaned?

Was this reply helpful? Yes No
Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

Hi Jon,

Can you please verify whether you have records available in Employees > Person(Tab) > Personal contacts?

If No then create a record and check the entity export. You should able to get the data that you expect.

If there is no record available the below form then you will not able to see the data via data entity export.

Was this reply helpful? Yes No
Jon Hacking 40 on at

Like (0)

Report

Hi Parag, Yes they are present in that form. If I create a new contact it is available in the export, but the pre-existing contact is not

Was this reply helpful? Yes No