It looks like I'm going to be doing two different data migrations from two different legacy systems, one of which will only give me a .dat file and the other of which will only give me an xml file.
Does anyone have suggestions for how to convert these to csv files safely, so I can read them, make changes, and upload the data safely into Salesforce? Are there any reliable converters out there, free or paid? Any other suggested methods or tips?
Thanks and best,
Missy
5 answers
It might be that the .dat file is just a plain CSV file, only with a different name. Your best bet is to get a sample dat file from them, or ask their Support for some details about the contents of the dat file export. Their web site (for non customers anyway) doesn't give any hint about what database they are using. If you find out anything more, post it here and we'll see if we can help more.
