Here is a very good article about the manipulation of date in javascript and how to internationnalize the script.
Posts in the Coding Category at myL10N.net
Currently, many applications have a web interface and therefore it is important to build automation to test the product or perform recurrent tasks and retreive information in particular sections.
Of course many test automation tools exists but they requires to pay a license which is often expensive.
In my work of software engineer, I have found it useful to know how to automate the Internet Explorer with VBA to extract so value or add some information.
Like PERL, Python is also commonly used to perform engineering tasks or to build more complex software.
If your company programming history is more Python oriented, it might be interesting to know how to use Python to pilot Excel or other application that are exposing a OLE object.
Here is an example of a Python script that calls Excel
import win32com.client
excel = win32com.client.Dispatch('Excel.Application')
excel.Workbooks.open(ficXls)
#parcours de la zone de données
for li in zoneLi:
Coord=[]
Coord.append(id)
id=id+1
for col in zoneCol:
valeur=excel.ActiveSheet.Cells(li,col).Value
Coord.append(valeur)
As a localization engineer, it is important to build your own tool and automate the different repetitive tasks to keep quality, efficiency and deadlines.
In order to achieve this challenge, many applications such as Microsoft Office, Trados etc… have an OLE functionality (Object Linking and Embedding) which allows to interact between all these applications.
Among all the programming languages, the most used ones are PERL, PYTHON, VBA to code your own process automation.
In this article, I will show some examples of interaction between applications.
How to check the available OLE object ?
Developers familiar with using Perl can take advantage of the Automation capabilities in Perl for Win32 to integrate with applications such as Microsoft Office. This article gives you some example Perl code that sends data to Microsoft Excel and then creates a Chart and PivotTable.
PERL is commonly used to manipulate, move file and their content.
Pre requisite
You need to make sure Perl is installed on the machine that will run your script. It sounds probably obvious but often obvious things are something not check when you have a problem.
When you are starting to code, it is probably the first thing you check but when you are migrating the machine or transfer the code to a new machine, you might not check first that PERL is installed and when you run the script you will have errors.
If you are running under Linux Distribution, you will need to add the link to the PERL engine at the beginning of your script
#!/usr/bin/perl
Here are some basic codes that you might use to start your engineering work and do recurrent tasks. If you want to know more about the PERL engine and all the PERL application, there are plenty of sites dedicated to PERL that you can google.
In this post category, I will add the different codes that I know when you use Java for your enginerring work or for your development tools.
In this post category, I will add the different codes that I know when you use Python for your enginerring work or for your development tools.
One of the languages that I have used and seen used is PERL.
In this post category, I will add the different codes that I know when you use PERL for your enginerring work or for your development tools.
You are welcome to add the articles you feel a software engineer need to improve efficiency.
