How to make sure your import/export ship has sailed

[heidi_schnakenb]

Sometimes importing and exporting data, records, and other necessities, can feel like a cargo ship stuck in customs. Maybe an import is taking longer than expected or when it does complete, some of the data is missing. Or the size of an export is too big or something's up with the transform map. Our team of experts have analyzed the kinds of obstacles that may prevent you from getting your data where it needs to go. Take a look at the troubleshooting paths below to help map out your import/export plan!

• Troubleshooting an import that fails
  • Determining if an import failed due to constraints on a MID Server installed on a VM
• Troubleshooting an import that is taking a long time to complete
  • Determining if there is a significant number of records being imported
  • Determining if a business rule is running on top of a transform map
  • Determining if another process is running at the same time as the import
    
• Troubleshooting an import that does not complete or is missing data
  • Missing data when importing JDBC source via MID Server
  • Missing data when column length is too short for import
  • Missing data as a result of LDAP configuration issue
  • Missing data as a result of LDAP large attribute data
  • Missing data as a result of wrong data format
    
• Troubleshooting export issues
  • Determine if there are too many records in the export set
  • Determine if the configured maximum rows to export is too low
  • Determine if there is a custom script manipulating data at the record level
  • Determine if the encoding setting is wrong
  • Determine if the version of Excel cannot handle the data set size
• Troubleshooting issues with transform maps
  • Determining if all columns are mentioned
  • Determining if the coalesced field is configured
  • Determining if a business rule is running on top of the transform map

To find all of our articles related to import/export, visit Integration Solutions > Import/Export in the Knowledge Base.

Next week we're going to have a ton of information on workflow. Get ready!