[Cod-bugs] FW: New Release of Search/Match database for Panalytical HighScore(Plus) SW

[Thomas Degen]

Unrestricted Document

Hello COD Crew,

This is Thomas Degen from Malvern Panalytical. We typically update the Search/Match database which is calculated from the COD database once a year.
Can someone please advice me, what’s the best way to upload this latest Search/Match Database based on the COD from this May?
This is (in the meantime) a 7.1 GByte SQLite database file.

Many Thanks and best regards,

Thomas Degen



Unrestricted Document

From: Thomas Degen
Sent: Wednesday, May 8, 2024 1:29 PM
To: Saulius Gražulis <grazulis at ibt.lt>
Subject: RE: New Release of Search/Match database for Panalytical HighScore(Plus) SW

Hello Saulius,

Its more than a year ago that we updated the MP COD Search/Match database.
I have just compiled a new one, using the COD data from May 5th.
How can I send you that big file, is it still the same options or is there something changed/new?

Thank’s and best regards,

Thomas

From: Saulius Gražulis <grazulis at ibt.lt<mailto:grazulis at ibt.lt>>
Sent: Monday, March 20, 2023 12:44 PM
To: Thomas Degen <thomas.degen at malvernpanalytical.com<mailto:thomas.degen at malvernpanalytical.com>>
Subject: Re: New Release of Search/Match database for Panalytical HighScore(Plus) SW

On 2023-03-17 17:49, Thomas Degen wrote:
This is Thomas Degen from Malvern Panalytical headquarters in Almelo, the Netherlands.
I think previously you were in contact with my colleague Thomas Dortmann, concerning the Search/Match version
Of the COD database for MP HighScore(Plus) software. Thomas Dortmann retired last year and now I would like to upload a
New version of the Search/Match database, to make it available for our users on your website.
This new version is based on the COD of February this year.
Do you maybe have an upload facility for such huge files?
The SQlite (Search/Match) database file is around 7GByte.

You can send me the files using the following options:

1) using anonymous FTP on my server, 'saulius.grazulis.lt' (I have to use my own server since our university has blocked the incoming traffic to FTP port at the moment). Since my server is behind the firewall, please use PASSIVE FTP mode to upload the files. An example upload session using a CLI ftp client is provided [1].

2) Using 'rsync' to an ssh account. To use this option, please send me your ssh public key (~/.ssh/id_rsa.pub or equivalent file), I will add an account for you and send the ssh login credentials (user name and server name);

3) you can place the files on any HTTP(S) server accessible to you and send me the URL of the file(s); I will download them.

Please let me know which option is the most suitable for you.

In any case, please send me the list of the files to be published together with their crypto-checksums (SAH256), and possibly file sizes, so that I can double check the uploads. If there are any problems, please let me know and I'll do my best to help resolving them.

Sincerely yours,
Saulius

Refs.:

[1] An example upload session to the 'saulius.grazulis.lt' FTP server. The bold italic monospaced text is typed by the client operator (in the example case, by me):
saulius at tasmanijos-velnias ~/ $ ftp saulius.grazulis.lt
Connected to saulius.grazulis.lt.
220 ProFTPD 1.3.5b Server (Debian) [::ffff:192.168.1.111]
Name (saulius.grazulis.lt:saulius): anonymous
331 Anonymous login ok, send your complete email address as your password
Password:grazulis at ibt.lt<mailto:grazulis at ibt.lt>
230-Welcome, archive user anonymous at 78-60-2-35.static.zebra.lt<mailto:anonymous at 78-60-2-35.static.zebra.lt> !
230-
230-The local time is: Mon Mar 20 11:31:05 2023
230-
230-This is an experimental FTP server.  If you have any unusual problems,
230-please report them via e-mail to <root at jonvabalis>.
230-
230 Anonymous access granted, restrictions apply
Remote system type is UNIX.
Using binary mode to transfer files.
ftp> cd incoming
250 CWD command successful
ftp> bin
200 Type set to I
ftp> pass
Passive mode on.
ftp> hash
Hash mark printing on (1024 bytes/hash mark).
ftp> put stack-x86.ora
local: stack-x86.ora remote: stack-x86.ora
227 Entering Passive Mode (78,62,46,183,165,93).
150 Opening BINARY mode data connection for stack-x86.ora
##############...
226 Transfer complete
6893812 bytes sent in 0.92 secs (7.1113 MB/s)
ftp> quit
221 Goodbye.



--

Dr. Saulius Gražulis

Vilnius University, Life Science Center, Institute of Biotechnology

Saulėtekio al. 7, LT-10257 Vilnius, Lietuva (Lithuania)

phone (office): (+370-5)-2234353, mobile: (+370-684)-49802, (+370-614)-36366

This email and any files transmitted with it are confidential and maybe legally privileged. Such message is intended solely for the use of the individual or entity to whom they are addressed. Please notify the originator of the message if you are not the intended recipient and destroy all copies of the message. Please note that any use, dissemination, or reproduction is strictly prohibited and may be unlawful.

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.crystallography.net/pipermail/cod-bugs/attachments/20240514/22e244af/attachment-0001.htm>