go to post Michael Davidovich · Feb 21, 2020 Using: Cache 2018 Excel 2013 Using my local Cache so localhost 1972
go to post Michael Davidovich · Feb 21, 2020 Thanks! I don't seem to have that option (54). I do have the others however,
go to post Michael Davidovich · Feb 21, 2020 I downloaded and installed in USER, but unfortunately I am having a lot of trouble following your documentation and your examples. When clicking around in the interface, I got lots of errors and ultimately had to force quit the program. I wonder if my config file isn't right, but that is hard for me to follow and understand too. Hopefully you can clean up your documentation and I can try again!
go to post Michael Davidovich · Feb 5, 2020 Yes, it doesn't get easier than that! Good point on the counter. Thanks, Alexey!
go to post Michael Davidovich · Feb 4, 2020 Thanks, @Vic_Sun. I think %SYSTEM.Process.JobType() will be our best, simplest bet here. It shouldn't be a ton of data to check that we can't brute force it. Thanks said, I'm not familiar with using these class queries on a result set. Can you point me to the starting documentation on that? Best, Mike
go to post Michael Davidovich · Dec 17, 2019 Thanks, after spending some time with this I see it way more clearly now. I was on the right track using $LB in my code, but I'm not efficiently storing my coordinates for each wire and I'm get a MAXSTRING error. More tomorrow. Best, Mike
go to post Michael Davidovich · Dec 16, 2019 @Dmitry Maslennikov I'm wondering if you can talk me through your Day 3 code? Specifically the draw function. I'm terribly confused on where crossType and crossSteps are being set. Also the InterSystems documentation clearly shows how to use $LB on the right side of an equals operator, but I haven't seen it on the left side or understand how that works: Set grid(y, x) = $Listbuild(type, steps) I guess simply it's setting that node in the array to a list of two elements, type and step? Maybe by Christmas I'll get to day 5! Haha! Mike
go to post Michael Davidovich · Dec 13, 2019 @Carmen Logue Thanks, Carmen! I'm not sure I can add too much to your Alpha development I personally haven't been using the OBDC to connect into Cache. What I do know is that some other groups have used ODBC to connect into Cache with SQL projections. My team want's to avoid projections specifically (at this point at least) because we tend to only use them to get data from Cache to our Data Warehouse (Oracle). Other than that, we still traverse our database via globals and good old MUMPS programming. The project I'm working on is taking those many many routines that we have that traverse globals for reporting, and transforming the data to JSON streams. An %CSP.REST API will call those routines and provide the data to a Tableau web data connector so we can get instant, live data without projecting our whole database. I'm just getting start with Tablaue and Cache so I may have some more input in the future. Best, Mike
go to post Michael Davidovich · Dec 13, 2019 @Benjamin De Boe Have you made any progress on this? We just starting playing around with using Web Data Connectors in Tableau to call APIs into Cache. Best, Mike
go to post Michael Davidovich · Dec 4, 2019 I went home and put the community edition on my laptop, however, I will see if I can follow the steps in your article here at work. Thanks!
go to post Michael Davidovich · Dec 3, 2019 Thanks Evengy :) Yeah, I think my plan is to code and run in ObjectScript and then once correct, copy to a file in NotePad++ and commit changes from there. Does that sound right?
go to post Michael Davidovich · Dec 3, 2019 Soooo, what is UDL form? A Google search shows Universal Design for Learning, but I can't seem to find a spec for writing code. Also, I'm still using Studio. I've saved a project called AOC.prj and created a class AOC.Day1 in USER, but I can't find the source folder for USER to start a git repo and push it up. Nor can I save the project to anywhere but the namespace. Anyone else using Studio? Trying to remain positive here as I haven't even coded the first day yet because of my set up challenges :(
go to post Michael Davidovich · Dec 3, 2019 Thank you @Eduard Lebedyuk Turns out my problem was 1) bad code and 2) I'm getting a <MAXSTRING> error when building out my JSON object. Obviously long strings aren't enabled in our instance(s) of Cache . . . and I would probably need to make a really really solid business case to the people who can own and enable that setting. Can/will moving to an async style of API help this? { "errors": [ { "code": 5002, "domain": "%ObjectErrors", "error": "ERROR #5002: Cache error: <MAXSTRING>zBN0010+91^CLAIMS.mxdavidovich.ApiTestv1.1", "id": "CacheError", "params": ["<MAXSTRING>zBN0010+91^CLAIMS.mxdavidovich.ApiTestv1.1"] }], "summary": "ERROR #5002: Cache error: <MAXSTRING>zBN0010+91^CLAIMS.mxdavidovich.ApiTestv1.1"}
go to post Michael Davidovich · Dec 3, 2019 Nevermind. "Note: You need to sign in to Advent of code (e.g. with Github or Google account) to see the leaderboard and participate in the contest."
go to post Michael Davidovich · Dec 3, 2019 The link seems to just take me to the overall leader board. Am I missing something? This is going well for me so far
go to post Michael Davidovich · Dec 2, 2019 Dmitriy, this is awesome and thank you for your work on this! I've looked through the issues and the discussion and I don't think I've seen anyone post feedback about password security. Thought I'd discuss here before posting it as an 'issue'. In our org, we can develop locally, sure, but usually we are developing in a low level development namespace on the server, thus we are usually connecting to the server. In our org our username and password happen to also be the same credentials for our Windows login, network, everything really. Are there ways to avoid hard coding the password in the extension settings? Or is this a feature that can be developed? That said, it seems you have to specify the namespace in the settings as well. Is there a faster way to toggle between namespaces? Thank you! Mike
go to post Michael Davidovich · Nov 14, 2019 Thanks, Benjamin. I didn't realize that an application had to be created. I have it working now. The link Eduard provided was helpful. Thank you both!
go to post Michael Davidovich · Sep 12, 2019 @Flávio Lúcio Naves Júnior Check out my thread: https://community.intersystems.com/post/use-cache-write-excel-filesBasically people mentioned using Zen, Apache POI or Python.What we ended up doing was reverse engineering a Excel spreadsheet and using the %XML.Writer class, created functions to build out an XML file that is built and optimized for Excel. The problem is that you're left with just and XML file and not a true Excel file. We are working on that post processing challenge now.Hope this helps!
