I am having an issue with the Table Extraction wizard. The web site I need to access requires logon, but I’ve found a public site which allows me to demonstrate the issue I’m seeing. If you follow these steps, you’ll see the issue:
Browse to DataTables example - Form inputs. This includes a table as shown in the first screenshot below, where Name is a read-only label, but Age and Position are input textboxes, and Office is a selectable dropdown list
Open the UiPath Table Extraction wizard, click Add Data, and then click on the first name field (“Airi Satou”). The table extraction wizard asks “would you like to extract all the columns from the table?”. Click Yes
Click the “Preview Data” button. This shows a table as shown in the second screenshot below, where Name is displayed correctly, Age and Position are blank (which is my issue) and Office shows all the values (which doesn’t affect me, but which is nevertheless still wrong)
Please can somebody tell me how I can use the Table Extraction wizard with the above example to ensure I get values for the Age and Position columns - that should address my issue
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!