Convert Infopath Default date to DD-MM-YYYY HH:MM:SS

You can display custom infopath Date Time from Infopath Default date Time.

The IP Fx formula is:

concat(substring(TestDate, 9, 2), "-", substring(TestDate, 6, 2), "-", substring(TestDate, 1, 4), " ", substring(TestDate, 12, 8))

MS SQL Server Connection String

SQl Server Connection String

Sharepoint Event receiver for SP List

Sharepoint Event Viewer and Receiver

Sharepoint 2007 Timer Job Development and Deployment Steps

Sharepoint 2007 Timer Job Create Timer job solution File. 1.Create C# project Library 2.Create Timer.CS, TimerInstaller.CS, Feature.xml, manifest.xml files 3.Copy existing code and past it in the proper files 4.Set strong name 5.Build DLL 6.Copy DLL id in the feature file 7.Build WSP and following deploying procedures. Deployment Timer Jobs: 1. C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES 1.1 Create a folder " KarNet.TimerJob " 1.2 Copy the files "Feature.xml" & "Manifest.xml" 2. Run the install.bat file to deploy the Solution file. 2.2 before that edit the file to point to correct SharePoint site, by changing the "TargetUrl". 2.3 stsadm -o installfeature -name KarNet.TimerJob -force 3. Copy the KarNet.TimerJob.DLL to GAC. 4. Activate the Site Collection feature to enable the custom Timer 5. Restart the Timer Service in services. 6. Create a Folder in C:\ as "KarNetLog" 7. Share the folder and allow "everyone" full access. Activate Feature manually C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o deactivatefeature -name KarNet.TimerJob -url "http://KarNet-46b4a490b" C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o uninstallfeature -name "KarNet.TimerJob" C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o installfeature -name KarNet.TimerJob -force C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o activatefeature -name "KarNet.TimerJob" -url "http://KarNet-46b4a490b " Timer .cs using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; using System.Diagnostics; using Microsoft.SharePoint.Workflow; using System.IO; using Microsoft.SharePoint.Utilities; using System.Collections.Specialized; using System.Text.RegularExpressions; namespace HRction.TimerJob { public class Timer : SPJobDefinition { public Timer() : base() { } [Persisted] private string siteToPerformJob; public Timer(string jobName, SPService service, SPServer server, SPJobLockType targetType) : base(jobName, service, server, targetType) { } public Timer(string jobName, SPWebApplication webApplication, SPSite site) : base(jobName, webApplication, null, SPJobLockType.Job) { this.Title = "HR.TimerJob"; this.siteToPerformJob = site.Url; } public override void Execute(Guid contentDbId) { try { //System.Diagnostics.Debugger.Break(); //System.Diagnostics.Debug.Assert(false); //System.Diagnostics.Debug.WriteLine(SPContext.Current.Site.WebApplication.Name); // get a reference to the current site collection's content database SPWebApplication webApplication = this.Parent as SPWebApplication; //LogMessage("Welcome " + webApplication.Name, EventLogEntryType.Information); //SPContentDatabase contentDb = webApplication.ContentDatabases[contentDbId]; //SPList taskList = contentDb.Sites["FEDemo"].RootWeb.Lists["Tasks"]; // create a new task, set the Title to the current day/time, and update the item //SPListItem newTask = taskList.Items.Add(); //newTask["Title"] = DateTime.Now.ToString(); //newTask.Update(); //int ID = 0; DateTime ActionDate; string IsError = ""; string strWFStatus = ""; string strActionDate = ""; string strItemID = ""; string strDivAction = ""; string strAction = ""; string strWfStarted = ""; string siteURL = ""; string CC = ""; string Body = ""; string TO = ""; string HRction_Mail_Group = ""; string GetHRctionEmail = ""; StringDictionary headers = new StringDictionary(); headers.Add("content-type", "text/html"); if (this.siteToPerformJob != null) { ////siteURL = this.siteToPerformJob + "/wss"; //need to enable for client deployment siteURL = this.siteToPerformJob + "/"; //need to enable for client deployment using (SPSite currentSite = new SPSite(siteURL)) { //LogMessage("SPSite - " + currentSite.Url, EventLogEntryType.Information); currentSite.AllowUnsafeUpdates = true; currentSite.CatchAccessDeniedException = false; using (SPWeb AnetWeb = currentSite.OpenWeb()) { AnetWeb.AllowUnsafeUpdates = true; //LogMessage("AnetWeb - " + AnetWeb.Url, EventLogEntryType.Information); ////SPList BGOperatorReminder = AnetWeb.Lists["BGOperatorReminder"]; SPList ActionList = AnetWeb.Lists["HRList"]; //- for Production foreach (SPListItem item in ActionList.Items) { strItemID = item["ID"].ToString(); LogMessage("Item ID " + item["ID"].ToString(), EventLogEntryType.Information); strActionDate = item["ReminderDate"].ToString().Replace("datetime;#", ""); // For Production ////LogMessage("strActionDate " + strActionDate, EventLogEntryType.Information); ActionDate = Convert.ToDateTime(strActionDate, System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat); //LogMessage("ActionDate " + ActionDate.ToString(), EventLogEntryType.Information); LogMessage("Reminder Date " + ActionDate.AddDays(-1).Date, EventLogEntryType.Information); strDivAction = item["Action"].ToString(); ////LogMessage("strDivAction " + strDivAction, EventLogEntryType.Information); strAction = Regex.Replace(strDivAction, "<[^>]*>", string.Empty); strWFStatus = item["WFStatus"].ToString(); strWfStarted = item["WFStarted"].ToString(); //LogMessage("strAction " + strAction, EventLogEntryType.Information); //LogMessage("Reminder " + item["Reminder"], EventLogEntryType.Information); //LogMessage("Added By " + item["AddedBy"], EventLogEntryType.Information); //LogMessage("WF Status " + item["WFStatus"], EventLogEntryType.Information); //LogMessage("WFStarted " + item["WFStarted"], EventLogEntryType.Information); if (item["Reminder"].ToString() == "True") { if (ActionDate.AddDays(-1).Date == DateTime.Today.Date && item["WFStatus"].ToString() == "Pending") // for Production (&& InFavourOf != "The Controller of Immigration") { if (item["WFStarted"].ToString() == "No") { using (SPSite site = new SPSite(siteURL)) { using (SPWeb web = site.OpenWeb()) { SPGroup gp = web.Groups["HRAction"]; if (gp != null) { foreach (SPUser usr in gp.Users) { if (usr.Name != "System Account") { if (HRAction_Mail_Group == "") HRAction_Mail_Group += usr.Name; else HRAction_Mail_Group += ", " + usr.Name; if (GetHRActionEmail == "") GetHRActionEmail += usr.Email; else GetHRCActionEmail += "," + usr.Email; } } } } } TO = GetHRActionEmail; if (TO.Length > 0) { headers.Add("from", item["FromEmail"].ToString()); Body = Body + "<table dir='ltr' cellspacing='0' designtimesp=23183> <tr designtimesp=23184><td designtimesp=23185> </td></tr>"; Body = Body + "<tr designtimesp=23186><td designtimesp=23187> The HR Competitor Action status as follows:</td></tr>"; Body = Body + "<tr designtimesp=23188><td designtimesp=23189> </td></tr><tr designtimesp=23190><td designtimesp=23191> </td></tr>"; Body = Body + "<table dir='ltr' cellspacing='1' cellspacing='1' border='1' designtimesp=23192><tr designtimesp=23193><th designtimesp=23194> Name</th><th designtimesp=23195> Name</th><th designtimesp=23196> Name </th><th designtimesp=23197>Action</th></tr>"; Body = Body + "<tr designtimesp=23198><td designtimesp=23199><p align='Center' designtimesp=23200>" + item["PropertyName"].ToString() + "</p></td><td designtimesp=23201><p align='Center' designtimesp=23202>" + item["Name"].ToString() + "</p></td><td designtimesp=23203><p align='Center' designtimesp=23204>" + item["AssociateName"].ToString() + "</p></td><td designtimesp=23205><p align='Center' designtimesp=23206>" + strAction + "</p></td></tr></table></td></tr>"; Body = Body + "<tr designtimesp=23207><td designtimesp=23208> </td></tr>"; Body = Body + "<tr designtimesp=23209><td designtimesp=23210> </td></tr><tr designtimesp=23211><td designtimesp=23212> </td></tr><tr designtimesp=23213><td designtimesp=23214>Best regards,</td></tr><tr designtimesp=23215><td designtimesp=23216> Admin Team</td></tr></table>"; //headers.Add("cc", CC); headers.Add("to", item["ToEmail"].ToString()); headers.Add("subject", "HR Status : " + item["AssociateName"].ToString()); SPUtility.SendEmail(AnetWeb, headers, Body); headers.Clear(); item["WFStatus"] = "Completed"; item["WFStarted"] = "Yes"; item.SystemUpdate(); CC = ""; Body = ""; TO = ""; HRAction_Mail_Group = ""; GetHRActionEmail = ""; } } } } } // INITIEAL FOR LOOP CLOSED } // SP WEB IF LOOP CLOSED // item.SystemUpdate(); /// # endregion } // SP SITE URL LOOP CLOSED } // SP TIMER JOB IF LOOP CLOSED //LogMessage("Updated", EventLogEntryType.Information); } // TRY LOOP CLOSED catch (Exception ex) { LogMessage(" Error " + ex.Message + " Trace " + ex.StackTrace, EventLogEntryType.Error); } } // EXCECUTE DB ID LOOP CLOSED protected static string StartWorkflow(SPListItem wfListItem, string workflowName, string SiteURL) { SPWorkflowAssociationCollection wfAssocs = wfListItem.ParentList.WorkflowAssociations; SPWorkflowAssociation activeWorkflowAssoc = null; string errorMessage = string.Empty; foreach (SPWorkflowAssociation wfAssoc in wfAssocs) { if (wfAssoc.Name.Equals(workflowName)) { activeWorkflowAssoc = wfAssoc; break; } } // if the workflow exists, start the workflow SPWorkflow activeWorkflow = null; if (activeWorkflowAssoc != null) { try { using (SPSite currentSite = new SPSite(SiteURL)) { activeWorkflow = currentSite.WorkflowManager.StartWorkflow( wfListItem, activeWorkflowAssoc, "<Data DESIGNTIMESP=23217></Data>"); } } catch (Exception ex) { errorMessage = "error " + ex.Message; } } else { errorMessage = "error No WF Found"; } return errorMessage; } //kcline private static void Log(String logMessage, string LogType, TextWriter w) { w.Write("\r\nLog Type :{0} ", LogType); w.WriteLine("\r\n{0} {1}", DateTime.Now.ToLongTimeString(), DateTime.Now.ToLongDateString()); //w.WriteLine(" :"); w.WriteLine(" - {0}", logMessage); w.WriteLine("-------------------------------"); // Update the underlying file. w.Flush(); } //kcline private void LogMessage(string message, EventLogEntryType type) { string FilePath = "C:\\HR Log"; //SPDiagnosticsService.Local.LogLocation.ToString(); string FileName = ""; bool EndSlash = false; if (FilePath.EndsWith("\\")) EndSlash = true; if (Directory.Exists(FilePath)) { if (EndSlash == false) FileName = FilePath + "\\" + " HR-Timer.log"; else FileName = FilePath + "HR-Timer.log"; string LogType = ""; using (StreamWriter w = File.AppendText(FileName)) { LogType = type.ToString(); Log(message, LogType, w); //ka line// Close the writer and underlying file. w.Close(); } } } } } TimerInstaller.cs using System; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; namespace HRction.TimerJob { class TimerInstaller : SPFeatureReceiver { const string JOB_NAME = "HRAction.Timer"; /// <summary> /// Occurs after a Feature is installed. /// </summary> /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param> public override void FeatureInstalled(SPFeatureReceiverProperties properties) { } /// <summary> /// Occurs when a Feature is uninstalled. /// </summary> /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param> public override void FeatureUninstalling(SPFeatureReceiverProperties properties) { } /// <summary> /// Occurs after a Feature is activated. /// </summary> /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param> public override void FeatureActivated(SPFeatureReceiverProperties properties) { // register the the current web SPSite site = properties.Feature.Parent as SPSite; // make sure the job isn't already registered foreach (SPJobDefinition job in site.WebApplication.JobDefinitions) { if (job.Name == JOB_NAME) job.Delete(); } // install the job Timer AnetTimerFBG = new Timer(JOB_NAME, site.WebApplication, site); SPMinuteSchedule schedule = new SPMinuteSchedule(); schedule.BeginSecond = 0; schedule.EndSecond = 59; schedule.Interval = 5; AnetTimerFBG.Schedule = schedule; //schedule.BeginHour = 12; //schedule.BeginMinute = 30; //AnetTimerFBG.Schedule = schedule; //AnetTimerFBG.Update(); AnetTimerFBG.Update(); } /// <summary> /// Occurs when a Feature is deactivated. /// </summary> /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param> public override void FeatureDeactivating(SPFeatureReceiverProperties properties) { SPSite site = properties.Feature.Parent as SPSite; // delete the job foreach (SPJobDefinition job in site.WebApplication.JobDefinitions) { if (job.Name == JOB_NAME) job.Delete(); } } } } Feature.xml <?xml version="1.0" encoding="utf-8" ?> <Feature xmlns="http://schemas.microsoft.com/sharepoint/" Id="2FAE7079-FD53-4371-81DF-E7A206884AA8" Title="HRction.TimerJob" Description="HR Action TimerJob ." Scope="Site" Hidden="FALSE" Version="1.0.0.0" ReceiverAssembly="HRAction.TimerJob, Version=1.0.0.0, Culture=neutral, PublicKeyToken=52505fa26f9ec918" ReceiverClass="HRction.TimerJob.TimerInstaller"> </Feature> manifest.xml <?xml version="1.0" encoding="utf-8" ?> <!-- Solution created by WSPBuilder. 5/25/2011 8:13:46 PM --> <Solution xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SolutionId="932AE855-EBA7-4c4c-A54A-7FD36415DCF7" ResetWebServer="True" xmlns="http://schemas.microsoft.com/sharepoint/"> <Assemblies> <Assembly Location="HRAction.TimerJob.dll" DeploymentTarget="GlobalAssemblyCache" /> </Assemblies> </Solution>

 

