CSV file

[CDM1CDM]

Hello. Thanks for putting this site together. Would it be possible to publish a nightly (or as the data changes) .csv file of your fields and the data rendered therein? This would be an incredibly useful data format for teams working with Splunk and other SEIM tools that don't have internet access for the api, or work in air-gapped environments but need this data. I would publish a write-up on my blog https://slice2.com/ (your data used as a Splunk lookup) to help evangelize your work.

Release Released Active Support Security Support Latest

Thanks,

CDM1CDM

[welcome]

Thank you for opening your first issue here 👍. Be sure to follow the issue template if you chose one.

[adriens]

💡 Hi, I would suggest, in this csv to feed all columns (see #2632)

related resources :

• 🎁 Weekly Scheduled offline exports on Kaggle ♾️  #2633
• 🦆 endoflife.date offline copy 💾
• Offline copy of data #2530
• Poor data quality > Please at least add releaseDate to readynas #2632

[marcwrobel]

Hi @CDM1CDM, would a JSON export work for you?

Product schema have multiple level of data that cannot be represented (at least easily) in CSV. For examples the releases field is a sublist with a variable number of element, and each of those elements have their fields. See https://deploy-preview-2080--endoflife-date.netlify.app/api/v1/products/almalinux/ for example (releasesis named cycles in this JSON payload)

Plus we already had a request to export the full dataset in JSON format (#2530).

[adriens]

Hi guys, I finally could manage to get something quite consistant, check https://www.kaggle.com/code/adriensales/endoflife-date-offline-copy/notebook

exports.tar.gz

[adriens]

The schedule is daily 💪

[adriens]

@CDM1CDM , let me know about the "fresh" csv you can now get

👇

• https://github.com/adriens/endoflife-date-exports

[adriens]

TADA ✨

adriens/endoflife-date-snapshots/issues/6#issuecomment-1471305488

duckdb -c 'SELECT * from read_csv_auto("https://raw.githubusercontent.com/adriens/endoflife-date-snapshots/main/data/details-with-headers.csv");'

[adriens]

• :repeat: Daily snapshots of product details :scientist: #2681

[marcwrobel]

Closing this as:

• @CDM1CDM never replied to the comments
• a CSV export of all the data is not possible (products and versions cannot be in the same file)
• some alternatives were provided.

[adriens]

As soon as V1 will have been officialy released, I'll deliver the data on a daily basis on various systems so people will be able to get that kind of things.
For now I keep the work private as it is subject to changes.... but it runs on a daily basis. 😸

[CDM1CDM]

I did reply and built a prototype dashboard in Splunk using the CSV file and posted an image of it to your site.  I just haven't had time to write it all up and share the xml. I've been very busy. Mc  On Sunday, July 30, 2023 at 04:12:14 PM EDT, Marc Wrobel ***@***.***> wrote: Closing this as: - @CDM1CDM never replied to the comments - a CSV export of all the data is not possible (products and versions cannot be in the same file) - some alternative were provided. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***>

[CDM1CDM]

OK. The CSV file is the only way I can use the data so thanks. Mc On Sunday, July 30, 2023 at 04:47:57 PM EDT, SALES ***@***.***> wrote: As soon as V1 will have been officialy released, I'll deliver the data on a daily basis on various systems so people will be able to get that kind of things. For now I keep the work private as it is subject to changes.... but it runs on a daily basis. 😸 — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***>