Line feed in comment causing error

  • 1
  • Problem
  • Updated 1 year ago
  • Solved
We are using Replicon webservices to run reports and process them in PowerBI.
If an employee enters a line feed (enter) in the timesheet comment, the parsing fails.
At the creation of the report, the respective entry should be put in quotes (as it is done with commas)!
Photo of Meyer, Philipp

Meyer, Philipp

  • 29 Posts
  • 2 Reply Likes

Posted 1 year ago

  • 1
Photo of Jim Martin

Jim Martin

  • 2 Posts
  • 0 Reply Likes
Do you use Power Query to transform the comments field?
Photo of Meyer, Philipp

Meyer, Philipp

  • 29 Posts
  • 2 Reply Likes
Yes. Actually I was a bit too fast with posting the issue. It turned out to be a special case wich threw the error. In general, the replicon reports put quotes around the comments with special characters properly.
We did a workaround now by adding additional quotes in a custom field of the report.
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1521 Posts
  • 106 Reply Likes
Hi Philipp,

Thank you for confirming the resolution!

Thanks,
Aashnee
Photo of ADMIN, ASTROPAK

ADMIN, ASTROPAK

  • 3 Posts
  • 1 Reply Like
Phillipp, I am very curious as to how you linked Replicon and PowerBI via web services. Can you please email me at Kohlman@astropak.com

Thanks,