Katalon Studio Version: KSE 8.4.0, Build 208 Windows 10 Enterprise (64-bit) Chrome: 107.0.5304.62 (Official Build) (32-bit) Hi folks, Does anyone have any insight as to how to Decode a ‘URL’ from an email file with Katalon. Setup: I have a test email file where the URL ‘https://www.google.com’ has been encoded to base64: aHR0cHM6Ly93d3cuZ29vZ2xlLmNvbQ== Test steps: Open the test.eml file in text mode Decode the base64 encoded URL Store the URL (https://www.google.com) in GlobalVariable.Decoded.Url for use in a called test case I found Base64 (Katalon Studio API Specification) But I am not sure how to implement it with Katalon. The test.eml file: X-Sender: “Do Not Reply” donotreply@anywhere.com X-Receiver: xyz.com MIME-Version: 1.0 From: “Do Not Reply” donotreply@anywhere.com To: xyz.com Date: 26 Oct 2022 14:43:15 -0700 Subject: Hello world, what is my URL? Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 Hello world, what is my URL? aHR0cHM6Ly93d3cuZ29vZ2xlLmNvbQ==

I believe, you are still using the version 0.3.2, not 0.3.3. Please check the Drivers folder. I presume in the Dirvers folder you have 2 jars; 0.3.2 and 0.3.3. Please remove the 0.3.2, close the project and reopen it.

I have repleased ver 0.1.1 [image] Releases · kazurayam/SortingFilesByDateTimeInContent A short exercise of Java programming. I wanted to sort text files under a directory by their content (Date header of Email message). - kazurayam/SortingFilesByDateTimeInContent I changed the PathComparableByContentEmailDate class to make it more robust against .eml files that contains irregular white space characters so that unable to parse as ver 0.1.0 expected. You can see the diff of the tag 0.1.0 and 0.1.1 at [image] Comparing 0.1.0...0.1.1 · kazurayam/SortingFilesByDateTimeInContent A short exercise of Java programming. I wanted to sort text files under a directory by their content (Date header of Email message). - Comparing 0.1.0...0.1.1 · kazurayam/SortingFilesByDateTimeIn...

Hi kazurayam, I downloaded and installed 'SortingFilesByDateTimeInContent-0.1.1.jar" in the Drivers folder. When I run the test with the following test case code I get the following error: import java.nio.file.Files import java.nio.file.Path import java.nio.file.Paths import java.util.stream.Collectors import com.kms.katalon.core.configuration.RunConfiguration import com.kazurayam.study20221030.PathComparableByDateTime import com.kazurayam.study20221030.PathComparableByContentEmailDate dataDir = Paths.get('//Test1//MailerPickupDirectory') List emlFiles = Files.list(dataDir) .filter({ p -> p.toString().endsWith(".eml") }) // wrap the Path object by a adapter class // to sort the Path objects by the Email Date in the file content .map({ p -> new PathComparableByContentEmailDate(p) }) // in the descending order of the Date value .sorted(Comparator.reverseOrder()) .collect(Collectors.toList()) // print path of all eml files //emlFiles.eachWithIndex { p, index -> // println((index + 1) + "\t" + p.getTimestampFormatted() + "\t" + dataDir.relativize(p.get())) //} =============== ROOT CAUSE ===================== For trouble shooting, please visit: https://docs.katalon.com/katalon-studio/docs/troubleshooting.html ================================================ 10-31-2022 06:05:36 PM Test Cases/A1_PreFeatureCases/01 How_to_cases/25 Katalon_tips/41 fileOpenKazurayam_network Elapsed time: 0.404s Test Cases/A1_PreFeatureCases/01 How_to_cases/25 Katalon_tips/41 fileOpenKazurayam_network FAILED. Reason: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: file:/C:/Users/devers/Katalon_QAS_Projects/25-mfda-oap/Scripts/A1_PreFeatureCases/01%20How_to_cases/25%20Katalon_tips/41%20fileOpenKazurayam_network/Script1667253349870.groovy: 10: unable to resolve class PathComparableByFileLastModified @ line 10, column 6. List emlFiles = ^ 1 error at com.kms.katalon.core.main.ScriptEngine.getScript(ScriptEngine.java:199) at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194) at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119) at com.kms.katalon.core.main.TestCaseExecutor.runScript(TestCaseExecutor.java:445) at com.kms.katalon.core.main.TestCaseExecutor.doExecute(TestCaseExecutor.java:436) at com.kms.katalon.core.main.TestCaseExecutor.processExecutionPhase(TestCaseExecutor.java:415) at com.kms.katalon.core.main.TestCaseExecutor.accessMainPhase(TestCaseExecutor.java:407) at com.kms.katalon.core.main.TestCaseExecutor.execute(TestCaseExecutor.java:284) at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:142) at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:133) at com.kms.katalon.core.main.TestCaseMain$runTestCase$0.call(Unknown Source) at TempTestCase1667264733319.run(TempTestCase1667264733319.groovy:25)

