DEV Community: Anjan Kant

How to Export Roundcube Contacts to Outlook?

Anjan Kant — Thu, 08 Apr 2021 06:26:34 +0000

Learn How to Export Roundcube Contacts to Outlook

Roundcube is one of the three webmail applications provided by the cPanel. Webmail is a web-based service that enables its users to access their emails, contacts, calendars, and other items by simply using a web browser. You only have to log into your webmail account to read/send emails. When you access your data using webmail, you are directly interacting with the server that has your information stored. Needless to say, you are free to use any browser to access your webmail account without being location bound with the help of a stable internet connection.

To access your data, you must be able to use the website of the email providers. Webmails are of the utmost importance when you urgently need to access your data items from your email account in some other computer device without configuring it. In other words, webmail allows you to access your email account with absolutely zero configurations.

Roundcube webmail client provides only one export option and that is vCard. A vCard (VCF) is a virtual business card file that is the standard file for sharing contact files. It stores all contact information such as personal data, phone number, name, contact image, FAX, email address, etc.

How to Export Roundcube Contacts to Outlook?
As already stated, Roundcube only offers exporting files in vCard but unfortunately, Outlook does not accept it. Therefore, you need to convert this VCF file to PST to import it into MS Outlook. To import vCard contacts to Outlook, you need to install a third-party tool.

Let's first learn how to Export vCard File from Roundcube:

Log into your Webmail account, you can use the following methods to enter the cPanel site:

https://domain.com:2096
servername.com/webmail
The account’s IP Address/webmail
domain.com/webmail
servername.com:2096
your account’s IP Address:2096

You will be taken to the Webmail interface. If it prompts you to select the service, then click on Roundcube.
After you have reached the homepage of the account, click on Contacts from the top menu.

Export Roundcube Contacts to Outlook Step 1

Your complete address book will display. From the Groups section, choose the address book you want to export.

Export Roundcube Contacts to Outlook Step 2

Now, click on the Export button and your entire list will export in VCF format.

But, remember MS Outlook does not support vCard format? So, your next step is to convert it into an acceptable format and that is a PST file. Want to know how? Keep

Steps to Export Roundcube Contacts to Outlook
Step #1
Download the PCVITA vCard Importer tool and install it. Now, launch the application.

Export Roundcube Contacts to Outlook Step 3
Step #2
Click on Add File or Folder. Now, select and load the VCF file(s) or folder in the software.

Export Roundcube Contacts to Outlook Step 4
Step #3
Next, preview and choose the file you want to convert and click on Export. If you want to convert only a selected number of files, then click on "Export Selected".

Export Roundcube Contacts to Outlook Step 5
Step #4
After that, select the Export type. You can choose to save the contacts in an existing PST file, a new PST file, or a default MS Outlook profile. Provide a destination to save and click on the Export button.

Export Roundcube Contacts to Outlook Step 6
Now you are required to import them to your Outlook account.
Launch Outlook, click on File
Click on Open & Export > Import/Export
Choose Import from another program or file > Next
Select CSV option > Next
Browse the file to import & select the folder to move it in
At last, match the custom contact fields.

Done! You have completed the process to convert contacts from one platform to another.

Manual Method to Export Roundcube Contacts to Outlook:
You can complete this process manually as well but no manual method wins over professional software. There are always some limitations associated with the manual procedure. Export contacts from Roundcube in the exact way as mentioned above. Then, follow the following steps.

Go to the Contacts folder (C:\ Users\ Admin\ Contacts)
Click on the Export button from the top menu
Select CSV (Comma Separated Values) >> Export
Provide a destination to save this CSV file >> Next >> Finish.

After this, follow the steps stated above to know how you can further move them into your Outlook.

The process is complete.

Conclusion:
In this blog, you learned methods to export Roundcube contacts to Outlook. We explained all the limitations as well as provided the best possible solution to execute this task. Users can use any of the above-mentioned methods to import contacts into Outlook 2019, 2016, 2013, 2010, all other versions.

What is new in .net Core 3.0?

Anjan Kant — Fri, 02 Apr 2021 11:17:25 +0000

Presentation

Our past article was on What Is New In ASP.NET Core 2.0 and we additionally talked about what is HAP and how could it be helpful! Here, in this blog, we will see the new story of the incredible monster for the PC world which is the .NET that improve on the assignment of creating cross-stage applications. Microsoft has as of late declared about sharing their arrangements of .NET Core 3.0 and hence, it is significant for us to realize What is new in .NET Core 3.0. The form 2.1 of the .NET is prepared for the delivery this year that offers a more noteworthy mix of instruments and highlights however to add greater energy to it, Microsoft has begun to lay streets for the advancement of .NET Core 3.0 and are hoping to deliver it in 2019. The intriguing part is that includes that were mentioned by the individual engineers and coding aficionados have been carried out.