ASP.Net Server side POP UP message box displayed

The below code is working in the server side of the ASP.Net code, You have to modify only the panel name based on you form
System.Web.UI.ScriptManager.RegisterClientScriptBlock(panel1, Page.GetType(), "strscript", "alert('Record Successfully Updated.')", true);

Error: InfoPath cannot load the view... unsupported HTML such as framesThe following HTML tag is not supported:'comment'

It may have a corrupted form.

Infopath forms (in 2007 anyway) are actually just Microsoft CAB files. Youcan rename a form from .xsn to .cab and then open it using any aplicationthat understands cab files.

There are a number of files in each CAB file, but the ones you areinterested in are probably the *.XSL (there is one for each InfoPath "View"plus some extras) and the manifest.xsf file which is like the "table ofcontents".WARNING!!! DANGER WILL ROBINSON!!! etc etcThis isn't for the faint-of-heart, but you did say you were desperate...
You may have to run through a combination of:

1. Renaming the .XSN to .CAB
2. Expanding the .CAB file
3. Hacking either the individual xsl views and/or the manifest.xsf to removethe offending view(s)
4. Repacking the CAB file
5. Renaming back to .XSN
6. Open in Infopath, hope error is gone

This has only happened to me once - I ended up having to delete theoffending view and recreate it. To find out which view was broken, I had todelete each view, reopen, repeat until I found out which of the views wasbroken. Worked for me (we had about 30 very complex views) and saved a wholelot of time.

