Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


kleberj
2022-11-11T11:11:52Z
Hello all,

we are using oAuth via VC a week now. After a couple of connection issues, the process is working. We had used in the past IMAP via VC, because we are downloading the emails, write the email into a .txt file and our internal program reads it in with the attachments into our programs.

But now we got the issue that our program can't read in the attachments, because the ID in the downloaded email folder is not the same one as in the .txt file.

When we used IMAP, the email was downloaded and the for example following numeric folders were created:
"154113"
"154115"
...
...
In those folder were the .EML file itself and a 'attachments' folder with the attachments in it.

But now with oAuth and EWS we got the following folders:

"AAMkADQzOTEwZDcwLTliZDgtNDdmYy1iYzhjLWU0MTE5MGI3ZjNiNgBGAAAAAABzwrm0fyppQ73aQ5xSdN5NBwBTrt0oHIL2SqtzcXmPSENJAAAAAAEMAABTrt0oHIL2SqtzcXmPSENJAAKhczz0AAA="
...
...

And our issue is now, that when the .txt file is created he is using the identifier ID, because the messageID is too long for VisualCron.
And this causes a new folder to be created with the identifier ID. This results in our program not being able to associate the text file with the downloaded email.

So for example we got the following .txt file:

"MAIL_SAVE_receiver@domain.com#2022-11-08#E2C588A9A194824F13B15952EFB5FD83#sender@domain.com"

But the folder name is:
"AAMkADQzOTEwZDcwLTliZDgtNDdmYy1iYzhjLWU0MTE5MGI3ZjNiNgBGAAAAAABzwrm0fyppQ73aQ5xSdN5NBwBTrt0oHIL2SqtzcXmPSENJAAAAAAEMAABTrt0oHIL2SqtzcXmPSENJAAKhcz1xAAA="

And thats why a new folder is created in the same directory with the following name:
"258891948241315952583" (look above, its the identifier ID without letters)
Then our program is reading in the email, but the attachments got lost.

For testing purposes I renamed the original created folder in "123456" and changed the .txt file name in "MAIL_SAVE_receiver@domain.com#2022-11-08#123456#sender@domain.com". After that our program could read in the email and also the attachments.


Here is our destination path with the triggers:
"D:\...\....\EMAIL\SUPPORT\MAIL_SAVE_{TRIGGER(Active|LastTrigger|Mail.Result.Mail.ToAddresses)}#{TRIGGER(Active|LastTrigger|Mail.Result.Mail.Received|yyyy-MM-dd)}#{TRIGGER(Active|LastTrigger|Mail.Result.Mail.Identifier)}#{TRIGGER(Active|LastTrigger|Mail.Result.Mail.FromAddress)}.txt"

The emails are saved in: "D:\...\...\EMAIL\SUPPORT".

VC Version: 9.9.12

What can we do that the downloaded folders are again numeric folders and has the same name, as the "Write into file" produced .txt files like with IMAP before?

Our issue is really critical!

Kind regards
Sponsor
Forum information
Michael Fjellström
2022-11-11T14:17:44Z
Originally Posted by: kleberj 

Hello all,

we are using oAuth via VC a week now. After a couple of connection issues, the process is working. We had used in the past IMAP via VC, because we are downloading the emails, write the email into a .txt file and our internal program reads it in with the attachments into our programs.

But now we got the issue that our program can't read in the attachments, because the ID in the downloaded email folder is not the same one as in the .txt file.

When we used IMAP, the email was downloaded and the for example following numeric folders were created:
"154113"
"154115"
...
...
In those folder were the .EML file itself and a 'attachments' folder with the attachments in it.

But now with oAuth and EWS we got the following folders:

"AAMkADQzOTEwZDcwLTliZDgtNDdmYy1iYzhjLWU0MTE5MGI3ZjNiNgBGAAAAAABzwrm0fyppQ73aQ5xSdN5NBwBTrt0oHIL2SqtzcXmPSENJAAAAAAEMAABTrt0oHIL2SqtzcXmPSENJAAKhczz0AAA="
...
...

And our issue is now, that when the .txt file is created he is using the identifier ID, because the messageID is too long for VisualCron.
And this causes a new folder to be created with the identifier ID. This results in our program not being able to associate the text file with the downloaded email.

So for example we got the following .txt file:

"MAIL_SAVE_receiver@domain.com#2022-11-08#E2C588A9A194824F13B15952EFB5FD83#sender@domain.com"

But the folder name is:
"AAMkADQzOTEwZDcwLTliZDgtNDdmYy1iYzhjLWU0MTE5MGI3ZjNiNgBGAAAAAABzwrm0fyppQ73aQ5xSdN5NBwBTrt0oHIL2SqtzcXmPSENJAAAAAAEMAABTrt0oHIL2SqtzcXmPSENJAAKhcz1xAAA="

And thats why a new folder is created in the same directory with the following name:
"258891948241315952583" (look above, its the identifier ID without letters)
Then our program is reading in the email, but the attachments got lost.

For testing purposes I renamed the original created folder in "123456" and changed the .txt file name in "MAIL_SAVE_receiver@domain.com#2022-11-08#123456#sender@domain.com". After that our program could read in the email and also the attachments.


Here is our destination path with the triggers:
"D:\...\....\EMAIL\SUPPORT\MAIL_SAVE_{TRIGGER(Active|LastTrigger|Mail.Result.Mail.ToAddresses)}#{TRIGGER(Active|LastTrigger|Mail.Result.Mail.Received|yyyy-MM-dd)}#{TRIGGER(Active|LastTrigger|Mail.Result.Mail.Identifier)}#{TRIGGER(Active|LastTrigger|Mail.Result.Mail.FromAddress)}.txt"

The emails are saved in: "D:\...\...\EMAIL\SUPPORT".

VC Version: 9.9.12

What can we do that the downloaded folders are again numeric folders and has the same name, as the "Write into file" produced .txt files like with IMAP before?

Our issue is really critical!

Kind regards



Hi,

Please create a ticket with this issue and send it to support@visualcron.com, as we are preparing to close down this section of the forums. So all technical issues are best (and fastest) solved via email tickets.
kleberj
2022-11-16T11:55:15Z
Originally Posted by: Michael Fjellström 

Originally Posted by: kleberj 




Hi,

Please create a ticket with this issue and send it to support@visualcron.com, as we are preparing to close down this section of the forums. So all technical issues are best (and fastest) solved via email tickets.





Hi Michael,

we did, but I didn't get an answer since 1 week. (request: 3621)
Scroll to Top