Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Importing Legacy Data into SMRT

Hi this question is obviously tempered by the fact that SMRT is soon to be obsolete, however, it currently has a few functionalities (such as, from memory, the search optimizer for greatest revenue from a given product combination if costs are known and a few other little tricks that have yet to be integrated into Light House). Plus you can import external data.

Is it possible to import data into SMRT from a legacy project that was done by another Market Research vendor before my time and before we were using Sawtooth?

All we have is a raw utilities sheet in .CSV format with the header rows exactly as they would appear in the 'Individual Utilities (Raw)' Analysis module (in fact it is just this sheet exactly). Does SMRT require any more information than this to run it's simulations?

I'm trying to do some retrospective analysis, which was never used in a simulator, to see if the out comes of the project are concordant with those that might have been achieved if a simulator was used.
asked Mar 6, 2017 by Jasha Bowe Bronze (1,680 points)

1 Answer

+1 vote
Best answer
Just need to reformat (manually) your .CSV file to a .HBU file format (which is a text-only format).  SMRT is very happy (under its Run Manager + Import) to import a .HBU file.  Documentation for .HBU file format is in SMRT's Help file.

.HBU contains a global header that you can just create manually using Notepad or Wordpad.  Then, the documentation shows that each respondent record has multiple rows.  But, you don't need to actually make those rows multiple rows (you can format it as one row per respondent).  You can just copy and paste your space-delimited respondent utilities into the bottom of the .HBU file from Excel (after adding the extra required fields as described in the .HBU documentation).

.HBU is an easy file format to build yourself and allows you to move utilities collected from anywhere into SMRT.
answered Mar 9, 2017 by Bryan Orme Platinum Sawtooth Software, Inc. (132,290 points)
selected Mar 9, 2017 by Jasha Bowe