Right around the time Microsoft introduced .net, I got out of the programming field as a professional. My training basically stopped after VB6. I've been using VB6 and VBA to develop applications that help me in my business. And it works just fine.
Recently, eBay gave me a block of workable Java code that's supposed to let me log on to their server to upload a file programmatically. Unfortunately, I am not trained in Java and cannot make it work, and my VB programming skill in the area of http is pretty rusty. I am hoping that some of the Gurus here can give me a hand in translating the Java script into VB code.
The Java script they gave is for both the production and a testing in their "sandbox". I guess all I need is the production version.
Before we go to the Java script, let me tell you what is supposed to happen when this script is run:
#1. Logon to eBay's server
#2. Upload a token file which I had downloaded from eBay and saved on my local harddrive to identify who I am.
#3. Upload a csv file which was created by my Excel routine and save on my local harddrive.
#4. Receive a confirmation file from eBay about the status of the upload
I know that I may be asking too much, but I know that I can count on some support here.
Thanks in advance.
Alex
The following is the Java script:
/**
* This is a sample *fully functional* commandline test program for uploading files
* in Sandbox or Production environments.
*
* the usage for production:
* java FEClient prod c:\path\to\file\test.csv token_string_for_prod
*
* the usage for sandbox:
* java FEClient sbx c:\path\to\file\test.csv token_string_for_sandbox
*
*/
import java.io.BufferedInputStream;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.InputStreamReader;
import java.i
utputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLConnection;
import java.security.Security;
import javax.net.ssl.HttpsURLConnection;
public class FEClient {
private static final String UPLOAD_URL_SANDBOX = " private static final String UPLOAD_URL_PRODUCTION = " private static final String UPLOAD_URL_QA = " private static final String UPLOAD_URL_DEV = "
/**
* String constant for multipart upload form content boundary
*/
private static final String CONTENT_BOUNDARY =
"-----------------------------BcLtEsToOlBoUnDaRy";
/**
* String constant that represents the HTML response's message start
*/
private static final String RESPONSE_STRING_START =
"<body>";
/**
* String constant represents the end of the HTML response message end
*/
private static final String RESPONSE_STRING_END = ".";
/**
* String constant for production environment
*/
private static final String ENV_PRODUCTION = "prod";
/**
* String constant for sandbox environment
*/
private static final String ENV_SANDBOX = "sbx";
/**
* String constant for qa environment
*/
private static final String ENV_QA = "qa";
/**
* String constant for dev environment
*/
private static final String ENV_DEV = "dev";
// default constructor
FEClient() {
}
/** This method reads in a specified file from the system and
* returns its contents as a string
* @param filename - complete path to file including name
* @return String representing file's contents
*/
protected String readFile(String filename) {
StringBuffer data = new StringBuffer("");
try {
System.out.println("DEBUG: reading file: " + filename);
File file = new File(filename);
FileReader fr = new FileReader(file);
BufferedReader in = new BufferedReader(fr);
int c;
while ((c = in.read()) != -1) {
data.append((char) c);
}
} catch (Exception e) {
e.printStackTrace();
}
return data.toString();
}
/** This method uploads the data content passed in to the url passed
* and passes the token provided as a form parameter.
* @param url - url to post to
* @param token - seller's token
* @param data - content of file
* @return - string status that is parsed from html response
*/
protected String uploadFile(String url, String token, String data) {
System.out.println("DEBUG: Uploading File...");
// stores response from upload post
StringBuffer response = new StringBuffer("");
OutputStream os = null;
BufferedReader in = null;
HttpURLConnection conn = null;
try {
System.out.println("DEBUG: Connecting to: " + url);
URL serverURL = new URL(url);
// connect to server
URLConnection uc = serverURL.openConnection();
conn = (HttpURLConnection) uc;
conn.setAllowUserInteraction(true);
//conn.setFollowRedirects(true);
conn.setInstanceFollowRedirects(true);
// set connection as POST
conn.setRequestMethod("POST");
conn.setDoOutput(true); // turns it into a post
// setup headers
conn.setRequestProperty(
"Content-Type",
"multipart/form-data; boundary=" + CONTENT_BOUNDARY);
conn.setRequestProperty(
"User-Agent",
"BCLUpload Test Tool/1.0 [en] (Java; U)");
conn.setRequestProperty("Accept-Language", "en-us");
conn.setRequestProperty("Accept-Encoding", "gzip, deflate");
conn.setRequestProperty(
"Accept",
"image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, application/pdf, application/x-comet, */*");
conn.setRequestProperty("CACHE-CONTROL", "no-cache");
// get reference to stream to post to
os = conn.getOutputStream();
// constructing data
//System.out.println("DEBUG: file read in was:" + data.toString());
String request =
"--"
+ CONTENT_BOUNDARY
+ "\r\n"
+ "Content-Disposition: form-data; name=\"token\"\r\n\r\n"
+ token
+ "\r\n"
+ "--"
+ CONTENT_BOUNDARY
+ "\r\n"
+ "Content-Disposition: form-data; name=\"file\"; filename=\"data.csv\""
+ "\r\nContent-Type: text/plain\r\n\r\n"
+ data
+ "\r\n"
+ "--"
+ CONTENT_BOUNDARY
+ "\r\n";
System.out.println("DEBUG: Sending the following request:\n\r" + request);
System.out.println("DEBUG: Sending the post request...\n\r");
os.flush();
// performing post
os.write(request.getBytes(), 0, request.getBytes().length);
os.flush();
// getting reference to response stream
in =
new BufferedReader(
new InputStreamReader(conn.getInputStream()));
String inputLine;
// reading respone
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
System.out.println(
"DEBUG: Raw Response was: " + response.toString());
// closing connections
in.close();
in = null;
os.close();
os = null;
conn.disconnect();
conn = null;
} catch (Exception e) {
e.printStackTrace();
} finally {
if (in != null)
try {
in.close();
} catch (Exception e) {
// ok to ignore this
}
if (os != null)
try {
os.close();
} catch (Exception e) {
// ok to ignore this
}
if (conn != null)
try {
conn.disconnect();
} catch (Exception e) {
// ok to ignore this
}
}
// parse and return response
return this.getStatusTextFromResponse(response.toString());
}
/** This method parses the message text from the HTML response.
* @param response - raw html response
* @return String representing message text in HTML response
*/
protected String getStatusTextFromResponse(String response) {
if (response == null || "".equals(response)) {
return response;
}
String status;
// get the index of the start of the message
int start =
response.toString().indexOf(RESPONSE_STRING_START)
+ RESPONSE_STRING_START.length();
// get the end of the message location
int end = response.toString().indexOf(RESPONSE_STRING_END, start);
// set status to substring btw start and end
status = response.substring(start, end);
return status;
}
/** This method sets up the vars needed for uploading
* @param args - args passed to the main program
* @return status returned from upload
*/
protected String executeUpload(String[] args) {
String status;
String env = args[0].toLowerCase();
String filepath = args[1];
String token = args[2];
//
// if you are copying & pasting the token by using the API's then the token
// will NOT be URL encoded. Uncomment this line if the token was obtained through the FE
// web page
// token = URLEncoder.encode(token);
String uploadURL = null;
if (env.equals(ENV_PRODUCTION)) {
// set production url
uploadURL = UPLOAD_URL_PRODUCTION;
} else if (env.equals(ENV_SANDBOX)) {
// set sandbox url
uploadURL = UPLOAD_URL_SANDBOX;
} else if (env.equals(ENV_QA)) {
// set sandbox url
uploadURL = UPLOAD_URL_QA;
} else if (env.equals(ENV_DEV)) {
uploadURL = UPLOAD_URL_DEV;
} else {
// return invalid env message
return "Invalid Environment selected:" + env;
}
// get data from file involved
String data = readFile(filepath);
// upload file
status = this.uploadFile(uploadURL, token, data);
return status;
}
protected void downloadFile(String urlToRead, String fileToWrite) {
OutputStream os = null;
BufferedReader in = null;
HttpsURLConnection conn = null;
try {
System.out.println("DEBUG: Connecting to:" + urlToRead);
URL serverURL = new URL(urlToRead);
conn = (HttpsURLConnection) serverURL.openConnection();
BufferedInputStream is = new BufferedInputStream(conn.getInputStream());
in = new BufferedReader(new InputStreamReader(conn.getInputStream()));
File file = new File(fileToWrite);
os = new FileOutputStream(file);
String inputLine;
while ((inputLine = in.readLine()) != null) {
os.write(inputLine.getBytes());
}
System.out.println("file created:" + fileToWrite);
in.close();
in = null;
os.close();
os = null;
conn.disconnect();
conn = null;
} catch (Exception e) {
e.printStackTrace();
} finally {
if (in != null)
try {
in.close();
} catch (Exception e) {
// ok to ignore this
}
if (os != null)
try {
os.close();
} catch (Exception e) {
// ok to ignore this
}
if (conn != null)
try {
conn.disconnect();
} catch (Exception e) {
// ok to ignore this
}
}
}
public static void main(String[] args) {
try {
// check arg length
if (args.length == 3) {
FEClient feClient = new FEClient();
String status = feClient.executeUpload(args);
System.out.println(
"\n\r\n\r\n\r*****STATUS RETURNED:" + status);
} else {
System.out.println("Invalid number of arguments.");
System.out.println(
"Usage: FEClient [prod|sbx|qa] filepath");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
Recently, eBay gave me a block of workable Java code that's supposed to let me log on to their server to upload a file programmatically. Unfortunately, I am not trained in Java and cannot make it work, and my VB programming skill in the area of http is pretty rusty. I am hoping that some of the Gurus here can give me a hand in translating the Java script into VB code.
The Java script they gave is for both the production and a testing in their "sandbox". I guess all I need is the production version.
Before we go to the Java script, let me tell you what is supposed to happen when this script is run:
#1. Logon to eBay's server
#2. Upload a token file which I had downloaded from eBay and saved on my local harddrive to identify who I am.
#3. Upload a csv file which was created by my Excel routine and save on my local harddrive.
#4. Receive a confirmation file from eBay about the status of the upload
I know that I may be asking too much, but I know that I can count on some support here.
Thanks in advance.
Alex
The following is the Java script:
/**
* This is a sample *fully functional* commandline test program for uploading files
* in Sandbox or Production environments.
*
* the usage for production:
* java FEClient prod c:\path\to\file\test.csv token_string_for_prod
*
* the usage for sandbox:
* java FEClient sbx c:\path\to\file\test.csv token_string_for_sandbox
*
*/
import java.io.BufferedInputStream;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.InputStreamReader;
import java.i
utputStream;import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLConnection;
import java.security.Security;
import javax.net.ssl.HttpsURLConnection;
public class FEClient {
private static final String UPLOAD_URL_SANDBOX = " private static final String UPLOAD_URL_PRODUCTION = " private static final String UPLOAD_URL_QA = " private static final String UPLOAD_URL_DEV = "
/**
* String constant for multipart upload form content boundary
*/
private static final String CONTENT_BOUNDARY =
"-----------------------------BcLtEsToOlBoUnDaRy";
/**
* String constant that represents the HTML response's message start
*/
private static final String RESPONSE_STRING_START =
"<body>";
/**
* String constant represents the end of the HTML response message end
*/
private static final String RESPONSE_STRING_END = ".";
/**
* String constant for production environment
*/
private static final String ENV_PRODUCTION = "prod";
/**
* String constant for sandbox environment
*/
private static final String ENV_SANDBOX = "sbx";
/**
* String constant for qa environment
*/
private static final String ENV_QA = "qa";
/**
* String constant for dev environment
*/
private static final String ENV_DEV = "dev";
// default constructor
FEClient() {
}
/** This method reads in a specified file from the system and
* returns its contents as a string
* @param filename - complete path to file including name
* @return String representing file's contents
*/
protected String readFile(String filename) {
StringBuffer data = new StringBuffer("");
try {
System.out.println("DEBUG: reading file: " + filename);
File file = new File(filename);
FileReader fr = new FileReader(file);
BufferedReader in = new BufferedReader(fr);
int c;
while ((c = in.read()) != -1) {
data.append((char) c);
}
} catch (Exception e) {
e.printStackTrace();
}
return data.toString();
}
/** This method uploads the data content passed in to the url passed
* and passes the token provided as a form parameter.
* @param url - url to post to
* @param token - seller's token
* @param data - content of file
* @return - string status that is parsed from html response
*/
protected String uploadFile(String url, String token, String data) {
System.out.println("DEBUG: Uploading File...");
// stores response from upload post
StringBuffer response = new StringBuffer("");
OutputStream os = null;
BufferedReader in = null;
HttpURLConnection conn = null;
try {
System.out.println("DEBUG: Connecting to: " + url);
URL serverURL = new URL(url);
// connect to server
URLConnection uc = serverURL.openConnection();
conn = (HttpURLConnection) uc;
conn.setAllowUserInteraction(true);
//conn.setFollowRedirects(true);
conn.setInstanceFollowRedirects(true);
// set connection as POST
conn.setRequestMethod("POST");
conn.setDoOutput(true); // turns it into a post
// setup headers
conn.setRequestProperty(
"Content-Type",
"multipart/form-data; boundary=" + CONTENT_BOUNDARY);
conn.setRequestProperty(
"User-Agent",
"BCLUpload Test Tool/1.0 [en] (Java; U)");
conn.setRequestProperty("Accept-Language", "en-us");
conn.setRequestProperty("Accept-Encoding", "gzip, deflate");
conn.setRequestProperty(
"Accept",
"image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, application/pdf, application/x-comet, */*");
conn.setRequestProperty("CACHE-CONTROL", "no-cache");
// get reference to stream to post to
os = conn.getOutputStream();
// constructing data
//System.out.println("DEBUG: file read in was:" + data.toString());
String request =
"--"
+ CONTENT_BOUNDARY
+ "\r\n"
+ "Content-Disposition: form-data; name=\"token\"\r\n\r\n"
+ token
+ "\r\n"
+ "--"
+ CONTENT_BOUNDARY
+ "\r\n"
+ "Content-Disposition: form-data; name=\"file\"; filename=\"data.csv\""
+ "\r\nContent-Type: text/plain\r\n\r\n"
+ data
+ "\r\n"
+ "--"
+ CONTENT_BOUNDARY
+ "\r\n";
System.out.println("DEBUG: Sending the following request:\n\r" + request);
System.out.println("DEBUG: Sending the post request...\n\r");
os.flush();
// performing post
os.write(request.getBytes(), 0, request.getBytes().length);
os.flush();
// getting reference to response stream
in =
new BufferedReader(
new InputStreamReader(conn.getInputStream()));
String inputLine;
// reading respone
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
System.out.println(
"DEBUG: Raw Response was: " + response.toString());
// closing connections
in.close();
in = null;
os.close();
os = null;
conn.disconnect();
conn = null;
} catch (Exception e) {
e.printStackTrace();
} finally {
if (in != null)
try {
in.close();
} catch (Exception e) {
// ok to ignore this
}
if (os != null)
try {
os.close();
} catch (Exception e) {
// ok to ignore this
}
if (conn != null)
try {
conn.disconnect();
} catch (Exception e) {
// ok to ignore this
}
}
// parse and return response
return this.getStatusTextFromResponse(response.toString());
}
/** This method parses the message text from the HTML response.
* @param response - raw html response
* @return String representing message text in HTML response
*/
protected String getStatusTextFromResponse(String response) {
if (response == null || "".equals(response)) {
return response;
}
String status;
// get the index of the start of the message
int start =
response.toString().indexOf(RESPONSE_STRING_START)
+ RESPONSE_STRING_START.length();
// get the end of the message location
int end = response.toString().indexOf(RESPONSE_STRING_END, start);
// set status to substring btw start and end
status = response.substring(start, end);
return status;
}
/** This method sets up the vars needed for uploading
* @param args - args passed to the main program
* @return status returned from upload
*/
protected String executeUpload(String[] args) {
String status;
String env = args[0].toLowerCase();
String filepath = args[1];
String token = args[2];
//
// if you are copying & pasting the token by using the API's then the token
// will NOT be URL encoded. Uncomment this line if the token was obtained through the FE
// web page
// token = URLEncoder.encode(token);
String uploadURL = null;
if (env.equals(ENV_PRODUCTION)) {
// set production url
uploadURL = UPLOAD_URL_PRODUCTION;
} else if (env.equals(ENV_SANDBOX)) {
// set sandbox url
uploadURL = UPLOAD_URL_SANDBOX;
} else if (env.equals(ENV_QA)) {
// set sandbox url
uploadURL = UPLOAD_URL_QA;
} else if (env.equals(ENV_DEV)) {
uploadURL = UPLOAD_URL_DEV;
} else {
// return invalid env message
return "Invalid Environment selected:" + env;
}
// get data from file involved
String data = readFile(filepath);
// upload file
status = this.uploadFile(uploadURL, token, data);
return status;
}
protected void downloadFile(String urlToRead, String fileToWrite) {
OutputStream os = null;
BufferedReader in = null;
HttpsURLConnection conn = null;
try {
System.out.println("DEBUG: Connecting to:" + urlToRead);
URL serverURL = new URL(urlToRead);
conn = (HttpsURLConnection) serverURL.openConnection();
BufferedInputStream is = new BufferedInputStream(conn.getInputStream());
in = new BufferedReader(new InputStreamReader(conn.getInputStream()));
File file = new File(fileToWrite);
os = new FileOutputStream(file);
String inputLine;
while ((inputLine = in.readLine()) != null) {
os.write(inputLine.getBytes());
}
System.out.println("file created:" + fileToWrite);
in.close();
in = null;
os.close();
os = null;
conn.disconnect();
conn = null;
} catch (Exception e) {
e.printStackTrace();
} finally {
if (in != null)
try {
in.close();
} catch (Exception e) {
// ok to ignore this
}
if (os != null)
try {
os.close();
} catch (Exception e) {
// ok to ignore this
}
if (conn != null)
try {
conn.disconnect();
} catch (Exception e) {
// ok to ignore this
}
}
}
public static void main(String[] args) {
try {
// check arg length
if (args.length == 3) {
FEClient feClient = new FEClient();
String status = feClient.executeUpload(args);
System.out.println(
"\n\r\n\r\n\r*****STATUS RETURNED:" + status);
} else {
System.out.println("Invalid number of arguments.");
System.out.println(
"Usage: FEClient [prod|sbx|qa] filepath");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
