Download .yxmd file from Mongodb (Scheduler db)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Alteryx experts,
Is there way I can download the scheduled yxmd file from mongodb ?
Accidentally we have lost the local copy, But we have scheduled that workflow yesterdy using "Run a copy of the workflow stored in the schedulre db" option. So, Can I download that yxmd file out of mongodb ?
Thanks
JB
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JBN! I've created the attached workflow. It's pretty rough, but I'm hoping it will work for you without much modification. You will need the Mongo password from the system settings on the server. You will need to tell me whether it's a YXMD or YXWZ ( I got lazy and didn't program that in...). You will also need to tell me what Module you're looking for. It will use the contains formula to find all the instances of that module, and just pull the one from the bottom of the Mongo. It should save it out as a yxmd (or yxwz).
It worked for me, but let me know if come across any problems (or need any more details)!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Awesome and Appreciate your effort in making this workflow. Thanks alot patrick_digan. You are a life saver. :)
Thanks
JB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
really cool concept and idea.. nice Job @patrick_digan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
One think to be aware of... if the workflow is large, it is 'chunked' and this method may not work. This method works great if the workflow is relatively small.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @patrick_digan!
Great solution and I've used this a couple of times internally. However, I'm applying this to a MongoDB of a client and run into an issue that it's only writing out one row of data rather than the blob output (__ServiceData). The output csv is therefore only 1kb and you get the error message saying 'Attempted to skip more lines than in the file. Please check import line'. The workflows/apps are quite big so it might be that they're chunked. But I can't find a way to stitch them together because there is no field I can group the results by in the AS_App_Chuncks collection. It's also not truncating the blob field. It's just not outputting the workflow XML.
Any ideas what might go wrong here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@andre347 I had a quick look and came up empty. I'm not sure how to get the workflow if it gets chunked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can anyone advise on this; we are trying to access the XML of all assets stored on the server (none are .yxzp's due to how we have set up the server, so we only have yxwz files and yxmd files stored (assets are all always unchecked), and we also do not load macros).
I've used @patrick_digan's workflow as a base, but every single workflow I pull down is outputted as a 1kb file.
Does anyone have any tricks up their sleeve that would allow us to do this?
Our usecase is quite simple. As the admin team, we want to monitor the XML files to see how they are documented, this would include scanning the xml file for comment boxes which are coloured in a specific set of hex colours.
Thanks in advance!
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BenMoss If your server is version 11.3+, I would highly recommend the Admin API. I've got a post about it here. Instead of trying to get data out of the MongoDB directly, they now have an admin API where you can do things like download all of the workflows in your gallery using various endpoints. I've had a lot of success with it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @patrick_digan, I will check out this option. Are you around next week in Colorado :), can we catch up about this then?
Ben