Going Big! Support for Windows Desktop Apps
One of the most exciting and impressive features that the team from Microsoft has planned is to provide support for the Windows Desktop applications and will span those especially such as UWP XAML, Windows Presentation Framework(WPF) and Windows Forms. Thus, it is a great opportunity for you as a developer to unleash your app developing skills to a higher level as you would be able to run any window desktop app regardless of it being old or new. This feature is in addition to those that are already present with the benefits that .NET Core has already got. The idea to give support came into the picture after the Microsoft has received numerous requests for the feature. Hence, its a delight for the desktop app lovers as this is a bonus to their interests. It has to be noted that, the other features such as that of web and cloud will still continue to exist as it used to be earlier, with the change being is the addition of desktop applications support.
Easy Conversion of existing Desktop Applications
Given the details of the information that there are some new features in .net core 3.0, any professional would be interested in converting their present applications to the system that uses the .NET core 3.0. Usually, developers face many troubles in moving the existing application to other technologies especially if the application size is big. It is such a painful task for them, but the process isn't hectic in the case of .NET Core 3.0. Surprisingly the entire procedure is rather made simple and straightforward. All that is required of you to do is to set the target of your existing desktop application as .NET Core 3.0 and compile the files again. You needn't set target for the dependencies but doing so would carry some benefits. One good example of this easy process is the story of conversion of the popular MS Paint application. The .NET team didn't have the source code of Paint within their reach but were able to get the binaries of the Paint.NET that were working based on the .NET Core. They used the WPF binaries that were available in the .NET directory which was present on their machine in the lab as they were not having the WPF special build. The paint, to their surprise was working very well and that too it reported a faster start-up without any optimization work being done on it. Apart from this, the .NET team had a heavy breath after they were able to find out the tricky bug that existed in .NET Core and have fixed it. Apart from this, there has been an attempt to make the EF6 work on .NET Core 3.0 by updating it. The EF Core is expected to come equipped with few new features. New applications regardless of what type they are, the EF Core remains to be the data stack that would be recommended highly. Those developers who are willing to take the advantages and extra benefits, it is advised from Microsoft to port to the new EPF Core for the projects.

Made it Simple Deployments
One could conclude easily that there is a lot of flexibility offered in deploying the project to suit the newly installed .NET Core 3.0. You are given the ability to do the central installation and service the application with its benefits. The good thing here is these don't require any in-place updates. For the subsequent versions release of .NET Core, apps could be updated in a pattern by doing it on one system after the other. These steps are accompanied by a guarantee that they won't affect any other apps. The above said deployment is of one variety which can be termed as Side-by-side deployment. You can also deploy your application updates yet in another way where you are in need of maximum isolation. The Microsoft is striving hard to deliver a new build tool that can enable you to bundle the app and .NET Core into a single exe(Executable) file.
Updating Project Files: A new approach
The adoption of SDK-style for projects for .NET core 3.0 has given a lot of improvements in various dimensions. NuGet packages are thereafter referenced using PackageReference, which is one of the key aspects of projects that are following SDK style. Project files result in smaller and cleaner versions when SDK is the approach. The advantage of support to multi-targeting is leveraged with this style. The packages.config is replaced by the PackageReference. This change helps a developer to refer the entire component area which is a total contrast to the earlier facility where only one single assembly could be referenced at once.
Closing Notes
The team from Microsoft are working hard to plan for few early releases of the .NET Core 3.0 so that they would have the measure of the quality with the help of user feedback. In addition to it, they have been conducting surveys to get a bigger picture of what more the users are willing to have in the latest version. Finally, the staff claims that there isn't any kind of big architectural changes in the newer version though!

How can we export datatable to PDF using iTextSharp

Anjan Kant — Fri, 02 Apr 2021 11:15:31 +0000

I have illustrated below with example how can we export data table to PDF using iTextSharp

Step 1. We can download itextsharp.dll from the website http://sourceforge.net/projects/itextsharp/
Step 2. Please click on add exiting item to add iTextSharp.dll in the "Bin" folder.
Step 3. In the next step of export data table to PDF using iTextSharp, put downloaded iTextSharp.dll in the project folder structure to add reference of the iTextSharp.dll in the application.
Step 4. You may check now that dll reference have been added in your application.
Step 5. Now I have provided below c# code snippet for How can we export datatable to PDF using iTextSharp as given below:

