Every progam that you plan to work on much be on a Programmers worklist which will be assigned to a Project/Task (or a Project/Task/Subtask) - so just think of the project as a way of grouping similar programs, or working tasks together:
Projects have Tasks.
Tasks have subtasks.
I hope this video helps - after watching you can goto:
So, I've been working on a freelance gig for some time now and the client uses Turnover (by Unicom) to manage their software development on their development system - an IBM Power System running the IBM i operating system. The Project involved writing some web-services to provide a web based interface between an old #ERP system and a new PHP enhanced warehousing system. There is a small team of 4 programmers on the project but software change management is just as important with a small team as it is with a huge global one...
I was asked to create instructions for team members to easily use the basic process for:
Part 1 - Using Turnover Projects and Tasks
Part 3 - Promoting code using Turnover Forms
During a meeting this morning, I was asked to provide a list of all Customer phone numbers for any System21 Customers that have ever been used on a Sales Order.
Perhaps this sounds like a complicated request but... have no fear SQL is here!!! In reality, its a very simple thing to find and takes just a few seconds using a SQL INNER JOIN.
How can we use SQL to find this data?
In this example, I'm working on a data cleanse to make sure that the phone numbers are properly formatted before sending them to FEDEX as part of the shipment information. We know that some of our data is badly formatted so lets quickly see how many are good, bad or ugly. Using SQL we can see all CUSTOMER entries from the Customer Master file (SLP05) which have been referenced on the Sales Order Header file (OEP40).
The SQL command goes like this:
So, I've been using my trusty Samsung S5 for the last 18 months and have generally been delighted with it. But, I've recently found it a little slow when playing #Ingress and decided it's time to upgrade to something just marginally quicker ahnd (most importantly) with a bigger screen for my sausage like fingers. </drumroll>Enter the mighty Samsung Note Edge</drumroll>
I snapped up a half price ATT Note Edge (model sm-n915a) on Craigslist, and I can confirm that it works very nicely on T-MOBILE. The only irritation I have, is the stock AT&T Android ROM and I would prefer to install a clean basic Android. But cant find a way yet!!! Apart from that minor thing, the phone works great and 4GLTE connectoin is steady and reliable.
To make the changes from ATT to the TMOBILE servers you just need to make a simple change to the APN connection info.
You just goto SETTINGS ! MOBILE NETWORKS ! ACCESS POINTS and delete any old ATT ones and create one called T-Mobile like this:
I'm in the final stages of a fun project writing web-services to interface INFOR System21 (on an IBM i aka AS400) with ACSIS Visitrack (on Windows Server), we are consuming (receiving) and serving (sending) all data in a standard alphameric layout But... as any RPG programmer will know... the conversion between alpha to numeric is easy to overlook and can quickly bite you in the arse.
This morning, I had a long discussion with one of the technical analysts talking about the differences in data layout between the "web" world and the "IBM i" world. Out there in website land data flows around in nice alphabetical chunks. I mean, my name is simply "Nick" and the number sixty seven is simply "67" and two and a half is simply "2.5". But in the database world character can be fixed length "Nick " or varying length "Nick%" and numerics are commonly stored as packed decimal data so 67 could be stored in a field that is 15,5p so would look like "000000000000067000". It sounds complicated but if we keep our code clean its a simple process to switch between these formats. Lord Sridhar Maheswar - I promised to write a blog about this to make it clear... here it is :)
Migrating Cousin Rob's www.DRUMSTHEWORD.com website from his 6 year old Drupal6 website to a new (hopefully sexier) Wordpress4 website has meant a lot fo data cleansing before golive. Before we get any comments about Drupal vs. Wordpress, or a CMS flamewar, the new website was chosen to be on Wordpress because of WOOCOMMERCE and a neat Wordpress Theme that had already been selected.
So, I'm going to leave a little blog about any particular problems I found, or cool tricks I found, during data migration.
The old drupal website had over 48,000 users defined... many of them spam... many of them dead... many redundant or no longer needed.
So how do we cleanup users?
Using the PHP panel I used this SQL script to select the users that have been registered but who have never ordered anything using Drupal6 Ubercart:
select count(*) from users where mail not in (select primary_email from uc_orders) and uid <> '0' and mail NOT LIKE "%drumstheword.com%" and mail NOT LIKE "%projex%"
note: do not touch uid=0 because this is the ANONYMOUS user and do not touch any *@drumstheword.com or *@projex.com users
this will give you a count value showing how many users are selected and if your ready to delete then just use:
Thanks to Mr Aaron Bartell (of Krengel Technologies) for this excellent article on using GIT for controlling source code changes on IBM i.
I've been doing this for a while on source code for PROJEX4i and have kept meening to write a little blog about it. Aaron's article nicely touches on the high level concepts of GIT, it's ease of use and nice documentation techniques. Perhaps I will follow this up with another blog talking about GITHUB and it's lovely windows GUI for GIT'ting things
<Article originally published via itjungle.com on 2/10/15>
In a previous article, we learned about Ruby methods and encapsulation. During the various exercises there were many code changes made and we didn't really have a simple way to keep track of how the code changed from one version to the next. That's where source change management (SCM) tools like git come into play and is what we will be diving into with this article.
Data Queues are a common object type in many applications on IBM i Systems: They offer an easy way to queue up data to be read and processed. Easy to load, easy to read and an easy way to handle sequential data. The only thing that I really dont like about them is the tricky way you have to poke around in them to look at their contents. But, I found this neat article on that highlights some new IBM i *API's that change to the old way that data quees are handled... we can now retrieve data queue entries without removing them. Yay!
This allows us to peek at Data Queue contents without upseting programs that are processing the queue itself...
In the past month or so, I've received two requests related to accessing data queue (*DTAQ) information. The first request concerned finding out how many messages were currently on a *DTAQ and how long the oldest message had been on the queue. These questions, to me anyway, suggest a management application to periodically poll *DTAQs and determine whether they are backlogged and in need of additional readers to be started and/or are stuck for some reason, for instance an outstanding inquiry message.