Next week, I will be heading out to Denver to check out the EAM (Enterprise Asset Management) conference. I won’t have a booth this time, but instead I’ll be out and about meeting people. If you are planning to be at the show, I’d love to meet up with you and chat for a few minutes. Email me and catch up.
mpiehl@gojavellin.com
Thanks for reading,
My latest trick in UI5 has me one step closer to my dynamic screen. Today I figured out how to loop through the JSON model. Turns out, once I had things in place, not as bad as I thought.
var oModel = this.getView().getModel(“config”).getProperty(“/results”);
if (oModel.length > 0) {
for(var i = 0; i < oModel.length; i++) {
var obj = oModel[i];
console.log(oModel[i].Field);
}
some things to notice. When you set oModel, be sure to use the getProperty(“/X”); where X is the group name. For me it was results, but if you aren’t sure, just look in debug mode and you’ll see what it should be.
Beyond that, it’s pretty easy. I added the console statement in here, just so I could see in Debug that it was looping through my table.
Thanks for reading,
I recently ran into this again in a current project, and of course, I had to look it up to remember how to fix it.
When you are in an ALV grid in SAP, you get the nice little export button. The first time you press it, it gives you the full list of output formats. it also has a check box to make it the default option. What they don’t explain is that once you press this check box, it’s not easy to get back and change it. In fact, the only way that I know of is to run a program.
SALV_BS_ADMIN_MAINTAIN
Inside this program, you can find the user and either change or delete the default for them. Seems strange, but it’s the way to fix it.
Thanks for reading,
I recently listened to a podcast that started talking about all the different forms of capital, and how each is incredibly valuable. I thought I’d spend a little time talking about the concept, and I’ll likely go into detail over future posts on what each of them means.
the idea behind this is that money isn’t the only thing of value. Especially when you look at starting a business. If you don’t have all 8 forms of capital is at least some form, you can’t expect to have wild success. For example, it’s taken me a long time to understand the value of social capital. Social capital at it’s heart is working with other people. If you don’t have this, you have no choice to do everything yourself. This includes building the product, building a sales and marketing pipeline, finding all your own prospects, closing the deals and on and on.
Being in a small business, I’ve tried to do this. It doesn’t work. The logic is very simple. No one has the time or aptitude to be great at all of these things. I used to shy away from the idea of partnering with other companies, thinking it would hurt my profit margin, and after all, I could do it myself. Nothing could be further from the truth. By companies that I can work with symbiotically, we can all win, instead of just flopping around trying to learn just enough skills to keep me afloat.
Some of the list is pretty obvious… others are require a little more thinking. But the bottom line is, what forms of capital are you currently leveraging? and how you leverage other forms of capital that you have overlooked?
Thanks for reading,
My UI5 journey has gone slower than I would like, but I’m still making steady progress. My latest obstacle to overcome was being able to read in my configuration tables, so that I could use them to dynamically alter what is shown on the screen. Obviously, the first thing I wanted to do was to be able to read in those tables, but I had a secondary objective, and that was to locally store all the values so that I wouldn’t need to read them in every time the application fired off. It took some digging, but I finally got there.
// Config Settings
// Using a local model for offline data capture
var oConfig = new sap.ui.model.json.JSONModel();
jQuery.sap.require(“jquery.sap.storage”);
//Check if there is data in the Storage
if (oStorage.get(“config”)) {
var oDataConfig = oStorage.get(“config”);
oConfig.setData(oDataConfig);
} else {
var urlCon = “Config”;
oModel.read(urlCon, null, null, false, function(oData, oResponse) {
oConfig.setData(oData);
}, null);
}
var oDataConfig = oConfig.getData();
oConfig.refresh(true);
oStorage.put(“config”, oDataConfig);
oView.setModel(oConfig, “config”);
so, if you take a look at this, the first section creates a JSON model (please note, that I have already connected to the service that contains everything. Now I just need to read it. the jquery.sap.storage is the cool class that is provided to locally store things in a browser. You will have nothing in here the first time the app is run from any browser (or if you clear the cache), but once it’s there, it will be read in, without a service call. The if statement above is what handles that. Note, that the url will have everything from the original model, I just needed to tell it what service to execute. In my case, Config, with no inputs. After the If statement, it is putting the data into the JSON model, and making the model available to the rest of the application.
Pretty easy, once you know the tricks. Next up, dynamically creating input and output fields using this data. But I have more homework to do before I can talk about that.
Thanks for reading,
Sorry for my absence of late. It’s been a crazy string of vacations, and today I’m finally back to the real world. Vacations are great, but it is damn tough to jump right back into everything. If you’re like me, there is always a never ending stream of daily tasks that I focus on. Suddenly, when you disappear for a full week, that means a lot of things got put on hold. Granted, I kept up with the most critical while I was out… but that left a lot of little things that I’m trying to get back under control.
Happily, my list has high, medium and low priorities… but when I see a huge list of things that all need my attention, it’s easy to get caught up in doing low priority tasks. I can’t lie… it’s how I spent the first hour of my day today… weeding through emails, and trying to check easy things off of the list. The problem is that it might make me feel a little better, I’m not getting the really important things done. But at least it helps me settle back into the routine… and if I can get away from the overwhelmed feeling, it makes it easy to start to tackle the more important things.
Moral of today… don’t beat yourself up. =)
thanks for reading,
Today I wanted to talk about the maintenance plans. At first glance, the maintenance plan is more of a feature than a benefit. Now in marketing 101, I’ve had it beaten into my head, benefits not features… Well, the concept of the maintenance plan actually fits both concepts… at least if you look at it the right way. The maintenance plan becomes a huge time saver if your business does any sort of repetitive service. Let’s go with an example everyone can relate to, oil changes…
In the auto service industry, everyone is familiar with the idea that you should change your oil every 3000 miles or 3 months. Well, using a maintenance plan, you could have a notification generated every 6 weeks. The notification would be for someone to send an email or a coupon to remind the person they have an oil change coming up soon. Now the amount of automation you build into this is up to you. But I’d be willing to bet that if you look at your industry there is at least some repetitive tasks that you could schedule.
Now, creating a notification or service order doesn’t really take that long, neither does sending an email. What does take time is monitoring a list, running a report, or checking a database to see who is who should be contacted, or who should be receiving a notification of upcoming service. If you set a plan one time, then you get to “set it and forget it”. This has multiple benefits, you get the obvious benefit of not having to babysit your marketing. But far more important, you move into the automated marketing world of keeping yourself in your customer’s minds. You get the chance to remind them of the value of “regular oil changes”, you get to offer them a discount if you choose, and you build a stronger relationship with your existing customers. The stronger the relationship, the more likely your customers will talk about you to their friends… giving you that perfect opportunity to get new customers and take care of them just as well as your existing customers.
Pretty solid ROI in my mind.
A couple months ago, I was emailing with a client that I helped blueprint their service. Well, about 18 months went by, and they still hadn’t started the project (glad I didn’t wait around for that gig). I emailed back and forth to see how things were going, and he asked me my opinion on CRM service. I was straightforward with him. I’m not a fan. Naturally, since they were thinking of implementing it, he wanted to know why. Well, here’s my opinion…
Now, admittedly, I’m biased. I like ECC (well as much as anyone can like a computer system), and I think it has a solid foundation. The only thing really missing, IMHO, is a nicer interface. This is obviously where CRM beats ECC hands down. But, an interface can be built. Between Fiori, personas, and UI5, I can build the same look and feel in ECC as I can in CRM, and I didn’t have to pay the 6 or 7 figure price tag to make it happen. Want to see it action? email me and I’ll give you a demo of just how nice you can make service in ECC. If there’s functionality in CRM that you need, talk to me first. I bet I can deliver it for a fraction of the cost of implementing CRM.
Thanks for reading,
Well, my most recent distraction has been trying to see if I can get rid of cable. Unfortunately, this comes with a lot of logistics that I need to prove out first, partially for myself, and mostly for my family 🙂 If you are anything like me, your cable + internet bill is usually around the $200/month (or more). Now, the biggest thing I complain about is that I’m paying well over a $100/month plus equipment rental fees, and in reality, I watch about 10 of the 200+ available channels. I’ve had more and more friends do this, so I thought I’d start to see what I could do.
First off, here’s a great post with tons of information that I’ve been using to get started.
https://www.groundedreason.com/cable-tv-alternatives/
Of course, things are never as easy as I would like. My first issue was that my uverse modem was old, so my speeds and connections were average at best. So after an hour or more with AT&T, I finally get a new router shipped to me. This was great, finally signal strength for the whole house, AC coverage, etc. Well, needless to say, that caused me tons of headaches for my SAP servers. A new router means all different settings. I think I finally have things working on that front, but starting yesterday, the internet keeps dropping. I have wi-fi, just no internet. As soon as I restart it, it works again. So great, I need to restart my router multiple times per day =(
the next big issue is that I decided to get rid of the wireless uverse box upstairs in my office. So far, all I’ve used that for is the Ethernet ports. Of course, that lead me down a whole different rabbit whole of how to get signal to all my computers upstairs. I’m wireless on most of the devices, but the servers don’t really run that well (and one won’t run at all unless it’s hardwired). So I think I’m going to go with a wi-fi extender with an ethernet port, then connect that to my switch so all my servers have connectivity.
NETGEAR AC750 Dual Band Gigabit Wi-Fi Range Extender (EX6100)
if anyone has experience with doing this, I’d love to hear from you. The sheer number of options are mind boggling, so a lot of my experiment is trial and error.
Next up, my Roku and antenna are on the way… so I’ll have more to talk about after I start experimenting with those.
Thanks for reading,
Yesterday, I started talking about the huge investment of an ERP system. The biggest point I hope I got across, is that the cost is very high, and if you don’t use effectively, the cost is MUCH higher. I know the service world very well, but I guarantee, it’s the same everywhere. The smaller you are, the more hats you have to wear. This means that you need every advantage you can get to keep things running smoothly. Often, the people down in the trenches aren’t “consulted” when a new computer system is being implemented. They usually get the memo when the consultants start showing up to “configure the system”. This means they often have to live with the best the consultant can give them.
All of these factors are why I started making my own applications for service management. Working in many small to midsize firms, made me quickly realize that 2 people can’t enter in all the data required for a repair and still do their normal “day job”. In general, the service groups are some of the best I have met in terms of getting the job done no matter what. The problem is that often they end up working outside the system, just get everything done. So, now this big expensive system that is supposed to capture all this data is being supplemented by some Excel files, and notebooks in the manager’s office. Try pulling those reports!!!
The best answer I came up with was a way to streamline the process. Make data entry as easy and straightforward as possible. That meant some programming work. I started down the path almost 10 years ago (at least that’s when the first idea started). Granted, there was a lot of ramp up time, learning curves to get past, systems to set up… But about 3 years ago, things got serious. Proximity became the dashboard for the repair depot and field service. Giving the managers a single spot to run the entire shop from, and giving technicians a simplified yet more complete view of their jobs. Renovation did the same thing for the call center and customer service. Creating applications to make lives easier has a much broader impact than I expected. It literally starts giving ROI to that big expensive ERP system. Instead of jumping from transaction to transaction or hiring a temp to transcribe paper into SAP, you get more info than you ever had before and the ERP finally becomes a help, not a hindrance. Am I saying you’ll instantly love SAP with all it’s rigorous checks and painstaking processes? maybe not… but at least you can start recognize some of the value that everyone promised when the purchasing decision was made 🙂
thanks for reading,