DonationCoder.com Software > Post New Requests Here
Idea: Program to update a MySQL database with data obtained from other programs
Tat1990:
I have a media database in MySQL. The program used to make it is not open source.
I would like to add information about the files on the database in automatic mode.
Example: Every time a new line is added or modified in a specific table,
get the path of the file (path is on database), run one or more programs like ImageMagik, Media info, a CRC32 command line utility,
and add the that data to predefined fields of another table.
I am not a coder, I don't know if it is possible, but my idea would be a program that we could use batch SQL statements to read and update the info.
The program should have several possibilities to get info from external programs (EX: read a log file, act as a console and read the result)
The program would receive the path of file to process via the batch SQL statement, run external programs, get their output and run update SQL batch.
Now this is me dreaming, it would be possible to change SQL batches behavior with tokens program would replace before launching the the SQL batch.
I am sorry for my poor English and for my poor capacity to explain my idea. Please feel free to ask what on heck I have in mind if this doesn't make a lot of sense to you. :)
Kisses for ladies, hugs to gentlemen,
Tatjana
JoTo:
Welcome Tatjana,
i see you followed my advice on the irc channel to post your wish here.
I hope, someone will grab the task for you. *FingersCrossed*
Greetings
JoTo
PS:
Hope to chat you in the channel again. Bye!
Renegade:
I'm not really sure what you are trying to do, but there are lots of front ends for MySQL. HeidiSQL is a good one. There are many others. Is that what you are looking for?
If you want, you can try using MS Access as a front end for MySQL. There seem to be many results for it. Found this in the first result:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_access_visual_guide.php
Tat1990:
No, I am trying to add to a MySQL database data the media collection manager software doesn't, but can read it if placed as "custom fields"
I know how to add data to a MySQL database, what I don't know is how to read that data from external programs and insert it into the database automatically.
I am avoiding naming the software because it is a commercial application. :P
Tatjana
Renegade:
...what I don't know is how to read that data from external programs and insert it into the database automatically.
-Tat1990 (September 26, 2011, 04:05 AM)
--- End quote ---
If the data in the external program is in a proprietary format, then you need to be able to program. It may not be easy.
If the data in the external program is in a MySQL database, then it's simple -- read it from where it is stored, then insert it where you want it.
For automation, I don't know of any easy tools to do that other than MS Access. I only know low-level tools that require programming.
Maybe someone else here knows some consumer-level tools that can help.
Navigation
[0] Message Index
[#] Next page
Go to full version