Merge Multiple XML Files using a batch file

You assumption is correct. This is the Whole file for 1:

<recording_info>
  <recording_tag>All Record</recording_tag>
  <recorded_call_id>36327</recorded_call_id>
  <recorder_cid />
  <recorded_cid>Kimberly Miles <109></recorded_cid>
  <recorder_account_id />
  <recorded_account_id>1107</recorded_account_id>
  <from_account_id>1107</from_account_id>
  <from_caller_id>Kimberly Miles <109></from_caller_id>
  <to_account_id>-1</to_account_id>
  <to_caller_id>95475425</to_caller_id>
  <duration>160</duration>
  <date_created_ts>2009-09-08 09:18:34.037292</date_created_ts>
  <date_created_secs>1252426714</date_created_secs>
  </recording_info>

I would prefer batch only because the machine that this will be ran on does not have awk installed... but i can if needed, just looking for a quick easy solution that i can run using the built in scheduler for windows, then once the file is created i can have MySQL take over the DB update part.

Well #2 the redirections are going to be a problem,  when i attempt to bring the into the DB they are getting identified as a column in the table so....

If we change the ones that contain a number <109> to "109" or 109; or strip themout totally that would be fine. Would prefer it if they were removed. We can keep each of the lines quoted  that is not causing an issue on the import.

also when running the bat file i get a "of was unexpected at this time" and it only writes the first file in the out put.

This may need to be a vb script to accomplish my goal as DOS is apparently not robust enough.

vegasIT,

The embeded "<" and ">" in the data fields would be easy enough to remove, we could add that to this batch file.

As far as the error you are getting, try editing the BAT file and change the @echo off to @echo on.  Then when the error occurs post up the last 10 or 15 lines of screen output, maybe I can see where the problem is.  I tested it here with your three example files and it processed all three.

~bp

OK so the code provided by Qlemo works great (almost), by escaping out the char it will import properly into the db and combines the files right. However the output file is creating a problem for me:


....
<date_created_secs>1252427280</date_created_secs>
<file_name>2009-09-08-09-27-59_109_105.wav</file_name>
<file_name>%nF.wav</file_name>
</recording_info>
<recording_info>
<recording_tag>All Record</recording_tag>
<recorded_call_id>36335</recorded_call_id>
<recorder_cid></reco
....

If you look at the <file_name> tags (yes now there are 2) the first one is correct, but the second one is causing an issue... it is not valid and on import it is overwriting the previous one in the db. If i could get rid of that it would be great.

Sorry, a single char was "lost in translation" ... See line 8

@echo off
setlocal EnableDelayedExpansion
set OutFile=merged.xml
 
(for %%F in (*.xml) do ^
if NOT "%%F" == %OutFile% ^
for /F "tokens=*" %%L in (%%F) do (
  if "%%L" == "</recording_info>" echo ^<file_name^>%%~nF.wav^</file_name^>
  echo %%L
)) > %OutFile%

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

Well i think we are getting closer :)

Now it is just putting the filename tag in twice, but it is formatted right, not sure how the second one is getting in there. The file name on that one is not correct.

<date_created_secs>1252427280</date_created_secs>
<file_name>2009-09-08-09-27-59_109_105.wav</file_name>
<file_name>2009-09-08-09-27-01_109_105.wav</file_name>