• Alan’s Easy Method For Building A CSV File From A Report

  November 20, 2013 Ted Holt

  I love simple solutions to common problems, and boy, have I got a good one for you today! Clever and faithful reader Alan Urtubia recently told me how he turned a report into a CSV file and I was impressed. Alan kindly allowed me to pass this tip along to you. Alan needed to create a CSV file from a report without modifying the RPG program. He found a method to do so without modifying or recompiling any of the original source code. To illustrate his technique, let’s begin with a simple report. Here’s the DDS for printer file QAD001P:

  … Read more

• Allow Repeated Change With SQL Triggers

  November 20, 2013 Paul Tuohy

  In my previous article, I described how an RPG program as a before trigger, could be used to synchronize two columns in a table. There is an alternative. Instead of using an RPG trigger, we could have used an SQL trigger. An SQL trigger allows us to be more specific about when the trigger is activated and also has the advantage of portability to other database management systems. The scenario was where a date, stored as a packed numeric column, was to be converted to a proper date field. This was accomplished by duplicating the packed numeric column (and

  … Read more

• Spinnaker Says Third-Party Support Biz Growing at a 30 Percent Clip

  November 19, 2013 Alex Woodie

  Spinnaker Support, which provides third-party technical support for ERP and CRM systems from Oracle, JD Edwards, and SAP, brought in 34 percent more money during the third quarter of 2013 than it did in Q3 last year, the company announced last month. One of the accounts it landed during the quarter was a big JD Edwards World shop by the name of Cook County. When it comes to third-party support for ERP applications, there are two main games in town: Spinnaker Support, which is based in the old JD Edwards stomping grounds of Denver, Colorado, and Rimini

  … Read more

• Kronos Ditches Reports with Analytics Updates

  November 19, 2013 Alex Woodie

  Kronos last week announced updates to its Workforce Analytics offering that should help customers make sense of large amounts of employee-related data stored in various Kronos applications. The company also used its annual KronosWorks user conference to tout big gains made in hosting its customers’ HR apps in the cloud. With the Workforce Analytics update, there will be a big focus on using visualizations to allow managers to explore their employee-related data sets in a self-service manner. For example, managers can start out using heat-map visualizations and 2-D imaging to see broad-based data about overtime, absence, scheduling, and productivity data.

  … Read more

• Joomla’s CMS is RAD

  November 19, 2013 Alex Woodie

  IBM i shops that are looking for a full-featured content management system (CMS) to run sophisticated Web sites might want to check out the latest release of Joomla, the PHP-based open source CMS. With the newly released version 3.2, Joomla gets lots of enhancements, with a big focus in the areas of app development, security, authentication, and version control. In early November, the Joomla Project and Community announced the availability of version 3.2 as a stable release. With about 600 new features and bug fixes, version 3.2 is the biggest release of the CMS ever, according to project coordinators.

  … Read more

• Cloud MFT from Ipswitch Gets Mobile

  November 19, 2013 Alex Woodie

  Ipswitch File Transfer last week unveiled MOVEit Cloud 8.0, a new version of its managed file transfer (MFT) software that customers can deploy in their own private clouds. New Android and iOS clients headline the new features in version 8. MOVEit Cloud version 8 is the second major release of the cloud product since Ipswitch first unveiled it in 2012. The Windows-based software delivers the same core set of secure file transfer features and capabilities that Ipswitch offers with its regular MOVEit products, including MOVEit File Transfer Server and MOVEit Ad Hoc Transfer. This includes support for FTPS, SFTP, and

  … Read more

• Infor M3 Gets Fresh with Food

  November 19, 2013 Alex Woodie

  Infor is working on a new version of its M3 ERP system that’s specifically designed to meet the needs of ultra-fresh food manufacturers whose products have a shelf life of days, rather than weeks or months. The food and beverage market is one of Infor’s strongest vertical industries for the Lawson M3 software, in addition to the clothing/footwear and equipment sale and rental industries. Along with the major verticals, Infor differentiates itself from other ERP vendors by targeting hundreds of so-called “micro-vertical” industries where it can deliver fine-tuned functionality and processes for specific types of businesses. The new ultra fresh

  … Read more

• ExaGrid Unveils New High-End Backup Appliance

  November 19, 2013 Alex Woodie

  ExaGrid last month unveiled its biggest backup appliance yet, the EX21000E, which holds can hold up to 210 TB of full backups when 10 of them are linked together in a grid. And thanks to a partnership with LaserVault, pushing backups from the IBM i server doesn’t involve weird Linux commands or expensive IBM backup software. ExaGrid makes disk-to-disk (D2D) appliances designed to address the backup and recovery needs of midsize organizations with growing data storage needs. The company says its horizontally distributed scale-out architecture gives it an advantage over other architectures that require forklift upgrades to expand capacity.

  … Read more

• Go Ahead And Test It, Midrange Dynamics Says

  November 19, 2013 Alex Woodie

  It’s tough to argue against the importance of testing new and modified applications before rolling them into production, especially with the www.healthcare.gov debacle still unfolding. While IBM i shops aren’t likely to roll out anything as big and complex as that website, they still should perform functional and regression testing, and new tools from change management software vendor Midrange Dynamics can help. The headliner of the latest release of Midrange Dynamics’ change management software, MDCMS version 7.1.1, is a new feature designed to make it very easy to copy production data to test environments. According to the vendor, developers can

  … Read more

• BCD Bolsters Nexus Portal with Authentication and CMS Functions

  November 19, 2013 Alex Woodie

  IBM i shops looking for a quick way to communicate with customers and partners over the Web might be interested in the latest release of Nexus, Business Computer Design Int’l.‘s IBM i-based Web portal. With the updated release of Nexus, BCD adopted the OpenLDAP authentication software, and added support for a new visual document designer called TinyMCE. The Nexus portal was initially created years ago as a side project that came out WebSmart, BCD’s Web application development and runtime environment for IBM i servers. One of the very first things that IBM i shops need upon creating a Web

  … Read more

Previous Articles Next Articles