Business Analyst, MTN Uganda

Anthony Matovu

<div>
<div class="content wysiwyg-content">
Seeking guidance on uploading/update website database 
 
I have a desktop application/software developed in Visual Basic.net. &nbsp;This application is supposed to regularly supply information to a website for reporting and review purposes. 
 
Help tell me if my plan is good or i should have a better way of implementing this 
 
Website is built in JAVA (Servlet,JSP on Tomcat and mysql) 
 
This is how I plan to do it. 
 
a. Desktop (database is in access) 
&nbsp; &nbsp;1. Get all new records or updates from the desktop database since last last data upload. 
&nbsp; &nbsp;2. Transform identified records into an XML format file. 
&nbsp; &nbsp;3.Upload the XML file to the website using FTP and the software 
 
b.server/website (database is in MYSQL) 
&nbsp; &nbsp; 1.identifies all new and un extracted xml files 
&nbsp; &nbsp; 2.Extract XML files to mysql database 
&nbsp; &nbsp; 3. generate reports 
 
Thanks
</div>
</div>

Seeking guidance on uploading/update website database

I have a desktop application/software developed in Visual Basic.net.  This application is supposed to regularly supply information to a website for reporting and review purposes. 

Help tell me if my plan is good or i should have a better way of implementing this

Website is built in JAVA (Servlet,JSP on Tomcat and mysql)

This is how I plan to do it.

a. Desktop (database is in access)
   1. Get all new records or updates from the desktop database since last last data upload.
   2. Transform identified records into an XML format file.
   3.Upload the XML file to the website using FTP and the software

b.server/website (database is in MYSQL)
    1.identifies all new and un extracted xml files 
    2.Extract XML files to mysql database
    3. generate reports 

Thanks

Update website from a desktop application

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.