https://help.junoviewerweb.com/pages/topic55-importing--exporting-fwp-comments-and-reasons.aspx Acme Forum - Forward Work Programme Related - Importing & Exporting FWP Comments and Reasons - Messages en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Sun, 27 Sep 2015 16:57:58 GMT Sun, 27 Sep 2015 16:57:58 GMT https://help.junoviewerweb.com/pages/topic55-importing--exporting-fwp-comments-and-reasons.aspx
Apart from these custom fields, you can also import information related to Treatments in a specific year. For each treatment year, JunoViewer Web allows you to import two special fields to denote comments and reasons related to a specific treatment. These fields should be denoted with headers "comment_20ZZ" and "reason_20ZZ", respectively, where 20ZZ is the year of treatment. Thus, for example, to import comments and reasons for treatments in the year 2018, you will need to have column headers:

• "treat_2018": to hold the name of the treatment for the year 2018;
• "comment_2018" to hold a comment related to the treatment in year 2018;
• "reason_2018" to hold a reason for assigning the treatment in year 2018;

The figure below shows an example of the use of these columns in action in a FWP import template:



Note that the use of the "comment_20ZZ" and "reason_20ZZ" columns are optional - if you do not have these columns in your FWP import template, then the template will still work, but no reason or comment information will be imported for year 20ZZ.

Finally, note that the comments and reasons you import in this manner can be viewed using the Quick Audit button in Forecast View.
edited by philip on 12/3/2015]]> Sun, 27 Sep 2015 16:57:58 GMT