This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
Thursday, July 29, 2010
Facebook Like button in asp.net C# code behind
Multiple row Select on JD Edwards Application Form
Multiple row Select on JD Edwards Application Form
Right click on form->Properties->Advance->click on checkbox Multiple Select->OK
RE: livecam
skytt pwsquvsqj xlrc ogtin imohjnfezil oplzccadpskf yykqoqofyve usqvlorsnzfl cptdqto iddudkgxqt hzyqgkgb utetytzvrzv wvsztoxap uejlzwjmjp
RE: action
xjurqewunt jjdudb geilcl cunyouaethzz ayxouobz bnxo hfksbuuqfc kexjl sahyyl urneff kzousvny uwkfpmir
Hotmail: Trusted email with powerful SPAM protection. Sign up now.
Monday, July 26, 2010
JD Edwards EnterpriseOne and Salesforce integration - Simple Steps
JD Edwards EnterpriseONE and Salesforce integration
Recently I create an application on web using asp.net C# to integrate JD Edwards EnterpriseOne (8.10/8.12/9.0) and salesforce, in this application I am uploading sales leads generated by our affiliate. Our affiliate entering sales leads in salesforce and my company wants to generate invoice from JD Edwards , So I created an online application so that anyone can use this application to upload data in JD Edwards from anywhere using internet by a single click.
We can also schedule this application to run in a particular time or run every night or weekly.
Technical Details:-
I did following steps in order to achieve this:-
1. Create a web-application using Salesforce api,C# to download Data in a sql-server table.
2. Check if all address# exist in JD Edwards, If not create a report, so that user can enter manually. I can automate this step by using address book z-file upload method but my company wants to create addresses manually.
3. Created a JD Edwards UBE report program to upload data in F47011/F47012 files and to run R47011 UBE.
4. Using RUNUBE command from webpage, to run R5542334 and R47011 to load data in F47011/F47012 and sales tables F4211/F4201.
5. Our sales team verifying these sales and creating invoices and also doing sales update.
If you want this process for your company or you have any questions please send email at dostind@hotmail.com .
Friday, July 23, 2010
Thursday, July 22, 2010
An unknown JAS sign in error occurred. Please contact the System Administrator. JD Edwards EnterpriseOne 9.0 Demo web server error
An unknown JAS sign in error occurred. Please contact the System Administrator.
Verify you have sqljdbc.jar file in C:\E900\system\OC4J\j2ee\home\lib. If you don't have it, please copy this jar file from the downloaded:
C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu
Test to make sure this works.
If Not run this
C:\E9Standalone\TEMP\ThirdParty\WebDevFeature\OH4A1013_setup.exe
But
You have to run this "OH4A1013_setup.exe" after copying the sqljdbc.jar file to C:\E9Standalone\TEMP\ThirdParty\WebDevFeature\JDBC directory.
Wednesday, July 21, 2010
Thursday, July 15, 2010
JD Edwards EnterpriseOne 9.0 Web server could not found Error
OracleJSP: oracle.jsp.provider.JspCompileException:
Errors compiling:C:\E900\system\OC4J\j2ee\home\application-deployments\webclient\webclient\persistence\_pages\_share\_html4login.java
Registry key 'Software\JavaSoft\Java Runtime Environment\CurrentVersion'
has value '1.6', but '1.5' is required.
Error: could not find java.dll
Error: could not find Java 2 Runtime Environment.
Wednesday, July 7, 2010
How to API key in web.config C#
web.config.
<
add key="APIKey" value="xxxxx" /><
add key="username" value="xxxxx" /><
add key="password" value="xxxxxx" />
{
HttpServerUtility Server = HttpContext.Current.Server;
// Reading a key
String Version = ConfigurationManager.AppSettings["ttttt"]; // Writing a key ExeConfigurationFileMap FileMap = new ExeConfigurationFileMap();FileMap.ExeConfigFilename = Server.MapPath(
@"~\Web.config"); Configuration Config = ConfigurationManager.OpenMappedExeConfiguration(FileMap, ConfigurationUserLevel.None);Config.AppSettings.Settings.Add(
"APIKey", "xxxxxxxxxx");Config.AppSettings.Settings.Add(
"username", "xxxxxx");Config.AppSettings.Settings.Add(
"password", "xxxxxxx");Config.Save(
ConfigurationSaveMode.Modified);}
JD Edwards EnterpriseOne 9.0 Standalone Demo $Oracle version$ | JDE Source
Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. See how.
ConstantContact API webservice Sample
Technology used: C# , asp.net 2.0
In this sample I am uploading first name, last name and email address to constant contact all mailing list.
1. From http://developer.constantcontact.com/license/login you can get api keys.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div style="margin-left: 30px; margin-top: 10px">
</div>
<table style="margin-top: 10px; vertical-align: top">
<tr>
<td style="padding-left: 25px; width: 480px; height: 457px;">
<table style="border-right: green thin solid; border-top: green thin solid; border-left: green thin solid;
border-bottom: green thin solid;">
<tr>
<td style="width: 200px">
<asp:Label ID="lblEmail" runat="server" Font-Bold="True" Font-Italic="False" Font-Names="Calibri"
Font-Overline="False" Font-Size="11pt" Font-Strikeout="False" Font-Underline="False"
Text="Email Address:"></asp:Label>
</td>
<td align="right">
<asp:TextBox ID="txtEmail" runat="server" Font-Names="Calibri" Font-Size="11pt" Width="254px"
MaxLength="50" TabIndex="1"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblFirst" runat="server" Font-Bold="True" Font-Italic="False" Font-Names="Calibri"
Font-Overline="False" Font-Size="11pt" Font-Strikeout="False" Font-Underline="False"
Text="First Name:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtFirst" runat="server" Font-Names="Calibri" Font-Size="11pt" Width="254px"
MaxLength="50" TabIndex="2"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblLast" runat="server" Font-Bold="True" Font-Italic="False" Font-Names="Calibri"
Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Text="Last Name:"
Font-Size="11pt"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtLast" runat="server" Font-Names="Calibri" Font-Size="11pt" Width="254px"
MaxLength="50" TabIndex="3"></asp:TextBox>
</td>
</tr>
</table>
</td>
<td style="height: 457px">
<div>
<div style="text-align: center">
<table>
<tr>
<td align="center">
<asp:Label ID="lblContactList" runat="server" Font-Bold="True" Font-Names="Calibri"
Font-Size="11pt" Width="416px" Text="Please select the areas of interest for which you would like to receive occasional email from us."></asp:Label>
</td>
</tr>
</table>
</div>
<asp:Panel ID="contactListsPanel" runat="server" BackColor="White" BorderColor="Green"
BorderWidth="1px" Height="39px" Width="117px" ScrollBars="Both">
<asp:CheckBoxList ID="chkListContactLists" runat="server" Width="300px" DataTextField="Name"
DataValueField="Id" CellSpacing="5" Font-Names="Calibri" Font-Size="11pt">
</asp:CheckBoxList>
</asp:Panel>
</div>
</td>
</tr>
<tr>
<td style="padding-left: 25px; width: 480px; height: 53px;">
<table>
<tr>
<td>
<asp:Button ID="btnAdd" runat="server" Text="Add Contact" OnClick="btnAdd_Click"
Font-Names="Calibri" Font-Size="11pt" />
<asp:CustomValidator ID="customValidator" runat="server" Display="None" OnServerValidate="customValidator_ServerValidate">
</asp:CustomValidator>
</td>
</tr>
</table>
</td>
<td style="height: 53px">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</td>
</tr>
</table>
</form>
</body>
</html>
code behind
using System;
using System.Collections.Generic;
using System.Data;
using System.Globalization;
using System.Text;
using System.Web.UI;
using System.Web.UI.WebControls;
using ConstantContactBO;
using ConstantContactUtility;
using UploadContactForm.App_Code;
public partial class Default3 : System.Web.UI.Page
{
private AuthenticationData AuthenticationData
{
get
{
if (Session["AuthenticationData"] == null)
{
Session.Add("AuthenticationData", ConstantContact.AuthenticationData);
}
return (AuthenticationData)Session["AuthenticationData"];
}
}
private List<ContactList> List
{
get { return (List<ContactList>)ViewState["contactList"]; }
set { ViewState["contactList"] = value; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
if (Session["NewContactEmailAddress"] != null)
{
// initialize the E-mail Address text box
txtEmail.Text = (string)Session["NewContactEmailAddress"];
Session.Remove("NewContactEmailAddress");
}
// get user Contact List collection
List = ConstantContact.GetUserContactListCollection(ClientScript);
chkListContactLists.DataSource = List;
chkListContactLists.DataBind();
for (int i = 0; i < chkListContactLists.Items.Count; i++)
{
chkListContactLists.Items[i].Selected = true;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
string[] emailAddress = new string[] { txtEmail.Text.Trim() };
try
{
string nextChunkId;
IList
if (list.Count == 0)
{
// create new Contact
Contact contact = GetContactInformation();
Utility.CreateNewContact(AuthenticationData, contact);
// Response.Redirect("~/AddContactConfirmation.aspx");
Label1.Text = "Added";
}
else
{
throw new ConstantException(String.Format(CultureInfo.CurrentCulture,
"Email address \"{0}\" is already a contact", txtEmail.Text.Trim()));
}
}
catch (ConstantException ce)
{
#region display alert message
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"");
ClientScript.RegisterStartupScript(typeof(Page), "AlertMessage", stringBuilder.ToString());
#endregion
}
}
protected void customValidator_ServerValidate(object source, ServerValidateEventArgs args)
{
string errorMessage = string.Empty;
if (string.IsNullOrEmpty(txtEmail.Text.Trim()))
{
errorMessage = "Please enter the contact email address.";
args.IsValid = false;
}
if (args.IsValid && !Utility.IsEmail(txtEmail.Text.Trim()))
{
errorMessage = "Please enter a valid contact email address.";
args.IsValid = false;
}
if (args.IsValid)
{
bool selected = true;
foreach (ListItem item in chkListContactLists.Items)
{
if (item.Selected)
{
selected = true;
}
}
if (!selected)
{
errorMessage = "Please select the list to which your contact will be added.";
}
args.IsValid = selected;
}
}
private Contact GetContactInformation()
{
Contact contact = new Contact();
contact.EmailAddress = Server.HtmlEncode(txtEmail.Text.Trim());
contact.FirstName = Server.HtmlEncode(txtFirst.Text.Trim());
contact.LastName = Server.HtmlEncode(txtLast.Text.Trim());
foreach (ListItem item in chkListContactLists.Items)
{
if (!item.Selected) continue;
ContactOptInList contactOptInList = new ContactOptInList();
contactOptInList.ContactList = new ContactList(item.Value);
contact.ContactLists.Add(contactOptInList);
}
return contact;
}
}
add api information in web.config
Building a Store Locator ASP.NET Application Using Google Maps API - Scott On Writing.NET
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. Get busy.