go to post Ben Spead · Dec 8, 2021 There appears to be an issue on Windows as it doesn't strip out the ":" from the filename when auto-generating the class( https://github.com/evshvarov/csvgen/issues/13). But beyond that I am stuck because is autodetecting my data/time column as Date and it is failing validation: USER>s sc=##class(community.csvgen).Generate("C:\temp\badge\data.csv",,"my.data") USER>w $system.Status.GetErrorText(sc) ERROR #5540: SQLCODE: -400 Message: ERROR #5002: ObjectScript error: <ZODAT>zWhenOdbcToLogical+1^my.data.1 This is that the file looks like: What,Where,Who,When,CardNum,Fac/CustCodeGranted Access [31358],"MYSPACE ""IN"" READER","Smith, John",12/06/2021 03:46AM,31358,314 So it is blowing up when it tries to read "12/06/2021 03:46AM" into the When field, which it auto-generated as: Property When As %Library.Date I could obviously hand-correct the auto-generated class but that wouldn't help if it just re-generates it the wrong way again when I try to do the import. Any suggestions on a way around this? Is there a way to force it to %Library.DateTime? Thanks! Ben
go to post Ben Spead · Dec 7, 2021 Congratulations @Timothy Leavitt - your article on Git for Shared Development Environments was the most viewed article on technical content!!
go to post Ben Spead · Dec 7, 2021 Well done to the winners! Thank you for participating in the contest and contributing to our community as a result!!
go to post Ben Spead · Dec 1, 2021 Absolutely! You will need to write a method that contains the SQL and then execute the method from a Task. As the linked docs suggest, write your own task by creating a class that extends %SYS.Task.Definition: https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?...
go to post Ben Spead · Nov 30, 2021 Wow - @Robert Cemper, thank you for this contribution back to the Community!!
go to post Ben Spead · Nov 30, 2021 In case this is helpful for any other AOC noobs, the '130669-ab1f69bf' code doesn't go in the sponsor code field that you will be shown when you first create an account. You need to click on the 'Private leaderboard' link in red to the right of that field, and that will bring you to a new page where you can enter the above code.
go to post Ben Spead · Nov 29, 2021 You should use $ZSTRIP with the "W" for whitespace: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Ben Spead · Nov 23, 2021 Don't worry about it - I have been writing ObjectScript code for 18 years and I had no idea about this method - I have always done it the way you did in your example :) Thanks for asking the question so I could learn something new as well!
go to post Ben Spead · Nov 23, 2021 This looks like an excellent resource and I hadn't heard of it before. Thank you so much for sharing!
go to post Ben Spead · Nov 19, 2021 @Guillaume Rongier - an interesting (and indeed radical) take on this ;) I agree that broader use of Python will allow gaps and new best practices to be identified more quickly, to the benefit of all. Your suggestion of not needing to use [language = python] is thought-provoking ... have you logged an enhancement to allow a descriptor at the class level which will allow python to be assumed across the entire class without requiring the python language to be specified in each method? I am generally quite conservative in nature, but your 'liberal' ideas are indeed thought provoking ;)
go to post Ben Spead · Nov 18, 2021 NOTE - the Git for Shared Development Environments code can be accessed from this post:https://community.intersystems.com/post/git-shared-development-environments
go to post Ben Spead · Nov 18, 2021 I would just like to point out that any attenders of Virtual Summit who missed Tim's presentation can still access the replay here: https://web.cvent.com/hub/events/90791fad-b517-47e6-a1ca-f6d419711986/sessions/a5d162c7-4c0d-4d07-a211-84d68c3c020c People who didn't attend Virtual Summit should stay tuned as the content will be published by InterSystems Learning Services and made available for everyone to watch.
go to post Ben Spead · Nov 18, 2021 ""My aim is to get DC members who a really fond of some particular aspect of ObjectScript, or Adapters, or Devices, or IRIS HL7 and IRIS FHIR to create cheat sheets which I will collect into one volume and have them styled in ISC colours and logo's and add them to the ISC Learning, Documentation, Global Masters repertoire" I really love this idea!! I know that @Michael Breen is also playing with ideas of how to crowd-source the simplification of ObjectScript reference resources to make it easier for new people to ramp up with the technology.
go to post Ben Spead · Nov 15, 2021 Congratulations @Matthew Giesmann!! Nice work on this challenging project. One small note - please change the font on your first paragraph - looks like it might be using Header or something like that. I look forward to seeing this extended
go to post Ben Spead · Nov 15, 2021 Thank you for sharing ... this looks like a great resource to keep on hand for Python newbies!
go to post Ben Spead · Nov 15, 2021 Well done @Mario Sanchez Macias !! A great utility to keep everyone from having to re-invent the wheel themselves :) Thank you for contributing
