panchristo Posted October 30, 2009 Share Posted October 30, 2009 Hi to all! Does anyone know if it is possible via scripting first to generate a filelist in a directory(with or without subdirectories), and then use this list to create and populate a table? From what I am slightly aware of, it can be done in terms of VBA and Access (hmm, that's the enemy right? - yuk). Is there any solution for FM? Link to comment Share on other sites More sharing options...
IdealData Posted October 30, 2009 Share Posted October 30, 2009 Closest thing would be Get(DocumentsPathListing), but I notice this is restricted to the Documents folder. Link to comment Share on other sites More sharing options...
Fenton Posted October 30, 2009 Share Posted October 30, 2009 There is a free MooPlug plug-in for Windows which can do this, and some other useful things with files. http://mooplug.com Link to comment Share on other sites More sharing options...
Kris M Posted October 30, 2009 Share Posted October 30, 2009 Ive got a way of doing it with a google app called xlm-dir-listing. Works with server or client (different configurations for each scenario) Link to comment Share on other sites More sharing options...
panchristo Posted October 30, 2009 Author Share Posted October 30, 2009 (edited) There is a free MooPlug plug-in for Windows which can do this, and some other useful things with files. http://mooplug.com Fenton, this must be as close as someone can get I believe, and probably in the easiest way. I'll try it and tell you. Awesome link!!! Many thanks for your contribution!!! :yourock: Edited October 30, 2009 by Guest Link to comment Share on other sites More sharing options...
Fenton Posted October 30, 2009 Share Posted October 30, 2009 You're welcome. But thank the developer. He's a great guy to do this plug-in for free. He is sometimes on the list here also. There is another free plug-in, ScriptMaster, from 360Works, which can do this, and all kinds of other stuff. But MooPlug is simpler and easier. Get both -! Link to comment Share on other sites More sharing options...
Wim Decorte Posted October 31, 2009 Share Posted October 31, 2009 One of the free plugins would be my choice. Without plugins it can still be done very easily: - use the Send EVent to launch this command: cmd /c dir >c:myDirList.txt - let FM pause of a second to give the command time to finish - import the file c:myDirList and parse through it. Link to comment Share on other sites More sharing options...
Lillian Posted January 31, 2011 Share Posted January 31, 2011 Hey there, I would love some advice from you guys. I was looking around for a solution to getting a directory listing, and found this (http://fmforums.com/forum/topic/69209-directory-listing/). I have to use a solution that works on both macs and windows, and I would like to avoid using a plugin if at all possible. I was just wondering if much has changed regarding this method (described in the last post) and if there is a "better" way of doing this. Thanks for reading -Lillian Link to comment Share on other sites More sharing options...
dansmith65 Posted February 3, 2011 Share Posted February 3, 2011 I don't think anything's changed since that last post. I've been working with the ScriptMaster plug-in lately, and I'd say that if you want cross-platform that's the way to go. If you really don't want a plug-in, then take Wim Decorte's suggestion for Windows, and perform a similar command on Mac (either via shell script, or AppleScript). Link to comment Share on other sites More sharing options...
Lillian Posted February 3, 2011 Share Posted February 3, 2011 I'll definitely be trying out this scriptmaker plugin, looks good, thanks dan! Also is it possible (and relatively easy) to do the following using either Scriptmaker or something else: Get a list of folders in a location, then get a list of documents in each of these folders and give them an ID related to the folder they're in. Hope this makes sense (and for the record, this wasn't my idea). Thanks all Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4829 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now