Re: [WebDNA] fileinfo - need photo w & h written to a database

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112697
interpreted = N
texte = 280--Apple-Mail=_13A3E094-ACB8-4826-9BDF-9F8C5992C249Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8Rich,Im no sure if get your problem, but this is how I understand it:There is a folder, in my example called =E2=80=9Eimages=E2=80=9C, which =has lots of images in it and you want to save them and their metadata to =a brandnew db.This is how I would do it:[ListFiles path=3D/images][FileInfo file=3D/images/[filename]][append =db=3Dimages.db&Autonumber=3Dimage_id]filename=3D[FileName]&size=3D[Size]&w=idth=3D[ImageWidth]&height=3D[ImageHeight][/append][/FileInfo][/Listfiles][listfiles] loops through all the files in the /imges folder; fileinfo =checks the image and gives you access to [FileName], [size], =[ImageWidth], [ImageHeight],=E2=80=A6 which you store in the db using =append...Noah> Am 26.03.2016 um 14:28 schrieb Rich Kwas :>=20> I failed miserably trying to use [loop] for a different part of a =project, so I thought I'd ask first about this part of it.>=20> There are a few thousand photos used in a site, and the client =populates many sliding galleries within this site (photos change =frequently). Currently the width and height are manually entered.>=20> I'd like to write all the existing photo filenames into a db with =their width and height so that when a photo is chosen the w&h populate =the gallery html without needing to be manually entered.....>=20> Currently using [listfiles] to show an alphabetical list of all the =photos, linking individual photos to a page where that photo is shown =with [fileinfo] showing its width and height.>=20>=20> Is there a way to do this?>=20> Since the w&h are determined when the image is viewed in a browser =window, it doesn't seem like there would be a way to do all of them =automatically without needing to view each one and then writing its =fileinfo into a db.>=20> Thanks>=20>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_13A3E094-ACB8-4826-9BDF-9F8C5992C249Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8

Rich,

Im no sure if get your problem, but this is how I =understand it:

There is a folder, in my example called ==E2=80=9Eimages=E2=80=9C, which has lots of images in it and you want to =save them and their metadata to a brandnew db.

This is how I would do it:

[ListFiles =path=3D/images]

[FileInfo =file=3D/images/[filename]]

=[append =db=3Dimages.db&Autonumber=3Dimage_id]filename=3D[FileName]&size=3D=[Size]&width=3D[ImageWidth]&height=3D[ImageHeight][/append]

<=div class=3D"">=[/FileInfo]

[/Listfiles]

[listfiles] loops =through all the files in the /imges folder; fileinfo checks the image =and gives you access to [FileName], [size], [ImageWidth], =[ImageHeight],=E2=80=A6 which you store in the db using =append...

Noah

Am =26.03.2016 um 14:28 schrieb Rich Kwas <richkwasniewski@yahoo.com>:

I =failed miserably trying to use [loop] for a different part of a project, =so I thought I'd ask first about this part of it.

There are a few thousand photos used in a site, =and the client populates many sliding galleries within this site (photos =change frequently). Currently the width and height are manually =entered.

I'd =like to write all the existing photo filenames into a db with their =width and height so that when a photo is chosen the w&h populate the =gallery html without needing to be manually entered.....

Currently using [listfiles] to show an =alphabetical list of all the photos, linking individual photos to a page =where that photo is shown with [fileinfo] showing its width and =height.

Is there a way to do this?

Since the w&h are determined when the image =is viewed in a browser window, it doesn't seem like there would be a way =to do all of them automatically without needing to view each one and =then writing its fileinfo into a db.

Thanks

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--Apple-Mail=_13A3E094-ACB8-4826-9BDF-9F8C5992C249--. Associated Messages, from the most recent to the oldest:

Re: [WebDNA] fileinfo - need photo w & h written to a database (Rich Kwas 2016)
Re: [WebDNA] fileinfo - need photo w & h written to a database (Noah Valley 2016)
Re: [WebDNA] fileinfo - need photo w & h written to a database (Terry Wilson 2016)
Re: [WebDNA] fileinfo - need photo w & h written to a database (Rich Kwas 2016)
Re: [WebDNA] fileinfo - need photo w & h written to a database (Terry Wilson 2016)
[WebDNA] fileinfo - need photo w & h written to a database (Rich Kwas 2016)

280--Apple-Mail=_13A3E094-ACB8-4826-9BDF-9F8C5992C249Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8Rich,Im no sure if get your problem, but this is how I understand it:There is a folder, in my example called =E2=80=9Eimages=E2=80=9C, which =has lots of images in it and you want to save them and their metadata to =a brandnew db.This is how I would do it:[ListFiles path=3D/images][FileInfo file=3D/images/[filename]][append =db=3Dimages.db&Autonumber=3Dimage_id]filename=3D[FileName]&size=3D[Size]&w=idth=3D[ImageWidth]&height=3D[ImageHeight][/append][/FileInfo][/Listfiles][listfiles] loops through all the files in the /imges folder; fileinfo =checks the image and gives you access to [FileName], [size], =[ImageWidth], [ImageHeight],=E2=80=A6 which you store in the db using =append...Noah> Am 26.03.2016 um 14:28 schrieb Rich Kwas :>=20> I failed miserably trying to use [loop] for a different part of a =project, so I thought I'd ask first about this part of it.>=20> There are a few thousand photos used in a site, and the client =populates many sliding galleries within this site (photos change =frequently). Currently the width and height are manually entered.>=20> I'd like to write all the existing photo filenames into a db with =their width and height so that when a photo is chosen the w&h populate =the gallery html without needing to be manually entered.....>=20> Currently using [listfiles] to show an alphabetical list of all the =photos, linking individual photos to a page where that photo is shown =with [fileinfo] showing its width and height.>=20>=20> Is there a way to do this?>=20> Since the w&h are determined when the image is viewed in a browser =window, it doesn't seem like there would be a way to do all of them =automatically without needing to view each one and then writing its =fileinfo into a db.>=20> Thanks>=20>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_13A3E094-ACB8-4826-9BDF-9F8C5992C249Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8