therabbitwindfall / dataloadercliq Goto Github PK

What steps will reproduce the problem?
1. Entered user id & password, press Validate


What is the expected output? What do you see instead?
Loading GUI...
- Unable to find required classes (javax.activation.DataHandler and 
javax.mail.internet.MimeMultipart). Attachment support is disabled.

What version of the product are you using? On what operating system?
cliq 1.4.22, downloaded 9/12/11, 
Windows 7, 
java version "1.6.0_23"
Java(TM) SE Runtime Environment (build 1.6.0_23-b05)
Java HotSpot(TM) 64-Bit Server VM (build 19.0-b09, mixed mode)


Please provide any additional information below.

What steps will reproduce the problem?
1. Started the process clicking bat file 
2. Selected the Operation and provided the process name
3. Clicked to Next button

What is the expected output? What do you see instead?

Process takes time to redirect user to the Login screen


What version of the product are you using? On what operating system?
CLIq- Latest on Window


Please provide any additional information below.

What steps will reproduce the problem?
1. Configure CLIq using an operation using an External Id
2. Run the script.
3. No records will be updated.

What is the expected output? What do you see instead?
Prompt the user for External ID fields and update the sfdc.externalIdField 
parameter in process-conf.xml

It would be helpful to have more prompts and instructions while running the 
wizard.

What steps will reproduce the problem?
Run Cliq with DataLoader 24.0


Workaround
Edit cliq.bat and change "_jvm" to "Java" in the path to java.exe.  The new 
Data Loader has changed the path, which has broken CLIq.  Fix coming soon.

What steps will reproduce the problem?
1. Run an extract file having French characters in a text field using the 
dataloader.jar program
2.
3.

What is the expected output? What do you see instead?
EXPECTED - SEE FRENCH CHARACTERS WITH ACCENTS
ACTUAL - FRENCH ACCENTS ARE REPLACED WITH DUMMY CHARACTER

What version of the product are you using? On what operating system?
unix 

Please provide any additional information below.

What steps will reproduce the problem?
1. Login and produce a cliq script directory
2. Finish
3. Login again try to product another cliq script

What is the expected output? What do you see instead?
Normal output is expected but I frequently get:
;nested exception is: javax.net.ssl.SSLException: Unrecognized SSL, plaintext 
connection?

What version of the product are you using? On what operating system?
1.4.19, Windows

Please provide any additional information below.
This doesn't happen ALL the time, but it does happen most of the time.  It 
seems to be some type of SSL clean up issue because if I wait a few minutes 
then it'll work but doing back-to-back sessions usually gets the error above.

What steps will reproduce the problem?
1. Choose a DML Operation
2. The resulting process-xml does not have the entity set.  It would have to 
be set manually.

What steps will reproduce the problem?
1. Attempt to run export from command line interface, using process-conf.xml
2.
3.

What is the expected output? What do you see instead?
INFO messages; DEBUG messages instead

What version of the product are you using? On what operating system?
Apex 21.0; Windows 7 Home Premium

Please provide any additional information below.
Worked on Apex 17.0, Windows XP
Changed sfdc.endpoint to "login.salesforce.com" instead of "www.salesforce.com"

What steps will reproduce the problem?
1. Put a number at the beginning of the project name.
2. This causes a problem because Java names cannot start with a number

What is the expected output? What do you see instead?
An error indicating that numbers cannot be used in the project name.

Please use labels and text to provide additional information.

What steps will reproduce the problem?
1. Create an Export and the file process-conf.xml will contain
sfdc.endpoint as http://www.salesforce.com which caused an exception from
Salesforce (listed below).

What is the expected output? What do you see instead?

I expected everything to export successfully but instead I had to change
the endpoint to https://www.salesforce.com.

What version of the product are you using? On what operating system?

cliq-0.4.1 / Windows XP SP2

Please provide any additional information below.

  - Error while logging in to web service at:
