Hi,

 I am having a VF page QuickCreate. There is a table in a section from where on button click the default data from custom settings will be displayed in the table.

The user can also change the data in the table of VF page. Here when iam trying to save the changed data is not displaying but only the default data is being displayed.

I had written get;set methods too.

VF page

<apex:repeat value="{!prop_ser}" var="ps" id="repeatBlock">

<tr class="headerRow">
   <th scope="col" class="" bgcolor="grey">Type</th>
   <th scope="col" class="" bgcolor="grey">Quantity</th>
   <th scope="col" class="" bgcolor="grey">Category</th>
   <th scope="col" class="" bgcolor="grey">Description</th>
   <th scope="col" class="" bgcolor="grey">Estimated Value</th>
   <th scope="col" class="" bgcolor="grey">Frequency</th>
</tr>
<tr class="first last even dataRow">
   <td class="dataCell"><apex:inputField value="{!ps.PropServiceRecord.Type__c}" id="proptype" onchange="javascript&colon;totalamtdisplay()"/></td>
           <td class="dataCell"><apex:inputField value="{!ps.PropServiceRecord.Quantity__c}" style="width:40px;"/></td>
            <td class="dataCell"><apex:inputField value="{!ps.PropServiceRecord.Material_Category__c}"/></td>
             <td class="dataCell"><apex:inputField value="{!ps.PropServiceRecord.Material_Description__c}"/></td>
              <td class="dataCell"><apex:inputField value="{!ps.PropServiceRecord.Estimated_Value__c}" id="estamt" style="width:40px;" 
                                           onblur="javascript&colon;totalamtdisplay()"/></td>
                <td class="dataCell"><apex:inputField value="{!ps.PropServiceRecord.Frequency__c}"/></td>
           </tr>
</apex:repeat>

Controller class

public mycontroller()
{

public List<QuickCreate.ProposedService> getprop_ser()
{
  if(IsQuickAddButton == true)
            {  
            	system.debug('Entered Quick Add code'+IsQuickAddButton);
                //Quick_Add_Products__c prop_services=Quick_Add_Products__c.getInstance('cmlinkParam');                                      
                prop_services =([select id,Type__c,Quantity__c,Frequency__c,Occurs__c,On_Call__c,Material_Category__c,Material_Description__c,Service__c from 
                                               Quick_Add_Products__c where Name=:cmlinkParam]);
                prod=([select id,Description,Material__c  from Product2 where id=:prop_services.Service__c]);
                propser = new Proposed_Services__c();
                propser.Service__c = prop_services.Service__c;
                propser.Type__c = prop_services.Type__c;
                propser.Quantity__c = prop_services.Quantity__c;
                propser.Frequency__c = prop_services.Frequency__c;
                propser.Occurs__c = prop_services.Occurs__c;
                propser.On_Call__c = prop_services.On_Call__c;
                propser.Material_Category__c = prop_services.Material_Category__c;
                propser.Material_Description__c = prop_services.Material_Description__c;
                system.debug('CHanged Data');
                
                QuickCreate.ProposedService ps = new ProposedService(propser, prod[0].Description, prod[0].Material__c);
                prop_ser.add(ps);
                system.debug('Quick Button'+prop_ser);
                System.debug('Size.....................' + prop_ser.size());
                IsQuickAddButton = false;
            }
           return prop_ser;
}
public class ProposedService
    {
        public Proposed_Services__c PropServiceRecord {public get; private set;}
        public String ServiceDesc {public get; private set;}
        public String ServiceMat{public get; private set;}
        public string ServiceType{public get;private set;}
        
        public ProposedService (Proposed_Services__c ps, String servDesc, String servMat)
        {
        	system.debug('Proposed Services Class:'+ps);
            PropServiceRecord = new Proposed_Services__c();
            PropServiceRecord = ps;
            ServiceDesc = servDesc;
            ServiceMat = servMat;
            //ServiceType=servType;
        }
    }
}

Here is my setter method:

public void setprop_ser(List<QuickCreate.ProposedService> ser)
    {
        prop_ser = ser;
        system.debug('PROP SER'+prop_ser);
    }

Can anyone help me sort out where iam making mistake.

I am not able to display the changed data when i click save.

