Recently i was asked how to create a empty DDF file when you only have an MDD file. In this article we will show you two ways to do this and create any type of empty data file.
Month: June 2017
JustCode : Delete a file if it exists
This code shows us how to check for a file and delete it if it already exists.
' ****************************************
' Designed by : Smarter Dimensions
' Last Updated : 23rd July 2009
' Delete a file if it exists
' ****************************************
Dim oFSO
If oFSO.FileExists("C:\TEMP\test.txt") = True Then
oFSO.DeleteFile("C:\TEMP\test.txt")
End if
Set oFSO = Null
JustCode : Create a new file with a line of text in it
This code shows us how to create a new file and add a line of text to it.
' ****************************************
' Designed by : Smarter Dimensions
' Last Updated : 23rd July 2009
' Create a new file with a line of text in it
' ****************************************
Dim oFSO, oFile
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFile = oFSO.CreateTextFile("C:\TEMP\test.txt", True)
oFile.WriteLine("HELLO WORLD")
oFile.Close()
Set oFSO = Null
Debugging your surveys with Chrome.
Hello , first off sorry for all the coughs and splutters in this recording but i just had to share what i discovered today. I am sure some of you already new this , but for me it was a life saver. Made my editing allot less painful. I hope you find it useful also.
JustCode : Add a language to an MDD
This “Just Code” post will show you how to add a language to an MDD file via script.
' ****************************************
' Designed by : Smarter Dimensions
' Last Updated : 26th September 2009
' Open MDD file and add language
' ****************************************
Dim oMDM
' Create the MDM object and open the Short Drinks .mdd file in read-write mode
Set oMDM = CreateObject("MDM.Document")
oMDM.Open("c:\temp\New.mdd", ,2)
oMDM.Languages.Add("JPN")
oMDM.Save()
oMDM.Close()
2×4 Survey Tester
Recently we had the opportunity to take a look at this great tool by 2×4. Survey Tester initiates process orientated automatic testing scenarios in which tester can flag problems directly on the screen. SurveyTester automatically creates screenshots and stores them so they can be reviewed by survey authors. Every test run is stored in the database and testers and survey authors can see in detail all the steps needed to replicate an identified issue. In addition, test runs can be exported and viewed individually or together through the visual work flow diagram.
Some of the features are
- Cloud solution no need to install software.
- One platform for testers, teams, survey authors and project managers.
- SurveyTester now automatically detects which survey pages are mobile friendly.
- Cost effective & time saving workflow process.
- Creates a clear communication channel for test runs.
2×4 have made some recordings that you can take a look at the product. I recommend you do so, it could save you and your team allot of trouble.
https://www.youtube.com/watch?v=1UV9smK3AcA&feature=youtu.be
https://www.youtube.com/watch?v=4xJKMaKtGCU&spfreload=10
Testing Unicom Intelligence with Office 2016
Just the other day I was required to upgrade to office 2016. I have set this post up to record any issues I find and record what I have tested. If you have done any testing on 2016 then please feel free to leave a comment and we can add it to the list of things that may need to be looked at by the Unicom Team.
| Product | Test | Outcome | Date |
| Excel | Can I use my existing VBA code to manipulate XL files | Yep , no issues here everything currently still works | 5/06/2017 |
| Excel | Can I export an MTD to an XL file | Yep , no issues here everything currently still works | 21/06/2017 |
| Excel | Can I export data file to a csv file that can be loaded into XL | Yep , no issues here everything currently still works | 21/06/2017 |
| Powerpoint | Can I use my existing VBA code to manipulate ppt/pptx files | Yep , no issues here everything currently still works | 5/06/2017 |
| Powerpoint | Can export my tables to a PPT/PPTX still using my old chart templates | Yep , no issues here everything currently still works | 5/06/2017 |
| Powerpoint | create a batch file and run an MRS that holds a TOM export to PPT | Excel seams to hang at end of export ( I think when it is saving the PPT ) Added code to kill process “TASKKILL /F /IM excelcnv.exe” to see if I can kill it | 21/06/2017 |
JustCode : Add / unlock a version in your MDD
When you are playing arround with MDD files you may need to add or unlock the version. This simple code shows you how to do it.
' ****************************************
' Designed by : Smarter Dimensions
' Last Updated : 4th July 2009
' Sub to unlock a MDD version.
' ****************************************
Dim oMDM,oVar,oElement,sLabel
Set oMDM = CreateObject("MDM.Document")
oMDM.Open("c:\temp\short_drinks.mdd", , openConstants.oREADWRITE)
oMDM.Versions.AddNew()
oMDM.Save()