RJS Hacks is a weekly column presenting detailed tutorials for novice and seasoned administrators alike. Questions and comments are encouraged, and if you have a topic you would like to see discussed please let us know.

Do you find that the folder structure that seemed so simple and concise when you initially set up WebDocs iSeries has become a source of pain and confusion? Documents may be moved en masse, and folder hierarchies may be restructured after the fact, and using the example below we will walk through a sample restructuring. Let’s assume that your current folder structure is as poorly thought through as the example on the screen below.

With some input from the departments affected, you’ve sketched out an alternative. You will do away with the CLERK folder altogether and make ACCOUNTING the parent directory instead, with AP as the child directory inside. Afterwards, you will move all the documents from the old folder structure to the new all at once, instead of working with one at a time.

The instructions in this article assume that you have access to an iSeries user profile with *ALLOBJ special authority, and that your RJSIMAGE library is at version 3.08 or above. If you’re unsure which version you are at, enter the following command on a command line:

DSPDTAARA RJSIMAGE/VERSION

Because we’ll be working directly with the WebDocs database, make sure that no one is using or checking new documents into WebDocs before going any further. If you have additional concerns, please contact Technical Support.

Note: WebDocs’ folder structure is virtual, so this change will not affect where the actual .pdf or .tiff files appear on your filesystem. If you need to move the files on the IFS as well, please see Part II: Moving documents between IFS folders.

How do I discover how the documents are distributed through the current folder structure?

To see what you’re working with, run the following SQL statements to return how many documents exist in each folder:

RJSIMAGE/DOCSQL SQLSTM('select count(*) from rjsimage/docs00 where folder1=''CLERK''')
RJSIMAGE/DOCSQL SQLSTM('select count(*) from rjsimage/docs00 where folder1=''CLERK'' and folder2=''ACCOUNTING''')
RJSIMAGE/DOCSQL SQLSTM('select count(*) from rjsimage/docs00 where folder1=''CLERK'' and folder2=''AP''')


The first query returned for me with 0 results, so there are no documents actually residing in the CLERK folder. The other two have lots of documents, so those are what will need to move.

Creating the new folder structure

On the iSeries, navigate to Work with Document Folders:

ADDLIBLE RJSIMAGE
GO RJSIMAGE
Option 11: Work with Document Folders


You’ll need to create your new directories first. Use F6 to create a new folder.

Set the Folder to ACCOUNTING, the Description to Accounting Reports and keep the IFS Directory the same as the original folder entries. Upon save the Edit Document Folder screen will remain up so that you can create additional directories. Keep the Folder as ACCOUNTING but add AP to the line below. Set the Description to Accounts Payable and the IFS Directory as is. Save this new entry, and then F12 to return to the folder list, with your new folders now present (it may require an F5 to refresh the list).

Setting rights to the new folders

At this stage, it may help to have two 5250 sessions active, so that you can switch back and forth easily. On the one session, put a 9 on the old folders (CLERK/ACCOUNTING and CLERK/AP) to see their securities. On the second session, do the same for ACCOUNTING and ACCOUNTING/AP. Ensure that ACCOUNTING matches with CLERK/ACCOUNTING and ACCOUNTING/AP with CLERK/AP. We don’t want to surprise any users by denying them access to documents they were once able to work with.

Moving documents between WebDocs iSeries folders

You now have a folder to move your documents to. You may now run an SQL update statement to change the WebDocs folder for all documents in CLERK/ACCOUNTING and CLERK/AP to ACCOUNTING and ACCOUNTING/AP, respectively. Because you will be making changes in the WebDocs database, make a backup of the DOCS00 physical file before proceeding.

The first update command moves documents from CLERK/ACCOUNTING to ACCOUNTING:

RJSIMAGE/DOCSQL SQLSTM('update rjsimage/docs00 set FOLDER1 = ''ACCOUNTING'', FOLDER2 = '''' where FOLDER1 = ''CLERK'' and FOLDER2 = ''ACCOUNTING''')

The second moves documents from CLERK/AP to ACCOUNTING/AP:

RJSIMAGE/DOCSQL SQLSTM('update rjsimage/docs00 set FOLDER1 = ''ACCOUNTING'', FOLDER2 = ''AP'' where FOLDER1 = ''CLERK'' and FOLDER2 = ''AP''')

Congratulations, you’ve moved all the documents – in WebDocs at least. In truth, the actual files themselves are in the same IFS directories they always were, but the folders that are presented to your users in the web interface reflect the new structure and naming scheme.

Deleting the old folders

To tidy up, you may clear all securities from CLERK, CLERK/ACCOUNTING and CLERK/AP by returning to the folder menu in RJSIMAGE and using option 9 on each folder in turn. Clear all the Y’s out, and then use option 4 on the folders to delete them.

Displaying the changes to your users

Finally, you will need to purge your users’ old sessions – they will not see the new folders until their existing sessions are cleared. You can force sessions to reload using the DOCRMVSESU command:

DOCRMVSESU USER(*ALL)

When they log into the web interface now, they will now see the new folder structure:

My oldest son flew in from Pennsylvania to visit us for a week and attend the Minnesota State Fair that I spoke of previously.  While he was here, he played the recently released StarCraft II with his younger brothers and became thoroughly hooked on the game’s fast multiplayer action.  The four of us have accounts with Battle.net, which is the backbone of Blizzard online service offerings (World of Warcraft, StarCraft II, Diablo, etc.) and all of us, except my oldest, use the Blizzard “Authenticator.” It is a rolling token generator used to add an additional layer of security to your Battle.net account.  When you sign in, you are asked for your username and password (which rarely change) and for the current displayed rolling key code (which changes every 30 seconds).

My oldest never got around to obtaining a Blizzard authenticator just because he’s never had a problem with his account. He couldn’t even be bothered with downloading the free version they offer for many phones. 

Let me fill you in on Blizzard Entertainment a bit more: World of Warcraft alone hosts over 11 million users worldwide, all paying anywhere from $10 to $20 a month, per account depending upon the global currency exchange rates. That’s some serious money.  Malware authors realize this and target gamers with keyloggers and CD key sniffers to gain access to end-user accounts.  There’s real money to be made in selling gold and in-game items in World of Warcraft. 

Funny/sad fact: There are multiple websites that will sell you character-leveling services where they will park someone in a chair and play your account and do all the hard (boring) work for you.

That being said, my oldest son received an email from Blizzard support that they had suspended his account on August 29th for “suspicious activities,” which was during the week he was here with us.  Prior to flying out to Minnesota from Pennsylvania, he helped his girlfriend move into her new dorm at the college she is starting this year.  The IT crew for the college came around to all new students in her dorm and installed some Cisco client on anything that was going to be connected to the campus LAN.  This client disabled her firewall and a keylogger was installed; unfortunately, she didn’t have any anti-virus installed at the time.  Now we’re not sure if the college IT staff was at fault and intentionally installed the malware or if it was someone else on the campus network, but his logon credentials for Battle.net were apparently captured and used by a third party.

A long call with Blizzard support later and we find that his World of Warcraft characters had vendered all of their items and mailed the gold to a character that was owned by another account.  Then all his characters were used to spam advertisements and URL links for a gold-selling website.  It was at this point that Blizzard stepped in and suspended the account.

So here is the lesson to be learned: The beauty of multifactor authentication is even if the malware gains access to your username and password (which rarely changes), it cannot replicate the rolling key generator (which changes every 30 seconds) because it doesn’t know the seed code used to generate said key.  This makes code prediction nearly impossible. 

Blizzard support recommended a couple different types of free anti-virus software to remove the malware.  My son downloaded and installed both and neither found the key logger.  He called me last Friday night and said he needed help.  I fired up GoToMeeting and installed Sophos, which unsurprisingly detected the malware as an Rbot variant and successfully removed it right away.  

