Friday, September 14, 2018

Need a Solution

I need an automated solution to maintain links from various HTML pages in the Disaster Recovery project in RoboHelp to all of the files in the ...\jpg, ...\xls, ...\txt, ...\pdf, ...\vsd, ...\ppt, &  ...\csv folders. The files in the ...\doc folder are just so I know how many links to Word documents are in this project.



I can generate a file like this:
Folder PATH listing for volume OSDisk
Volume serial number is A48B-4BCB
C:.
+---Communications-CTE
| \---Wired Data Network
| \---WAN
| \---CMS-Muscatine&Dialysis
| \---Voice
| SV8500 LCDDL 20180503 103121.csv
|
\---Enterprise Storage
\---Storage Services
| SyncIQJobsReport20170608000000064.csv
| SyncIQPoliciesReport20170608000000064.csv
|
+---TIER-0-SVC
| \---IBM FLASH_SVC upgrade
| Summary PRD--to--SUP FC Incremental.csv
|
\---TIER-2-ISILON
SyncIQJobsReport20170425000000036.csv
SyncIQJobsReport20170608000000027.csv
SyncIQJobsReport20171005000000690.csv
SyncIQPoliciesReport20170425000000036.csv
SyncIQPoliciesReport20170608000000027.csv
SyncIQPoliciesReport20171005000000690.csv

I created the above using the TREE command in DOS. I need 4 HTML files:
  1. Communications-CTE - Wired Data Network - WAN - CMS-Muscatine&Dialysis - Voice.htnl with a link to SV8500 LCDDL 20180503 103121.csv
  2. Enterprise Storage - Storage Services.html with links to SyncIQJobsReport20170608000000064.csv & SyncIQPoliciesReport20170608000000064.csv
  3. TIER-0-SVC - IBM FLASH_SVC upgrade.html with a link to Summary PRD--to--SUP FC Incremental.csv
  4. TIER-2-ISILON.html with links to the following:
    • SyncIQJobsReport20170425000000036.csv
    • SyncIQJobsReport20170608000000027.csv
    • SyncIQJobsReport20171005000000690.csv
    • SyncIQPoliciesReport20170425000000036.csv
    • SyncIQPoliciesReport20170608000000027.csv
    • SyncIQPoliciesReport20171005000000690.csv
I'm experimenting with some find and replace commands in MS Word that I hope will change into a macro.

No comments: