Extract File

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
mango57
Newbie
Posts: 3
Joined: Thu Apr 06, 2017 12:35 pm

Extract File

Post by mango57 » Thu Apr 06, 2017 12:46 pm

Hi,
I can not extract file = I can not find Call_log.csv in C:\Users\snaz\Downloads.

ZipExtractFiles>C:\Users\snaz\Downloads\Call_log_fast_06.04.17_12-12.zip,Call_log_fast_05.04.17_08-25.csv,C:\Users\snaz\Downloads,Call_log.csv

0: CWD=C:\Windows\system32
0: CALL_LOG.CSV=0
0: CR=
0: CRLF=
0: LF=
0: PROGRAM_FILES=C:\Program Files (x86)
0: PROGRAM_FILES_NATIVE=C:\Program Files
0: COMMA=,
0: USER_NAME=snaz
0: NULLCHAR=
0: TAB=
0: SPACE=
0: DESKTOP_DIR=\\corp.mango.ru\users\profiles\snaz\Desktop
0: OS_PLATFORM=WIN64
0: SYS_NATIVE=C:\Windows\Sysnative
0: LOCALVARS=0
0: VAREXPLICIT=0
0: IGNORESPACES=0
0: TEMP_DIR=C:\Users\snaz\AppData\Local\Temp\
0: USERDOCUMENTS_DIR=\\corp.mango.ru\users\profiles\snaz\My Documents
0: SYS_DIR=C:\Windows\system32
0: OS_VER=NT.6.1.7601
0: WIN_DIR=C:\Windows
0: SCRIPT_FILE=\\corp.mango.ru\users\profiles\snaz\My Documents\Macro Scheduler 14\777.scp
0: SCRIPT_NAME=777
0: COMMAND_LINE="C:\Program Files (x86)\Macro Scheduler 14\msched.exe"
0: MSCHED_VER=14.3.11
0: MACRO_PARMS=
0: THOUSAND_SEPARATOR= 
0: FIP_SCANPIXELS=ALL
0: DECIMAL_SEPARATOR=,
0: SCRIPT_DIR=\\corp.mango.ru\users\profiles\snaz\My Documents\Macro Scheduler 14
0: BMP_DIR=\\corp.mango.ru\users\profiles\snaz\My Documents\Macro Scheduler 14\777
0: RND_SEED=-645552617
0: CF_OVERWRITE=0
0: WF_TYPE=1
0: SK_DELAY=0
0: COMPUTER_NAME=WSHP306MSK
0: MSG_STAYONTOP=0
0: MSG_XPOS=CENTER
0: MSG_YPOS=CENTER
0: MSG_WIDTH=273
0: GAW_TYPE=0
0: MSG_HEIGHT=200
0: _LINE_NUM=2

User avatar
Marcus Tettmar
Site Admin
Posts: 7395
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Extract File

Post by Marcus Tettmar » Fri Apr 07, 2017 8:57 am

ZipExtractFiles does not rename the file. And the last variable is for a result code. You have used CALL_LOG.CSV as the result variable. If you look in your watch list this is set to 0 which means it was sucessful. So there should be the file Call_log_fast_05.04.17_08-25.csv in Downloads.

I would use a different result variable name and if you want the file called CALL_LOG.CSV then rename it after extraction:

Code: Select all

ZipExtractFiles>C:\Users\snaz\Downloads\Call_log_fast_06.04.17_12-12.zip,Call_log_fast_05.04.17_08-25.csv,C:\Users\snaz\Downloads\,zipRes
If>zipRes=0
  DeleteFile>C:\Users\snaz\Downloads\CALL_LOG.CSV
  RenameFile>C:\Users\snaz\Downloads\Call_log_fast_05.04.17_08-25.csv,C:\Users\snaz\Downloads\CALL_LOG.CSV
Endif
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

mango57
Newbie
Posts: 3
Joined: Thu Apr 06, 2017 12:35 pm

Re: Extract File

Post by mango57 » Fri Apr 07, 2017 12:10 pm

Hi,
I nave got CALL_LOG.CSV=0, but I do not have the file Call_log_fast_05.04.17_08-25.csv in Downloads!

User avatar
Marcus Tettmar
Site Admin
Posts: 7395
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Extract File

Post by Marcus Tettmar » Fri Apr 07, 2017 12:30 pm

Can you send your zip file to support (support AT mjtnet.com) and we'll try it out here.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

mango57
Newbie
Posts: 3
Joined: Thu Apr 06, 2017 12:35 pm

Re: Extract File

Post by mango57 » Fri Apr 07, 2017 12:50 pm

I'm very sorry. I had an error in the file name. ОК now!

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts