NIH | National Cancer Institute | NCI Wiki  

  1. Apelon notifies us monthly when a new version of NDFRT is available and sends us instructions for how to login to the download site. 

Download

    1. Once there, navigate to "SPL ProjectDownloads" and select the files "NDFRT Public YYYY.MM.DD TDE", "NDFRT Public YYYY.MM.DD TDE Inferred", "NDFRT Public YYYY.MM.DD TDE ByName" and "NDFRT YYYY.MM.DD SPL"
    2. Now navigate to NDFRT Downloads and select "NDFRT vYYYY.MM.DDxx" full load and diff load files.

For LexEVS

  1. Copy NDFRT_Public_YYYY-MM-DD_TDE_ByName.zip to the private ftp at /evs/upload/NDFRT
  2. Notify nci-meta-l that the file is ready for processing
  3. When notified, download the OWL file from the private ftp and load to LexEVS

TDE files

  1. Copy NDFRT_Public_<date>_TDE.zip onto the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming/_Old+Misc
    1. Copy NDFRT_Public_<date>_TDE.zip onto the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming and rename to NDFRT_Public_All.zip
    2. Put a copy of NDFRT_Public_All.zip in the public ftp at cacore/EVS/NDF-RT
    3. Copy NDFRT_Public_<date>_TDE.zip onto the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming and rename to NDFRT_Public_All YYYY-MM-DD.zip.
    4. Delete the previous month's NDFRT_Public_All YYYY-MM-DD.zip from NCICB/EVS/FTP/NDF-RT/0_Incoming
    5. Put a copy of NDFRT_Public_All YYYY-MM-DD.zip in the public ftp at cacore/EVS/NDF-RT/archive
  2. Copy NDFRT_Public_<date>_TDE_inferred.zip onto the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming/_Old+Misc
    1. Copy NDFRT_Public_<date>_TDE_inferred.zip onto the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming and rename to NDF-RT_XML_Inferred.zip
    2. Put a copy of NDF-RT_XML_Inferred.zip in the public ftp at cacore/EVS/NDF-RT
    3. Copy NDFRT_Public_<date>_TDE_inferred.zip onto the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming and rename to NDF-RT_XML_Inferred YYYY-MM-DD.zip
    4. Delete the previous month's NDF-RT_XML_Inferred YYYY-MM-DD.zip from NCICB/EVS/FTP/NDF-RT/0_Incoming
    5. Put a copy of NDF-RT_XML_Inferred YYYY-MM-DD.zip in the public ftp at cacore/EVS/NDF-RT/Archive
  3. Copy the 77_full and 77_diff files to the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming
    1. Delete the previous month's 77_full and 77_diff files from NCICB/EVS/FTP/NDF-RT/0_Incoming
    2. Put a copy of each in the public ftp at cacore/EVS/NDF-RT/archive
    3. Put a copy of each in the public ftp at cacore/EVS/NDF-RT
    4. Delete the previous month's 77_full and 77_diff files from the public ftp at cacore/EVS/NDF-RT
  4. Extract NDFRT_Public_YYYY.MM.DD_TDE.xml from NDFRT_Public_YYYY.MM.DD_TDE.zip.
    1. zip NDFRT_Public_YYYY.MM.DD_TDE.xml into NDF-RT_XML.zip
    2. Put a copy of NDF-RT_XML.zip on the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming
    3. Put a copy of NDF-RT_XML.zip in the public ftp at cacore/EVS/NDF-RT
    4. Put a copy of NDF-RT_XML.zip on the group drive at NCICB/EVS/FTP/NDF-RT/0_Incoming and rename it NDF-RT_XML YYYY-MM-DD.zip
    5. Delete the previous month's NDF-RT_XML YYYY-MM-DD.zip from NCICB/EVS/FTP/NDF-RT/0_Incoming
    6. Put a copy of NDF-RT_XML YYYY-MM-DD.zip in the public ftp at cacore/EVS/NDF-RT/archive

