Search the Community
Showing results for tags 'csv'.
We have a Recipe Guide app in Caspio. I wanted to export all our recipes. It wasn't easy to find, but there is a "Download all records" button if you click on search, and then submit a search form. However, the CSV that is downloaded has question marks where there should be special characters, such as the 1/2 glyph or curly quote marks. Is there a way to get a UTF8 CSV of my data, with all special characters intact? Having the data riddled with question marks is useless. Examples: Recipe name (should be Marron glacés): Candied Chestnuts (Marrons Glac?s) Yield (should be 1½ to 2 quarts) 1? to 2 quarts stock Description (should be aren’t) Unfortunately, they aren?t easy to find.
I would like to set up a database where my authenticated users can upload their records (can be anywhere from 2-10k) in one go (who would fill in my form 10 thousand times a quarter?). The import feature worked great for me here, and if they had the ability to do something similar on their end - including the mapping ability the import wizard has it would be a life saver. Is this possible? I can't seem to find that option. Thank you kindly for your support! This is my first day and I do enjoy the ease of use here.
I'm using the below select statement in a calculated field, the resultset works great in the html grid when I fire the datapage, but when I export the datapage the columns are blank. I am able to get results if I change the values from 'true' and 'false' to 1 and 0. Has anyone run into this? We would like the text value of either 'true/false' or 'yes/no' Thanks, -John select case when sum(b.CCO_Place_Points) > [@field:State_Points_Required_Required_Points] then 'True' else 'False' end from JRRESULTSTABLENEW a join Lookup_Places_2 b on b.CCO_Place_ID = a.CCO_PlaceID where a.MemberID = [@field:JRCOOKSLISTING_MemberID]