Article Evgeny Shvarov · Jun 8, 2016 1m read How to post an article from Word or Google Docs Hi, Community!If you prepare your longread for DC in Microsoft Word or Google Docs there is one very easy way how to add your formatted text and images in DC post at once.To make it do the following:1.Click Create Post on Developer Community.2. Copy all the text in Word o GDocs to the buffer.3. Click the button Paste from word (see the shot):4. Paste the text to the opened window an press OK. #DC Feedback #Developer Community FAQ 0 7 0 519
Announcement Evgeny Shvarov · Jun 1, 2016 Developer Community May Digest Hi!Here is the digest of the most interesting and valuable posts on Developer Community published in May 2016.Here we go!News and EventsCaché and Ensemble 2016.3 field test now available2016.2 Field Test Kit 2016.2.0.665.0 #Digest #Developer Community Official 1 0 0 502
Question Evgeny Shvarov · May 30, 2016 Solution for T9 Spelling Problem in Caché ObjectScript Hi, Community! Last weekend we held the Final of InterSystems Contest on Caché, DeepSee and iKnow under the aegis of IT Planet Student Championship in Ekaterinburg. BTW, this year we had more than 1,400 participants in InterSystems Contest. #Caché #ObjectScript 3 20 0 1.3K
Announcement Evgeny Shvarov · May 16, 2016 DC Statistics: 2000 comments! 1000+ posts! Hi, Community!Today we reached 2000 comments and answers on DC! The comment was made by Fabio Gonsalves!Also, a couple of weeks ago we had the 1000th post by Murray Oldfield!And we have 1,227 DC members today! #Digest #Developer Community Official 2 1 0 173
Announcement Evgeny Shvarov · May 13, 2016 Meet InterSystems Developer Community Twitter! Hi, Community!We've launched Twitter for InterSystems Developer Community!Follow us to be in touch what happens on InterSystems Developer Community. Find valuable postings, hot discussions and best practices links there. You can also retweet and like what you find significant!See how it looks:Join! #Developer Community Official 3 5 0 479
Question Evgeny Shvarov · May 12, 2016 Full series of dates in Time Dimensions in DeepSee Hi!Sometimes, especially when I work with Combined Cubes, I need to have all the dates in Date Dimension, not only members with rows in Fact table.Is there any way to switch it on? #InterSystems IRIS BI (DeepSee) 1 6 0 336
Article Evgeny Shvarov · May 11, 2016 1m read The simplest snippet to read from file in InterSystems IRIS Hi! I believe the simplest is (to work with csv delimited by ";"): set file = ##class(%File).%New( "data.csv" ) set sc = file.Open( "R" ) if $$$ISERR(sc) quit ; or do smth while 'file.AtEnd { set str=file.ReadLine() for i=1:1:$length( str, ";" ) { set id=$piece( str, ";" ,i ) write !, id // or do smth } } do file.Close() Possible options: different variants of error handling with sc code. Embrace while loop into try/catch block. And what's yours? #Code Snippet #CSV #ObjectScript #Caché #InterSystems IRIS 3 16 0 6.9K
Announcement Evgeny Shvarov · May 5, 2016 Developer Community April 2016 Digest Hi!Here is April digest of most interesting and valuable postings on Developer Community in April 2016.Here we go!News and EventsInterSystems Global Summit 2016 - Session ContentSources for InterSystems Global Summit 2016 Sessions and Expereiences2015.2.3 Maintenance Release #Digest #Object Data Model #Developer Community Official 1 0 0 373
Question Evgeny Shvarov · Apr 24, 2016 Import/export data from InterSystems Caché Hi! Suppose I have full access to Caché database instance A and want to export consistent part of the data and import it into another Caché instance B. Classes are equal. What are the most general and convenient options for me? TIA! #Databases #Data Import and Export #Object Data Model #Caché 0 11 0 6.9K
Article Evgeny Shvarov · Apr 16, 2016 1m read Try catch block I usually use in InterSystems ObjectScript Hi! Want to share with you code snippet of try catch block I usually use in methods which should return %Status. { try { $$$TOE(sc,StatusMethod()) } catch e { set sc=e.AsStatus() do e.Log() } Quit sc } Here $$$TOE is a short form of $$$TROWONERROR macro. Inside macro StatusMethod is any method you call which will return %Status value. This value will be placed into sc variable. #Code Snippet #ObjectScript #Caché #InterSystems IRIS 5 21 2 3.2K
Question Evgeny Shvarov · Apr 16, 2016 Atelier project hidden files. What should I commit? Hi!In every Atelier project you can find following hidden files:.buildpath.version.connection.project.Should I include all of them into commit?I understand that .project is mandatory. But what about the rest? Is there any general rule?F.e. if we work in team and everybody has their own connection on locale machine .connection should not be included. Yes? 1 1 0 374
Article Evgeny Shvarov · Apr 15, 2016 2m read Sources for InterSystems Global Summit 2016 Sessions and Experiences Hi! Please find all the source code Global Summit 2016 Sessions and Experiences in following GitHub repositories: #Global Summit 2016 #ObjectScript #Global Summit 4 1 0 934
Question Evgeny Shvarov · Apr 5, 2016 How to avoid writing duplicate code in dtl InterSystems Ensemble Hi! There is a question for Ensemble on Stackoverflow:I have the below dtl. In the foreach loop, I am just copying the same code in another part under anif condition. How can I avoid this redundancy? Can I reuse using sub transformation?Here is the dtl class file :https://docs.google.com/document/d/1snJXElyw13hAfb8Lmg5IaySc7md_DE8J40FB79hBaXU/edit?usp=sharing #Ensemble 1 2 0 563
Announcement Evgeny Shvarov · Apr 1, 2016 Developer Community March 2016 Digest Hi, Community!Here is the digest of the most interesting and valuable articles published on Developer Community in March 2016.If we missed something interesting, please feel free to add it in comments.So, here we go!News and EventsCaché and Ensemble 2016.1 ReleaseNew Book, Caché and MUMPS – Part II #Digest #Developer Community Official 3 0 0 397
Question Evgeny Shvarov · Mar 31, 2016 Running total without %CELL Hi!There is an example in Samples which shows how to implement 'running total' measure: "Pareto Chart for Category" dashboard.To calculate running total this pivot uses calculated measure with %Cell expression:Measures.[Revenue as Percent of Total] + %CELL(0,-1) #InterSystems IRIS BI (DeepSee) #Analyzer #MDX 0 3 0 428
Question Evgeny Shvarov · Mar 23, 2016 Get coordinates against street address Hi!Does anyone have an example of subj?I know there is google service for it. Anyone uses it in production? What is the feedback?In case of positive feedback would you please post the code example?TIA! #Caché #Code Snippet 0 5 0 446
Article Evgeny Shvarov · Mar 18, 2016 1m read Developer Community MVP of March and the Winner of GLobal Summit Contest II is ... Hi, Community! The Second InterSystems Global Summit Contest finished yesterday, and we have a new winner! John Murray has won the prize and showed very impressive contribution activity with the result: #Global Summit 2016 #DC Feedback #Global Summit 2 4 0 308
Announcement Evgeny Shvarov · Mar 10, 2016 Global Summit Contest II - half time review! Hi, Community! The Second Global Summit Free Registration Contest is running and we have only one week to celebrate new winner! Here is current leaderboard amongst non-InterSystems DC Members after a half of the race: #Contest #Global Summit 2016 #Other 3 0 0 148
Article Evgeny Shvarov · Mar 10, 2016 1m read DeepSee Termlist Deployment What is the best way to deploy DeepSee Termlists? #InterSystems IRIS BI (DeepSee) 0 5 0 359
Article Evgeny Shvarov · Mar 9, 2016 2m read How to make posts with code on Developer Community Hi! Here is small "How to" again. Suppose you need to share something with source code. How can we manage it on DC? Sharing code snippets 1. Add normal post (not Code Package). 2. Paste your code in the post and format it with highlighting as it is described here. #Caché #Code Snippet #Coding Guidelines #DC Feedback 3 2 0 488