Hi All,

 I had a requirement where i need to display the grid in the section based on the button clicked in a multi button menu.

Here the field types should be from Custom object Proposed_Services__C but the data should be from Custom setting=Quick_Add_Product__C.

I am retrieving the data from Custom setting through a SOQL query:

public Quick_Add_Products__c prop_services=new Quick_Add_Products__c();

prop_services =([select id,Type__c,Quantity__c,Frequency__c,Occurs__c from Quick_Add_Products__c where Name='2 Yrd Recycle']);

here Type is a picklist, OnCall is a checkbox and so on in Proposed_Services__C

Here i need to get those datatypes from Custom object Proposed_Services__c and Data from Custom Setting Quick_Add_Products__c.

Anyone plz suggest me how to do this.

Appreciate your help.

Thankyou,

Carol

Hi,

 I am having a Picklist with 3 options: None, Commercial and Rolloff.

If None is selected then the below two sections in VF page should be hidden.

If commercial/Roll Off is selected then the below 2 sections should be shown to the user to enter the data.

Anyone please help me doing this.

Appreciate your help.

Thankyou,

Carol

Hi ,

I need help in creating editable grid.

Iam having a multi button menu with value1 , value2 options.

When i click Value1 then an editable grid with data from Products object should be displayed in the lbelow section of the visualforce page.

This grid contains picklist values, textbox and action buttons delete and edit.

Can you please give me any idea to move on this.

Thankyou,

Carol.

Hi,

Iam in a urgent help regarding the Sharing rules migration.

We are having a customer  ABC where there are 5 sharing rules in which 3 are manual user or public group sharing.

But in production we can see only 3 sharing rules under customer ABC which is making a mess.

Now the requirement is to migrate the missing sharing rules of individual customers into production.

We have no idea how all those are moved into production long back and how are they missing.

Now we should move the missing individual user or group sharing rules.

Can any one of you please help me in resolving this.

Appreciate your help.

Thankyou,

Carol

Hi,

I want to use the command Line Data Loader to extract files to a folder.

Do i need to set any classpath? iam getting Java error:

java.lang.ClassNotFoundException: com.salesforce.lexiloader.process.ProcessRunne
r
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:242)
        at org.springframework.util.ClassUtils.forName(ClassUtils.java:108)
        at org.springframework.beans.factory.support.BeanDefinitionReaderUtils.c
reateBeanDefinition(BeanDefinitionReaderUtils.java:65)
        at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.
parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:426)
        at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.
parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:392)
        at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.
parseBeanDefinitions(DefaultXmlBeanDefinitionParser.java:307)
        at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.
registerBeanDefinitions(DefaultXmlBeanDefinitionParser.java:191)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registe
rBeanDefinitions(XmlBeanDefinitionReader.java:295)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadB
eanDefinitions(XmlBeanDefinitionReader.java:223)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:173)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:148)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:68)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:56)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:79)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:68)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:256)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:242)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:221).

Can anyone of you please help me in resolving this.

Thankyou,

carol

Hi,

Can anyone of you please help me in resolving this issue.

When iam running a commandline dataloader to extract the Accounts using the following command

C:\Program Files\salesforce.com\Apex Data Loader 18.0\bin>process.bat "c:\program files\salesforce.com\apex data loader 18.0\test\" csvAccountExtractProcess ---------------> Process name in Process.conf.XML file

iam getting the following message

Usage: java [-options] class [args...]
           (to execute a class)
   or  java [-options] -jar jarfile [args...]
           (to execute a jar file)

