Chris Metcalf's dashboard

Chris Metcalf replied on November 18, 2009 18:01 to the question "Are you guys ever going to add calculated columns?" in Socrata:

Dave -

Calculated columns is a feature that is on our backlog and that we are planning on implementing at some point. We're currently experimenting with a feature that will allow you to build simple queries, similar to SQL, and you'll be able to perform basic calculations as well as "mash up" data from multiple datasets.

What is your use case where you're looking to use Calculated Columns? I'm curious what you're trying to build and I'd like to take it into consideration with our plans.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

A comment on the question "How do I edit my dataset?" in Socrata:

@weaselinks -

There's currently a limitation on number columns where you can only search for the entire value of a number cell, so you'd have had to type in the full IMEI number for the search results to work.

I went ahead and converted your IMEI column into a "Text" column, so searching within that column should work now.

Sorry for your troubles,
Chris Metcalf – Chris Metcalf, on November 12, 2009 22:20

A comment on the question "How do I edit my dataset?" in Socrata:

@weaselinks -

Alright, it looks like I can reproduce your issue. I'll have an engineer take a look at it and get back to you when we have a solution. Thanks for reporting it.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com – Chris Metcalf, on November 12, 2009 19:48

Chris Metcalf replied on November 12, 2009 02:23 to the question "upload data" in Socrata:

Koji -

Yes, you can use the "Append" feature to add new rows to an existing dataset. It's available in the dataset menu under "Data" -> "Upload More Rows" -> "Append From a File":



Append will allow you to upload a file with the same columns as your existing dataset, and have those rows added to the bottom of the dataset. The "Refresh" feature available to premium customers also allows you to replace all of the rows in a dataset.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on November 06, 2009 22:08 to the question "How do I edit my dataset?" in Socrata:

Lynette -

It sounds like you're having a different problem. Can you provide me with a link to your dataset so I can take a look at what might be going on?

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on November 06, 2009 01:47 to the question "Email notification for comments?" in Socrata:

Pirls -

That's a feature we're planning on adding, and we want to make it configurable so you can choose whether or not to receive emails for a given dataset.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 22, 2009 21:25 to the idea "Firefox Search Plugin" in Socrata:

Jeff -

Are you thinking of a search plugin for Firefox to allow you to search for public Socrata datasets? That's a pretty great idea.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 21, 2009 20:42 to the question "How can I insert a row and move a row within a dataset?" in Socrata:

efficiencyunit -

You can add a new row to a dataset by clicking into the row labeled "new" at the bottom of the dataset. Unfortunately you cannot insert a new record into the middle of a dataset currently, although this is a feature we'll be working on soon.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 21, 2009 20:39 to the question "How to collaborate the dataset on embedded websites?" in Socrata:

cwytsang -

You can embed your dataset into a social networking site using our "Publishing" feature. In the "Publish" tab below your dataset, you can copy the HTML code necessary for you to then paste into the social networking site to embed your dataset.

We don't currently allow users to edit datasets when they're embedded in another page, but you can grant other Socrata users "collaborator" access to a dataset, which will allow them to update the data in your dataset, which will then be reflected in the embedded version.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 15, 2009 00:36 to the problem "My Dataset Disappeared." in Socrata:

Don't worry, I'm hard to shake :)

The "Tools" menu is actually in the Firefox menu bar. Here's where it is on an Apple computer:



Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 14, 2009 20:03 to the problem "My Dataset Disappeared." in Socrata:

Hmm... When you load the page, do you see any errors under "Tools" -> "Error Console"?

Thanks,
Chris

Chris Metcalf replied on October 14, 2009 18:54 to the problem "My Dataset Disappeared." in Socrata:

@5030Go -

If you follow the instructions in this WikiHow article to clear your web browser cache, and then refresh that page, do you still see no columns?:

http://www.wikihow.com/Clear-Your-Bro...'s-Cache

Thanks,
Chris

Chris Metcalf replied on October 13, 2009 18:47 to the problem "My Dataset Disappeared." in Socrata:

@5030go -

Can you send me a link to the dataset that you're having issues with? I'll dig into it and see if I can get your columns back and see what might have happened to make them disappear.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 13, 2009 18:04 to the question "Can you search and dynamically display data results?" in Socrata:

Steve -

Sorry about not getting back to this thread sooner, but our advanced filtering tool is now available. You can find it in the dataset menubar under "Filter & View" -> "Filter Out Rows":



Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 12, 2009 22:55 to the question "Editing in a filter view not preserved in full dataset??" in Socrata:

Michelle -

Can you provide me with a link to the dataset you're having problems with? I'll try to reproduce your issue from my end and see what might be going wrong.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 12, 2009 17:54 to the question "how do i move rows?" in Socrata:

Michael -

Sorry about taking so long to get back to you. Are you trying to move rows from dataset to dataset or are you trying to sort or reorder rows inside a dataset?

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

A comment on the question "How do I edit my dataset?" in Socrata:

@weaselinks -

Can you send me a link to the dataset you're trying to search in so that I can give this a try?

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com – Chris Metcalf, on October 12, 2009 17:52

Chris Metcalf replied on October 12, 2009 17:50 to the question "can i create a dataset and then allow others to add to it?" in Socrata:

David -

Unfortunately not. Visitors need to have Socrata accounts and they must be marked as a Contributor in order to edit a dataset.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 05, 2009 22:33 to the question "Editing in a filter view not preserved in full dataset??" in Socrata:

Michelle -

You should be able to edit through a filtered view, as long as you're logged in and you have the right privileges to edit that dataset.

When you made your edits, did the cells turn yellow and then, after a moment, turn white again? While the background is yellow, the cell is saving, and you shouldn't change back to the parent dataset, since your changes will be lost.

Please try again and let me know what happens.

Thanks,

Chris Metcalf
Technical Program Manager
chris.metcalf (at) socrata.com

Chris Metcalf replied on October 02, 2009 17:26 to the question "How do I edit my dataset?" in Socrata:

We've actually released a new version of our data grid recently that removes the necessity to click on the edit button. Now you can edit by just clicking once to select a cell, and again to move the cursor into it, much like you do with a normal spreadsheet application.