[Solved] Calc File listing

[mandrill]

Hi there, wasn't sure where to put this, feel free to move if necessary.

I'm currently working on preparing data for use in the backend of an e-commerce website and I need to make sure that I have the required images for each item that will be sold on the website. This is not something that can be done manually in a timely fashion (over 1800 items with 4 images each).

What I'd like to do is get a listing of every image file I have in a directory (and sub-dirs) and output that to a calc spreadsheet for comparison to the data I have for each item.

as far as I can see this would require a few steps.

1. Producing a spreadsheet which lists each file separated into columns for the image sizes (XL zoom, Lg, Med, sm)
2. Checking the list of items (each with a unique SKU) against each file name (XXXXX_<size>.jpg eg TW0373_xl.jpg) ignoring the size designation part of the filename)
3. Output a spreadsheet where each item is listed along with whether the relevant size image exists.

Steps 2 and 3 I can do but I can't figure out how to get the list of files in the first place. Any suggestions?

(I've had a look at other topics which seem to address this issue but they're not much help.)

[acknak]

In Linux it's a snap; on Windows, I don't know. The same principle applies for both: use the command line to get a directory listing in a text file, then import the text file, but I don't know how to get the listing in a useful layout in WIndows, and I can't test it to make a suggestion. Maybe someone else can tell you.

Alternataively, if you can use a macro, this may do the trick: http://user.services.openoffice.org/en/ ... 21&t=41231

[RoryOF]

This might help for Windows
http://windowssecrets.com/support-alert ... -explorer/

[Hagar Delest]

Does it help: DIRECTORY LIST - files or folders to Calc?
For installation, see Tutorial: How to install a code snippet.

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.

[mandrill]

Thanks guys. much appreciated.