Today we’ll see how we can move files that contain a particular word, a specific directory/subdirectories, recursively. Sometimes we may need to move files that meet a certain pattern to a particular folder.
For example, imagine that we have a directory/subdirectories with thousands of audio files, with metadata in the filename and we want to make an automatic selection of all the audio files that contain the word SALES in the name tag. We could go directory to directory looking for the word SALES and cutting and pasting in a folder or we could use the Windows search and give us the results, but sure that the following command can be more than useful.
FOR /R "C:\AUDIO_DIRECTORY\" %%G IN (*SALES*.mp3) DO move "%%G" "C:\SALES_AUDIO\"
Copy this code, save it in a bat file and run it. It will automatically dump all mp3 audio files containing the word SALES in the C:\SALES_AUDIO\ folder.
From here we can apply this small code to any example you can think of.
I hope it will help you;)
MicroStrategy allows us to link documents to other documents/reports and create a navigation between them. Depending on our needs, the default way of Microstrategy to make links couldn´t be enough for our purposes, for this reason I will talk about API URL, which allow us to create custom links to other reports, documents, pages, exports … from objects such as text labels or images:
Some time ago I published an entry in relation to the creation of Datamart Report in Microstrategy, which you can find at this link:
Now I will devote a few lines to speak further about configuration and characteristics of this functionality.
MicroStrategy provide us the possibility to store statistics about our projects in physical tables. This information is varied and includes access dates, fault recording, runtimes … If we want to see the definition and composition of statistical tables which Microstrategy gathers, we can consult in:
Microstrategy 9.4 AdminSupplemental
since 463 page, there, we can see the information contained in each table.
In this post, I will combine information from the statistics repository with the information which we have in MicroStrategy metadata, for this reason it is advisable to take a look at the previous post:
Microstrategy Metadata Queries (I)
By default in the case we use attributes and metrics that are being mapped in many tables Microstrategy uses the fact table for the reports that has the lowest logical size.