My oldest son is now a believer; he is now the proud owner of a Blizzard Authenticator and his girlfriend is the proud owner of a Sophos protected laptop.

Bob Sullivan of MSNBC writes a fantastic blog, called “The Red Tape Chronicles.”  In our opinion, it’s a daily read. We’re reposting his “Top 5 Most Successful Internet Scams” and we’re continuing the countdown with #3…

#3  Facebook impersonation

Facebook is no longer a Web site — it’s a full-fledged platform, rapidly approaching the scale of the Internet itself. Many young users spend more time on Facebook than on e-mail, and actually use Facebook as their e-mail service.  That means scammers are now crawling all over the service, since they always go where the people go.  There are hundreds of Facebook scams, such as phishing e-mails, Trojan horse infections, misleading advertisements and so on.

But the crime you should most worry about is Facebook impersonation. A criminal who hacks into your Facebook account can learn a staggering amount of information about you. Worse yet, he or she can gain trusted access to friends and family.  We’ve seen plenty of stories that show Facebook friends can easily be tricked into sending money in response to believable pleas for help.

For this reason, it’s time to upgrade your Facebook password. Treat it like an online banking site, because it’s not a stretch to say that a criminal who hacks your Facebook account is only one small step away from stealing your money (“Hello, First National Bank, I’ve lost my password. But my high school mascot is the Owl and my mother’s maiden name is Smith. Oh, and my first girlfriend’s name was Mary. Can you reset the password now?”)

Stop by next week for #2 on Bob’s countdown of the internet’s most successful scams. 

The Internet’s most successful scams, by Bob Sullivan – March 21, 2010

Here are a few Friday links to enjoy after a nice shortened work week!

Ah yes… our country’s great debate!  Is it pop, soda or Coke?  The website, Pop vs. Soda, has compiled thousands of answers to this great question and created fun geographical maps to illustrate how different states tackle this battle of words.  Tell us what you think and where you’re from in our comment section.  I say soda (and Duck, Duck. Gray Duck)!

Who hasn’t wondered what it would be like to own a dream home?  Well now you can for a small investment of several million dollars!  Here’s a ridiculous slideshow of current celebrity homes on the market and you’ll be floored by the over-the-top accessories.  From the late Dennis Hopper’s multi-level guest condos to Pete Sampras’ separate gym, these celebrities really have it rough.    

Like many children, I dreamed of becoming an astronaut so I could visit the moon.  I never became an astronaut, but with the power of technology, I can help NASA map out the moon from my couch!  The project Moon Zoo, is enlisting humans from across the globe to assist in mapping out the many craters on the moon’s surface for scientific purposes. It’s actually really interesting and is a great learning experience for people of all ages. 

Sheep aren’t the “brightest” of animals, but they sure do follow orders!  In 2009, a group dubbed the “Baaa-Studs” came up with an idea to mix artistic flair, LED lights and sheep into a completely awesome experience.  You won’t want to miss this brilliant bit of creative genius!  

Enjoy the weekend!

I’ve been actively avoiding the whole social media scene for years now. Let me tell you why:

1)      It’s what the kiddies do and I’m an old fart.

2)      I’m not a fan of public exposure; I like to keep to myself.

My kids all have Facebook accounts and so does my wife. Even my mom has a Facebook page. I’m the only hold out. I’m definitely in the minority here within my family and perhaps more than anything else, I really don’t have the time to keep up with Facebook… at least that’s my current excuse. 

Here’s why I hate the lime light: 

Many moons ago I worked as a community admin for an online game service.  95% of my responsibility was to keep the peace within the online community.  Much like any online community, there were a percentage of users who were out to cause trouble for the rest. We were usually forced to ban/perma-ban these individuals from the community as they were hell-bent on doing as much damage as they could for whatever reasons.  The game developer decided it would be a nice gesture to reward our hard work by posting the real names of the admin staff and our contact emails in the owner’s manual that shipped with the game.  Unfortunately he didn’t warn us… he surprised us.  “Surprise! What do you think?”  

