MarcusD

Hi, sure - i found a solution by searching in these forum

Found a solution !

Hi all, for a small project i need to have a letter counter for the export filename, means the first file has counter AAAAA.txt, the 2nd AAAAB.txt etc. After 26 Files the counter starts with AAABA.txt etc next Block .... If the Counter reaching ZZZZZ.txt than it should be reset and start with AAAAA.txt again. Hopefully anyone can help me ... Thanks a lot Best regards, Marcus

Hi all, short question, what is the best way to connect to 2 different MS SQL servers ? Currently i´m using the UDF _SQL.au3, but I think with this I can only connect to one sql server on time, right ? Any suggentions ? Thanks Marcus

Hi , i need your advise / recommondation how to store (encrypt) Login Data for winhttp request . Thanks ! Marcus

Hi Subz, Thanks - very helpful ! MArcus

Hi, to store the last invoice no. is not necessary , that means i got every day a complete new file...

Hi, i got the invoice (flat) file on a daily base and the structure of the file is fix. My question is, how is the best way to regonize a new invoice no . Marcus

Hi Francesco, thanks for your reply - the main question is, how to check if there is a new invoice no or not. Marcus

Good morning I need you help / advise. I got a flat CSV invoice file like: INVNo|ProductName|Description|PRICE 17146330|PRODUCT A|Description|29.30 17146330|PRODUCT B|Description|50.30 17147635|PRODUCT B|Description|50.30 17147635|PRODUCT C|Description|100.00 17147698|PRODUCT D|Description|50.00 17147887|PRODUCT C|Description|100.00 17147887|PRODUCT D|Description|50.00 17149649|PRODUCT A|Description|29.30 17149649|PRODUCT A|Description|29.30 For each Invoice No i need a new CSV file - Do you have any idea how this might work? Thanks for helping ! Marcus

Hi, i found a solution . How can i close this topic ? Thanks Marcus

Hi all, i got the the part of source code from https://www.devglan.com/online-tools/aes-encryption-decryption , any ideas to adapt this to Autoit ? @RequestMapping(value = "/aes-decryption", method=RequestMethod.POST) public @ResponseBody String aesDecrypt(@RequestBody AesEncryption aesEncryption) { if(aesEncryption.getKeySize() > 128) { try { Field field = Class.forName("javax.crypto.JceSecurity"). getDeclaredField("isRestricted"); field.setAccessible(true); field.set(null, false); } catch (Exception ex) { ex.printStackTrace(); } } String output; try{ SecretKeySpec skeySpec = new SecretKeySpec(aesEncryption.getSecretKey().getBytes("UTF-8"), "AES"); Cipher cipher = Cipher.getInstance("AES/"+aesEncryption.getMode()+"/PKCS5PADDING"); if(aesEncryption.getMode().equals("ECB")){ cipher.init(Cipher.DECRYPT_MODE, skeySpec); }else { IvParameterSpec iv = StringUtils.isEmpty(aesEncryption.getIv()) ? new IvParameterSpec(new byte[16]): new IvParameterSpec(aesEncryption.getIv().getBytes("UTF-8")); cipher.init(Cipher.DECRYPT_MODE, skeySpec, iv); } byte[] original; if(aesEncryption.getDataFormat().equals("Base64")) { original = cipher.doFinal(Base64.decodeBase64(aesEncryption.getTextToDecrypt())); }else { original = cipher.doFinal(DatatypeConverter.parseHexBinary(aesEncryption.getTextToDecrypt())); } output = Base64.encodeBase64String(original); } catch (Exception ex) { output = ex.getMessage(); } return output; } Thanks Marcus

Hi Francesco, you found a Solution ? Thanks marcus

Thanks for the hint ! i added it to my post. Marcus

the same output / result ..... It´s not working