Forum Discussion
TSV Export Unusable state in Bookings
If you want more control over the data that is exported, you can try out the Bookings Graph API. This will let you export the data that you want programmatically:
https://docs.microsoft.com/en-us/graph/api/resources/booking-api-overview?msclkid=e622f360bf1311ec8ffee3f6ffe1e6a8&view=graph-rest-1.0
- Joshua_R_JonesMar 28, 2023Iron Contributor
davisjr
I appreciate your patience, sorry for not being able to get back as soon as I originally intended.
I created a new test page environment to confirm, the Japanese text is almost definitely the problem in the TSV files. All data is dummy data, so no need to censor.
Attached for larger viewing size. Here the first name I went with was 東 太郎, but as you can see the output was 譚ア縲螟ェ驛 (complete gibberish). This is true for all Japanese fields, none display correctly.
What's more, any row with the Japanese customer name you can see the columns are shifting over and squishing again. I had a mix of inputs on row 2, but interestingly the column shift only happens if the customer name is Japanese (at least here).
If you'd like to test yourself, I have some filler data for you here
Name: 東 太郎
email: english, not needed
phone: not needed
address: 石川県かほく市モ356ー7
Staff: (I don't know what's supposed to go here, it's always corrupted to 繧ク繧ク in all our pages)
Staff Name: ジョーンズジョシュアロデリック (My name)
Service: テストサービスIf a video call or the actual TSV would be useful for troubleshooting please let me know.
- Joshua_R_JonesMay 31, 2023Iron ContributorHi, this was a while ago but I haven't seen any improvement.
Is Bookings not capable of supporting Japanese for all features?
Appreciate any help.- Joshua_R_JonesAug 15, 2023Iron ContributorFollowing up on this, it is still the same.
- Joshua_R_JonesMar 22, 2023Iron Contributor
Hey, davisjr thanks for getting back to me.
I will be trying in a new Bookings to see if I can replicate. In particular, I think this is a problem with the Japanese language characters, so I will create test data with that in mind and perform and export. Will post results here for troubleshooting purposes.
In the meantime, I will look into the API for Graph. I'm not familiar with Graph yet (name only) but if it works as a solution for our reporting that'd be great.
Appreciate your willingness to help, will get back with tests later this week.