As you can guess, my email account became the target of some of those we had banned from the service with vengeance on their minds. It wasn’t long before my email address became unusable from all the spam and I was eventually forced to move to another account and service.  I still check the account now and then just for laughs. I sometimes have the RJS techs guess how many times I won the UK lottery on a given day.  Today I won it 31 times. 

Today, one only has to visit Graham Cluley’s blog over at Sophos and read up on the latest Facebook scam going around. Social media networks are where the sheeple congregate and the malware authors know it and target it with glee.

So now I can add another reason to my list of why I avoid social media:

3)      90% of malware today is distributed via social media outlets.

My wife makes the point that “you use Sophos, you’re protected,” and to that I reply “I also have insurance on the car, that doesn’t mean I’m going to drive into oncoming traffic.” A large percentage of avoiding an accident is not being there when it happens! I can now hear her getting upset as she notices a malware-infused spam post from her unsuspecting sister. “Why would my sister send me this to ‘like?’ SHE doesn’t even like Justin Bieber. Why would she think I would want to ‘like’ it?” I just shake my head and reply, “It’s oncoming traffic’, honey.”

Bob Sullivan of MSNBC writes a fascinating blog, called “The Red Tape Chronicles.”  We’re reposting his “Top 5 Most Successful Internet Scams” and we’re continuing the countdown with #4…

#4  Fake or “rogue” anti-virus software

We’ve all seen the pop-ups: “Your computer is infected! Get help now!”

If you’ve ever clicked through such an ad (really, a hijacking), you know that the price for freedom is $20 or $30 a month.  At first, the ads were clunky and the threats idle. But now, many pop-ups are perfect replicas of windows you would see from Windows or an antivirus product. Some sites actually employ so-called ransomware, which disables your PC until you pay up or disinfect it with a strong antivirus product. That’s why consumers forked over hundreds of millions of dollars to fake antivirus distributors in 2009, according to the Federal Trade Commission.

Your best bet?  Make a plan now.  This is the one scam that just about anyone can fall for.  The best protection of all is to back up your important files, so the day your computer is hacked, your digital life won’t be on the line.  It’s also important to have a fire extinguisher nearby.  A second PC or laptop is often your best help when disaster strikes.  Many viruses disable Internet access, so you’ll need a second computer to research your infection and download disinfectant software.  Have a flash drive nearby, too, so you can move the inoculation from one computer to the other.

Meanwhile, if you aren’t paying for antivirus software, at least employ one of the popular free products like AVG or Windows Defender.

Stop by next week for #3 on Bob’s countdown of the internet’s most successful scams. 

The Internet’s most successful scams, by Bob Sullivan – March 21, 2010

I’m finally back after a wonderful week and a half off.

Here’s a quick list of the stuff I did over vacation:

1) Went to the Minnesota State Fair.

2) Saw RUSH in concert at said Minnesota State Fair.

3) Rooted my HTC Evo 4G and removed all the bloatware that Sprint installed with the Android 2.2 update.

4) Searched out the mythical 4G towers around the Twin Cities.

The Minnesota State Fair is a blast, so many activities you can do there. My personal favorite is people watching, I can see where the idea for the zombie apocalypse came from.

The RUSH concert on Friday night (Aug 27^th) was outstanding.  No opening act, just 3+ hours of RUSH playing their hearts out. It was also Alex Lifeson’s birthday that night, he was given a 2-foot-long corndog and a steak-on-a-stick on stage to celebrate. They played the Moving Pictures album in its entirety.

I was pretty excited by the pending Android 2.2 (Froyo) update; I had read about the many optimizations and improvements that were added to the build that vastly improved battery life, so when it showed up unannounced on my Evo, I jumped on the update immediately… big mistake.  It seems that Sprint decided that improved battery life was something wasted on their customers, so they loaded their version of the 2.2 update with a lot of bloatware. This rendered the battery life back down to the stock 2.1 levels since all the bloat is running constantly in the background, and there is no way to uninstall it.  The rest of the bad news was that 2.2 fixed a lot of the rooting loop holes that were used in the 2.1 build, so once you had 2.2 on it, you were stuck with it until the rooters figured out another way in. 

