QUESTION:
When using MassBackup I receive the error "too many fields defined", how do I correct this?
ANSWER:
MassBackup writes a copy of all the Salesforce tables to a .mdb file (Microsoft Access 2003 file). A different file type cannot be selected in MassBackup.
Access will not allow more than 255 fields to be defined for a particular table. Therefore, if any table has a lot of custom fields, such that the overall number of fields exceeds the 255 field limit, the backup will fail for that particular table with the error "too many fields defined" reported in the logfile.
MassEffect can also be used to export data from any individual table and multiple file types are supported for a MassEffect export (i.e. xls, xlsx, csv etc). Additionally MassEffect allows for only specific records to be exported, as well as provides the ability to choose which fields should be exported.
MassEffect exports can also be scheduled.
NOTE: The overall size of the resulting .mdb file also cannot exceed 2GB. If the data in your Salesforce exceeds this limit, the .mdb file will be created but will only contain data for tables up until the point where the 2GB limit was exceeded, so a complete backup may not have been done.
