Lee Hoffman wrote: > Of course, this makes it harder to automate plugging the > ID# into the Reference Field. John Cardinal may be able > to suggest something that would mitigate this problem > using his TMG Utility. As Joyce mentioned, TMG Utility can be used to create a reference field value. The basic steps are to (1) create a data file with two columns: - ID of person - Value for reference field) ... and then (2) ask TMG Utility to use the data file to update your project via the "Set Person Field" feature. One way to make the data file is to use a List of People (LoP) report. You create a two-column list where both columns have the same value, the ID number. Configure the LoP to create a tab-delimited output file. On the Report Definition Screen, set "File type" to "Text (ASCII) Delimited with Tab". To make the second column values start with leading zeroes, you must edit the data file prior to using it with TMG Utility. One relatively easy way to do it is to open the data file in Excel or another spreadsheet program. Change the format of the second column to a number with a fixed-width. In Excel, you'd use a custom cell format of "000000000". Nine zeroes will handle IDs up to single-digit millions. To change the format of a column in Excel, right-click the column header and choose Format Cells. In the Format Cells window, change the Category to "Custom" and then key "000000000" in the "Type:" textbox. After you make that format change, save the file. Use "Save As" in Excel to make sure you save it as a tab-delimited file, which I think Excel calls "Text (Tab-delimited)". John

Thanks for help with my "problem" on the list ,and to Michael for offering his help splitting!!. -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av John Cardinal Sendt: 22. november 2017 18:18 Til: TMG-L <[email protected]> Emne: Re: [TMG] 2Gb file limit Lee Hoffman wrote: > Of course, this makes it harder to automate plugging the ID# into the > Reference Field. John Cardinal may be able to suggest something that > would mitigate this problem using his TMG Utility. As Joyce mentioned, TMG Utility can be used to create a reference field value. The basic steps are to (1) create a data file with two columns: - ID of person - Value for reference field) ... and then (2) ask TMG Utility to use the data file to update your project via the "Set Person Field" feature. One way to make the data file is to use a List of People (LoP) report. You create a two-column list where both columns have the same value, the ID number. Configure the LoP to create a tab-delimited output file. On the Report Definition Screen, set "File type" to "Text (ASCII) Delimited with Tab". To make the second column values start with leading zeroes, you must edit the data file prior to using it with TMG Utility. One relatively easy way to do it is to open the data file in Excel or another spreadsheet program. Change the format of the second column to a number with a fixed-width. In Excel, you'd use a custom cell format of "000000000". Nine zeroes will handle IDs up to single-digit millions. To change the format of a column in Excel, right-click the column header and choose Format Cells. In the Format Cells window, change the Category to "Custom" and then key "000000000" in the "Type:" textbox. After you make that format change, save the file. Use "Save As" in Excel to make sure you save it as a tab-delimited file, which I think Excel calls "Text (Tab-delimited)".