XDA Developers to the rescue!  One of their many talented developers, working closely with the Unrevoked team who brought us build after build of rooting goodness, figured out a way to force the stock 2.1 ROM onto a 2.2 loaded phone. Sheer brilliance!  Once rooted, I installed the Ava-FroyoV6 build which is basically the 2.2 stock HTC/Sprint build minus the recovery image which allows you to maintain root access once flashed. I then installed Titanium Backup and joyfully removed all the bloatware.  Battery life is amazing! 

I paid a visit to my favorite Sprint shop and got the lowdown on what to look for around town for 4G.  Apparently Clearwire, whom Sprint just picked up a 51% ownership of recently, is going to be serving 4G in the Twin Cities and are currently up and running a few towers here and there as a test bed.  With that in my skull, I drove the 494/694 loop around the Cities looking for 4G signals and found a few.  Most of the towers I ran into would serve up a 4G signal but appeared to be locked by MAC address, most likely for closed testing.  However, if you happen to be in Roseville by the mall, turn on 4G, you’ll connect immediately to Sprint and obtain an IP address.  I was lunching at Wendy’s in Roseville last Saturday running download tests and was reliably seeing 8.5mb down, and 1.5mb up with full net access.  Flipped on my hotspot, turned on my laptop, connected, and dished out some raw pain to some poor souls in StarCraft II as my burger and fries slowly went cold. 

I run Qwest 20mb fiber service at the house, but the WIFI on the router they provide is hardware limited to 10mb throughput despite the 45mb connection. My hotspot service on the Evo was just a tad slower at 8.5mb throughput on the download but faster on the upload, 1.5mb compared to the 1mb up I get via Qwest. This is definitely a contender in a mobile device offering and I can see where it’s going to pay off in spades when I’m working onsite connecting multiple laptops to the hotspot.  The downside of 4G is that it is a battery eater. It takes a lot of power to run its capabilities and the hotspot service combined, hence the need to carry the data cable with to steal power from my laptop.  The sacrifices we make…

“Also, I can kill you with my brain.” – River Tam (Summer Glau), Firefly

Break out the grills, start a bonfire and move the kids back into college… the summer is coming to a close!  Kick-off your extended weekend with another round of RJS Friday Fun Links.  

Saturday Night Live has had its ups and downs since rocking our television sets with classic sketches like Dan Aykroyd’s Super Bass-O-Matic ’76 and John Belushi’s Little Chocolate Donuts.  The long-time comedy show has become surprisingly funny again and here’s a list to prove it: top 10 SNL moments of the season.   

Speaking of things that make us laugh, does anyone remember the Yugo?  Our marketing manager, Joel, spotted one the other day and it was still running!  Voted the worst car of the millenium, the Yugo was an epic mistake for the auto industry and now there’s a book that details the hilarity of it all.  “Mix one rabid entrepreneur, several thousand ‘good’ communists, a willing U.S. State Department, the shortsighted Detroit auto industry, and improvident bankers, shake vigorously, and you’ve got The Yugo: The Rise and Fall of the Worst Car in History.” 

As the housing market continues to plummet, it’s easy to wonder where the most livable bargain market is these days.  MSN put together an intriguing top 10 list of cities that provide the most bang-for-the-buck when shopping for real estate.  Sorry Los Angeles, you didn’t make the cut.      

Have you ever wondered what a musician was thinking when they made a music video?  Us, too!  If you search “literal videos” on YouTube, you find a list of hilarious parodies of hit songs that boasted utterly ridiculous music videos.  What makes these parodies so funny is that they change the words of the song to reflect the literal happenings of the videos themselves.  From Bonnie Tyler’s “Total Eclipse of the Heart” to Creed’s “With Arms Wide Open,” these literal videos had us rolling on the floor.

 Have a great Labor Day Weekend!

