In Feburary 2016 28,
Open Internet Explorer.
Type in the top search box 'ftp://' appended with the appropriate FTP address. For example, if the FTP address is ftp.Microsoft.com, type 'ftp://ftp.Microsoft.com' in the search box. The FTP address could also be a set of four numbers separated by dots, such as 127.0.0.1; in this case, type in 'ftp://127.0.0.1.'
Enter your FTP user name and password and then click the 'Log On' button. Files will appear in the open window. Earlier versions of Internet Explorer will open the FTP site inside the Internet Explorer window. More recent versions of Internet Explorer will automatically open Windows Explorer and display the FTP site in that window.
Upload Files to the FTP Site
Click 'Start,' type 'Windows Explorer' in the search box and press 'Enter.'
Position Windows Explorer side by side with the open FTP window by dragging the Windows Explorer window to the left and the FTP window to the right.
Navigate in Windows Explorer to the file you want to upload to the FTP site. Click and drag the file from the left Windows Explorer window to the FTP window. The file will be uploaded to the FTP site.
In Feburary 2016 28,
Showing posts with label separated. Show all posts
Showing posts with label separated. Show all posts
Sunday, 28 February 2016
Wednesday, 24 February 2016
How to Export Windows Event Logs to ExcelIn Feburary 2016 24,
In Feburary 2016 24,
Right-click the 'Computer' icon on the desktop. If the 'Computer' icon is not on the desktop, click the 'Start' button to locate the 'Computer' icon from within the Start Menu programs.
Click 'Manage' from the options box to open the Computer Management Tools console.
Click the right-facing arrow in front of the group 'Event Viewer' to open the available Event Viewer logs.
Right-click the log to be exported, such as the 'Security event log.' From the available options, click 'Save all Events as... .'
Click the down arrow in the 'Save as type:' box and select 'CSV (Comma Separated Value) (*CSV).'
Click in the 'File name:' box and type a file name and save location for the file. For example: 'c:\SecurityEventLog' will save the file called SecurityEventLog and place it on the C: drive.
Click 'Save' to save the CSV file to the C: drive.
Close the Computer Management Console by clicking the 'X' in the upper right-hand corner of the console box.
Open CSV File in Excel and Sort by Event ID
Open Microsoft Excel by clicking 'Start,' 'All Programs,' 'Microsoft Office' and 'Microsoft Office Excel.'
Click the 'Office' button in the upper left-hand corner of the Excel application and click 'Open.'
Type 'C:\SecurityEventLog.cvs' in the 'file name:' box and click 'Open' to start the Text Import Wizard.
Select 'Delimited' on the first page of the Text Import Wizard and click 'Next.'
Select 'Comma' and deselect 'Tab' under the Delimiters options and click 'Next.'
Select 'General' under the Column data format box and click 'Finish' to open the Event Viewer log in Excel.
Click on the 'Event ID' column heading to highlight the entire column of Event IDs.
Click 'Data' from the menu options at the top of the Excel application.
Click 'Sort' from the Data menu tab, select 'Expand the selection' when the Sort Warning box appears and click 'Sort.'
Click 'Event ID' in the 'Sort by' drop-down box, specify the sort order by selecting from the available options under the 'Order' drop-down box and click 'OK.'
Review the list of Windows event IDs in Excel and save the file for future use.
In Feburary 2016 24,
Right-click the 'Computer' icon on the desktop. If the 'Computer' icon is not on the desktop, click the 'Start' button to locate the 'Computer' icon from within the Start Menu programs.
Click 'Manage' from the options box to open the Computer Management Tools console.
Click the right-facing arrow in front of the group 'Event Viewer' to open the available Event Viewer logs.
Right-click the log to be exported, such as the 'Security event log.' From the available options, click 'Save all Events as... .'
Click the down arrow in the 'Save as type:' box and select 'CSV (Comma Separated Value) (*CSV).'
Click in the 'File name:' box and type a file name and save location for the file. For example: 'c:\SecurityEventLog' will save the file called SecurityEventLog and place it on the C: drive.
Click 'Save' to save the CSV file to the C: drive.
Close the Computer Management Console by clicking the 'X' in the upper right-hand corner of the console box.
Open CSV File in Excel and Sort by Event ID
Open Microsoft Excel by clicking 'Start,' 'All Programs,' 'Microsoft Office' and 'Microsoft Office Excel.'
Click the 'Office' button in the upper left-hand corner of the Excel application and click 'Open.'
Type 'C:\SecurityEventLog.cvs' in the 'file name:' box and click 'Open' to start the Text Import Wizard.
Select 'Delimited' on the first page of the Text Import Wizard and click 'Next.'
Select 'Comma' and deselect 'Tab' under the Delimiters options and click 'Next.'
Select 'General' under the Column data format box and click 'Finish' to open the Event Viewer log in Excel.
Click on the 'Event ID' column heading to highlight the entire column of Event IDs.
Click 'Data' from the menu options at the top of the Excel application.
Click 'Sort' from the Data menu tab, select 'Expand the selection' when the Sort Warning box appears and click 'Sort.'
Click 'Event ID' in the 'Sort by' drop-down box, specify the sort order by selecting from the available options under the 'Order' drop-down box and click 'OK.'
Review the list of Windows event IDs in Excel and save the file for future use.
In Feburary 2016 24,
Tuesday, 23 February 2016
How to Format Date Parameters in SQLIn Feburary 2016 23,
In Feburary 2016 23,
Create a new query statement in SQL to extract a date from the database. However, instead of extracting the raw data value stored in the database, use the 'Date_Format' command in conjunction with the query to ensure the extracted date is in your desired format.
Enter the name of the database variable that represents the raw date value as the first parameter in the 'Date_Format' command. This command uses two parameters separated by a comma inside the command's parenthesis. The format is 'Date_Format(date, format)'.
Identify the SQL date format codes that represent the many date formats that SQL may output. These codes cover all conceivable date formats and may be arranged in any order. Each code begins with a percent sign and is followed by a letter which represents a portion of a date displayed in a particular fashion. For example, '%Y' is the four-digit year, while '%y' is the two-digit year.
Format the second parameter of the 'Date_Format' command using SQL date codes to match the desired output format of the date that is extracted from the database. For example, to create a verbose text output of the date, use '%W, %M %e, %Y'. This date format will appear as 'Sunday, April 18, 2010'. Commas are entered in the format where they should appear in the final output.
Format the date as a numerical string by typing 'Date_Format([date],'%e-%c-%Y')'. Note that the single quotes are not included in the actual typed SQL query. Use the actual name of the database variable for '[date]' in this example. The output will resemble '18-4-2010'.
In Feburary 2016 23,
Create a new query statement in SQL to extract a date from the database. However, instead of extracting the raw data value stored in the database, use the 'Date_Format' command in conjunction with the query to ensure the extracted date is in your desired format.
Enter the name of the database variable that represents the raw date value as the first parameter in the 'Date_Format' command. This command uses two parameters separated by a comma inside the command's parenthesis. The format is 'Date_Format(date, format)'.
Identify the SQL date format codes that represent the many date formats that SQL may output. These codes cover all conceivable date formats and may be arranged in any order. Each code begins with a percent sign and is followed by a letter which represents a portion of a date displayed in a particular fashion. For example, '%Y' is the four-digit year, while '%y' is the two-digit year.
Format the second parameter of the 'Date_Format' command using SQL date codes to match the desired output format of the date that is extracted from the database. For example, to create a verbose text output of the date, use '%W, %M %e, %Y'. This date format will appear as 'Sunday, April 18, 2010'. Commas are entered in the format where they should appear in the final output.
Format the date as a numerical string by typing 'Date_Format([date],'%e-%c-%Y')'. Note that the single quotes are not included in the actual typed SQL query. Use the actual name of the database variable for '[date]' in this example. The output will resemble '18-4-2010'.
In Feburary 2016 23,
Wednesday, 17 February 2016
How to Connect to Zymic With FilezillaIn Feburary 2016 17,
In Feburary 2016 17,
Launch FileZilla.
Enter your website address, such as 'websitename.zxq.net' in the 'Host' box at the top of the screen.
Enter your website subdomain and main domain, separated by an underscore, in the 'Username' box. For example, if your website address is 'websitename.zxq.net,' your username is 'websitename_zxq.'
Enter your password in the 'Password' box.
Enter '21' in the 'Port' box.
Click 'Quick Connect' to connect to your Zymic account.
Drag files from the left side of the screen into the right side to upload them to your Zymic account.
In Feburary 2016 17,
Launch FileZilla.
Enter your website address, such as 'websitename.zxq.net' in the 'Host' box at the top of the screen.
Enter your website subdomain and main domain, separated by an underscore, in the 'Username' box. For example, if your website address is 'websitename.zxq.net,' your username is 'websitename_zxq.'
Enter your password in the 'Password' box.
Enter '21' in the 'Port' box.
Click 'Quick Connect' to connect to your Zymic account.
Drag files from the left side of the screen into the right side to upload them to your Zymic account.
In Feburary 2016 17,
Thursday, 4 February 2016
How Do I Change My Linksys NAT Settings?In Feburary 2016 04,
In Feburary 2016 04,
Locate the IP address of the computer that you want to change the NAT settings for. Go to 'Start --> Run.' In the run window, type in the command 'cmd.exe'. This will open up a command window. Type 'ipconfig' at the command line. When you see the line 'IP V4 address,' write down the numbers that follow. They will be in the form of four numbers separated by dots, like so: 192.168.1.4. Write this number down.
Open up a web browser and type in the following address 'http://192.168.1.1'. You will be prompted for your Netgear's admin login and password. If you haven't changed the default settings, login with the username 'admin' and password 'password' (no quotes).
Scroll odwn to the bottom of the administration menu. Look on the left-hand side of the screen, underneath the 'Advanced' section. Click the button marked 'Port Forwarding.'
Select the protocol that you want to change the NAT settings for, either 'HTTP' (for web services, such as a proxy server) or 'FTP' (for FTP servers).
Type the IP address of the computer that you looked up in Step 1 in the 'Server' box. In the drop-down menu, select the 'TCP/UDP' option. Click the 'Apply' button.
In Feburary 2016 04,
Locate the IP address of the computer that you want to change the NAT settings for. Go to 'Start --> Run.' In the run window, type in the command 'cmd.exe'. This will open up a command window. Type 'ipconfig' at the command line. When you see the line 'IP V4 address,' write down the numbers that follow. They will be in the form of four numbers separated by dots, like so: 192.168.1.4. Write this number down.
Open up a web browser and type in the following address 'http://192.168.1.1'. You will be prompted for your Netgear's admin login and password. If you haven't changed the default settings, login with the username 'admin' and password 'password' (no quotes).
Scroll odwn to the bottom of the administration menu. Look on the left-hand side of the screen, underneath the 'Advanced' section. Click the button marked 'Port Forwarding.'
Select the protocol that you want to change the NAT settings for, either 'HTTP' (for web services, such as a proxy server) or 'FTP' (for FTP servers).
Type the IP address of the computer that you looked up in Step 1 in the 'Server' box. In the drop-down menu, select the 'TCP/UDP' option. Click the 'Apply' button.
In Feburary 2016 04,
Subscribe to:
Comments (Atom)