Hello all, I'm in need of some help both context as well as in theory. I am in need of software (or maybe there is/are some scripts) that can help me to put/bulk upload fields to a db.
Short and simple, I need to get information (text, urls/hyperlinks, and images) from an excel file (which I can ofcourse transform that into a csv/access/html table/xml) into a mysql db. In bulk! I'm sure I could manage if it were just a few records, and by being a db noob could even enter 100 records by hand  if I had to before realizing there is a much easier way!
I do alot with html/php and ajax/spry regions and repeat lists, but that concepts kinda breaks down because of other js that I use.
So, I was hoping that someone here could refer me to either some software(s) or scripts that I could use that will without alot of tweeking create the table and place into it all of the records the proper way all of the text and most importantly images from my master file excel/csv/access/html table/xml will actually go into DB the proper way.
So that have I can then proceed with the 'stuff' that I do know to continue to build my pages utilizing this db.
So, does anyone use or know of a software package, script, or method to accomplish this? If possible a list of options would be nice because anything I need to buy falls under a budget that is provided for. I've googled for this and have come up with a few softwares, but am not finding anything that works in the fashion of bulk upload, especially of images. I guess in the DB, per record could point to an image file residing in a folder (that will work because I can upload all images in said folder). But, it is a must that I have that bulk feature.. thanks for any help! |
