Python Forum
Rename Files based on XML file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Rename Files based on XML file
#1
I am working to rename a list of files that are received daily with an index key which is an XML file. Currently file names are given in an indistinct manner. The existing file name structure is as follows AT1_ID1_TT3_ID6-1624820795.4719.WAV .

I receive thousands of tiles with the same name which is a pain to try and identify which file I am looking for. Ideally, the file name would be renamed something a little more meaningful like `Smith John - 6-10-2021 5555555555.WAV'

The first set of code is the XML structure. I am looking to join the

<all>
  <recording_index recapp_id="" recapp_name="" last_generated="0">
    <day_index date="2021-06-27">
      <recording target_name="10 Digit Dialing" filename="AT1_ID1_TT3_ID6-1624820795.4719.WAV" filesize="60K" date="2021-06-27 15:07" source="Gloria Reyes" destination="555206203"/>
      <recording target_name="10 Digit Dialing" filename="AT1_ID1_TT3_ID6-1624820858.4721.WAV" filesize="129K" date="2021-06-27 15:09" source="Gloria Reyes" destination="555674217"/>
      <recording target_name="10 Digit Dialing" filename="AT1_ID1_TT3_ID6-1624820986.4723.WAV" filesize="33K" date="2021-06-27 15:10" source="Gloria Reyes" destination="555875330"/>
      <recording target_name="10 Digit Dialing" filename="AT1_ID1_TT3_ID6-1624821029.4725.WAV" filesize="22K" date="2021-06-27 15:10" source="Gloria Reyes" destination="969426666"/>
      <recording target_name="10 Digit Dialing" filename="AT1_ID1_TT3_ID6-1624821071.4727.WAV" filesize="6K" date="2021-06-27 15:11" source="Gloria Reyes" destination="553055567"/>
    </day_index>
  </recording_index>
</all>
import xml.etree.ElementTree as ET
from posixpath import join
import wave
import os

tree = ET.parse('./06-27-2021/index.xml')
root = tree.getroot()

for file_name in os.listdir('./06-27-2021'):
    if file_name.endswith(".WAV"):
        for child in root:
            for child in child:
                for child in child:
                    filename = child.items()[1][1]
                    
                    username = child.items()[4][1]
                    calldate = child.items()[3][1]
                    calldate = calldate.replace(":","_")
                    destination = child.items()[5][1]
                    output = join(username, calldate, destination)
                    
                    output = output.replace("/", "_")

                    output = join(output, ".WAV")
                    output = output.replace("/", "")
                    
                    os.rename(file_name, output)
I get the following error:
Error:
PS C:\Users\XXXXX\Desktop\ipitomy_python> & C:/Users/XXXXX/AppData/Local/Programs/Python/Python39/python.exe c:/Users/XXXXX/Desktop/ipitomy_python/06-27-2021/sandbox.py Traceback (most recent call last): File "c:\Users\XXXXX\Desktop\ipitomy_python\06-27-2021\sandbox.py", line 27, in <module> os.rename(file_name, output) FileNotFoundError: [WinError 2] The system cannot find the file specified: 'AT1_ID1_TT3_ID6-1624820795.4719.WAV' -> 'Gloria Reyes_2021-06-27 15_07_7878206203.WAV'
From what I gather the code is searching for 'Gloria Reyes_2021-06-27 15_07_7878206203.WAV' but not finding it, instead, I need it to look for 'AT1_ID1_TT3_ID6-1624820795.4719.WAV' and rename it. I'm sure that I have something swapped but I can't quite figure out what it swapped.
Reply
#2
So debug your program - work out which value is wrong (adding extra calls to print will help) and where that's coming from. Check whether you've got the arguments to rename the right way round (see the docs to see what they should be).
Reply
#3
os.listdir() dos not return absolute path,so will get problem(file not found) if not is same folder when try to rename.
A trick can be to add line-8,so it change to this folder:
os.chdir('./06-27-2021')
Or join so using absolute path:
os.rename(os.path.join(path, scr), os.path.join(path, dst))
Reply
#4
(Oct-22-2021, 05:42 PM)snippsat Wrote: os.listdir() dos not return absolute path,so will get problem(file not found) if not is same folder when try to rename.
A trick can be to add line-8,so it change to this folder:
os.chdir('./06-27-2021')
Or join so using absolute path:
os.rename(os.path.join(path, scr), os.path.join(path, dst))

That's exactly what I was missing. I didn't realize that it was not calling to the right folder to run and made so much more sense once I read your reply. Thank you!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Copy Paste excel files based on the first letters of the file name Viento 2 346 Feb-07-2024, 12:24 PM
Last Post: Viento
  Rename first row in a CSV file James_S 3 523 Dec-17-2023, 05:20 AM
Last Post: James_S
  Move Files based on partial Match mohamedsalih12 2 743 Sep-20-2023, 07:38 PM
Last Post: snippsat
  Rename files in a folder named using windows explorer hitoxman 3 692 Aug-02-2023, 04:08 PM
Last Post: deanhystad
  Rename all files in a folder hitoxman 9 1,384 Jun-30-2023, 12:19 AM
Last Post: Pedroski55
  Making a question answering chatbot based on the files I upload into python. Joejones 1 1,148 May-19-2023, 03:09 PM
Last Post: deanhystad
  rename file RolanRoll 0 507 May-18-2023, 02:17 PM
Last Post: RolanRoll
  '' FTP '' File upload with a specified string and rename midomarc 1 1,104 Apr-17-2023, 03:04 AM
Last Post: bowlofred
  Split pdf in pypdf based upon file regex standenman 1 1,971 Feb-03-2023, 12:01 PM
Last Post: SpongeB0B
  rename same file names in different directories elnk 0 680 Nov-04-2022, 05:23 PM
Last Post: elnk

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020