http://www.salesforce.com/services/Soap/u/17.0, error was: HTTPS Required
[UnexpectedErrorFault [ApiFault  exceptionCode='UNSUPPORTED_CLIENT'
 exceptionMessage='HTTPS Required']]

For testing and development, it would be helpful to be able to choose the 
endpoint in the UI.

What steps will reproduce the problem?
1.Enter proxy info in cliq.properties
2.Run the batch file
3.Select an Operation and Process Name then click Next

What is the expected output? What do you see instead?
Expect: Something
See: Nothing. Except some Java statements on the cmd.exe window. The 
Wizard goes nowhere, though I can click Cancel to exit.

What version of the product are you using? On what operating system?
V1.2 on Windows XP Professional.

Please provide any additional information below.
Proxy settings are the same as I set for the Apex Data Loader. I set the 
host and port, but not the username

Create sh file for UNIX/Mac

What steps will reproduce the problem?
1. Running an upsert
2.
3.

What is the expected output? What do you see instead?
Upsert records (29000)

error telling me external id filed name provided does not match an external id 
for workflow1

I upsert data into this object with another process with no issues.


What version of the product are you using? On what operating system?

The latest 2.1.1
Please provide any additional information below.

What is the expected output? What do you see instead?
When a new version is available, prompt for download and install 
automatically.

What steps will reproduce the problem?
run ./cliq.sh -t on a UNIX platform

What is the expected output? What do you see instead?
The text ui should execute, but it does not.

What steps will reproduce the problem?
1. Create a process on Windows with DL 24.0
2. Run the process
3. You  will see an error.

Workaround
There will be a line like this in the <process>.bat file:
call %DLPATH%\_jvm\bin\java.exe

it needs to change to:
call %DLPATH%\Java\bin\java.exe

