Tagged: merge
- AuthorPosts
- 2023-01-14 at 3:18 pm #18328Shawn WalshMember
Good morning, I’m new to the MyDataMerge plug-in and had an interesting thing happen to me today. When I have a $0 record in my csv file, it will not merge. If I change that to $1 or any other $#, the merge is successful.
Any ideas on how to solve for this?
thanks
shawn
2023-01-14 at 3:25 pm #18329PatStaffHi Shawn
And welcome aboard.
This is interesting. Could you please send a Demo data csv file to support@toolboxcode.com? You can delete any other record that is not relevant and rename crucial/private data. Before sending please try if the behaviour is still the same with the reduced file.
Regards
Pat
Official MyDataMerge Team
2023-01-16 at 3:31 pm #18333PatStaffHi Shawn
thank you for sending the files. We can reproduce it here and have an explanation but not the solution (yet). MyDataMerge partially uses InDesigns GREP functionality to inject data. In GREP, $0 is a special character with its own functionality so this breaks here.
We will figure out a solution and get back to you.
Regards,
PatOfficial MyDataMerge Team
2023-01-16 at 10:27 pm #18343PatStaffAn update for you:
We have implemented a fix to solve this which will be released with the next update.
Until then you might do the follwing: do a mass replace of $ to a generic string e.g. XYZ in your csv
Setup the project as you’ve done before, then go to export > extras > grep text.
Add a new rule, search for XYZ and replace it with $. This will be applied right after the merge.
Regards
Pat
Official MyDataMerge Team
2023-01-17 at 4:56 pm #18345Shawn WalshMemberThanks for looking into this so quickly. I will keep my eye on the update. In the meantime, I tried the quick solve and unfortunately it’s still not working. I tried both XVZ0 and XYZ 0 in the data file. I first thought the no space was causing it. Any thoughts?
2023-01-17 at 8:36 pm #18347PatStaffHi Shawn
i apologize. I didn’t check it before. Grep replacements rely on the same technology and therefor are affected by the same issue. We already have fixed it in the new version and grep replacements then work again (although if you then don’t need them).
Good News is that we will release it this week. I will let you know it here once it’s released.
Regards, Pat
Official MyDataMerge Team
2023-01-18 at 8:24 pm #18358PatStaffHi Shawn,
we just released 2.1.0 – go to the MyDataMerge Menu > Check for Updates
Please let me know if it works for you.
Regards,
PatOfficial MyDataMerge Team
2023-01-18 at 9:26 pm #18367Shawn WalshMemberPat,
Just updated and ran a new export, WORKS PERFECT! Thank you so much for getting this updated so quickly.
2023-01-18 at 9:50 pm #18368PatStaffGlad we could help. Just let us know if there’s anything else you need to know.
Official MyDataMerge Team
- AuthorPosts
- The topic ‘$0 Not Merging’ is closed to new replies.