You need to insert a line: import com.kazurayam.study20221030.PathComparableByDateTime And you need to change a line from: .map({ p -> new PathComparableByContentEmailDate(p) }) to .map({ p -> new PathComparableByFileLastModified(p) })

Thanks @kazurayam! Will update as per your instructions tomorrow.

HI @kazurayam, I am now getting 2 errors using this test case code: Also had one more Question: Would it be possible to add a search ‘To:’ email search criteria? For example search for the last modified file where the To: field contains “johnDoe” johnDoe would be a Variable/GlobalVariable so it could be changed/updated? import java.nio.file.Files import java.nio.file.Path import java.nio.file.Paths import java.util.stream.Collectors import com.kms.katalon.core.configuration.RunConfiguration import com.kazurayam.study20221030.PathComparableByContentEmailDate import com.kazurayam.study20221030.PathComparableByDateTime Path dataDir = Paths.get(RunConfiguration.getProjectDir()).resolve("Include/data") List emlFiles = Files.list(dataDir) .filter({ p -> p.toString().endsWith(".eml") }) // wrap the Path object by a adapter class // to sort the Path objects by the Email Date in the file content .map({ p -> new PathComparableByFileLastModified(p) }) // in the descending order of the Date value .sorted(Comparator.reverseOrder()) .collect(Collectors.toList()) //print path of all eml files //emlFiles.eachWithIndex { p, index -> // println((index + 1) + "\t" + p.getTimestampFormatted() + "\t" + dataDir.relativize(p.get())) //} Error: =============== ROOT CAUSE ===================== For trouble shooting, please visit: https://docs.katalon.com/katalon-studio/docs/troubleshooting.html ================================================ 11-01-2022 08:00:17 AM Test Cases/A1_PreFeatureCases/01 How_to_cases/25 Katalon_tips/41 fileOpenKazurayam_local Elapsed time: 0.392s Test Cases/A1_PreFeatureCases/01 How_to_cases/25 Katalon_tips/41 fileOpenKazurayam_local FAILED. Reason: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: file:/C:/Users/devers/Katalon_QAS_Projects/25-mfda-oap/Scripts/A1_PreFeatureCases/01%20How_to_cases/25%20Katalon_tips/41%20fileOpenKazurayam_local/Script1667253365735.groovy: 10: unable to resolve class PathComparableByFileLastModified @ line 10, column 6. List emlFiles = ^ file:/C:/Users/devers/Katalon_QAS_Projects/25-mfda-oap/Scripts/A1_PreFeatureCases/01%20How_to_cases/25%20Katalon_tips/41%20fileOpenKazurayam_local/Script1667253365735.groovy: 15: unable to resolve class PathComparableByFileLastModified @ line 15, column 15. .map({ p -> new PathComparableByFileLastModified(p) }) ^ 2 errors at com.kms.katalon.core.main.ScriptEngine.getScript(ScriptEngine.java:199) at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194) at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119) at com.kms.katalon.core.main.TestCaseExecutor.runScript(TestCaseExecutor.java:445) at com.kms.katalon.core.main.TestCaseExecutor.doExecute(TestCaseExecutor.java:436) at com.kms.katalon.core.main.TestCaseExecutor.processExecutionPhase(TestCaseExecutor.java:415) at com.kms.katalon.core.main.TestCaseExecutor.accessMainPhase(TestCaseExecutor.java:407) at com.kms.katalon.core.main.TestCaseExecutor.execute(TestCaseExecutor.java:284) at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:142) at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:133) at com.kms.katalon.core.main.TestCaseMain$runTestCase$0.call(Unknown Source) at TempTestCase1667314814646.run(TempTestCase1667314814646.groovy:25)