What steps will reproduce the problem?
1.Running ./cliq.sh, wait a while and the GUI pops out
2.Enter Operation/Process Name and click next
3.Enter username and password (no matter whether they're correct or wrong) and 
click "Verify Username and Password"

What is the expected output? What do you see instead?
Expect : Log In Information
Result : ;nested exception is: java.io.IOException

What version of the product are you using? On what operating system?
DataLoader 22, CLIq 1.4.22, Ubuntu 10.10

Please provide any additional information below.
I followed the steps provided by Vijay to run the CLIq under UNIX. Have opened 
all the permission (and all subfolders) inside the dataloader folder. Tried all 
combination with the correct password and wrong password, they all show the 
same error.
I even tried ./cliq.sh -t, after entering password, it went into eternal loop 
asking for username and password.

What version of the product are you using? On what operating system?
i am using dataloader 23.0 and CLIq 2.1. OS is win-XP

Please provide any additional information below.
after entering the credentials and clicked the verify button ... i am unable to 
get the login result..you can see the attached image.....

What steps will reproduce the problem?
1.Followed same steps as in Video by Vijay.
2. Could reach to the point on executing the query but could not export it. 
Received error  "The system cannot find the path specified"
3. Then could not find Click_process file.

What is the expected output? What do you see instead?
Export to happen successfully and find Click_process file

What version of the product are you using? On what operating system?
2.1.1 and 2.2.2

Please provide any additional information below.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

What steps will reproduce the problem?
1. including a data element name from SF with 38 characters in the name
2.
3.

What is the expected output? What do you see instead?
expected "Query is valid" in the result window...instead, get "Exception 
occurred during event dispatching: java.lang.OutOfMemoryError: Java heap space" 
in the dataloader cliq batch session window

What version of the product are you using? On what operating system?
1.4.20

Please provide any additional information below.
eliminating long data name corrected the query

What steps will reproduce the problem?
1. Install DataLoader 18.0
2. Install CLIq 1.2
3. Create a process and run the batch/sh script

The console will show SOAP errors.

What is the expected output? What do you see instead?
There should not be any errors.

Unable to Login through CLIq.

Failed to send request to https://test.salesforce.com/services/Soap/u/23.0 
message is displayed. Error Log attached.

What steps will reproduce the problem?
1. Run CLIq from a non-Internet connected PC
2. An exception will be shown, but no log file is created.

What is the expected output? What do you see instead?
A log file with all errors.

Please use labels and text to provide additional information.

What steps will reproduce the problem?
1. Start CLIq behind a proxy
2. An IOException will be displayed because it cannot connect to the Internet

What is the expected output? What do you see instead?
Prompt for proxy server.

Please use labels and text to provide additional information.

What is the expected output? What do you see instead?
Allow the user to choose the destination for the CLIq output files.

Please use labels and text to provide additional information.

What steps will reproduce the problem?
1. Enter a proxy host and username
2. The password will be echoed instead of "*" or nothing.

What is the expected output? What do you see instead?
The password should be hidden or masked.

What is the expected output? What do you see instead?
Add an "Export All" option in the UI, which will create an "extract_all" 
operation in the process-conf.xml.

Please use labels and text to provide additional information.

What steps will reproduce the problem?
1.Enter proxy info on cliq.properties
2.Run the batch file
3.Enter Operation/Process name, press Next
4.Enter credentials, click "Verify Username and Password"

What is the expected output? What do you see instead?
Expect: Log in confirmation
See: Result shows error message ";nested exception 
is:javax.net.SSLException: Unrecognized SSL message, plaintext connection?"

What version of the product are you using? On what operating system?
1.2, Windows XP Pro

Please provide any additional information below.
The other issue I logged is relevant as well as this one. Experienced on 
separate PCs on the same network.

What steps will reproduce the problem?
1. Set a proxy password in cliq.properties
2. Create a CLIq configuration
3. The password is not encrypted in the process-conf.xml

What steps will reproduce the problem?
1.after login and verfying query successfully it shows below error

directory already exist delet it first..
But when i check there is no directory for such name.

what to do?

i am on Windows 7. if it is a problem pls guide step by step

What is the expected output? What do you see instead?
After creating a CLIq configuration, there should be a button to restart the 
wizard to create another configuration.

Please use labels and text to provide additional information.

What steps will reproduce the problem?
1. Choose Export
2. Enter a bad query

What is the expected output? What do you see instead?
I should see an error, but the program crashes.

Please use labels and text to provide additional information.

What steps will reproduce the problem?

1. running cliq for unix to upload sfdc attachment file containing special 
character in file name.

1.insert any attachment containing a file name which has special character (i 
used the file name as "MedInfoFAQs_3772_olai_pat_was ist zypadhera™ und wozu 
wird es angewendet.mht")

2.upload the attachment using cliq tool generated script sh file for sfdc 
account related attachment object

3.In output log it is showing an error like "Error converting value to correct 
data type: 
/mkt/crml4/inbound/STAR_PROD/Full/STAR_FAQ_12122011/MedInfoFAQs_3772_olai_pat_wa
s ist zypadhera™ und wozu wird es angewendet.mht (No such file or directory)

Expected result should be uploading successful for this attachment file 
containing special char in file name.


CLIQ version used: 
Operating system: UNIX

Hi!,

I'm using this tool to schedule upserts to Salesforce.

I found exactly the same problem as described in Issue 17 
(http://code.google.com/p/dataloadercliq/issues/detail?id=17) , but with 
Products. Seems that the solution given doesn't work. As output I get the same 
error as reproduced but with TTL_ID__c instead.

Can you explain your fix?, and, if it's possible a solution for this.

Thanks,

MGA

As a user, I want to set a default username, so I don't have to retype it each 
time.

What steps will reproduce the problem?
1. Create an Export Process
2. Enter a SOQL query with a ">" or "<"
3. The script will show an XML error because "<" and ">" cannot be part of 
XML content.

What is the expected output? What do you see instead?
In SOQL queries,
> should be &gt;
< should be &lt;

Workaround
1. Open process-conf.xml
2. In the query, replace:
 > with &gt; 
 < with &lt;

As a User, I want to see a picklist of valid Entities (Objects) in my org, so 
that I don't have to find the API Name of an object when creating a DML 
operation.

Add logging for:
- Salesforce authentication
- Properties file loading

What steps will reproduce the problem?
1. Creation of the process files works great (cliq interface) (ex.: select 
name from Account)

2. execution of the batch fails  : 
   C:\Program Files\salesforce.com\Apex Data Loader 
17.0\cliq_process\exportAccount> exportAccount.bat >> ErrorLog.txt

3. Please see the batch file log attached

What is the expected output? What do you see instead?
CSV of the export operation. CSV has 0 bytes

What version of the product are you using? On what operating system?
Cliq_latest, Windows 7 (ultimate Edition)

Please provide any additional information below.

What steps will reproduce the problem?
1. Running CLIq on Windows 7


What is the expected output? What do you see instead?
Access denied when trying to create the data loader CLI files via the GUI.


What version of the product are you using? On what operating system?
v19 on Windows 7

Please provide any additional information below.
Workaround is to turn of the Window 7 UAC. 

Hi I'm trying to automate upserting process with Cliq and this is error I got.

2012-04-12 14:09:09,717 INFO  [main] controller.Controller initLog 
(Controller.java:404) - The log has been initialized
2012-04-12 14:09:09,827 INFO  [main] process.ProcessConfig getBeanFactory 
(ProcessConfig.java:103) - Loading process configuration from config file: 
H:\DataLoader\cliq_process\Upsert\config\process-conf.xml
2012-04-12 14:09:10,734 INFO  [main] xml.XmlBeanDefinitionReader 
loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean 
definitions from file 
[H:\DataLoader\cliq_process\Upsert\config\process-conf.xml]
2012-04-12 14:09:20,858 INFO  [Upsert] controller.Controller initConfig 
(Controller.java:365) - The controller config has been initialized
2012-04-12 14:09:20,874 INFO  [Upsert] process.ProcessRunner run 
(ProcessRunner.java:116) - Initializing process engine
2012-04-12 14:09:20,889 INFO  [Upsert] process.ProcessRunner run 
(ProcessRunner.java:119) - Loading parameters
2012-04-12 14:10:00,758 ERROR [Upsert] config.Config decryptProperty 
(Config.java:682) - Error loading parameter: sfdc.proxyPassword of type: 
java.lang.String
java.lang.NumberFormatException: For input string: "Br"
    at java.lang.NumberFormatException.forInputString(Unknown Source)
    at java.lang.Integer.parseInt(Unknown Source)
    at java.lang.Integer.valueOf(Unknown Source)
    at java.lang.Integer.decode(Unknown Source)
    at com.salesforce.dataloader.security.EncryptionUtil.textToBytes(EncryptionUtil.java:68)
    at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:204)
    at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:668)
    at com.salesforce.dataloader.config.Config.postLoad(Config.java:625)
    at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:646)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
    at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