protected void btnPDF_Click(object sender, ImageClickEventArgs e)
{
DataTable dtn = new DataTable();
dtn = GetDataTable();
dtPDF = dtn.Copy();
for (int i = 0; i <= dtn.Rows.Count - 1; i++)
{
ExportToPdf(dtPDF);
}
}

public void ExportToPdf(DataTable myDataTable)
{
Document pdfDoc = new Document(PageSize.A4, 10, 10, 10, 10);
try
{
PdfWriter.GetInstance(pdfDoc, System.Web.HttpContext.Current.Response.OutputStream);
pdfDoc.Open();
Chunk c = new Chunk("" + System.Web.HttpContext.Current.Session["CompanyName"] + "", FontFactory.GetFont("Verdana", 11));
Paragraph p = new Paragraph();
p.Alignment = Element.ALIGN_CENTER;
p.Add(c);
pdfDoc.Add(p);
string clientLogo = Server.MapPath(".") + "/logo/tpglogo.jpg";
string imageFilePath = Server.MapPath(".") + "/logo/tpglogo.jpg";
iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageFilePath);
//Resize image depend upon your need

jpg.ScaleToFit(80f, 60f);
//Give space before image

jpg.SpacingBefore = 0f;
//Give some space after the image

jpg.SpacingAfter = 1f;
jpg.Alignment = Element.HEADER;
pdfDoc.Add(jpg);
Font font8 = FontFactory.GetFont("ARIAL", 7);
DataTable dt = myDataTable;
if (dt != null)
{
//Craete instance of the pdf table and set the number of column in that table

PdfPTable PdfTable = new PdfPTable(dt.Columns.Count);
PdfPCell PdfPCell = null;
for (int rows = 0; rows < dt.Rows.Count; rows++)
{
for (int column = 0; column < dt.Columns.Count; column++)
{
PdfPCell = new PdfPCell(new Phrase(new Chunk(dt.Rows[rows][column].ToString(), font8)));
PdfTable.AddCell(PdfPCell);
}
}
//PdfTable.SpacingBefore = 15f; // Give some space after the text or it may overlap the table

pdfDoc.Add(PdfTable); // add pdf table to the document

}
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment; filename= SampleExport.pdf");
System.Web.HttpContext.Current.Response.Write(pdfDoc);
Response.Flush();
Response.End();
//HttpContext.Current.ApplicationInstance.CompleteRequest();

}
catch (DocumentException de)
{
System.Web.HttpContext.Current.Response.Write(de.Message);
}
catch (IOException ioEx)
{
System.Web.HttpContext.Current.Response.Write(ioEx.Message);
}
catch (Exception ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message);
}
}

How to Add SSL Certificate?

Anjan Kant — Fri, 02 Apr 2021 11:00:37 +0000

Here you discover splendid 10 stages how to add SSL declaration through IIS (Internet Information Service). Assume, we don't have board to send our application empowered with SSL then we need IIS complete information to deeply our application with SS authentication.

Step 1: Open your IIS (Internet Information Services) from start windows or with hotkeys (ctrl + R then type inetmgr).
Step 2: On the home you will see features of IIS (Internet Information Services) then click on the “Server Certificates”, you are now in server certifcates menu.
Step 3: Now click on right side pane Under “Actions”, click on “Create Self Signed certificate”, now you will pop up a new window “Specify Friendly Name”. Type your desired name here and click on “OK” button.
Step 4: Now you will see “Website4” certificate is now listing in certificate lists.
Step 5: Now go to your “Sites” and click on specific website for which do you need to install certificate. Now click on “Edit Bindings…”.
Step 6: Now click on “Add” button to add signed certificate to your website.
Step 7: Now you are on “Add Site Binding” windows, here you have to select type “https” & enter IP Address & also defined Port no for your respective website, now at the end on “SSL Certificate”, set your certificate which is created in our earlier steps.
Step 8: Here you can see your certificate click on certificate.
Step 9: Here you can see your website “Site Bindings”, now you can click on “Browse” button and it will navigate to view your website in browser explorer.
Step 10: Here you can see that your web address has included “https”. Now SSL certificate has been installed successfully in your website.
Above key steps will help to work out on how to add SSL Certificate.

How to Add FTP Site in IIS?

Anjan Kant — Fri, 02 Apr 2021 10:55:43 +0000

Now find the complete process of Add FTP Site in IIS.

