Re: Inserting files from a folder
- From: "Remi-Noel Menegaux" <rnmenegaux@xxxxxxx>
- Date: Tue, 15 Nov 2005 08:44:46 +0100
I must say I didn't know anything about these features of the 'dir'
command.
This solution is spectacular. Thanks for the "dir /n /b /s /a-d >
dir.txt".
Now, back to TroiFile, I can't let say that it 'freezes' the machine
after a while. I use it extensively in FMP6 for a museum to import in
containers the references of thousands images files and it has worked
for years perfectly.
The only limit I saw in it is that when dealing with a folder full of
images files it puts all their file names in a single temporary field.
In FMP6 the field size has a limit of 64K characters thus limiting the
number of files you can handle at a time : say 6400 if each image file
name is 10 characters long including '.jpg' for example.
So in another solution in FMP6 I made - still with TroiFile - for a DVD
renting store - I had to 'import' 30 000 cover images - I had to set up
a more complex solution, splitting the original folder into something
like 40 subfolders to stay in the limit of 5000 images per folder. It
works at night and works well.
I can share this solution with anyone interested and ready to invest
some time in it.
Remi-Noel
"Dan Fretwell" <dan@xxxxxxxxxxxxx> a écrit dans le message de news:
1132019201.139858.238230@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> If you are only going to store the reference try doing it without a
> container. For example in Windows the following command prompt (which
> you can put into a batch file if you wish)
>
> dir /n /b /s /a-d > dir.txt
>
> produces a text file, dir.txt, containing a listing of all the files,
> with full path, in the current directory and all its subdirectories.
>
>
> Looks like this:
>
> E:\All_Documents\Desktop.ini
> E:\All_Documents\dir.txt
> E:\All_Documents\Info.bat
> etc....
>
> This text file can be imported into a Filemaker database importing
> each
> line into a text field Filename. You can open the file by using an
> Open
> URL(table::Filename), if you haven't moved the file in the meantime.
>
.
- Follow-Ups:
- Re: Inserting files from a folder
- From: Bill Marriott
- Re: Inserting files from a folder
- References:
- Inserting files from a folder
- From: Abhi
- Re: Inserting files from a folder
- From: Dan Fretwell
- Inserting files from a folder
- Prev by Date: Re: FM8 odd behavior in scripted copy/paste into pop-up menu fields
- Next by Date: Templates
- Previous by thread: Re: Inserting files from a folder
- Next by thread: Re: Inserting files from a folder
- Index(es):
Relevant Pages
|
