Rational Functional Tester: Creating and Reading Datapool cell value in RFT

Hello,

Hope this will help for my friends who is trying to use data pool for dynamic values.If you want to use any run time values in between scripts then you will be looking for the functions to read/write/create datapool cells dynamically.

/************ Dp row count *************************/

IDatapoolIterator  ite;

ite.dpCurrent().getEquivalenceClass().getRecordCount();

/***************** to set cell value **************/

IDatapoolIterator it;

((DatapoolCell) it.dpCurrent().getCell("RunTimeSheetForContainers")).setCellValue("Y");

/*********** to load CSV files (csv to Datapool)*******************************/

public IDatapoolIterator LoadCSV(String Sname)

      {

            File fname=getFileName(Sname);

            IDatapool dp=DatapoolUtilities.loadCSV(fname,",",true);

            IDatapoolIterator ii=dpFactory().open(dp, null);

            ii.dpInitialize(dp);

            return ii;

           

      }

/*********** appending a record *********************************/

public IDatapoolIterator appendrecord(IDatapoolIterator it,String[][] dat)

{

IDatapoolEquivalenceClass equivalenceClass = (IDatapoolEquivalenceClass) it.getDatapool().getEquivalenceClass(it.getDatapool().getDefaultEquivalenceClassIndex() );

                  IDatapoolRecord dpRecord = equivalenceClass.constructRecord();

            if(dat!=null)

                  for(int i=0;i<dat.length;i++)

            {

            //    System.out.println("\""+dat[i][0]+"\"\""+dat[i][1]+"\"");

            ((DatapoolCell) dpRecord.getCell(dat[i][0])).setCellValue(dat[i][1]);

           

            }

            equivalenceClass.appendRecord(dpRecord);

           

            return it;

           

      }