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 = 112698
interpreted = N
texte = 281 ------=_Part_1755125_782809982.1459259894688 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I was able to use exiftool to scan all images and generate a file with all = w&h info in a database format even.... I may have misunderstood how [fileionfo] works. I always thought you had to view the image in a browser window to get its w= idth/height etc. Just did a little test and I see now that's not the case. =20 On Tuesday, March 29, 2016 5:41 AM, Noah Valley wro= te: =20 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 im= ages 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/imag= es/[filename]] [append db=3Dimages.db&Autonumber=3Dimage_id]filename=3D[Fil= eName]&size=3D[Size]&width=3D[ImageWidth]&height=3D[ImageHeight][/append] [= /FileInfo][/Listfiles] [listfiles] loops through all the files in the /imges folder; fileinfo chec= ks the image and gives you access to [FileName], [size], [ImageWidth], [Ima= geHeight],=E2=80=A6 which you store in the db using append... Noah Am 26.03.2016 um 14:28 schrieb Rich Kwas : 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 ma= ny 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 wid= th and height so that when a photo is chosen the w&h populate the gallery h= tml 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 [filein= fo] 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 w= ithout needing to view each one and then writing its fileinfo into a db. Thanks ---------------------------------------------------------This message is se= nt 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 se= nt 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 ------=_Part_1755125_782809982.1459259894688 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I was able to use exifto= ol to scan all images and generate a file with all w&h info in a databa= se format even....

I may have misunderstood how [fileionfo] works.

I always thought you had = to view the image in a browser window to get its width/height etc.
Just did a li= ttle test and I see now that's not the case.





=


On Tuesday, March 29, 2016 5:41 AM, Noah Valley <= ;valley@mac-web.ch> wrote:


Ri= ch,

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]
<= div class=3D"yiv7171843294">=09[FileInfo file=3D/images/[filename]]
=09=09[append db=3Dimages.db&Autonumbe= r=3Dimage_id]filename=3D[FileName]&size=3D[Size]&width=3D[ImageWidt= h]&height=3D[ImageHeight][/append]
=09[/FileInfo]
[/Listfiles]
<= /div>

[listfiles] loops through all the file= s 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
<= div class=3D"yiv7171843294">
Am 26.03.2016 um 14:28 schrieb Rich Kwas <richkwasnie= wski@yahoo.com>:

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

There are a few tho= usand photos used in a site, and the client populates many sliding gallerie= s within this site (photos change frequently). Currently the width and heig= ht are manually entered.

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

Currently using [lis= tfiles] to show an alphabetical list of all the photos, linking individual = photos to a page where that photo is shown with [fileinfo] showing its widt= h 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 the= m automatically without needing to view each one and then writing its filei= nfo into a db.

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

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


=
--------------------------------------------------------- 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 ------=_Part_1755125_782809982.1459259894688-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] fileinfo - need photo w & h written to a database (Rich Kwas 2016)
  2. Re: [WebDNA] fileinfo - need photo w & h written to a database (Noah Valley 2016)
  3. Re: [WebDNA] fileinfo - need photo w & h written to a database (Terry Wilson 2016)
  4. Re: [WebDNA] fileinfo - need photo w & h written to a database (Rich Kwas 2016)
  5. Re: [WebDNA] fileinfo - need photo w & h written to a database (Terry Wilson 2016)
  6. [WebDNA] fileinfo - need photo w & h written to a database (Rich Kwas 2016)
281 ------=_Part_1755125_782809982.1459259894688 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I was able to use exiftool to scan all images and generate a file with all = w&h info in a Database format even.... I may have misunderstood how [fileionfo] works. I always thought you had to view the image in a browser window to get its w= idth/height etc. Just did a little test and I see now that's not the case. =20 On Tuesday, March 29, 2016 5:41 AM, Noah Valley wro= te: =20 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 im= ages 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/imag= es/[filename]] [append db=3Dimages.db&Autonumber=3Dimage_id]filename=3D[Fil= eName]&size=3D[Size]&width=3D[ImageWidth]&height=3D[ImageHeight][/append] [= /FileInfo][/Listfiles] [listfiles] loops through all the files in the /imges folder; fileinfo chec= ks the image and gives you access to [FileName], [size], [ImageWidth], [Ima= geHeight],=E2=80=A6 which you store in the db using append... Noah Am 26.03.2016 um 14:28 schrieb Rich Kwas : 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 ma= ny 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 wid= th and height so that when a photo is chosen the w&h populate the gallery h= tml 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 [filein= fo] 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 w= ithout needing to view each one and then writing its fileinfo into a db. Thanks ---------------------------------------------------------This message is se= nt 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 se= nt 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 ------=_Part_1755125_782809982.1459259894688 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I was able to use exifto= ol to scan all images and generate a file with all w&h info in a databa= se format even....

I may have misunderstood how [fileionfo] works.

I always thought you had = to view the image in a browser window to get its width/height etc.
Just did a li= ttle test and I see now that's not the case.





=


On Tuesday, March 29, 2016 5:41 AM, Noah Valley <= ;valley@mac-web.ch> wrote:


Ri= ch,

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]
<= div class=3D"yiv7171843294">=09[FileInfo file=3D/images/[filename]]
=09=09[append db=3Dimages.db&Autonumbe= r=3Dimage_id]filename=3D[FileName]&size=3D[Size]&width=3D[ImageWidt= h]&height=3D[ImageHeight][/append]
=09[/FileInfo]
[/Listfiles]
<= /div>

[listfiles] loops through all the file= s 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
<= div class=3D"yiv7171843294">
Am 26.03.2016 um 14:28 schrieb Rich Kwas <richkwasnie= wski@yahoo.com>:

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

There are a few tho= usand photos used in a site, and the client populates many sliding gallerie= s within this site (photos change frequently). Currently the width and heig= ht are manually entered.

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

Currently using [lis= tfiles] to show an alphabetical list of all the photos, linking individual = photos to a page where that photo is shown with [fileinfo] showing its widt= h 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 the= m automatically without needing to view each one and then writing its filei= nfo into a db.

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

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


=
--------------------------------------------------------- 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 ------=_Part_1755125_782809982.1459259894688-- . Rich Kwas

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Carrying over data? (1997) Need WebDNA that crashes server for testing (2000) AJAX with WebDNA (2006) Credit Card not accepted (1998) [TaxableTotal] - not working with AOL and IE (1997) Help with Repost Data msg from form (1997) Leap of Faith (2001) Sample Tearoom Search Error (1997) Preventing Merchant Settling ? (1997) RequiredFields template (1997) Possible Bug in 2.0b15.acgi (1997) webcat and OS 8 (1997) [append] vs. [appendfile] delta + question? (1997) shipcost (1997) What if SSL server down? MAC (1997) docs for WebCatalog2 (1997) Make sure I understand this??? (1997) Mac Typhoon, WebCatalog Plugins Work Better With FireSite Now (1998) WebCat editing, SiteGuard & SiteEdit (1997) Caching [include] files ... (1997)