Tag Archives: VBScript

How to Import all Files in a Directory

We’ve recently been on a Property Management project using TM1 to deliver a Management, Planning and Reporting Solution. The Client has properties which are managed by an external property manager who produces tenancy schedules and general ledger reports for data consumption. The Problem: Every properties reports would come from the external property manager in a different file. Making the process to load these into TM1 only mildly faster than using … Continue Reading

Sending Emails from TM1 (Part 1: Plain Text)

Sending Emails from TM1 – Using HTML Problem: Although some additional components of TM1 have built-in email functionality, TM1 does not have email functionality built into its ETL Engine. Solution Process: Within a TI Process output text to a file to be used as the body of the email to be sent. Execute an email script command to send off the email to recipients. Executing the TI script: The TM1 … Continue Reading