An Interesting Data Loading Question ..
Thursday, June 29, 2006
What I'm missing on MassEffect\Insert is returning the created IDs directly to a field in the source file, similar to the way this is handled with the sforce connector. This way it would be much easier to handle complex migrations, because you no longer would have to pull the newly created records and map them back to the source table before proceeding with the next object.
What does anybody think about how useful this would be? Would it just be easier to have the data loader be able to load sub-objects via a foreign or imported key? Thougts anyone?
posted by Mark Esdale @ 7:44 AM,
What I learned about Access the other day
Wednesday, June 28, 2006
Working with a DemandTools customer the other day I learned that Microsoft Access is limited to only 255 maximum fields in any object. The client I was working with when we exported the case object had columns AA-MF ((13*26)+6) or 344 fields populated when we exported to csv.
Simply too big for access in the horizontal direction .
http://www.databasedev.co.uk/access_specifications.html for more information about Access capabilities.
posted by Mark Esdale @ 9:20 AM,
First posting
First posting to the CRMfusion blog
posted by Glenn Wilson @ 8:02 AM,