Repacking the extracted files of infopath back to .xsn

Right-click on the manifest.xsf, select Design, save as xsn.

Populate Dynamic Dropdown values based on Radio button in the Infopath form 2007

The below Dataconnection name is TestConn.Create dataconnection in the Infopath form

the List GUIid is {46A48934-00D5-4914-8EF2-E012AD40343C}

http://star:111/sites/pf/_vti_bin/owssvr.dll?Cmd=Display&List={46A48934-00D5-4914-8EF2-E012AD40343C}&XMLDATA=TRUE&noredirect=true

set the dataconnection in the VSTA code

First write the code in the button changed event
--------------------------------------------------------
XPathNavigator root = MainDataSource.CreateNavigator();
// Get the value for the selected department string Filter = "HC";
// Clear the last selected value in the Months drop-down list box root.SelectSingleNode("//my:Months", NamespaceManager).SetValue("");
// Retrieve the data connection bound to the HC radio button FileQueryConnection con = (FileQueryConnection)DataConnections["TestConn"];
// Change the location of the data connection to point the XML file // returned by the owssvr.dll with a filter on department con.FileLocation = @"http://star:111/sites/pf/_vti_bin/owssvr.dll" + "?Cmd=Display&List={46A48934-00D5-4914-8EF2-E012AD40343C}" + "&XMLDATA=TRUE&FilterField1=FName&FilterValue1=" + Filter;
// Query the data connection to fill the Months drop-down list box with items con.Execute();


---------------------------------------------------
Second write the code in the button changed event
----------------------------------------------------
XPathNavigator root = MainDataSource.CreateNavigator();
// Get the value for the selected department string Filter = "NI";
// Clear the last selected value in the Months drop-down list box root.SelectSingleNode("//my:Months", NamespaceManager).SetValue("");
// Retrieve the data connection bound to the NI radio button FileQueryConnection con = (FileQueryConnection)DataConnections["TestConn"];
// Change the location of the data connection to point the XML file // returned by the owssvr.dll with a filter on department con.FileLocation = @"http://star:111/sites/pf/_vti_bin/owssvr.dll" + "?Cmd=Display&List={46A48934-00D5-4914-8EF2-E012AD40343C}" + "&XMLDATA=TRUE&FilterField1=FName&FilterValue1=" + Filter;
// Query the data connection to fill the Months drop-down list box with items con.Execute();