ThreeSixtyGiving / standard

The 360Giving data standard for UK philanthropic giving
http://www.threesixtygiving.org
Other
10 stars 15 forks source link

Case sensitive field names #35

Closed stevieflow closed 7 years ago

stevieflow commented 9 years ago

Are field names case sensitive - eg id rather than Id ? I'm guessing this is so - as laid out in the schema.

There is a use case whereby if someone manually enters the field names into excel/calc, then the software will auto capitalise the first letter of the string (id to Id), which could cause problems....

practicalparticipation commented 9 years ago

Field names are generally case sensitive for most consuming apllications but if in our tooling for the registry we are going to generate converted copies of each sheet we could make our tools more forgiving and make the validator WARN rather then throw errors on this.

That would shift more of the sorting data out labour onto users and lower fiddly barriers to publishing.

Depends on how tricky we think some people would find it to correct those headers and how supportive we can make the validator I think.... On 21 Jan 2015 20:27, "Steven Flower" notifications@github.com wrote:

Are field names case sensitive - eg id rather than Id ? I'm guessing this is so - as laid out in the schema.

There is a use case whereby if someone manually enters the field names into excel/calc, then the software will auto capitalise the first letter of the string (id to Id), which could cause problems....

— Reply to this email directly or view it on GitHub https://github.com/ThreeSixtyGiving/standard/issues/35.

timgdavies commented 8 years ago

@Bjwebb @kindly Can you confirm what the position is now on case sensitivity with flattening tools?

I'm flagging this as an issue that should be clarified in updated documentation where I suggest:

but

Bjwebb commented 7 years ago

Are tools treat field names as strictly cases sensitive, but all 360Giving spreadsheet users use titles, which are case insensitive.