• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tFileUnarchive doesn't unzip .tar.gz files

#1 2012-04-06 12:03:50

tpk
Member
Registered: 2012-01-20
Posts: 178

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

Offline

#2 2012-04-06 12:19:52

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pavan

The component tFileUnarchive can unzip *.tar.gz file.

Do you encounter any errors?

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-04-06 12:42:12

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

yes, I encounter few problems while using tfileUnarchive. I have attached the screen shots of the job and error. Please give me any solution or correct me if i am using the component wrongly

Thanks and Regards
Pavan

pedro wrote:

Hi Pavan

The component tFileUnarchive can unzip *.tar.gz file.

Do you encounter any errors?

Regards,
Pedro


Uploaded Images

Offline

#4 2012-04-07 10:26:49

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi,

Can any one give me the solution how to solve the problem i am facing?

Thanks and Regards,
Pavan

tpk wrote:

Hi Pedro,

yes, I encounter few problems while using tfileUnarchive. I have attached the screen shots of the job and error. Please give me any solution or correct me if i am using the component wrongly

Thanks and Regards
Pavan

pedro wrote:

Hi Pavan

The component tFileUnarchive can unzip *.tar.gz file.

Do you encounter any errors?

Regards,
Pedro

Offline

#5 2012-04-08 08:23:53

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi all,

Can any one give me the solution for the problem i am facing?

Thanks and Regards,
Pavan

tpk wrote:

Hi,

Can any one give me the solution how to solve the problem i am facing?

Thanks and Regards,
Pavan

tpk wrote:

Hi Pedro,

yes, I encounter few problems while using tfileUnarchive. I have attached the screen shots of the job and error. Please give me any solution or correct me if i am using the component wrongly

Thanks and Regards
Pavan

pedro wrote:

Hi Pavan

The component tFileUnarchive can unzip *.tar.gz file.

Do you encounter any errors?

Regards,
Pedro

Offline

#6 2012-04-09 04:01:17

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi

Sorry for my delay to answer.

I have reproduced this issue in TOS 5.0.1 and it works fine.
Can you delete tFileCopy and just run tFileUnarchive only?
If you still encounter the same error, you'd better check "Archive File" parameter of tFileUnArchive.
Or click on "..." button to browse the file.

Regards,
Pedro


Only Paranoid Survive.

Offline

#7 2012-04-09 10:31:59

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

I still encounter the same problem, can u guide me what path should be give in "Archive File" parameter

Thanks and Regards,
Pavan


pedro wrote:

Hi

Sorry for my delay to answer.

I have reproduced this issue in TOS 5.0.1 and it works fine.
Can you delete tFileCopy and just run tFileUnarchive only?
If you still encounter the same error, you'd better check "Archive File" parameter of tFileUnArchive.
Or click on "..." button to browse the file.

Regards,
Pedro

Offline

#8 2012-04-09 10:33:16

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pavan

Could you send me an email and attach this tar.gz file?
I will test it for you.

Regards,
Pedro


Only Paranoid Survive.

Offline

#9 2012-04-09 10:43:55

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

The Size of the file is 169 MB, i can't send it as attachment, is there any alternative?

Thanks and Regards,
Pavan

Offline

#10 2012-04-09 10:46:48

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pavan

I think this may be due to this tar.gz file.

Because I can unzip mysql-5.5.8-linux2.6-i686.tar.gz or other tar.gz files in TOS 5.0.1.

Which OS do you use?

Regards,
Pedro


Only Paranoid Survive.

Offline

#11 2012-04-09 10:52:31

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

I Use Windows Server 2008 R2 Datacenter, TOS for DI 5.0.1

Thanks and Regards,
Pavan

Last edited by tpk (2012-04-09 10:53:12)

Offline

#12 2012-04-09 12:07:18

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

Is there any other way to unzip the files, how can i use winzip.exe component in my job to unzip the files. I had read in component manual documentation that by using tSystem_1 we can use .exe's in our job, but i could not understand the demonstration example that was given in documentation. Can u help me out?

Thanks and Regards,
Pavan

Offline

#13 2012-04-09 12:12:38

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pavan

