datasync icon indicating copy to clipboard operation
datasync copied to clipboard

GUI no longer produces a column ID list

Open levyj opened this issue 10 years ago • 2 comments

The GUI no longer has the "Get Column ID List" button. This was a useful feature when creating control files. Could you reinstate it?

We are still on Verson 1.5.3 for our production use due to Issue #93 so I think this issue was introduced in Version 1.6 but am not sure. It exists in 1.6.1.

/CC @tomschenkjr @shua123

levyj avatar Dec 02 '15 22:12 levyj

As an update, we have since switched to 1.8.0 and this feature is sort of present but buried. If one goes to Map Fields / Advanced Import Options and scrolls down, there is a Display Control File button.

In addition to being harder to find / get to, the other issue with this approach is that it presents a bit of a Catch-22. The accurate column list only appears after doing the manual mapping but my main use case previously was getting the column list from the dataset in order to drop it into a control file to be used headlessly.

levyj avatar Mar 21 '17 16:03 levyj

Related, http://socrata.github.io/datasync/resources/faq-common-problems.html still refers to "Get Column ID List" button, even though it has been gone for at least two years.

How do I find the API field names for my columns?

Columns within a dataset have both a display name and an API field name. Datasync only operates using API field names. If using the DataSync GUI, you can get the list of API field names by clicking the ‘Get Column IDs’ button after entering the Dataset ID [emphasis added]. You may also view the API field names from your browser, by hovering over the information icon on any column.

levyj avatar Dec 13 '17 23:12 levyj