dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: CSV to WEB via XML?

Hybrid View

  1. #1
    Join Date
    Dec 2011
    Location
    Saskatoon SK
    Posts
    7

    CSV to WEB via XML?

    Wow, that's a lot of acronyms! Now that I've dispensed some humor, here is the nitty gritty of the situation;

    I have a CSV file containing all my data (including links to my images that correspond as well) that I want displayed. It's pretty basic as it looks something like this;

    ItemName
    ItemStatus (A=available, P=pending)
    ItemDescription
    ItemNumber
    ItemLocation (/images/item/picXXXXXXXX.png)
    ItemPicture (/images/item/itemXXXXXXXX.png)

    I've been using a CSV or spreadsheet as it's easier to track and maintain the database, but lately I've been wondering, rather than hardcoding and the tedious amount of work that goes with it, if there was a way to extract all this information and just use XML to display what is currently in the database?

    With the status what I would like to do is once "A" is found when reading in, a small graphic will be associated with it (for example (/images/avail.png)) same goes with "P"

    So for example thumbnails get generated, displayed with Item Name, Item Status Graphic next to it, small description, and it's number. Clicking on the thumbnail will bring you to ItemPicture (which will appear in a lightbox). See attached to see what I mean!

    Not sure this would be the right section of the Forum for this but if it's not, please move it to the appropriate section where it will receive the proper attention.

    Thanks in advance,
    Gary A.MacDonald
    Attached Images Attached Images

  2. #2
    Join Date
    Nov 2002
    Posts
    2,632
    Quote Originally Posted by Crazygar View Post
    I've been using a CSV or spreadsheet as it's easier to track and maintain the database
    By database, do you mean the CSV file, or an actual database? I would only use a file for data storage if it was a small amount of data and one that is only read read from. Anything beyond that, I would use an actual database. If you are consistently reading and updating the data, I think using a database would just be easier. You can output your data in XML format rather easy or a table as well.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles