CRM 4.0 does have its own Excel-style import that you should likely use instead of trying to import directly into the DB.
If you have created your own entities in CRM, then there is a CRM SQL views (something regarding Custom_Entities) that will show you the mapping. Keep in mind that CRM has tons of relationships between Contacts and Activities, etc. Let me know if this doesn't help. William Sanders / EFG wrote: > I've got an adhoc request from an old client to take a ton of telemagic > data (in vfp) and slam it into MicroSoft CRM 4.0 . > > I'm thinking to import it into the Leads System - > > but - I can't really figure out the mapping of : > > what's displayed visually at the UI (some outlook thingie, acts like a web > page) vs what's stored in the SQL DB. > > Did MS put out any field mappings anywhere on this? > > Torqing the data from TeleMagic is easy, making the CSV output files for > an import is easy, heck - even putting together a data mapping template > for the IMPORT is easy - but - > > I'm stumped on the mappings... (Visual UI vs BackEnd SQL DB columns ) > > If you've got a clue to share or an url - I'd appreciate it, much !!! > > > I've done about 11 'swags' on it, I'm still not happy with the outcome. > > Mondo Regards [Bill] > > PS - Yup, I'm still alive - went through 4 software publishing thingies > this year, had a nice rest for two weeks after... ;) > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