2012-04-12 14:10:00,773 FATAL [main] process.ProcessRunner topLevelError 
(ProcessRunner.java:238) - Unable to run process Upsert
java.lang.RuntimeException: 
com.salesforce.dataloader.exception.ParameterLoadException: Error loading 
parameter: sfdc.proxyPassword of type: java.lang.String
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:162)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
    at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.salesforce.dataloader.exception.ParameterLoadException: Error 
loading parameter: sfdc.proxyPassword of type: java.lang.String
    at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:683)
    at com.salesforce.dataloader.config.Config.postLoad(Config.java:625)
    at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:646)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
    ... 2 more
Caused by: java.lang.NumberFormatException: For input string: "Br"
    at java.lang.NumberFormatException.forInputString(Unknown Source)
    at java.lang.Integer.parseInt(Unknown Source)
    at java.lang.Integer.valueOf(Unknown Source)
    at java.lang.Integer.decode(Unknown Source)
    at com.salesforce.dataloader.security.EncryptionUtil.textToBytes(EncryptionUtil.java:68)
    at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:204)
    at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:668)
    ... 5 more

Please can you help.

What steps will reproduce the problem?
1. run the command ./cliq.sh -t on unix machine with no X windows on it
2.
3.

What is the expected output? What do you see instead?
I was expecting so sort of text based interface. I got the following error
bash-2.05$ ./cliq.sh -t
./cliq.sh: 
CLASSPATH=cliq.jar:../DataLoader.jar:lib/miglayout-3.7.1.jar:lib/jaf-1.0.2/activ
ation.jar:lib/javamail-1.4.2/mail.jar:lib/commons-discovery-0.2.jar:lib/axis.jar
:lib/axis-ant.jar:lib/jaxrpc.jar:lib/log4j-1.2.8.jar:lib/saaj.jar:lib/wsdl4j-1.5
.1.jar:.: is not an identifier