Step 1
Open your Control board, presently find "Uninstall or change a program" highlight. Snap on left sheet "Turn Windows includes on or off". Presently grow "Web Information Services". Presently grow "FTP Server" and check all under this hub.

Step 2
Open your IIS (Internet Information Services) through shortcut key (Ctrl + R then type “intermgr”). Now right click on “Sites” then click on property “Add FTP Site…”.

Step 3
Now a popup window "Add FTP Site" will open "Webpage Information", type "FTP website name" at that point click on "Actual way", select your site to transfer, at that point click on "next" catch to follow subsequent stages.

Step 4
Now on next window, a new window “Authentication and Authorization Information” will open, here you can tick check boxes for “Authentication” i.e. Anonymous, Basic. Now drill down “Authorization” allows access to specific user. You can provide access to all users, anonymous users but it is highly recommended “Specific users” due to security reason.

Step 5
In this window, user name is entered “ftp_user” to allow upload website stuff.

Step 6
Now you are on “Binding and SSL Settings” where you can enter your IP address, Port No etc.

Step 7
Now you can provide security concerns Read, Write, Read & Execute, Modify, Full Control etc.

Step 8
Now you can enter your IP address (host name), User name and password. In this window, you can see that website directory is displayed when you entering correct (host name, user name & password) login detail to access website stuff.

Find the complete video of How to Add FTP Site in IIS now. Just visit the site

HAP: What is HTML Agility Pack C#?

Anjan Kant — Fri, 02 Apr 2021 10:47:57 +0000

Being an eager C# developer, it may intrigue you a ton to extend a similar coding language into the universe of web programming yet it is very chaotic to do everything without any preparation. In such sort of examples, there are a few offices from advances to facilitate your work and one of them is the HTML Agility Pack. Subsequently, it would be ideal and important to realize what is HTML deftness pack or what is HTML Agility pack C# as this is an incredible apparatus that would prove to be useful to utilize.

HTML Agility Pack: Preface
In a web programming arena, the development work is divided into the server-side and client-side. On the client-side, there are things such as HTML, CSS, Javascript, and others while on the server side there are many options such as PHP, Java, C#, and Python. C# combined with ASP.NET framework has been vividly used by many large scale and medium scale organizations on the server side.

HTML Agility pack C#: Your Coding Friend
After the preamble, now exactly what is HTML agility pack and why it is used? Many times, it becomes a requirement to read or what is technically called as parse an HTML document where the source could be a file, or a string or another web source. Thus, what is HTML agility pack c# is that it is one of the .NET libraries that gives the C# developer to read and write the DOM (Document Object Model) and has explicit support for plain XPath or XSLT and the bonus is, you don't even have to know about these terminologies? The library is so forgiving that it won't trouble much with its functionality even if the source of HTML is malformed in standards. Thus, it's the best choice to rely on this library instead of writing up the parsing code all by yourself.

How can we export datatable to PDF using iTextSharp

Anjan Kant — Thu, 01 Apr 2021 04:20:57 +0000

Introduction
I have illustrated below with example how can we export data table to PDF using iTextSharp

Step 1. We can download itextsharp.dll from the website http://sourceforge.net/projects/itextsharp/
Step 2. Please click on add exiting item to add iTextSharp.dll in the "Bin" folder.
Step 3. In the next step, put downloaded iTextSharp.dll in the project folder structure to add reference of the iTextSharp.dll in the application.
Step 4. You may check now that dll reference have been added in your application.
Step 5. Now I have provided below c# code snippet as given below:

New Features: What is new in .net Core 3.0

Anjan Kant — Thu, 01 Apr 2021 04:18:37 +0000

Introduction
Our previous article was on What Is New In ASP.NET Core 2.0 and we also discussed what is HAP and how is it useful! Here, in this blog, we are going to see the new tale of the powerful beast for the computer world which is the .NET that simplify the task of developing cross-platform applications. Microsoft has recently announced about sharing their plans of .NET Core 3.0 and therefore, it is important for us to know What is new in .NET Core 3.0. The version 2.1 of the .NET is ready for the release this year that offers a greater blend of tools and features but to add more excitement to it, Microsoft has started to lay roads for the development of .NET Core 3.0 and are expecting to release it in 2019. The interesting part is that features that were requested by the individual developers and coding enthusiasts have been implemented.

SQL Server Installation Fix: Repair a Failed SQL Server 2016 Installation

Anjan Kant — Thu, 01 Apr 2021 04:14:14 +0000

