Using text files with NeoGroup and GroupBuilder

Beginning with Version 4.4, it became possible to perform several functions in NeoGroup and GroupBuilder with respect to names, folders, group images and row names by importing one or more text files.

  1. Name lists can be imported for non 'home' folders
  2. Row names can be set by text file
  3. Folders can be created for non 'home' folders
  4. Images can be imported by text file and automatically allocated to a folder

Note the above functions can all be accomplished with a single text file or with individual text files. In the interests of simplicity and clarity the examples below will use a separate text file to demonstrate each feature.

Importing names for home folders

Using a text file to create name lists for subjects home folders has been a long standing feature of NeoGroup, GroupBuilder and DataPost. The text file need simply contain the subject's ID (unique field) their row and their position. (It can contain more information but these are the critical fields) Importing the text file will then add the subject to the correct row and position for their home folder group page.

Consider the following extract from a comma delimited text file. The three fields are ID, row and position respectively

ID,ROW,POSITION
23432,1,1
45654,1,2

The text file can either be imported in Names Mode or Details Mode. The following field mapping applies to Names Mode


Figure 1: Field mapping in names mode

Importing names for non home folders

The example above can only set names for the subjects' home folders since there is no field in the text file designating a folder. The home folder must therefore be assumed. In order to set the names for a folder other than the home folder it is therefore necessary for the text file to include a field to that effect.

ID,ROW,POSITION,FOLDER
23432,1,1,
45654,1,2,
23432,3,2,Football
45654,4,5,Basketball

The text file extract above includes the same two subjects but now has an additional field indicating the folder for which the name should be set. Leaving this 'folder name' field blank indicates the name is to be added to the home folder. In the example above, subject 23432 will be in row 1 and position 1 for his home folder but row 3 and position 2 for the Football folder. Subject 45654 will be in row 1 position 2 for his home folder and row 4 position 5 for the Basketball folder.

The text file can again be imported in either Names Mode or Details Mode. The following field mapping applies to Names Mode. Note checking the 'Folder name field' option activates the additional field to be mapped.


Figure 2: Mapping the folder name field

Setting row names

Traditionally row names (also referred to as headers, labels or titles) have been set manually in Names Mode. When name lists have been created by text file the row names would default to Row 1, Row 2 etc. With the advent of Version 4.4 it is possible to also set row names by text file.

Consider the text file extracts above. An additional field can be added to specify the row name

ID,ROW,POSITION,ROWNAME
23432,1,1,,Front Row
45654,1,2,,Front Row
23432,3,2,Football,Third Row
45654,4,5,Basketball,Fourth Row

Importing the text file and mapping the fields can again be done in either Names Mode or Details Mode.


Figure 3: Mapping the row name field

Creating folders and importing group images

Using a text file to import subject data and create their home folders is a long standing practise in Timestone Software and is well documented elsewhere. However with Version 4.4 it became possible to create non home or 'extra' folders. In addition it became possible to import group images and allocate them to their correct folder.

These two new features are demonstrated by the single text file below. Note however each function could be performed by its own separate text file. Conversley this text file could be used in conjunction with any of the features listed above.

Consider the text file extract below. The fields are

  1. Folder - the name of the folder to be created
  2. Group image - the filename of the group image to be imported
  3. Lastname - this needs to have the value 'group' in order for the group image to be 'matched' to the correct folder

LASTNAME,FOLDER,GROUPIMAGE
group,CricketA,100.jpg
group,CricketB,101.jpg
group,Netball,113.jpg
group,Captains,127.jpg

It may seem odd to require the lastname field as per above. However this is needed because, as stated, the text file could also contain subject data. In this case the 'group' value in the lastname field differentiates this row of data from the 'normal' subject data

Importing the text file with the mapping shown in the screen grab will have the following result. Note this text file can only be imported in the Details Mode of NeoGroup or GroupBuilder.

  1. Folders are created
  2. Group images are imported
  3. Group images are allocated to the appropriate folder


Figure 4: Creating folders and importing group images

Recent Discussions

15 Sep, 2018 10:29 AM
11 Sep, 2018 10:52 PM
04 Sep, 2018 03:16 PM
14 Aug, 2018 02:48 PM
03 Aug, 2018 03:05 PM