It's the same with using commands in CMD.
You can get more info here.

Still I think there is something wrong with your tar.gz file.

Regards,
Pedro


Only Paranoid Survive.

Offline

#14 2012-04-09 12:27:58

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

If there is a problem then the particular file should not be extracted by winzip.exe also right? I use Winzip.exe directly in my SSIS job to accomplish this requirement it works fine there.

Thanks and Regards,
Pavan

Offline

#15 2012-04-09 14:01:23

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

I think this is an issue with tFileUnarchive_1 component. Inside the "*.tar.gz" if there are files with size 1.5 GB and more than 1.5 GB tFileUnarchive_1 is unable to unzip/process those files. I had checked with other "*.tar.gz" files which have .tsv files compressed inside these "*.tar.gz" files with size 1.43 GB, it is working for them and i am able to unzip these files. Let me put it in more clear way

If there are files compressed with size >1.5 GB ----- tFileUnarchive not able to unzip the "*.tar.gz" files
If there are files compressed with size <1.43 GB -----tFileUnarchive is able to unzip the "*.tar.gz" files

Can u please check in this way?Because i am able to unarchive the files with less size

I had attached the images of files which tFileUnarchive could unzip and image of File which tFileUnarchive_1 could not open/unzip. Kindly go through them i think they will be helpful for your better understanding

Thanks and Regards,
Pavan


Uploaded Images

Offline

#16 2012-04-10 04:57:23

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

Any Comments on the above mentioned?

Thanks and Regards,
Pavan

Offline

#17 2012-04-10 05:05:56

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pavan

I feel so sorry about this. Because I can't reproduce this issue in my local machine.
Here are some images.

Now the workaround is to use tSystem to call winzip.exe.

Did anybody encounter this issue before?

Regards,
Pedro


Uploaded Images


Only Paranoid Survive.

Offline

#18 2012-04-10 07:10:17

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

Can you give me the syntax how to execute the command in tSystem component, i am not able to trace out the correct syntax that should be given, as far as my understanding i had given the below command in the Command property type

"cmd winzip32 -e -o C:/Test1/bcsteepandcheapiphoneapp_2012-03-30.tar C:/Test"

But i think it does not work out,am i doing any thing wrong here?
Can you help me please?

Thanks and Regards,
Pavan

Offline

#19 2012-04-10 08:51:44

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

Can you give me the code syntax to execute in tSystem component for unzipping the file?

Thanks and Regards,
Pavan.

Offline

#20 2012-04-10 09:38:20

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi all,

Can any one tell me how to write the winzip.exe command in tSystem component to unzip the files?

Thanks and Regards,
Pavan

Last edited by tpk (2012-04-10 09:38:44)

Offline

#21 2012-04-10 09:55:43

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pavan

Finally I get a trial version of winzip from internet.

Code:

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


Only Paranoid Survive.

Offline

#22 2012-04-10 12:10:08

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

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


Uploaded Images

Offline

#23 2012-04-10 12:19:41

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tFileUnarchive doesn't unzip .tar.gz files

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.

Code:

"C:\\Test1\\bcbackcountry_2012-04-08.tar.gz"

Regards,
Pedro


Only Paranoid Survive.

Offline

#24 2012-04-10 12:43:10

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

Hi Pedro,

Even i change the path as you mentioned still the same the alert appears to be same

Thanks and Regards,
Pavan

Offline

#25 2012-04-25 10:10:31

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: tFileUnarchive doesn't unzip .tar.gz files

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/bcb … _10.tar.gz
Short URL:    http://twelio.com/zyrqmt


bcsteepandcheap_2012-04-10.tar.gz... (194.49MB) - Completed
Download:    https://sizablesend.com/file/2s5fi2/bcs … _10.tar.gz
Short URL:    http://twelio.com/izjgn6

You can use the above path to download the files

Thanks and Regards,
Pavan


pedro wrote:

Hi Pavan

Could you send me an email and attach this tar.gz file?
I will test it for you.

Regards,
Pedro

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tFileUnarchive doesn't unzip .tar.gz files

Board footer

Powered by FluxBB