Hi Peter. Many thanks for your response, which is really helpful. I can follow what you’re saying, but am new to UiPath and cannot find the “Edit Data Definition” button that you show in your screenshot. The preview window I’m seeing is in the screenshot of the original post and only has an “OK” button. Am I doing the right thing opening the Table Extraction wizard, and if so where do I find the “Edit Data Definition” button? Thanks again for your help
please do a screenshot of what you do see. We assume that the wizard within the modern design style is displayed. So we check for the alternate support steps. Thanks
Just give a try on completing the wizard and then edit manually the extract config on the properties of the activity
Thanks Peter. I’ve tried pasting your XML into the correct section, and then I get an error - I assume because the new XML only has tags but no tags? I’ll have a look tomorrow to try to work out the XML issue - at least I now know where to make those changes so am a step closer!
I’ve managed to clear the errors, but it’s still not working (in fact the output is identical to what I had originally, where the Name works, the Age and Position are blank, and the Office shows all options rather than the selected option).
I think my issue is that I don’t understand the XML metadata. When I run the Table Extraction wizard the generated XML metadata has the outer tags as , whereas in your XML you use “”. If I remove the tags I get errors, so I’ve taken the generated XML and your XML and have merged them together as below. This is now running, but still not delivering the correct results (see image below). I’ve pasted a picture below which shows the original and merged XML and results
Is there a page that explains the XML structure? Apologies, whilst I have a background in programming I don’t have in-depth experience with HTML/XML!
@LJD
in general we configure the columns, get created also the table setting and afterwards we do reconfigure the extract metadata. when doing all manually we also have to take care about the matching table settings
Thanks. Is there a set of documentation on the XML Metadata tags? Changing the metadata is easy, but I have no idea what tags or values to enter! I feel like I’m so close to getting this working, but the XML you provided doesn’t work, and when I try to merge that XML with the original XML, that doesn’t work either. Thanks very much for your help
Thanks so much for your continued help, but this doesn’t work for me. I just get the error below. I still don’t understand what XML tags I can use, but the clear difference to me is that the XML produced by the Table Extraction wizard is wrapped in “” tags whereas this new XML is wrapped in “” tags
That new XAML file is working the first 3 columns! I haven’t yet checked the differences between the original file and the amended file, but will do later. The final column is not working, but I’m less worried as I don’t need to scrape a dropdown list. I will now continue with development and try to get to next level. Thanks so much for your help!
it coukd be the case that a lot leading spaces will give the impression of empty values (did faced it). Indeed it was surprising in all. A post edited metadata was not accepted, but wenn doing the wizard againg and modifying the results it was extracting.
Maybe you will find out the small difference, causing this behaviour. Otherwise we can this also share with the UiPath tech team
The good news is that I figured out the difference between your working code, and my not working code. Your working code had the Target Selector value set to “” whereas my not working code had it set to “”. I can now reliably get that test page to work!
The bad news is that I am still having issues with the real page that I need to scrape the data for. I have extracted the HTML as attached. On this page, I can get the first two columns to be displayed correctly, but not the third column.
With the Extract Metadata set as per the attached screenshot below, I only get the first 2 columns displayed: