From Gian Enrico Conti:
http://www.ingconti.com/Software/SQLRevenues/?id=helpuppose You are an iPhone developer. Apple sends You awful TXT files containing your revenues.
You don't want to open excel, convert, join all the files, join past files, ad macro and formulas... simply to calc your revenues.
Or suppose Your company wants to add these items to your SQL Database, to extract more info and data.
I wrote it for my own revenues: every time Apple sends mail about new files, I simply drag them to the app and.. voila', these new records are added.
If You have mysql installed, they are automatically added to the DB, and You will see totals on video, based on ALL records.
Note that You can use the currency exchange of the date You process, and these
values are saved in DB with the date of insertion, as changes will vary on time.