where options include:
    -client       to select the "client" VM
    -server       to select the "server" VM
    -hotspot      is a synonym for the "client" VM  [deprecated]
                  The default VM is client.

    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A ; separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose[:class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  require the specified version to run
    -showversion  print product version and continue
    -jre-restrict-search | -jre-no-restrict-search
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
    -agentlib:<libname>[=<options>]
                  load native agent library <libname>, e.g. -agentlib:hprof
                    see also, -agentlib:jdwp=help and -agentlib:hprof=help
    -agentpath:<pathname>[=<options>]
                  load native agent library by full pathname
    -javaagent:<jarpath>[=<options>]
                  load Java programming language agent, see java.lang.instrument

Iam having Apex dataLoader of 18.0 version and JRE SE v1.4.2_19.

Can any one of you know how to resolve this issue.

Thankyou,

Carol

Hello,

Can anyone of you please help me in resolving this issue.

When iam running a commandline dataloader to extract the Accounts iam getting the following error.

C:\Program Files\salesforce.com\Apex Data Loader 18.0\bin>process.bat "c:\progra
m files\salesforce.com\apex data loader 18.0\test\" csvAccountExtractProcess

Usage: java [-options] class [args...]
           (to execute a class)
   or  java [-options] -jar jarfile [args...]
           (to execute a jar file)

where options include:
    -client       to select the "client" VM
    -server       to select the "server" VM
    -hotspot      is a synonym for the "client" VM  [deprecated]
                  The default VM is client.

    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A ; separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose[:class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  require the specified version to run
    -showversion  print product version and continue
    -jre-restrict-search | -jre-no-restrict-search
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
    -agentlib:<libname>[=<options>]
                  load native agent library <libname>, e.g. -agentlib:hprof
                    see also, -agentlib:jdwp=help and -agentlib:hprof=help
    -agentpath:<pathname>[=<options>]
                  load native agent library by full pathname
    -javaagent:<jarpath>[=<options>]
                  load Java programming language agent, see java.lang.instrument

Iam having Apex dataLoader of 18.0 version and JRE SE v1.4.2_19.

Can any one of you know how to resolve this issue.

Thankyou ..

Carol

 Hi All,

When iam running the Process for dataextract through command line dataloader, iam getting the following error:

Can anyone of you know where iam doing the mistake.

I changed the values in config-properties and Process-conf.xml files.

C:\Program Files\salesforce.com\Apex Data Loader 18.0\bin>process ./conf csvAccountExtractProcess

0 [main] INFO com.salesforce.dataloader.process.ProcessConfig  - Loading process
 configuration from config file: C:\Program Files\salesforce.com\Apex Data Loade
r 18.0\bin\.\process\process-conf.xml
47 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader  -
Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex Dat
a Loader 18.0\bin\.\process\process-conf.xml]
47 [main] ERROR com.salesforce.dataloader.process.ProcessConfig  - Error loading
 process: csvAccountExtractProcess configuration from config file: C:\Program Fi
les\salesforce.com\Apex Data Loader 18.0\bin\.\process\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from file [C:\Program Files\salesforce.com\Apex Data Loader 18.
0\bin\.\process\process-conf.xml]; nested exception is java.io.FileNotFoundExcep
tion: C:\Program Files\salesforce.com\Apex Data Loader 18.0\bin\.\process\proces
s-conf.xml (The system cannot find the path specified)
java.io.FileNotFoundException: C:\Program Files\salesforce.com\Apex Data Loader
18.0\bin\.\process\process-conf.xml (The system cannot find the path specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:106)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:85)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:167)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:148)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:68)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:56)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:79)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:68)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:256)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:242)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:221)

Thanks in advance.

Thankyou,

Carol.

Hi All,

Iam in need of extracting related data from 4 diff objects of SFDC on weekly basis and send it to FTP.

Can anyone of you know how to approach with this.

Can we schedule extracting data on weekly/daily basis from SFDC using ANT tool.

We are having Autosys Job scheduling tool.

So, If i can extract files from SFDC to a local folder on weekly basis then i can use autosys tool to get that files and through query map those and send the data to FTP.

Any information/suggestion to approach would be appreciated.

Thankyou in advance.

carol.

Hi All,

Iam in need of extracting related data from 4 diff objects of SFDC on weekly basis and send it to FTP.

Can anyone of you know how to approach with this.

Can we schedule extracting data on weekly/daily basis from SFDC using ANT tool.

We are having Autosys Job scheduling tool.

So, If i can extract files from SFDC to a local folder on weekly basis then i can use autosys tool to get that files and through query map those and send the data to FTP.

Any information/suggestion to approach would be appreciated.

Thankyou in advance.

carol.

Hi,

   Iam new to sfdc and i need a help regarding data extract. I learned many things from these discussion boards and thought i can get a help from here.

 I want to extract activities data at account level whose user profile_name='HSO' and also some data from custom object 'Visits'.

