Tag Archives: Windows 10

Guide – Renaming Files With Trailing Spaces ” ” in Windows Explorer

5 Replies

As part of my job as IT support I see and experience many different issues. Most of them are well documented online in forums, blog posts or in technical documentation, but then there are some that just really boggle your mind. This situation is one of those, and I found the fix by chance in a comment on a blog post!

Scenario

In my case I had an issue with some backup software where it was failing to read some files on a file server, skipping them entirely.

After contacting the backup vendor support they informed me the issue was that the files:

  1. Did not have a file extension
  2. Had trailing space (” “) characters at the end of their file names

These files had been generated by a Linux based embedded system which is used as part of a packaging line for one of our clients. Linux (and apparently also Macintosh) file systems allow you save files with a space at the end of the filename, Microsoft Windows however does not.

When I would open Windows Explorer to the location of the files I found that when I tried to:

  1. Rename
  2. Read properties
  3. Open/read data

I would receive this very ambiguous message from Windows:

Could not find this item. This is no longer located in [Path]. Verify the item’s location and try again.

As the folder path was rather long, coming in at around 288 characters, I first thought there was an issue with the long path name that Windows has suffered for many years – however my go-to fixes (such as using the subst command) returned the same error, file not found.

I went through many different “solutions” online to no avail, until I found the fix which luckily for me and my client is free and very easy to use!

The Fix

Assumptions

The following is assumed:

  • You have Full Control or Modify rights over this folder
  • You are able to log in as a Local or Domain administrator to install applications
  • You are using a modern Windows operating system, no earlier than Windows 7 (although I could see this fix working as far back as Windows XP)
  • You have the File name extensions enabled in Windows Explorer

Process

  1. Connect to the device in question and log in as a user with administrative rights
  2. Download the latest edition of 7-Zip from their website: https://www.7-zip.org/
    1. Download the 32-bit or 64-bit version depending on your operating system architecture
  3. Install the downloaded application
  4. From the Start Menu go to All Programs and then open the 7-Zip folder and then start 7-Zip File Manager
  5. Using Windows Explorer navigate to the folder which contains the problem file(s)
  6. Click in the address bar of the Windows Explorer window and copy the file path
  7. Click back into 7-Zip File Manager and paste the path into the address bar and then hit Return/Enter on your keyboard
  8. 7-Zip File Manager should now show the directory that houses the problem files
  9. Right click on the problem files and choose Rename or press the F2 key on your keyboard
  10. Remove the trailing space key and provide a file extension if it is missing
  11. You should now be able to amend/read/modify the file in Windows explorer and all applications should be OK to access these files.

Add More Clip Art in Office 97 (Windows 10)

Leave a Reply

If you have managed to successfully install Microsoft Office 97 onto your Windows 10 computer, and have followed my previous guide on how to get the Clip Art Gallery working then you (like myself) probably felt a little deflated when you opened it up to find only a meagre 79 clips.

In this guide I will show you how to end up with over 3,000 clips for free, complimentary of Microsoft themselves without the requirement for any dodgy downloads or needing to manually catalogue each clip.

The Problem

The problem we are trying to fix in this guide is simple, not enough clips! And let’s be honest if you’ve got this far and gone to this much trouble to get Clip Art working under Windows 10 you’ll probably want all the clips you can get, right?

Assumptions/Prerequisites

The following assumptions are being made:

  • You are using either Windows 10 build 1809 or 1803
  • The version of Windows you are using is of 64-bit architecture
  • You have installed Office 97 and selected the Clip Gallery and Popular Clipart options
  • You have installed Office 97 with one or more applications enabled: Word, Excel, PowerPoint, Publisher
  • At time of installation you left the installation location to its default path of C:\Program Files (x86)\Microsoft Office
  • You have administrative rights over your PC
  • You have the original Office 97 Standard CD-ROM (or a disc image of the CD-ROM)

The Fix

