Stay updated with announcements, get answers from the community, and share your feature suggestions with us.
You can also submit a trouble ticket or send us an email at firstname.lastname@example.org. We strive to respond to all service requests within one business day.
Support is also available by phone from 9AM to 5PM Pacific at (206) 340-8008, extension 3.
For current status of all Socrata-powered sites, see our status page at status.socrata.com
Stay in the know! Subscribe to support announcements. Click Here to Learn More
To learn more about the Socrata platform, please visit www.socrata.com.
Kellie Fontes Feb 20 • 3 • Announcements
Early in Socrata’s platform development, we decided that all Socrata accounts would be global across domains. The same account you used for open data NYC would work for open data San Francisco, only your roles and therefore permissions would be different. This decision, over time, led to the creation of SPAM accounts, that even though were not created on a specific domain, appeared to belong to such. In November 2013, we added a CAPTCHA to all Socrata user’s account creation page to help mitigate the potential creation of SPAM accounts.
In order to further slow down the creation of SPAM accounts on Socrata’s customers’ platforms, we are immediately:
Proactively deleting accounts that were created historically and are clearly SPAM
Deploying a temporary code change that makes all user profiles private by default and requires all user-profile access to be authenticated.
We anticipate that these changes will have no impact to your experience with your Socrata platform. The latter change will create the positive impact of search bots from Google or Bing no longer being able to index our customers’ users. Following these changes, we will investigate long-term solutions to further reducing the potential creative of SPAM accounts including implementing additional SPAM detection and a developing a cleaner means of allowing search bots to index the appropriate content for users.
Kellie Fontes Feb 11 • 2 • Announcements
For status updates on scheduled maintenances please refer to our status site status.socrata.com.
Kellie Fontes Feb 07 • 4 • Announcements
On Tuesday, February 11th we will be deploying a change to our Publisher API upsert method which will change how it deals with null (or blank) values. This change will only affect upserts of CSV data (rather than JSON data). This includes using the upsertCsv method within the soda-java library or using the Publisher API directly (by issuing a POST with a CSV payload and setting the Content-Type header to text/csv).
Currently you cannot update cells in an existing row of data using upsert so they to take a null (or blank) value. Passing an empty value in a row being upserted in CSV format results in the cell maintaining the pre-existing value instead of taking on the value of null (or blank). Non-null (or non-blank) cells get updated as expected.
The new behavior will allow successfully upserting rows with null (or blank) values using an empty value with double quotes (,””,) or without (,,) in the CSV. Before this change passing in ,””, or ,, for a given cell results in no change to the value of the cell in the dataset (it simply maintains the existing value before the upsert). After this change passing ,””, or ,, will cause the cell to take on the null (or blank) value for the cell.
IMPORTANT: If you have been using ,””, or ,, CSV formatting to update datasets using upsert via the API thus far, fields which you intended to be null would not have been successfully updated. We highly encourage you to review your datasets to see if this is the case and to take remediative steps if you find invalid data.
If you have any questions please email support [at] socrata.com.
Cam Caldwell Jan 24 • Announcements
The Visualize Sidebar (green panel) has a new look, and with it, significant UX improvements and functionality to help you as you visually explore and understand your data. The new Visualize Sidebar can be tried out on any dataset at opendata.socrata.com. Below are details of some of the most important changes. This change will be effective for all customers the week of 1/27/14.
Can’t figure out which chart will best reflect your data? Did you select and apply Bar chart when you meant Column? The chart selection pane now distinguishes which chart is which with helpful iconography and grey-shading lets you know which charts are applicable for your data’s format. Click through chart icons to decide the best format to understand your data or tell your story.
As you change between chart types, you will notice that the chart automatically re-draws on the screen. Instead of hitting “Apply” and waiting for changes to appear, you can now add more data columns, change colors, and change options in place, without having to “Apply” them each time.
Sections such as “Data Selection”, “Display Options”, and “Flyouts” now contains semi interactive icons to clarify some of the features provided in the Visualize sidebar. Below (left), adding a data column to a stacked column chart is demonstrated with the dotted lines above each column indicating the additional data series.
The new Visualize tab provides better feedback for which chart types and data columns
you can and cannot use and why.
All the color settings are in one place and you don’t have to worry about colors overwriting one another.
Conditional formatting is now part of the Filter Sidebar (blue panel). You can think of it as Filtering with colors (which is what it’s been all along!).
The Visualize Sidebar has been streamlined and reorganized to group functionality with useful titles and sections. These groupings are based on usability tests designed to extract the organization that makes the most intuitive sense.
All of these changes are the result of feedback, usability tests, and experimenting. We hope you like the improvements. As always, we are happy to hear what you think.
Please contact email@example.com or submit a ticket at support.socrata.com with comments or questions.