import pandas as pd
import os

url = "https://portal.cgmitalia.net/mailNotturne/dispCGMITALIA.txt"

# Correct folder path
download_folder = "/home/motortex836/public_html/ftp-test/cgm/"
os.makedirs(download_folder, exist_ok=True)

# Output file path
local_csv = os.path.join(download_folder, "stock.csv")

try:
    try:
        df = pd.read_csv(url, sep=None, engine="python")
    except:
        df = pd.read_csv(url)

    df.to_csv(local_csv, index=False)

    print("Done: CSV generated successfully")

except Exception as e:
    print("Error:", e)