Search the Community

I wanted to clarify this question from another post here in the hopes a Caspio person will see this and resolve the issue. It would be extremely helpful to be able to push a new calendar event from a Caspio Submit (or Update) datapage to google calendar. I found a post that uses the example below to open Google Calendar and populate a new event's fields with example data. This creates a button that pushes it all in the url: <a class="btn btn-primary btn-xs" href="https://www.google.com/calendar/render?action=TEMPLATE&amp;text=Lunch%20with%20Stripe&amp;dates=20161116T120000Z/20161116T140000Z&amp;details=https%3A%2F%2Flondon.techhub.com%2Fevents%2Ffounders-lunch-5&amp;location=TechHub%20London&amp;sprop=&amp;sprop=name:" id="addToGoogle"><i class="fa fa-google-plus"></i>&nbsp;Google</a> The problem is getting the Caspio fields to populate the data- especially the dates and times. Also on a Submission form it seems to only bring into the url Authenticated fields (maybe because the new record's values aren't saved yet). That's ok if an Update form must be used, to make sure the field's values are pushed into the url. The issue is it doesn't seem to be pushing the values in a way Google Calendar can use it, especially the first 'text=' and the dates. Using the example above as a map, how does the below code need to be modified so google calendar can read it correctly? <a class="btn btn-primary btn-xs" href="https://www.google.com/calendar/render?action=TEMPLATE&amp;text=[@field:mytitletfield]&amp;dates=[@field:CalDate*]/[@field:CalDate*]&amp;details=[@field:myNotesfield]&amp;location=[@field:myLocationfield]&amp;sprop=&amp;sprop=name:" id="addToGoogle"><i class="fa fa-google-plus"></i>&nbsp;Google2</a> I can get all but the first 'text=' and the Dates to work. Any help in figuring this out would be greatly appreciated.

Hi, is there any way to download the data from a Tabular Report Datapage via the API? Or even export it?

Is there a way to retain the original format of timestamp date when exported? In the table the format is mm/dd/yyyy but when data is exported it changes to m/d/yyyy. This is the format in the table. While this is the format in the exported file. I need to have the same format(mm/dd/yyyy) for my exported file.

I'm trying to work with a datapage's download file in a bit of a different way then normal. Instead of the user clicking the 'Download' link I need that download csv file to just 'open in the url.' (meaning the datapage tabular view doesn't open at all). This is because I need that download csv file to be available via a url for another, outside app to access (using that url) and then use to import that data. I need to cut out the steps where the user has to 'download the data,' take that file and then 'upload it to the outside app' to do the actual import. The outside app should be able to just go to a url and grab the data. I’ve looked into the Datahub but it won't work for this particular need because it’s an ‘all data all the time’ thing with 2 drawbacks. 1) it doesn't 'authenticate' the data at a sub-account level, other than the overall CB account and 2) all records need to not be exported at all times- only records the user designates or that are in a queue using various fields in the View for filters. The existing ‘download’ link in a tabular datapage is close to solving both the authentication issue because 1) the datapage will only show data for the account that’s logged in and authenticated already, by design and 2) the ‘export status’ issue is dealt with using normal filters to filter out non-exportable or already exported records. These are the 2 big hurdles and using existing data pages solves them both. The missing part of this solution would merely be setting the datapage to ‘open the download file’ instead of opening the datapage view, on load. Since the datapage already has a download link the user can click on to get the data downloaded in xml/csv, it’s got to be just a matter of pointing the ‘on load’ of the datapage to just go to that existing ‘download’ link and instead of downloading anything just open it in the data page’s existing url. Another related option might be for the datapage's 'onload' to activate the 'download csv' file and send it to a specific, designated url that's not the opening datapage (if that's easier). Then the outside app can go to that url and pull the download csv file. Surely this can be done? It seems like it’d be very similar to the code for ‘select all’ and then ‘open bulk edit’ automatically that can be implemented on a tabular datapage. We just need ‘onload’ to be ‘open download xml/csv.' Any help on this would be greatly appreciated-

I'm asking to hopefully save time later. (Note that I don't need this for application functionality - just for a final downloaded file.) I need to end up with an excel file that has no null fields - they need to be converted to "0". Is it possible to download a table as a csv/xls file and convert simultaneously? Or have that happen during a scheduled task export? Any tips would be greatly appreciated. Thanks!

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.

Hello! I setup a Scheduled Task to export some data on a daily basis. Everything works great, but I am just wondering if there is a way to specify the formatting of the date in the file name when you check the option to "Append date to file name". Currently, the date comes out as follows: "filename_2017-Jan-19_2200.csv". I would like the file name to be saved as: "filename_20170119.csv" (filename_YYYYmmDD.csv) I don't see any areas that cover this in the Help section and under Localizations. Thank you for your help!

I would like to schedule an Export Task that saves a small non-zipped table to a local network folder without using ftp. Is this possible? Thanks.

How do I export my Table Design to a spreadsheet? I do not what the data table....just the table design.

I am able to export my apps manually one at a time (extremely time-consuming) through “Tools/Export”. Is there a way to batch export all Apps? I have setup “Scheduled Export Tasks” through DataHub on my account. I am able to export Tables and Views but do not see an option to export the App’s datas pages. Am I missing something or does the DataHub task scheduler only support tables and views for export. Thanks in advance for all sugestions