Bob Sullivan of MSNBC writes a fascinating blog, called “The Red Tape Chronicles.”  It is a great source for a multitude of scary stories on internet scams and consumer fraud.  Check it out… it’s on our daily blogroll! 

Bob penned a topical article this spring that definitely struck a chord in our office and we wanted to share it with you.  Today we are going to begin counting down Bob’s “Top 5 Most Successful Internet Scams.”  Enjoy!

#5   Online dating scams

Anyone out there never done anything dumb for love?  If you are raising your hand, congratulations. You may now relinquish your credentials as a human being.  The rest of you should read on.

Love-based cons are the easiest to perpetrate. Why? Because love always involves a leap of faith — trusting something you can’t see or touch. Just like Internet scams.  For years, criminals have made haunts out of dating services and lonely-hearts chat rooms.  Broken-hearted folks are rarely in their right minds, so they make easy targets. 

I once knew the FBI agent in charge of investigating cyber-love scams.  He put it this way:  Men could learn a lot from con artist lovers. They send flowers and candy constantly while wooing a mark (purchased with stolen credit cards, of course).  Gifts really do put women in an agreeable state of mind, he assured me.

Some cons spend months grooming their marks, waiting until after several “I love yous” before asking for $800 to be wired to the passport office in London to help clear up a paperwork mess so he can come to America for a visit.

Yes, it all sounds ridiculous. It’s not. It’s so profitable that criminals actually pay monthly fees on some dating services. Generally, the more you pay for a service the fewer criminals you’ll see, and free Craigslist personal ads tend to be a cesspool. But I’ve heard from victims who never joined a dating service but were still conned into fake love from perfectly innocent-sounding places like Facebook groups or chat rooms devoted to hobbies like stitching or horses. It all starts with a simple e-mail, perhaps enhanced by a little Facebook research (“Hey, you love the New York Islanders and the Beatles, too! Wow”)

Since I’ve written about this scam many times, I’ve even heard from concerned family members who beg me to talk the deluded lover down off the cliff when he or she is about to send a bunch of money to a scammer. Usually, I fail. Love is blind; it’s also really, really stubborn.

In the latest flavor of the scam, when a deluded lover actually wises up and confronts the criminal, he or she admits to the crime but then adds this twist: “Yes, at first it was just a con, but while we were talking I’ve really fallen in love with you.”

For a whole lot more on this insidious, more-common-than-you’d-believe crime, visit romancescams.org. The group, founded by former victims, has been fighting back for nearly 10 years. They post blacklisted photos there, e-mail addresses and typical opening lines from scammers, and lots of additional helpful scam-fighting tools. If you fall in love and have any doubts, visit the site.

Stop by next week for #4 on Bob’s countdown of the internet’s most successful scams. 

The Internet’s most successful scams, by Bob Sullivan – March 21, 2010

Save 50% or More on Key Data Integration and Productivity Software.

Load up on software that will save you a bundle without blowing your budget.

Spool File Management Bundle: Stop storing spool files in ouput queues. Use this solution to capture, index, route and retrieve IBM i spool files.  Sale price: $5K (Regular price: $13K)

RPG2SQL Integrator: Share, transfer and update data in real-time across platforms. Combine IBM i and PC data to sync databases, generate reports and more effectively analyze information.  Sale price: $4K (Regular price: $8,400)

PDF/TIFF Conversion Utility: This tool is all you’ll ever need to print, merge, convert and split PDF and TIFF files natively from the IBM i.  Sale price: $1K (Regular price: $4K)

Additional Sale Items
Take 50% off the following Report Delivery and Data Integration Products:

WinSpool
Batch Report Server
Email Report Server
AS/400 Report Splitter
PDF Splitter
PDF Converter
Native IBM i Converters
DataImport Report Converter
iPrint
iSeries Office Integrator
Spreadsheet Conversion Bundle

*Offer good through Oct. 15, 2010.