What version of the product are you using? On what operating system?
Data loader 19.0 and Cliq 19.0

Please provide any additional information below.

What steps will reproduce the problem?
1. Create new process
2. Use name that already exists

What is the expected output? What do you see instead?
An error saying that the directory already exists.
There is currently no error.

What steps will reproduce the problem?
1. Login Credential verification process takes time
2.
3.

What is the expected output? What do you see instead?
Should display some custom message "Processing..."

What version of the product are you using? On what operating system?
CLIQ1.1 Window

Please provide any additional information below.

What steps will reproduce the problem?
1. Set up export CLIq process on desired custom object
2. Set up hard delete CLIq process on desired custom object
3. Run CLIq export process (will output the ids of objects)
4. Copy output (write) file to input (read) of CLIq delete process
5. Run CLIq hard delete process

What is the expected output? What do you see instead?
Expected hard delete of objects listed.  Nothing was written to error or 
success .csv file.  sdl.log noted the following:

2012-02-02 22:06:04,070 INFO  [CLIDeleteTest] action.OperationInfo 
instantiateAction (OperationInfo.java:62) - Instantiating action for operation: 
hard_delete
2012-02-02 22:06:04,070 FATAL [CLIDeleteTest] action.OperationInfo 
unsupportedInstantiation (OperationInfo.java:75) - Error instantiating 
operation hard_delete: could not instantiate class: null.
2012-02-02 22:06:04,071 FATAL [main] process.ProcessRunner topLevelError 
(ProcessRunner.java:212) - Unable to run process CLIDeleteTest
java.lang.RuntimeException: java.lang.UnsupportedOperationException: Error 
instantiating operation hard_delete: could not instantiate class: null.
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:137)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:75)
    at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:227)
Caused by: java.lang.UnsupportedOperationException: Error instantiating 
operation hard_delete: could not instantiate class: null.
    at com.salesforce.dataloader.action.OperationInfo.unsupportedInstantiation(OperationInfo.java:76)
    at com.salesforce.dataloader.action.OperationInfo.instantiateAction(OperationInfo.java:68)
    at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:104)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:124)
    ... 2 more
Caused by: java.lang.NullPointerException
    at com.salesforce.dataloader.action.OperationInfo.instantiateAction(OperationInfo.java:66)
    ... 4 more


What version of the product are you using? On what operating system?
This was done on Windows 7 Professional, SP 1.  Using CLIq version 2.1.1.


Please provide any additional information below.
Was able to execute soft delete successfully.  All other activities (insert, 
upsert, etc.) work fine.  Only problem is with hard delete.  User used for 
login has Bulk API Hard Delete enabled in profile.

What is the expected output? What do you see instead?
Create default log-conf.xml and write files to cliq/log directory.
This can help with debugging.

Please use labels and text to provide additional information.

What steps will reproduce the problem?
1. Create an export process
2. Run the process
3. The output file will be overwritten.

What is the expected output? What do you see instead?
Create a backup of the export output file.