from ftplib import FTP
import pandas as pd
import os

host = "ftp.oxfordproducts.com"
username = "maximomoto"
password = "m!axi#mo#mo!t#o"

remote_file = "/stock.txt"


download_folder = "/home/motortex836/public_html/ftp-test/oxford/"


os.makedirs(download_folder, exist_ok=True)

local_txt = os.path.join(download_folder, "stock.txt")
local_csv = os.path.join(download_folder, "stock.csv")

try:
    # Connect to FTP
    ftp = FTP(host)
    ftp.login(user=username, passwd=password)

    # Download TXT file
    with open(local_txt, "wb") as f:
        ftp.retrbinary(f"RETR {remote_file}", f.write)

    ftp.quit()
    print("TXT file downloaded successfully")

    # Convert TXT to CSV
    df = pd.read_csv(local_txt, sep=None, engine="python")
    df.to_csv(local_csv, index=False)

    print("CSV file converted successfully")

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