Introduction
SQL Server 2016 is a recently released version of Microsoft’s popular database platform that is developed with inbuilt advanced analytic and higher security technology. It targets all the critical applications and deeper insights in your data across on-premises and cloud. Here are few tips to handle the installation process to avoid the failure along with the method to repair the failed SQL Server 2016 Installation.
Scenarios when SQL server 2016 installation failed and need repair operation
When an instance of SQL Server got corrupted after successful installation and you need to repair that particular instance only.
When you need to repair a particular instance of SQL Server in case the upgrade operation is cancelled or failed after the instance name is mapped to the newly-upgraded instance.
If the following message appears in summary log, you need to repair the failed upgrade instance:
Error message: "SQL Server upgrade failed. To continue, investigate the reason for the failure, correct the problem, and then repair your installation."
In case the following message appears in the summary log, you need to uninstall and reinstall SQL Server, as you will not be able to repair the SQL Server instance.
Error Message:"SQL Server upgrade failed. To continue, investigate the reason for the failure, correct the problem."
When you repair an instance of SQL Server all the missing or corrupt files, registry keys are replaced with the new ones and all missing or invalid configuration values are set to their default values.
Note: Before initiating SQL Server failover clusters, remember that the repair process must be run on individual cluster nodes only. To repair a failover cluster node after a failed prepare operation, use Remove node and then continue performing the Prepare step again.
Repair steps when SQL Server installation get failed from the Installation Center
Run the SQL Server Setup application (setup.exe) from SQL Server installation media.
When you are done with prerequisites and system verification, you will be prompted to the Setup program that displays the SQL Server Installation Center page.
Now, select Maintenance located in the left-hand navigation area, and click Repair to initiate the repair operation.
The next window runs all the setup support rule and file routines to get assurance about all the prerequisites installed and then Setup validation rules. Now, select OK button or Install to continue.
Now, on the Select Instance page, choose the instance you want to repair, and click ‘Next’ button.
To validate the operation repair rules will run, click ‘Next’ to continue.
The next page will be ‘Ready to Repair page’, which indicates that the operation is ready to proceed, click Repair.
You will be able to view the status of the repair operation through Repair Progress page.
SQL Server Installation Fix
Steps to repair failed installation of SQL Server using Command Prompt
You can also run the given command at a command prompt to repair failed installation:
1
2
‘Setup.exe /q /ACTION=Repair /INSTANCENAME=instancename’
Summary
These are the manual steps you can use to repair a failed SQL server 2016 installation. But in case you are unable to repair SQL instances then you can always go with the alternate solutions available in the market. There are various SQL repair tools available that offer you advanced modules to repair SQL 2016 instances without following many steps.
Relevant Reading
Could not open a connection to SQL Server
How to Schedule Backup in SQL Server
Saving Changes not permitted in SQL Server
Author Bio: Priyanka Chouhan is a technical writer in Stellar Data Recovery with 5 years of experience and has written several articles on SQL server & SharePoint. In the spare time, she loves reading and gardening.

How can we export datatable to PDF using iTextSharp ?

Anjan Kant — Tue, 16 Mar 2021 05:52:08 +0000

Introduction
I have illustrated below with example how can we export data table to PDF using iTextSharp

Step 1. We can download itextsharp.dll from the website http://sourceforge.net/projects/itextsharp/
Step 2. Please click on add exiting item to add iTextSharp.dll in the "Bin" folder.
iTextSharp.dll

Step 3. In the next step, put downloaded iTextSharp.dll in the project folder structure to add reference of the iTextSharp.dll in the application.

iTextSharp.dll

Step 4. You may check now that dll reference have been added in your application.

iTextSharp.text

Step 5. Now I have provided below c# code snippet as given below:

Suggested Reading
Interface class c#
What is the difference between a mutable and immutable string in C#?
What is the difference between an interface and abstract class
Jquery Timer Countdown in MVC Application. visit our site -https://www.technologycrowds.com/2013/09/how-can-we-export-datatable-to-pdf.html

DEV Community: Anjan Kant

How to Export Roundcube Contacts to Outlook?

What is new in .net Core 3.0?

How can we export datatable to PDF using iTextSharp

How to Add SSL Certificate?

How to Add FTP Site in IIS?

HAP: What is HTML Agility Pack C#?

How can we export datatable to PDF using iTextSharp

New Features: What is new in .net Core 3.0

Top Angular 4 Interview Questions and Answers

SQL Server Installation Fix: Repair a Failed SQL Server 2016 Installation

Top 3 Solutions to Convert MSG to PST File Format

How can we export datatable to PDF using iTextSharp ?