Download .yxmd file from Mongodb (Scheduler db)

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

Input

Settings

MongoDB

Scheduler

Accepted answers

patrick_digan

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)!

Read from Server.yxzp

All comments

patrick_digan

It worked for me, but let me know if come across any problems (or need any more details)!

Read from Server.yxzp

JBN

Awesome and Appreciate your effort in making this workflow. Thanks alot patrick_digan. You are a life saver.

Thanks

levell_x_dunn

really cool concept and idea.. nice Job @patrick_digan

andre347

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?

EdP

Attached is an update of Patrick Digan's excellent workflow for 23.2+ where the __ServiceData blob field has been replaced with standard fields.

An alternative is to explore a more recent feature to convert these types of "hidden" scheduled workflows to standard/visible schedules and workflows.

Migrate Schedules to the Server

Read from Server_23_2+.yxzp

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703