In this visits Obj we are maintaining some activity information of an Account.

This for now i need to get the manual extract but later i need to automate it on weekly basis.

can anyone of you help in moving forward with a solution.

Appreciate any help/information.

Thankyou,

carol.

Hi,

 I am having a Picklist with 3 options: None, Commercial and Rolloff.

If None is selected then the below two sections in VF page should be hidden.

If commercial/Roll Off is selected then the below 2 sections should be shown to the user to enter the data.

Anyone please help me doing this.

Appreciate your help.

Thankyou,

Carol

Hi,

I want to use the command Line Data Loader to extract files to a folder.

Do i need to set any classpath? iam getting Java error:

java.lang.ClassNotFoundException: com.salesforce.lexiloader.process.ProcessRunne
r
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:242)
        at org.springframework.util.ClassUtils.forName(ClassUtils.java:108)
        at org.springframework.beans.factory.support.BeanDefinitionReaderUtils.c
reateBeanDefinition(BeanDefinitionReaderUtils.java:65)
        at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.
parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:426)
        at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.
parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:392)
        at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.
parseBeanDefinitions(DefaultXmlBeanDefinitionParser.java:307)
        at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.
registerBeanDefinitions(DefaultXmlBeanDefinitionParser.java:191)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registe
rBeanDefinitions(XmlBeanDefinitionReader.java:295)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadB
eanDefinitions(XmlBeanDefinitionReader.java:223)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:173)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:148)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:68)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:56)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:79)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:68)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:256)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:242)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:221).

Can anyone of you please help me in resolving this.

Thankyou,

carol

 Hi All,

When iam running the Process for dataextract through command line dataloader, iam getting the following error:

Can anyone of you know where iam doing the mistake.

I changed the values in config-properties and Process-conf.xml files.

C:\Program Files\salesforce.com\Apex Data Loader 18.0\bin>process ./conf csvAccountExtractProcess

0 [main] INFO com.salesforce.dataloader.process.ProcessConfig  - Loading process
 configuration from config file: C:\Program Files\salesforce.com\Apex Data Loade
r 18.0\bin\.\process\process-conf.xml
47 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader  -
Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex Dat
a Loader 18.0\bin\.\process\process-conf.xml]
47 [main] ERROR com.salesforce.dataloader.process.ProcessConfig  - Error loading
 process: csvAccountExtractProcess configuration from config file: C:\Program Fi
les\salesforce.com\Apex Data Loader 18.0\bin\.\process\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from file [C:\Program Files\salesforce.com\Apex Data Loader 18.
0\bin\.\process\process-conf.xml]; nested exception is java.io.FileNotFoundExcep
tion: C:\Program Files\salesforce.com\Apex Data Loader 18.0\bin\.\process\proces
s-conf.xml (The system cannot find the path specified)
java.io.FileNotFoundException: C:\Program Files\salesforce.com\Apex Data Loader
18.0\bin\.\process\process-conf.xml (The system cannot find the path specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:106)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:85)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:167)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:148)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:68)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:56)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:79)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:68)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:256)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:242)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:221)

Thanks in advance.

Thankyou,

Carol.

Hi All,

Iam in need of extracting related data from 4 diff objects of SFDC on weekly basis and send it to FTP.

Can anyone of you know how to approach with this.

Can we schedule extracting data on weekly/daily basis from SFDC using ANT tool.

We are having Autosys Job scheduling tool.

So, If i can extract files from SFDC to a local folder on weekly basis then i can use autosys tool to get that files and through query map those and send the data to FTP.

Any information/suggestion to approach would be appreciated.

Thankyou in advance.

carol.

Hi All,

Iam in need of extracting related data from 4 diff objects of SFDC on weekly basis and send it to FTP.

Can anyone of you know how to approach with this.

Can we schedule extracting data on weekly/daily basis from SFDC using ANT tool.

We are having Autosys Job scheduling tool.

So, If i can extract files from SFDC to a local folder on weekly basis then i can use autosys tool to get that files and through query map those and send the data to FTP.

Any information/suggestion to approach would be appreciated.

Thankyou in advance.

carol.