Export Job .csv to S3 but end up with a File Type 00000
Hello, I have configured a connection for exporting a worksheet to an S3.
Connection is good, export is good.
When the export finishes, a file appears in S3 with a file type of 00000
When I download the file and open in excel expecting to see csv
it gives me a single column with all fields together, with delimeter ,
The below is the file exported to S3 look like
The below is the configuration of the Data Details, the only thing I have changed is input the file name
The below is data mapping
-
Hello Anson.
When exporting data as a CSV, you set the output file's name in the ExportJob configuration. Datameer doesn't add an extension to the target file, because it is not necessarily a comma-separated file one expects to load to MS Excel, you could set any character as a delimiter. The tailing 0000 is a file id to handle a parallel export, not a file type.
What I usually do to properly open a CSV file in Excel is to:- Open a new MS Excel Workbook.
- Go to the Data tab and choose the load From Text option.
- Choose the required CSV file and press Get Data.
- At the Text Import Wizard, choose Delimited data type and press Next.
- Choose Delimiter the source file has.
- Finish loading the data.
Be aware that you might need to find the right combination of the Excel settings to properly display the data, e.g. empty values.
I hope this helps.
Please sign in to leave a comment.
Comments
2 comments