Posts Tagged ‘output’

Q&A: How can I best ingest xml data and audio files into a database which can output various formats of data?

Question by Huxton_Billbob: How can I best ingest xml data and audio files into a database which can output various formats of data?
I run the content department at an independent media company. We have to keep track of tens of thousands of audio files, as well as image files and metadata files in various formats that are associated with them. We also have to output files and data in even more different formats. We have been manually organising the system using excel and DOS batches, but it is getting to the stage where we need it to be more automated.

Is it possible to ingest XML/XLS data and other files all at once and add them to a database which manages data AND files? Or is this wishful thinking?

I don’t expect many people to understand what the hell I’m talking about… if you do though, please help!

Best answer:

Answer by Empanada
Most RDBMS systems provide a BLOB (binary large object) data type that can be used to store data files such as audio files. You can also store XML files in an associated table/column, but it would probably be best to transform the XML and import the data into the schema rather than simply store the XML so that the audio files are searchable. I’m not aware of any off-the-shelf applications to do specifically what you’re looking for, so you might need to write an application to perform the imports/exports to your database.

Give your answer to this question below!

Tags: , , , , , , , , ,

No Comments


sending output to a file and screen in c++?

Question by spicy11225: sending output to a file and screen in c++?
this is my program so far: i am trying to send and output to a file and also to the screen. i do not want the prompts to appear on the screen, therefore i need to send the prompts to a file. Some how it is going to a file but on the screen i still have to input the information.
can someone tell me please what i am doing wrong.

{
int custnum;
double $ orderplaced, $ orderpaid, balancedue;

ofstream outfile;
outfile.open(“g:A3.out”);

cout.setf(ios::fixed,ios::floatfield);
cout.precision(2);

cout << "\t\tHandy Hardware Company's Customer Database" << endl;
cout << "\t\t__________________________________________ " << endl;
cout << endl;
cout << "\tOrders Placed($ )\tOrders Paid($ )\tBalance Due\tStatus " << endl;
outfile << "Enter the Customer Number " << endl;
cin >> custnum;
while (custnum > 0) { // read unitl a negative number is entered
outfile << "Enter dollar amount of Orders placed

Best answer:

Answer by Graham
Well,
1.$ is an illegal character for a declaration (I think).
2.I think you mean “G:\A3.out”.
Hold on a second, I need to see the details again…
Oh, that’s it? Well, you’re doing OK so far. Remeber
cout is tied to stdout (the screen).
outfile is tied to file G:a3.out (do you mean G:\A3.out? The double backslash is because of the backslash being an escape character.)
and cin is tied to stdin (the keyboard).

What do you think? Answer below!

Tags: , , ,

1 Comment



SetPageWidth