- 2023-09-15 at 12:12 pm #19176Martin MCustomer
I am exporting around 26000 PDFs. I keep getting the same error randomly. I tried to go in ranges of 100, and then it mostly works, but sometimes I get the error aswell. It is independent from the entry in the source file or the respective PDF. Within the same range of 100 it stops at different files.
What does that mean and how can this be fixes?2023-09-15 at 12:16 pm #19177Martin MCustomer
I also send the feedback via the help menu right after the error.2023-09-15 at 12:25 pm #19178PatStaffThis reply has been marked as private.
Official MyDataMerge Team2023-09-15 at 12:29 pm #19180Martin MCustomer
I replaced the / with a dash (-) in the Excel file and now it works. But I cannot do this for 26000 records. It would be great if you could provide a solution. Also as the field is being used in the INDD file as title, the dash should stay in there to display correctly on the PDF content.
Martin2023-09-15 at 12:33 pm #19184PatStaff
Glad it works
i will submit a ticket to the developers for checking this behavior. I will let you know here if there is a solution available.
Official MyDataMerge Team2023-09-15 at 7:07 pm #19192PatStaff
developers just signalized that this isn’t the expected behavior. A sanitizing will be implemented that only allows alphanumeric characters (a-z, A-Z), dash (-) and underscore (_) in filenames.
This means that receiving “text/text” will be changed to “text_text”, but only for the filename. Content to be put inside the layout will remain “test/test”
This will be available with the next update.
EDIT: Even if macOS is more comfortable with spaces or other characters in filenames, windows is not. Assuming a lot of users send the merged files to clients that might own windows, it’s the correct way to choose a strict file naming working on both systems.
Official MyDataMerge Team2023-09-17 at 1:01 pm #19196PatStaff
Developers rejected my ticket and told me, there’s another option right now available
When defining your (dynamic) filename, you usually add a datasource element (where you select the datasource column). This element has a gear icon. Click it and select the “Sanitize for web” option which basically does exactly that (allowing no character except a-z,A-z and 0-9).
But what we will implement is a filename test that will check the final filename for illegal characters and throw a warning.
Official MyDataMerge Team2023-09-23 at 8:36 am #19222PatStaff
we just release version 2.1.4. For your case we added improved error message to provide better guidance. There now is a check of filenames before export and a warning if some of the filenames include unsupported characters. Then you just need to enable the “sanitize for web” option in the elements of the filename setup to avoid this issue.
Official MyDataMerge Team2023-10-04 at 2:56 pm #19252PatStaff
Any progress on this?
Official MyDataMerge Team
- You must be logged in to reply to this topic.