topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday March 29, 2024, 7:10 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Free (or cheap) simple database app to generate XML files.  (Read 10135 times)

Carol Haynes

  • Waffles for England (patent pending)
  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 8,066
    • View Profile
    • Donate to Member
Free (or cheap) simple database app to generate XML files.
« on: September 08, 2008, 04:03 AM »
I need an app that can set up a simple card index type database (including text fields and urls at the minimum) and then output the database as a simple XML file.

All of the cards will have the same format so the XML file will be very simple.

It needs to be very simple to use.

Anyone any ideas?

TIA

e712

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 25
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #1 on: September 12, 2008, 07:18 PM »
Hi,

Would a spreadsheet exported as XML work? 

Ed

Carol Haynes

  • Waffles for England (patent pending)
  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 8,066
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #2 on: September 13, 2008, 05:02 AM »
Thanks for the suggestion - I will give it a try.

What I am trying to do is to find a simple method to produce an XML database in a simple way for an AJAX based website.

tinjaw

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,927
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #3 on: September 15, 2008, 08:25 AM »
Carol,

I haven't any experience with it, but spotted Advanced CSV Converter on the Iconico preview email today. It might be what you are looking for.

A Hassle-Free Way to Convert Your CSV Files
If you’ve ever had to input information into a database, then you’re probably familiar with CSV files. Databases use CSV files because they’re an efficient way to store large amounts of data using relatively little space; however, you occasionally might find yourself wanting to convert these files into more convenient formats.

With Advanced CSV Converter, converting CSV files has never been faster or easier. It can handle a host of formats, including DBF (Dbase III, Dbase IV, Visual Foxpro), TXT, HTML, PRG (Clipper, Foxpro), XML , XLS (Excel), SQL, and RTF.

Although some converters can be tricky to use, Advanced CSV Converter uses an intuitive system that makes conversion a breeze. It simply plucks all the data out of the CSV in question and turns it into a nice list of data fields, ready to be saved to a multitude of formats. Best of all, the program operates via a step-by-step wizard, letting you monitor every step of the conversion process.


f0dder

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 9,153
  • [Well, THAT escalated quickly!]
    • View Profile
    • f0dder's place
    • Read more about this member.
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #4 on: September 15, 2008, 08:40 AM »
Perhaps an SQLite frontend with XML output capabilities? Surely somebody must have written a free tool for this, and it would definitely be simple (no complex setup etc).
- carpe noctem

Carol Haynes

  • Waffles for England (patent pending)
  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 8,066
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #5 on: September 15, 2008, 10:19 AM »
Thanks - the main requirement is that it has to be completely idiot proof to use.

I suppose ideally what I would like is a very simple card database type program that can also hand a field with JPEG images. It should then be really simple to input a new card, edit an existing card, delete a card and oput put the whole database as a simple XML file (and preferably upload it via FTP to a web address).

Something like this could be really useful too for generating RSS feeds manually etc.

tinjaw

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,927
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #6 on: September 16, 2008, 07:34 AM »
Something like this could be really useful too for generating RSS feeds manually etc.

FYI, ListGarden is an easy way to create RSS feeds manually.

Carol Haynes

  • Waffles for England (patent pending)
  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 8,066
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #7 on: September 16, 2008, 07:49 AM »
Thanks - ListGarden looks really useful.

justice

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,898
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #8 on: September 16, 2008, 08:12 AM »

Carol Haynes

  • Waffles for England (patent pending)
  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 8,066
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #9 on: September 16, 2008, 09:00 AM »
Sorry can't really see how GoogleBase help? I can input data but how do I export my data to an XML database file (and also keep it private)?

tinjaw

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,927
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #10 on: September 16, 2008, 12:43 PM »
FYI: I downloaded and played with the trial version of Advanced CSV Converter I mentioned earlier in the thread and it looks good. It is easy to use and does what it advertises.

Carol Haynes

  • Waffles for England (patent pending)
  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 8,066
    • View Profile
    • Donate to Member
Re: Free (or cheap) simple database app to generate XML files.
« Reply #11 on: September 16, 2008, 01:10 PM »
Thanks tinjaw - sorry I didn't comment earlier. The problem is the person I want to use the program. If it was just for me it would be fine but I really need a simple one step solution and Adv. CSV converter just moves the problem on one stage. I would then have to find an easy way for him to generate the correct CSV files, then show him how to convert them, and then how to upload them.

Maybe I'll have a go at writing something myself - it has been a long time since I wrote applications so it will be a steep learning curve but probably worth it in the long term!