Hi all, Have had this for the longest and need to loop through folder/sub folders containing xml files and extract specific elements to excel file.  I have not touched this software in quite a while and I am very rusty.  any help would greatly be appreciated. I have included a sample xml file and the elements i will need are (user_name, created_date, target_file, target_path and duration)

Category Survey AutoMate 7 version: 7.1.3 Windows version: Windows 7

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<?xml version="1.0" encoding="UTF-8"?> <root> <system_name>DSSPlayerProR5</system_name> <file_version>1.0</file_version> <dictation> <author> <host_name>LA-PC47</host_name> <user_name>george</user_name> </author> <common_header> <author_id>DS5000</author_id> <attribute_flag>FF</attribute_flag> <licensee_id>00000002</licensee_id> <typist_id> </typist_id> </common_header> <original_location> <backup_status>Other</backup_status> <moved_date> </moved_date> <file_path> </file_path> </original_location> <completed_date>2015-07-17T17:38:36.000</completed_date> <created_date>2015-07-17T17:34:54.000</created_date> <deleted_info> <deleted_date> </deleted_date> </deleted_info> <dictation_status> <process>0</process> <status>3</status> </dictation_status> <downloaded_date>2015-07-17T17:38:56.114</downloaded_date> <edit_history> <operation1> <process_time>2015-07-17T17:38:56.116</process_time> <process>1103</process> <category>1</category> <host_name>LA-PC47</host_name> <user_name>george</user_name> <additional_value>E:\DSS_FLDC\DS502692.DSS</additional_value> </operation1> <operation2> <process_time>2015-07-17T17:38:56.117</process_time> <process>1501</process> <category>2</category> <host_name>LA-PC47</host_name> <user_name>george</user_name> </operation2> </edit_history> <encrypted_location> </encrypted_location> <audio_format>1</audio_format> <target_file>Jimenez, M. _DS502692_717201553454PM.DSS</target_file> <targe_path>H:\worddata\DICTATION\GSM\FolderA</targe_path> <forwarded_date> </forwarded_date> <last_moved_date>2015-07-17T17:38:56.115</last_moved_date> <guid>6240173C-F91E-4567-AD5A-0B97FF1AADF5</guid> <index_mark /> <instruction_comment> </instruction_comment> <encrypted>0</encrypted> <job_number>232</job_number> <linked_item> <path> </path> <name> </name> </linked_item> <recognition> <document> </document> <recognition_done>0</recognition_done> </recognition> <optional_header> <comment>Jimenez, M. </comment> <playback_position>0</playback_position> <quality_detail> <quality>1</quality> <channel>1</channel> <sampling_rate>12kHz</sampling_rate> <bit_rate>13.7kbps</bit_rate> <quantization_bit_rate>16bit</quantization_bit_rate> </quality_detail> </optional_header> <option_item_info> </option_item_info> <priority_level>7</priority_level> <priority>00</priority> <rebuild_managefile>0</rebuild_managefile> <duration>127968</duration> <routing> <routing_encryption>0</routing_encryption> <routing_password /> </routing> <transcription_completed> </transcription_completed> <transcriptionist /> <transcription_started> </transcription_started> <verbal_comment /> <voice_recognition>00</voice_recognition> <work_type> </work_type> </dictation> </root>

Hello Sal,

We suggest looping through the folder containing the XML files, and creating a dataset for the xml files. Once you have the parameter for the xml file names, you can create a secondary loop within the first loop to extract the information requested (XML node to dataset) and write it to an excel file. Once the inner loop has written to the xml file, it will break back out to the main loop changing the xml file name, and once again processing it inside the second loop.

Please let us know if that works for you.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665