How do I add multiple text block records from text file?

[aaron_thomas]

The data manager documentation (page 151) for MDM 5.5 SP3 indicates that one or more new text blocks can be added to the Text Blocks object table from files. It is noted that the files must be plain text files.

I use notepad and create a text file with two lines as follows:

Test 1

Test 2

When I try to add the text blocks following documentation mentioned above, it only adds one record for the Data Group I have chosen and the record contains the entry "Test 1" from the first line in the text file.

How can I add multiple records to the data group from a file?

[aaron_thomas]

From my testing it appears that you need to have one text file per text block record in Data Manager.

I wrote VBA macro to so that I could input my text blocks into an Excel spreadsheet and then the macro will take the contents of each cell in a highlighted column and create one text file per cell.

Then using Data manager, I can select all of the text files at once and it will import them, creating one record per text file.