Release Notes

  1. Extract NDFRT_Public_Edition_Release_Notes_YYYY.MM.DD.txt from NDFRT_Public_YYYY.MM.DD_TDE.zip.
    1. Open NDFRT_Public_Edition_Release_Notes_YYYY.MM.DD.txt in a text editor and edit to make 78 character lines and remove special characters from text.
    2. Save a copy as NDF-RT Public Edition Release Notes.txt
    3. Save a copy as NDF-RT Public Edition Release Notes YYYY-MM-DD.txt
    4. Put both copies onto group drive under NCICB/EVS/FTP/FDA/ndfrt/0_Incoming
    5. Put the dated copy onto group drive NCICB/EVS/FTP/FDA/ndfrt/Archive
    6. Delete the previous month's NDF-RT Public Edition Release Notes YYYY-MM-DD.txt from NCICB/EVS/FTP/FDA/ndfrt/0_Incoming
    7. Put both copies in the public ftp at cacore/EVS/FDA/ndfrt
    8. Put the dated copy in the public ftp at cacore/EVS/FDA/ndfrt/Archive
    9. Delete the previous month's NDF-RT Public Edition Release Notes YYYY-MM-DD.txt from the public ftp at cacore/EVS/FDA/ndfrt
  2. Extract NDFRT_Public_YYYY.MM.DD_NUI.txt from NDFRT_Public_YYYY.MM.DD_TDE.zip

    1. Check to make sure each line of the file has 2 fields using the command:

      gawk -F"\t" 'NF != 2' *_NUI.txt

    2. Sort the lines and move NUIs from end to start of line using the command:

      sort  -f  *_NUI.txt  | gawk  -F"\t" 'BEGIN { OFS = "\t" } { print $2, $1 }' > NDF-RT.txt
    3. Open in editor and convert " [" to "\t["
    4. Save a copy of NDF-RT.txt as NDF-RT YYYY-MM-DD.txt
    5. Put copies of both NDF-RT.txt and NDF-RT YYYY-MM-DD.txt on group drive NCICB/EVS/FTP/NDF-RT/0_Incoming
    6. Delete previous month's NDF-RT YYYY-MM-DD.txt from group drive NCICB/EVS/FTP/NDF-RT/0_Incoming
    7. Put copy of NDF-RT.txt on public ftp under cacore/EVS/NDF-RT
    8. Put copy of NDF-RT YYYY-MM-DD.txt on public ftp under cacore/EVS/NDF-RT/Archive

SPL Files

  1. Copy NDFRT_YYYY.MM.DD_SPL.zip to group drive EVS/FTP/FDA/ndfrt/_Old+Misc
  2. Extract NDFRT_YYYY.MM.DD_SPL.zip to get the 3 SPL files.
    1. Create header files for each of the SPL files
      echo "NDF-RT Code NDF-RT Name" > MechanismOfAction.txt
      echo "NDF-RT Code NDF-RT Name" > StructuralClass.txt
      echo "NDF-RT Code NDF-RT Name" > PhysiologicEffect.txt
    2. Merge the SPL files into the headers.
      sort -f +1 *moa_nui.txt >> MechanismOfAction.txt
      sort -f +1 *cs_nui.txt >> StructuralClass.txt
      sort -f +1 *pe_nui.txt >> PhysiologicEffect.txt
    3. Using a text editor, convert "|" to tab for all 3 SPL files and change the spaces in the column headers to tab.
    4. Copy the three txt files to the group drive in NCICB/EVS/FTP/FDA/ndfrt
    5. Copy the three txt files to the public FTP at /cacore/EVS/FDA/ndfrt
    6. Create dated versions of each of the 3 files of format * YYYY-MM-DD.txt
    7. Copy the three dated text files to the public FTP at /cacore/EVS/FDA/ndfrt/Archive

SPL Excel Files

  1. Open last month's MechanismOfAction.xls
    1. Delete all the data from row 2 down, leaving the column headers.
    2. Open this month's MechanismOfAction.txt and copy all the data from the second row down. Paste this into the MechanismOfAction.xls and save.
    3. Save a copy as MechanismOfAction YYYY-MM-DD.xls
  2. Open last month's PhysiologicEffect.xls
    1. Delete all the data from row 2 down, leaving the column headers.
    2. Open this month's PhysiologicEffect.txt and copy all the data from the second row down. Paste this into the PhysiologicEffect.xls and save.
    3. Save a copy as PhysiologicEffect YYYY-MM-DD.xls
  3. Open last month's StructuralClass.xls
    1. Delete all the data from row 2 down, leaving the column headers.
    2. Open this month's StructuralClass.txt and copy all the data from the second row down. Paste this into the StructuralClass.xls and save.
    3. Save a copy as StructuralClass YYYY-MM-DD.xls
  4. Distribute the xls files
    1. Copy each of the undated xls files to the group drive at NCICB\EVS\FTP\FDA\ndfrt
    2. Copy each of the undated xls files to the public FTP at cacore/EVS/FDA/ndfrt
    3. Copy each of the dated xls files to the group drive at cacore/EVS/FDA/ndfrt/Archive

  • No labels