I am trying to upload to our Open Data site powered by Socrata. I did enough research that I saw I would need to change the data to something Socrata would accept. But if I tell the writer it is a 'calendar_date' field, the schema is uploaded, but no records are created.
Question
Socrata writer using calendar_date writes the schema but not the data. Changing it to text it works, but is not a date.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+13- Safer
I haven't used Socrata before, but this sounds similar to something I came across in the past with another format.
As a possible first step, I'm wondering if your destination table in Socrata has already been setup with a non-date data type. I'm hoping you can check that out using Socrata. If not, try importing the writer feature type (two methods shown below) to bring in the existing schema of the destination table:
Once imported, you can open up the writer feature type parameters, go to User Attributes and see what data type the 'calendar_date' is set to:
+13- Safer
After taking a closer read of your description, sounds like you are seeing the attribute set to calendar_date in Socrata.... I'm wondering if you need to convert the values to a date format that Socrata accepts for calendar_date prior to writing out to Socrata using the DateTimeConverter. Let us know if none of these do the trick and we can try escalating it.
- Contributor
Thanks @nampreetatsafe I definitely tried letting the software create the data set and schema in case that was the issue. It didnt seem to help.