[image] Dave_Evers: file:/C:/Users/devers/Katalon_QAS_Projects/25-mfda-oap/Scripts/A1_PreFeatureCases/01%20How_to_cases/25%20Katalon_tips/41%20fileOpenKazurayam_local/Script1667253365735.groovy: 10: unable to resolve class PathComparableByFileLastModified @ line 10, column 6. List emlFiles = ^ You need to add an import statement: import com.kazurayam.study20221030.PathComparableByFileLastModified

[image] Dave_Evers: Would it be possible to add a search ‘To:’ email search criteria? For example search for the last modified file where the To: field contains “johnDoe” johnDoe would be a Variable/GlobalVariable so it could be changed/updated? Done, possible. See [image] Sorting text files by DateTime in content Katalon Studio released 0.3.2. It supports filtering text files by the vaue of Email header value (such as “To: xyz.com”) AND sorting the files by the lastModifiled property of java.io.File. You can perform it like this: ... List files = Files.list(this.dir) filter(p -> p.getFileName().toString().endsWith(".eml")) // filter files with "To: xyz.com" header .map(p -> new PathComparableByContentEmailHeaderValue(p, "To")) .filter(p -> p.getValue().matches("xyz…

Thanks & Sorry as I should have used CTRL + Shift + O to bring in the imports. The search by Last Modified date works like a charm now > thanks! :smile:

Hi kazurayam, Thanks so much for adding the ability to search based on the ‘To’ field. I used Ctrl+Shift+O to load import the supporting files but I am still seeing an ‘expecting ‘)’, found ‘->’ @ line 10, column 11.’ error for 'filter(p → p.getFileName().toString().endsWith(“.eml”))". I added the ‘SortingFilesByDateTimeInContent-0.3.0.jar’ to my Drivers folder. No doubt I messed up again… import java.nio.file.Files import java.nio.file.Path import java.nio.file.Paths import java.util.stream.Collectors import com.kazurayam.study20221030.IPathComparable dataDir = Paths.get('//q-van-bsl1//MailerPickupDirectory') List files = Files.list(dataDir) filter(p -> p.getFileName().toString().endsWith(".eml")) // filter files with "To: xyz.com" header .map(p -> new PathComparableByContentEmailHeaderValue(p, "To")) .filter(p -> p.getValue().matches("xyz.com")) // to sort by the lastModified timestamp .map(p -> new PathComparableByFileLastModified(p.get())) .sorted(reverseOrder()) .collect(Collectors.toList()); [sortbyName01] [sortbyName02]

You need to be aware of syntactical difference between Java and Groovy language. My sample code is written in Java using “Lambda expression”. So I wrote filter(p -> p.getFileName().toString().endsWith(".eml")) or filter(p -> { return p.getFileName().toString().endsWith(".eml");}) On the other hand, you are writing code in Groovy. So you should write using “Closure” syntax: filter({p -> p.getFileName().toString().endsWith(".eml")}) F.Y.I for Java Lambda → https://www.baeldung.com/java-stream-filter-lambda for Groovy Closure → https://www.baeldung.com/groovy-closures

How do I decode a base64 encoded URL from a test email using Katalon

Miscellaneous

kazurayam November 1, 2022, 10:54pm 29

Done, possible.

See