These instructions should, once completed, change the behaviour of the Clip Gallery in all Microsoft Office programs that support Clip Art. We are simply using Microsoft Word as the default example.

  1. Open File Explorer by launching it from the task bar or by clicking Start and typing This PC
  2. Insert (or mount if using a disc image) the Office 97 Standard CD-ROM. Open the CD-ROM’s contents in Explorer by right clicking the CD-ROM device in This PC and then choosing Open from the context menu.
  3. Open the folder CLIPART. Using your keyboard and mouse, hold SHIFT and then left-click on the first folder (Bullets). While still holding the SHIFT key click on the last folder SCRBEANS.
  4. With these folders selected either press CTRL + C on your keyboard or right-click on a selected folder and choose Copy from the context-menu.
  5. Click on the Local Disk (C:) option from the left-hand pane in Explorer, then drill down the folder structure by opening Program Files (x86) and then Microsoft Office then Clipart. In a white space right-click and choose Paste from the context-menu.
  6. Explorer will then begin to calculate the amount of files it needs to copy. It will identify 80 duplicate files (which are the 79 clips you see already, plus 1 CAG file), choose the option Skip these files.
  7. You will then be asked to give Administrator Permission to complete the copy process. Tick the Do this for all current items checkbox and then click on the Continue button, you may be asked to enter the credentials of an administrator account.
  8. Explorer will now begin to copy the files across from the CD-ROM to your local disk drive. This process may take a few minutes depending on the speed of your hard disk drive and if you are using a CD-ROM or a disc image as the source for the copy.
  9. With the copy completes, open Microsoft Word 97. Open the Clip Gallery by choosing Insert then Picture and finally Clip Art from the menu bar.
  10. Don’t be disappointed, when you open up Clip Gallery it will still only show 79 items. However we now need to import the additional 4,000 clips in. Click on the Import Clips button.
  11. The Add clip art to Clip Gallery dialog box will then appear. Change set the Files of type drop-down to Clip Gallery Packages (should be last in the list) and then click the directory level up button (folder with an arrow pointing upwards) – you should now be in the Clipart folder.
  12. Open the folder OFFICE and select the only CAG file present. Click Open to load the file into Clip Gallery, you should then receive a message confirming the package has been added to the Clip Gallery and that you will need to quit and restart the Clip Gallery to view the new items.
  13. Click OK to dismiss the confirmation message. and then close the Clip Gallery by choosing the Close button. Re-open the Clip Gallery (Insert then Picture and finally Clip Art).
  14. You should now see that you have 2079 clips available under the Clip Art tab. You can add more content by clicking Import Clips and adding the CAG files found in the folders PHOTOS, POWERPNT and SCRBEANS (closing and re-opening Clip Gallery with each action). Under the Pictures tab you should have 144 items. The Sounds and Videos tabs will likely still show 0 items. You can increase this number by importing the CAG file under MMEDIA however you will find at the moment you are unable to preview or insert any of these items.

Summary

If you have followed the above steps you should now have just over 3,000 additional clips in your Clip Gallery. More clips could be added from later versions of Office if they have the .CAG file present, or from third party compilations.

What is nice is that because clip art uses mostly vector technology, the clips can scale to the large HD resolutions that we operate today without corruption or degradation of quality.

Although it is a shame that at the moment I cannot get the audio-clips or video-clips to operate – the 3,000 clips should certainly keep any one keen on a nostalgia trip happy for some time.

Explanation of Fault

Around the time that Office 97 was released, hard disks were still on the small size in comparison to today’s 100’s if not 1000’s of terabytes of storage. For this reason many items of computer software (including video games) would often keep a lot of their media assets (such as graphics, videos and sound files) on the CD-ROM, instead of copying the content to the local hard disk drive. This would mean that for some of these items of software to operate, or for the user to experience the full feature set of an application (such as Microsoft Office) they would need to keep the CD-ROM handy or in their CD-ROM drive during use.

Although when you consider that the content we have copied here only amounts to a measly 86.7 MB (on disk) – this could be considered a serious amount of free space lost for most computer users in 1997.

There really isn’t any further explanation needed as to why Office 97 included (by default) such a small amount of clips – it was simply a design choice to reflect the needs of users at the time.

Guide – Get Clip Art (Clip Gallery 3.0) for Office 97 Working with Windows 10

Leave a Reply

This guide will quickly explain how to get Microsoft Clip Gallery 3.0 (included with the Office 97 suite) working under Windows 10.

By following this guide you will be able to import clip-art items into your documents, spreadsheets, publications or presentations with any of the following Office 97 applications:

  • Word 97
  • PowerPoint 97
  • Excel 97
  • Publisher 97

The Problem

This guide addresses the following errors or problems you may be facing.

  • Error dialog: The Clip Gallery encountered an error. Try restarting Windows, or reinstalling Microsoft applications.
  • Error dialog: The Clip Gallery can not run because the database file has been marked read-only. Use File Manager or the Explorer to locate ARTGALRY.CAG, and remove the read-only file property.

  • Display issue: The clip gallery is empty, no clip art is available or visible for selection/insertion.

Assumptions/Prerequisites

