Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Morinello]

Does anyone recognize these tables? I am doing some cleanup research and don’t have any notes on these tables in several of the GP company databases.

TABLE_Name

eContactAddrAttach

eContactAddress

eContactAttachment

eContactCompany

eContactContact

eContactCustomerAddLists

eContactCustomerOp

eContactDistAdd

eContactDistList

eContactNote

eContactVendorAddLists

eContactVendorOp

——————————
David Morinello
Senior Dynamics GP Systems Architect
Ascend Learning, LLC
Leawood KS
——————————

[Charles Allen]

I couldn’t find anything. Are they being updated now? If so, you can use SQL Profile to create a trace to see what process is updating the records. 

What modules are listed in Dynamics.set?

——————————
Charles Allen
Senior Managing Consultant
BKD Technologies
Houston, TX
——————————
——————————————-

[David Morinello]

They are not being updated and haven’t any newer data in the last several years. Most data is clustered around 2009-2010.

Likely they are orphan tables and data, probably from something installed on GP10 or earlier and since removed. Before my time here at Ascend for sure. They are not associated with any existing module in our Dynamics.set.

I just wanted to do my due diligence before making the decision to clean them. My GP notes go back quite a ways also and I can’t find any mention of them either.

——————————
David Morinello
Senior Dynamics GP Systems Architect
Ascend Learning, LLC
Leawood KS
——————————
——————————————-

[Matthew Arp]

Could always just rename the tables or restrict security that way any use of the table would become obvious and easily reversible. Then once you’re satisfied that they’re no longer used drop the buggers. I also feel like ‘s power tools has something to verify tables based on the current set file. Would be a quick way to check.?

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[David Musgrave]

is correct GP Power Tools (which you have) can help.

If the product is installed, the Resource Information window (in table mode) will identify the product from the table’s physical name.

The Database Validation?? window will identify any tables in the system that cannot be matched to installed products, thus confirming that they are not being used by any dexterity dictionaries.

Finally, a quick internet search found the article below. Looks like eContact is a MC2Visions product.

http://mc2visions.com/knowledge-base/gp-agent-and-econtact-setup-tips/

Regards

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[David Morinello]

Exactly what I needed to know. 

Thanks everyone!

——————————
David Morinello
Senior Dynamics GP Systems Architect
Ascend Learning, LLC
Leawood KS
——————————
——————————————-

[Andrew Kennedy]

It’s been quite a while since I’ve seen it, but MC2 used to have a product called eContact that sync’d GP contacts with Outlook.  Might be related to that.

——————————
Andrew Kennedy
Principal Consultant
Velosio
Seven Hills OH
——————————
——————————————-