Hi Shawn

and welcome aboard.

 Having an issue with hard returns, i know there is an option for Excel, but i do not have access to excel and currently use Google Sheets. Is there a way around this issue using a Google doc.

We do not support Google Sheets natively. If you require Hard Returns, MyDataMerge only supports them from Excel. I currently do NOT know if there’s an option to export to Excel from Google Sheets. Edit: Can you replace the hard returns by a custom string like !!!RETURN!!!? Then there’s another possibility to keep them, cause CSV files won’t preserve them correctly.

We use a lot of data that includes dollar amount entries like this…$X,XXX. when using a comma delimited csv file, the export will place it in “”, is there a way to use comma delimited csv files and not have the export include the “”?

Did you try the import Setting “Sanitize” on the import screen? (Gear icon above the CSV field once you dropped a file). If that didn’t work, please let me know

I was told there is no limit to the number of placeholders within a document, but i just tested a doc that included 81 placeholders, no export, getting [Error code 404032]. i keep knocking this down and exporting, wouldnt export until i got to 43 placeholders, any ideas?

There are unlimited placeholders supported. Error 404032 tells us (developers) that theres an (uncaught) error during the merge – args!. Deleting the placeholders down to 43 probably removed the one causing the issue. We can identify this and help you solving your issue. We have some steps to do this. First of all: Right after the issue appears go to MyDataMerge menu > Help > Send Feedback. Then fill in your name and email as well as a note referring to this ticket (paste URL). Tick the checkbox so we receive the logfile. Then we can have a look.

Merging data is a very complex process as there are millions of cases to take care about. We at MyDataMerge try to make this the most easiest process for our customers. If starting feels a bit stumbling, we’re here to help.

According to your other issues please send us the feedback mentioned to inspect this

Yes. As I said #LINEBREAK# is a reserved string in MyDataMerge and will result in a hard return in InDesign in the merged document. So if you do exactly that it will be a hard return in InDesign in the final document. If you need a soft linebreak use #SOFTLINEBREAK# instead.

If course this won’t solve your other issues where you need to follow the previously mentioned steps if we shall assist any further

Regards

Pat