The following assumptions are being made:

  • You are using either Windows 10 build 1809 or 1803
  • The version of Windows you are using is of 64-bit architecture
  • You have installed Office 97 and selected the Clip Gallery and Popular Clipart options
  • You have installed Office 97 with one or more applications enabled: Word, Excel, PowerPoint, Publisher
  • At time of installation you left the installation location to its default path of C:\Program Files (x86)\Microsoft Office
  • At time of installation you left the program group value to its default value of “Microsoft Office“
  • You have administrative rights over your PC

The Fix

In this series of instructions we use Microsoft Word as the application to be used with Clip-Art. For other applications such as Excel, PowerPoint or Publisher please read their names instead of Word in this guide.

  1. Open File Explorer by launching it from the task bar or by clicking Start and typing This PC
  2. Click in the address bar and paste the following string:
    %appdata%\Microsoft\Windows\Start Menu\Programs\Microsoft Office
  3. Tap enter to go to the above location.
  4. Select Microsoft Word and right click, choose Properties from the context menu.
  5. With the Properties window open choose Compatibility and tick the option Run this program as an administrator under the Settings header
  6. Click OK to save changes.
  7. Run Microsoft Word by starting it from your Start Menu⚠ You may have to accept/dismiss a UAC/Administrator prompt when opening Microsoft Word ⚠
  8. With Microsoft Word running open the Clip Gallery by choosing Insert > Picture > Clip Art…
  9. The Microsoft Clip Gallery 3.0 should now open with a selection of clips.

If the Clip Gallery is Empty

  1. Click on the Import Clips… button in the Microsoft Clip Gallery 3.0
  2. An Add clip art to Clip Gallery dialog will open
  3. Click the Look in: drop-down menu and change the option to Local Disk (C:)⚠ Your C: drive may have a name different to Local Disk, choose the disk that is assigned the letter C ⚠
  4. Open the folder Program Files (x86) and then Microsoft Office and then Clipart and finally Popular
  5. Press CTRL + A on your keyboard to select all the files in the folder and then click Open
  6. A Clip Properties dialog window will now open. Tick Add all clips to the selected categories and then choose OK
  7. You will then see another dialog box The Clip Gallery Package has been added to Clip Gallery. You must quit and restart Clip Gallery to view the new package –click OK to dismiss this message
  8. Close the Microsoft Clip Gallery 3.0 window, and then re-open it from Word (Insert > Picture > Clip Art…). The Clip Gallery should now show any clips you have imported.

Summary

If you have followed the above steps you should now be able to easily add in the clip-art that is included with your Office installation into documents, spreadsheets, presentations and publications.

By default the Office 97 installer only installs 79 Clip Art clips – no pictures, sounds or videos. If you have the Microsoft Office 97 Standard Edition CD-ROM available you can increase this number to over 4,000 clips easily by following this guide here.

Explanation of Fault

Although I am not affiliated with Microsoft in any way, I do have a good grasp on how their modern operating systems work and what issues these may pose to applications that are over 20 years old.

Modern Windows operating systems (starting with Vista through to 10, including 7, 8 and 8.1) implement a stricter security system to all operating systems to prevent the unauthorised installation of software, modification of system files or access to personal documents. Although this security system does help prevent unauthorised access from other individuals in your home or office, the main purpose of this security system is to prevent malware (such as viruses) to infect, corrupt or otherwise modify system files without your explicit approval.

When the Office 97 suite was implemented security was rather archaic, and UAC simply did not exist. When the Office 97 suite installs the applications, including the Clip Gallery and clips to your disk it places the files in areas that Windows considers by default “secure” locations. This means that when you try to open an application such as Word without elevating the application with an administrator prompt (such as UAC) it does not have security clearance to amend these files. By elevating the application you are granting that application (or process, in this case WINWORD.EXE) full security clearance to those protected locations.

The Clip Gallery uses a simple database file know as a CAG file (Clip Art Gallery Package file). This file is usually empty when it is installed, and needs to be populated. If the process, in this case WINWORD.EXE, does not have write access to this file (due to not being elevated) then the application will either throw a critical system error message or simply enter the Not Responding state.

What we do in this process is set the WINWORD.EXE process to always request to be elevated. Upon the next execution of the application we are prompted with a UAC Prompt to allow this elevation. From here the process can access the CAG file and modify it as necessary.

Although it is likely that an application as simple as WINWORD.EXE would not make any dangerous changes to system files, it is best practice to avoid constantly running the application with elevated privileges. However you will likely find that if you don’t elevate the process you will not be able to insert any further clip-art until you elevate WINWORD.EXE.

I could tell that it was likely a security permission issue that was causing this fault, however I did evidence my findings by using Sysinternals Process Monitor which confirmed that the WINWORD.EXE process was unable to open the CAG file for amendment.