Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tFileUnarchive doesn't unzip .tar.gz files

Hi,
As a part of daily job i have to copy files from one location to another location and unzip the copied files. The file format is .tar.gz. I used tFileUnarchive component which is used to unzip files, but it is not working for .tar.gz file format.
Is there any other component to unzip .tar.gz files? or Can any one tell me how to use winzip.exe to unzip the files using talend?
TOS for DI Version:5.0.1.r74687
Thanks and Regards,
Pavan
Labels (2)
35 Replies
Anonymous
Not applicable
Author

Hi Pavan
Finally I get a trial version of winzip from internet.
new String[]{"C:\\Program Files\\WinZip\\WINZIP32.exe" ,"-e", "-o" ,"D:/mysql.tar.gz" ,"D:/Test"}

Type this in tSystem component.
C:\\Program Files\\WinZip\\WINZIP32.exe : this is the absolute path of winzip32.exe
Regards,
Pedro
Anonymous
Not applicable
Author

Hi Pedro,
I am getting the below error, can you help me out?
I have attached the images of the job and alert message.
Thanks and Regards,
Pavan
Anonymous
Not applicable
Author

Hi Pavan
This is because the file path "C:/Test1/bcbackcountry_2012-04-08.tar" is wrong.
You'd better recheck it and change it into this pattern.
"C:\\Test1\\bcbackcountry_2012-04-08.tar.gz"

Regards,
Pedro
Anonymous
Not applicable
Author

Hi Pedro,
Even i change the path as you mentioned still the same the alert appears to be same
Thanks and Regards,
Pavan
Anonymous
Not applicable
Author

Hi Pedro,
I am giving you the links below where you can download the zip files and check what is wrong with the zip files and kindly suggest what i need to do to run it properly. The file format is fixed it can not be changed because this is the format that our client send us files daily from the past. Earlier we have an SSIS job which will call the WinZip.exe in the job to accomplish the extraction, now as we are moving the job to talend i am using tFileUnarchive to accomplish this job, but i think there is no much luck with me in using this component
bcbackcountry_2012-04-10.tar.gz... (207.55MB) - Completed
Download: https://sizablesend.com/file/ec3xw3/bcbackcountry_2012_04_10.tar.gz
Short URL: http://twelio.com/zyrqmt

bcsteepandcheap_2012-04-10.tar.gz... (194.49MB) - Completed
Download: https://sizablesend.com/file/2s5fi2/bcsteepandcheap_2012_04_10.tar.gz
Short URL: http://twelio.com/izjgn6
You can use the above path to download the files
Thanks and Regards,
Pavan

Hi Pavan
Could you send me an email and attach this tar.gz file?
I will test it for you.
Regards,
Pedro
Anonymous
Not applicable
Author

Hi Pavan
Thanks for your feedback.
I will download it soon and test it for you.
Regards,
Pedro
Anonymous
Not applicable
Author

Hi Pedro,
Thank you very much, I will be waiting for your valuable feed back on the above.
Thanks and Regards,
Pavan
Thanks for your feedback.
I will download it soon and test it for you.
Anonymous
Not applicable
Author

Hi Pavan
After some attempts, I find that the suffix of these two files are wrong.
They should be .gz but not tar.gz.
If I rename these two files, the tFileUnarchive works fine. Or I shall get the errors you mentioned above.
SizableSend.com-Upload-04-25-2012-887977---bcsteepandcheap_2012_04_10.gz
SizableSend.com-Upload-04-25-2012-887978---bcsteepandcheap_2012_04_10.gz

I do these tests in TOS 5.0.1 and TOS 5.1.0.
My OS is win7 32bit.
I don't think this is an issue related to file size.
Wait for your feedback.

Regards,
Pedro
janhess
Creator II
Creator II

Do you need to change c:/Test to c:\\Test
Anonymous
Not applicable
Author

Hi Pedro,
If we change the name of the file it works but this is going to complicate the job as this extraction is interlinked with the job which we had discussed in the below link
https://community.talend.com/t5/Design-and-Development/quot-File-Not-Found-quot-exception-for-tFileU...
After extraction of each file 13 files will be extracted and from that 13 files i will read hit_data.tsv file which will be processed by the tOracleBulkExec which u can see the job in detail in the above link i had given. But if i do as you mention by changing the name of the file the extracted file name is changed to the changed gz file name and obviously tOracleBulkExec will fail because it will fetch for hit_data.tsv file. So this wont work out. I think this is definitely an issue with tFileUnarchive component, because my remaining all files are being extracted with out changing the file name, why should i now change the file name?

Thanks and Regards,
Pavan