Bookmarks - Unstructured to Structured Conversion

[GMPLLC]

Hello,
I have a need to capture my bookmarks (i.e. Google Bookmarks) and migrate them to a salesforce database. My problem is converting the bookmarks to a readable structured format. The typical 'Bookmarks' format has no structure to it, making it difficult to extract and migrate data. My question or request is how to convert a typical bookmarks html page to a structured html table. I have attached a before and after HTML files (Zip'd) for reference and included the before and after TXT files. Thank you in advance.
TK

[GMPLLC]

Just to clarify.....in case my 'After' is not the best way to do this.

I'm looking to take the following unstructured text.....

Label A
Bookmarks (A1, A2, A3, A4....?)

Label B
Bookmarks (B1, B2, B3, B4....?)

Label C, D....and so on.

.......and convert it into the following structured text.....

Row: Label A, Bookmark A1 (Title), Bookmark A1 (URL), Bookmark A1 (Notes)
Row: Label A, A2 (Title), A2 (URL), A2 (Notes)
Row: Label A, A3 (Title), A3 (URL), A3 (Notes)
Row: Label B, B1 (Title), B2 (URL), B2 (Notes)

Important:
- Not every Bookmark contains Notes.
- Number of Labels is dynamic
- Number of Bookmarks is dynamic

[forumsupport]

Hello,

We have created the sample as per the requirement. To run this task,

.Please copy .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy .htm under C:\.


If you face difficulties with the task then please email us at Automation Anywhere - Open A Support Case and one of our support people will get in touch to resolve the issue quickly.

Alternatively, you can reach us at 1-888-484-3535 x 3

Hope that helps.

[GMPLLC]

I've ran the task and nothing happens besides it opens index.htm and data.csv. When I try to edit one of the components within the task, AA terminates.

[forumsupport]

Hello,

Task that we sent extracts the data from Index.htm file into data.csv sucessfully.

May we please know the version of Automation Anywhere you are using? You can check the version from Help->About Automation Anywhere.

Note: The task would work in the latest, Automation Anywhere 5.5.1 version as it includes the latest Pattern matching feature in Web Recorder.

You can download free trial version of Automation Anywhere 5.5.1 from our website:
Automation Anywhere - The Automation Software. Automate & Schedule IT & Business processes easily.

If you are running the latest version then can you please tell us, are you getting an error while editing the task? If yes, can you please send us screenshot of it so that we can actually see?

That would help us investigate further.