I don't know if this can be done or not, but I need an answer ASAP please. I created a Tracking Data Extract activity that includes just "Extract Status Changes" for 7 days. According to documentation, tracking extracts are automatically compressed so I have the file extension as .zip. I created a File Transfer activity that places that file on the ExactTarget FTP. I also created an Import activity to import that file to a data extension. I will eventually create an automation to run all of this and some other activities but for testing this, I just created a Program activity with the Step1 = Data Extract, Step 2 = File Transfer, and Step 3 = Import. When I run this it creates the zip file, puts it on the FTP and then errors on the Import with a "No columns found on input that map to data extensions.." error. I finally boiled it down to that it doesn't appear that the Import extracts the actual csv file that is in the zip file so that it can be imported into the data extension. I need this to be an automated process but I don't see anywhere in the Import activity UI where it lets you specify how you can do this. Am I trying to do the impossible here? Help Please! Thank you!
You need to use another File Transfer activity to unzip the file, then you can import the csv.
You can do this. What you're forgetting is the file transfer activity. So, the process would be (set up in either a program or in Automation Studio).
DE extract activity
File Transfer Activity, moving ZIP out of safe house
File Transfer Activity AGAIN, moving it back into the safe house. This is required to unzip and/or decrypt. It needs to end up in yourFTPsite/Import
Import activity to Data Extension.
NOTE: Where most people go wrong is the FTA's are not looking in the right place. The Import Activity needs the file to be in the Import folder on your FTP site, and it needs to be unzipped in order to work. If the FTA did not do this, it won't work. You can create these locations in the Admin tab, under File Locations.