//d1=application.ptImport.documentDAO.getSourceData(); //d=application.ptImport.documentController.buildMapping(740); //d=application.ptImport.JobController.runJob(jobid='F50856E7-9AD0-30AB-6CFD9D527EB25ED0'); //d=application.ptImport.documentController.buildDocument(4823); //i=application.ptImport.imageDAO.getSourceData(); //i=application.ptImport.imageController.buildMapping(746); i=application.ptImport.imageController.buildImage(4884); #cfdump(i)# --SELECT * FROM LinkUsage --SELECT LINKUSAGE.* FROM LinkUsage INNER JOIN view_page_mapping_ce_data ON LinkUsage.PageID = view_page_mapping_ce_data.newPageID WHERE LINKUSAGE.TableName = 'Data_TextBlock' AND LINKUSAGE.VersionState >= 2 AND view_page_mapping_ce_data.newPageID > 0 AND view_page_mapping_ce_data.newPageID IS NOT NULL --SELECT * from formats SELECT * FROM import_job_item_data ORDER BY ID DESC bean=JobController jobItemIDs=1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38 jobName=Subsites-mapping2 jobRecordCount=38 jobStartDate= jobType=Subsites-mapping method=createJob application.ptImport.JobController.createjob( jobName='Subsites-mapping2', jobStartDate='', jobType='Subsites-mapping', jobRecordCount='38', jobItemIDs: '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38' ) #cfdump3(gak)# #cfdump3(jobData)# #cfdump3(gak)# #cfdump3(jobItemQry)# #cfdump3(jobItemStatus)# #cfdump3(sourceQry)# #cfdump3(mapQuery)# #cfdump3(d)# #cfdump(cfhttp)# //sourceQry = application.ptImport.PageDAO.getSourceData(); //dumpout(sourceQry); //t = application.ptImport.PageController.buildMapping(jobItemDataID=32790); //t = application.ptImport.PageController.buildPage(13881); //m = application.ptImport.PageDAO.getMappingData(); //dumpout(t); //dumpout(m); //sourceQry = application.ptImport.DocumentDAO.getSourceData(); //dumpout(sourceQry); //t = application.ptImport.DocumentController.buildMapping(jobItemDataID=32790); //t = application.ptImport.DocumentController.buildDocument(13881); //m = application.ptImport.DocumentDAO.getMappingData(); //dumpout(t); //dumpout(m); /* // Verify the docs can build m = application.ptImport.documentService.filterMappingData("not-created"); pageIDListToRun = valueList(m.PAGEID); //dumpout(m); for(k=1;k LTE ListLen(pageIDListToRun);k++){ mapData = application.ptImport.DocumentDAO.getMappingData(pageid=VAL(ListGetAt(pageIDListToRun,k))); dumpout(mapData); docData = application.ptImport.documentService.buildDocData(mapData); dumpout(docData); // If the dumps have the "imgbinary" field populated then we can import the image from the source file path. } */ //sourceQry = application.ptImport.ImageDAO.getSourceData(); //dumpout(sourceQry); //t = application.ptImport.ImageController.buildMapping(33170); //t = application.ptImport.ImageController.buildImage(19316); //m = application.ptImport.ImageDAO.getMappingData(); //dumpout(t); //dumpout(m); /* // Verify the images can build m = application.ptImport.ImageService.filterMappingData("not-created"); pageIDListToRun = valueList(m.PAGEID); //dumpout(m); for(k=1;k LTE ListLen(pageIDListToRun);k++){ mapData = application.ptImport.ImageDAO.getMappingData(pageid=VAL(ListGetAt(pageIDListToRun,k))); dumpOut(mapData); imgData = application.ptImport.imageService.buildImageData(mapData); dumpout(imgData); // If the dumps have the "imgbinary" field populated then we can import the image from the source file path. } */ // FIX LINKS csPageID=44240; //p = application.ptImport.PageDAO.getMappingData(newPageID=csPageID); //dumpOut(p); //d=application.ptImport.pageController.buildPage(p.pageID); //d=application.ptImport.pageController.fixLinks(csPageID); //dumpOut(d); // MATC //d=application.ptImport.pageController.buildPage(6257); //d=application.ptImport.pageController.fixLinks(6703); //d=application.ptImport.pageService.getNewPageData(newpageid=7187); application.ADF.utils.dodump(d,"d",false); //d=application.ptImport.JobController.runJob(jobid='6323A716-5056-9D00-03C27D52E170C9BD'); //dumpout(d); //t = application.ptImport.DocumentController.buildDocument(15751); //dumpout(t); /* // Verify the docs can build //m = application.ptImport.documentService.filterMappingData("not-created"); //pageIDListToRun = valueList(m.PAGEID); pageIDListToRun = 15751; //dumpout(m); for(k=1;k LTE ListLen(pageIDListToRun);k++){ docData = application.ptImport.documentService.buildDocData(application.ptImport.DocumentDAO.getMappingData(VAL(ListGetAt(pageIDListToRun,k)))); dumpout(docData); // If the dumps have the "imgbinary" field populated then we can import the image from the source file path. } */ #cfdump3(ListLen(tmp),"ListLen(tmp)",false)# ---> sourceQry = application.ptImport.DocumentDAO.getSourceData(); dumpout(sourceQry); SELECT DISTINCT pageID from sourceQry m = application.ptImport.PageDAO.getMappingData(newpageid=#pageid#); dumpout(m);