QUESTIONS ANSWERS
We cannot access the FTP site?
  • You cannot access it through a proxy
  • You have to have the rights to access such sites
  • You IT security has to allow it
You have to be a member (then a password/login will be given)
Can we have access to a web-based solution

Yes

It has been provided. You have to go on the DG Relex website. The proposed solution is XSLT, replacing the previous CSS solution. You have a search and print tools. There are 2 types of lists: Alphabetical and by entry . This web based solution is compatible with Internet Explorer 6 and Mozilla (Netscape) 1.6
The XML is not easy to handle when you are not an IT person. Is there the possibility to have an interface more user-friendly in order to avoid manipulating the XML tags?

Yes

It has been provided. You have to go on the DG relex website. The proposed solution is XSLT. You have a search and print tools. There are 2 types of lists: Alphabetical and by entry . This web based solution is compatible with Internet Explorer 6 and Mozilla (Netscape) 1.6. However, you cannot download this interface.

Could we have the definition of the XML structure? Please refer to the on-line help – section Structure and definition
On the basis of what criteria the data introduction was performed ?

The English version of the Official Journal was the primary Master.Then the other linguistic versions were analysed to pin down the spelling/alphabet differences in the Names/Last Names/Nicknames/Arabic numbers/Birth date. The fields Addresses/Remarks are only in English

Why are there sometimes names and aliases repeated several times?

At the time that you viewed the XML files, there was a missing attribute: Linguistic version. Indeed solely for the fields under Names and aliases, the different linguistic versions of a name/last name/nickname were introduced.

Why are there different font styles (uppercase/lowercase)

As underlined in the on-line help file (section How was handled the data), the Official Journal lists were introduced into the database by copying and pasting them (field by field). The expert teams did not “touch” the data. Therefore, what you have in the e-list is what you have in the Official Journal.

Why are there different date formats (dd.mm.yyyy or Day Month Year …)

As underlined in the on-line help file (section “How was handled the data”), the Official Journal lists were introduced into the database by copying and pasting them (field by field). The expert teams did not “touch” the data. Therefore, what you have in the e-list is what you have in the Official Journal.

Why are there the acronyms aka, alias…? It will disappear in a short while as it causes problems for the alphabetical list.
What are the 3 letters for the countries?

ISO code for countries

Problem with the “reserved” characters like “&”

It has been resolved. They will be replaced by their “HTML” coding and not removed as we have to produce the exact copy of the OJ content. In order to avoid that your DBMS picks up these characters you have to produce a specific parser.

The content covers which Regulations?

Only the Financial Sanctions

Notification system Not implemented
Can I contact someone for support?

No

You can consult the online Help or your own IT administrator.