• Weber Ralph
  • NEWBIE
  • 0 Points
  • Member since 2023

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
Hello,

I am trying to insert test Account data via Data Loader using the Command Prompt. 
Here is what I get back after process.bat is run....

C:\Users\amanda.mentgen\dataloader_v59.0.0\bin>process.bat "C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf" accountInsert
Data Loader requires Java JRE 17 or later. Checking if it is installed...
2023-09-29 09:47:32,013 INFO  [main] process.ProcessRunner getInstance (ProcessRunner.java:288) - Initializing process engine
2023-09-29 09:47:32,013 INFO  [main] process.ProcessRunner getInstance (ProcessRunner.java:303) - process.nameis specified in the command line. Loading DynaBean with id accountInsert from process-conf.xml located in folder C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf
2023-09-29 09:47:32,029 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:106) - Loading process configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
Standard Commons Logging discovery in action with spring-jcl: please remove commons-logging.jar from classpath in order to avoid potential conflicts
2023-09-29 09:47:32,178 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:98) - Error loading process: accountInsert configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 3 in XML document from file [C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml] is invalid
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:402) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:338) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:184) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:220) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:191) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:253) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:128) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:94) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:696) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:142) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:85) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:113) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:95) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:308) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:254) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.runApp(DataLoaderRunner.java:101) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:83) [dataloader-59.0.0.jar:?]
Caused by: org.xml.sax.SAXParseException: Document root element "pkg:package", must match DOCTYPE root "null".
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:204) ~[?:?]
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:135) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:396) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:284) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(XMLDTDValidator.java:1539) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1806) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:728) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1407) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(XMLDocumentScannerImpl.java:1292) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3079) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:836) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:605) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:542) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:889) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:825) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:247) ~[?:?]
        at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:342) ~[?:?]
        at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:77) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadDocument(XmlBeanDefinitionReader.java:432) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:390) ~[dataloader-59.0.0.jar:?]
        ... 19 more
2023-09-29 09:47:32,195 FATAL [main] process.ProcessRunner logErrorAndExitProcess (ProcessRunner.java:244) - Unable to run process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: accountInsert configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:99) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:308) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:254) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.runApp(DataLoaderRunner.java:101) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:83) [dataloader-59.0.0.jar:?]
Caused by: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 3 in XML document from file [C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml] is invalid
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:402) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:338) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:184) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:220) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:191) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:253) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:128) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:94) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:696) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:142) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:85) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:113) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:95) ~[dataloader-59.0.0.jar:?]
        ... 4 more
Caused by: org.xml.sax.SAXParseException: Document root element "pkg:package", must match DOCTYPE root "null".
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:204) ~[?:?]
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:135) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:396) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:284) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(XMLDTDValidator.java:1539) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1806) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:728) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1407) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(XMLDocumentScannerImpl.java:1292) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3079) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:836) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:605) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:542) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:889) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:825) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:247) ~[?:?]
        at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:342) ~[?:?]
        at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:77) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadDocument(XmlBeanDefinitionReader.java:432) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:390) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:338) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:184) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:220) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:191) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:253) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:128) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:94) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:696) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:142) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:85) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:113) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:95) ~[dataloader-59.0.0.jar:?]
        ... 4 more
2023-09-29 09:47:32,195 FATAL [main] process.ProcessRunner logErrorAndExitProcess (ProcessRunner.java:244) - Unable to run process
java.lang.RuntimeException: Error loading process: accountInsert configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessRunner.logErrorAndExitProcess(ProcessRunner.java:245) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:270) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.runApp(DataLoaderRunner.java:101) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:83) [dataloader-59.0.0.jar:?]
Exception in thread "main" java.lang.RuntimeException: Error loading process: accountInsert configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessRunner.logErrorAndExitProcess(ProcessRunner.java:245)
        at com.salesforce.dataloader.process.DataLoaderRunner.runApp(DataLoaderRunner.java:103)
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:83)

Here is what I have in the XML file...
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="accountInsert"
class="com.salesforce.dataloader.process.ProcessRunner"
scope="prototype">
<description>accountInsert job gets the account record from the CSV file
and inserts it into Salesforce.</description>
<property name="name" value="accountInsert"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="false"/>
<entry key="sfdc.debugMessagesFile"
value=" C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\status\accountInsertSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://ifcjdevdata.lightning.force.com"/>
<entry key="sfdc.username" value="devdata123@ifcjdevdata.org"/>
<!--Password below has been encrypted using key file,
therefore, it will not work without the key setting:
process.encryptionKeyFile.
The password is not a valid encrypted value,
please generate the real value using the encrypt.bat utility -->
<entry key="sfdc.password" value="ea90e3df7f51caaf3cb4e96b6c7c479d1abcd46bd319814ee7e"/>
<entry key="process.encryptionKeyFile"
value="c:\Users\amanda.mentgen\.dataloader\dataLoader.key"/>
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Account"/>
<entry key="process.operation" value="insert"/>
<entry key="process.mappingFile"
value="C:\amanda.mentgen\dataloader_v59.0.0\samples\conf\accountInsertMap.sdl"/>
<entry key="dataAccess.name"
value=" C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\data\insertAccounts.csv"/>
<entry key="process.outputSuccess"
value=" C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\status\accountInsert_success.csv"/>
<entry key="process.outputError"
value=" C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\status\accountInsert_error.csv"/>
<entry key="dataAccess.type" value="csvRead"/>
<entry key="process.initialLastRunDate"
value="2023-09-29T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>
Hi there :)

i'm currently working on an native Android app for my company and ran into some problems with Salesforce lately.

I hope i can find some help here.

What i want to achieve:
The company has a lot of Accounts in Salesforce with 3 important fields for the app: Name, Business (Workshop or Parts Dealer) and location(latitude, longitude)
I would like to show those Accounts(Workshops/Parts Dealers) as markers on a google map in my Android app based on a radius around the user's current location. So it would be more than sufficient to get the data as JSON or XML(i read about sObjects, which would be nice too)

The app will be freely available on Google Play Store and every user should be able to see all the Workshops/Parts dealers around the world.

The problem i'm facing is that i can't find a way to fetch the data inside my app without authenticating every user with a Salesforce-Login. 
Which API is the best to use in this case?

It would be so awsome if anybody could help me with this problem.

What i tried so far: 
- SalesforceMobileSDK: If i extend SalesForceApplication i always end up with the Salesforce-Login Screen.
It seems that every client has to be authenticated for API-calls to work. I tried using the method "peekUnauthenticatedRestClient", but this method only works on full path URL's(e.g. "https://api.spotify.com/v1/search?q=James%20Brown&type=artist"), which isn't really practically for my Use-case.

- I feel like i read nearly all docs about salesforce api, but can't quite get my head around how to solve this problem, although it seems like to be a pretty common use-case.  

- would a salesforce-apex method which would select all records inside a set radius around the user's location be accessable without authentication?

Thanks for your help in advance!

Roman