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 = 112692
interpreted = N
texte = 275 --Apple-Mail=_BD92A75E-0DDC-44EE-AA09-CDC345454F8D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 [Shell] is for unix linux and mac. For Windows you'll need to use the = other command that escapes me at the moment. Someone else chime in here=85= Thanks for the info on the EXIF Tool. Sounds like a winner, and glad it = provided your solution. Terry On Mar 26, 2016, at 10:44 AM, Rich Kwas = wrote: > Terry, I did download your module a few days ago dealing with = something else.... >=20 > The installation of ImageMagick on my win7 desktop was going haywire, = downloaded and installed the latest.... all works well from the command = line, but I "still" can't get your module to work with it in my local = IIS setup... Probably a path issue, although all seems OK as I've been = staring at the setup. >=20 > The upload etc functions are all behaving....=20 > but I get this error at the top of the page when I try to resize an = image using your module: > [shell]/ImageMagick-6.9.3-Q8//convert uploads/1354764682549.jpg -scale = '500x500>' +profile "*" images/1354764682549.jpg[/shell] = [shell]/ImageMagick-6.9.3-Q8//convert images/1354764682549.jpg -scale = 100x100 -format jpg +profile "*" -unsharp 0x.5 = images/1354764682549_th.jpg[/shell] >=20 > Haven't tried it over at the actual server, but I'm guessing it might = behave the same way... I'll revisit that a bitb later today. >=20 >=20 > Regarding my issue with those thousands of images and the w&h .... >=20 > I downloaded ExifTool, and even though the docs are real messy I = finally got it to read and write to an output file the filenames and the = width and height of images..... Works pretty darn quick too. >=20 > ExifTool by Phil Harvey >=20 > ExifTool by Phil Harvey > A command-line application and Perl library for reading and writing = EXIF, GPS, IPTC, XMP, makernotes and other... >=20 >=20 >=20 >=20 >=20 >=20 >=20 > On Saturday, March 26, 2016 12:16 PM, Terry Wilson = wrote: >=20 >=20 > Rich - Go here: >=20 > http://www.webdna.us/page.dna?numero=3D173 >=20 > And download my ImageMagick module. It will do what you want. >=20 > Thanks Chris for putting the credit field back on the page! >=20 > Terry >=20 > On Mar 26, 2016, at 6:28 AM, Rich Kwas = wrote: >=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 >=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 >=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=_BD92A75E-0DDC-44EE-AA09-CDC345454F8D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 [Shell] is for unix linux and mac. For Windows you'll need to use the = other command that escapes me at the moment. Someone else chime in = here=85

Thanks for the info on the EXIF Tool. Sounds = like a winner, and glad it provided your = solution.

Terry

On Mar = 26, 2016, at 10:44 AM, Rich Kwas <richkwasniewski@yahoo.com>= ; wrote:

Terry, I did download your = module a few days ago dealing with something else....

The installation of = ImageMagick on my win7 desktop was going haywire, downloaded and = installed the latest.... all works well from the command line, but I = "still" can't get your module to work with it in my local IIS setup... = Probably a path issue, although all seems OK as I've been staring at the = setup.

The upload etc functions are = all behaving.... 
but I get this error at the = top of the page when I try to resize an image using your = module:
[shell]/ImageMagick-6.9.3-Q8//convert = uploads/1354764682549.jpg -scale '500x500>' +profile "*" = images/1354764682549.jpg[/shell] [shell]/ImageMagick-6.9.3-Q8//convert = images/1354764682549.jpg -scale 100x100 -format jpg +profile "*" = -unsharp 0x.5 = images/1354764682549_th.jpg[/shell]

Haven't tried it over at the = actual server, but I'm guessing it might behave the same way... I'll = revisit that a bitb later today.


Regarding my issue with = those thousands of images and the w&h ....

I downloaded ExifTool, and = even though the docs are real messy I finally got it to read and write = to an output file the filenames and the width and height of images..... = Works pretty darn quick too.









On Saturday, March 26, 2016 = 12:16 PM, Terry Wilson <terry@terryfic.com> = wrote:


Rich - Go here:


And = download my ImageMagick module. It will do what you want.

Thanks Chris for putting the credit field back = on the page!

Terry

On Mar 26, 2016, at 6:28 AM, Rich Kwas = <richkwasniewski@yahoo.com>= ; wrote:

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 to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webdna.us/l= ist/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/l= ist/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/l= ist/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 --Apple-Mail=_BD92A75E-0DDC-44EE-AA09-CDC345454F8D-- . 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)
275 --Apple-Mail=_BD92A75E-0DDC-44EE-AA09-CDC345454F8D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 [shell] is for unix linux and mac. For Windows you'll need to use the = other command that escapes me at the moment. Someone else chime in here=85= Thanks for the info on the EXIF Tool. Sounds like a winner, and glad it = provided your solution. Terry On Mar 26, 2016, at 10:44 AM, Rich Kwas = wrote: > Terry, I did download your module a few days ago dealing with = something else.... >=20 > The installation of ImageMagick on my win7 desktop was going haywire, = downloaded and installed the latest.... all works well from the command = line, but I "still" can't get your module to work with it in my local = IIS setup... Probably a path issue, although all seems OK as I've been = staring at the setup. >=20 > The upload etc functions are all behaving....=20 > but I get this error at the top of the page when I try to resize an = image using your module: > [shell]/ImageMagick-6.9.3-Q8//convert uploads/1354764682549.jpg -scale = '500x500>' +profile "*" images/1354764682549.jpg[/shell] = [shell]/ImageMagick-6.9.3-Q8//convert images/1354764682549.jpg -scale = 100x100 -format jpg +profile "*" -unsharp 0x.5 = images/1354764682549_th.jpg[/shell] >=20 > Haven't tried it over at the actual server, but I'm guessing it might = behave the same way... I'll revisit that a bitb later today. >=20 >=20 > Regarding my issue with those thousands of images and the w&h .... >=20 > I downloaded ExifTool, and even though the docs are real messy I = finally got it to read and write to an output file the filenames and the = width and height of images..... Works pretty darn quick too. >=20 > ExifTool by Phil Harvey >=20 > ExifTool by Phil Harvey > A command-line application and Perl library for reading and writing = EXIF, GPS, IPTC, XMP, makernotes and other... >=20 >=20 >=20 >=20 >=20 >=20 >=20 > On Saturday, March 26, 2016 12:16 PM, Terry Wilson = wrote: >=20 >=20 > Rich - Go here: >=20 > http://www.webdna.us/page.dna?numero=3D173 >=20 > And download my ImageMagick module. It will do what you want. >=20 > Thanks Chris for putting the credit field back on the page! >=20 > Terry >=20 > On Mar 26, 2016, at 6:28 AM, Rich Kwas = wrote: >=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 >=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 >=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=_BD92A75E-0DDC-44EE-AA09-CDC345454F8D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 [shell] is for unix linux and mac. For Windows you'll need to use the = other command that escapes me at the moment. Someone else chime in = here=85

Thanks for the info on the EXIF Tool. Sounds = like a winner, and glad it provided your = solution.

Terry

On Mar = 26, 2016, at 10:44 AM, Rich Kwas <richkwasniewski@yahoo.com>= ; wrote:

Terry, I did download your = module a few days ago dealing with something else....

The installation of = ImageMagick on my win7 desktop was going haywire, downloaded and = installed the latest.... all works well from the command line, but I = "still" can't get your module to work with it in my local IIS setup... = Probably a path issue, although all seems OK as I've been staring at the = setup.

The upload etc functions are = all behaving.... 
but I get this error at the = top of the page when I try to resize an image using your = module:
[shell]/ImageMagick-6.9.3-Q8//convert = uploads/1354764682549.jpg -scale '500x500>' +profile "*" = images/1354764682549.jpg[/shell] [shell]/ImageMagick-6.9.3-Q8//convert = images/1354764682549.jpg -scale 100x100 -format jpg +profile "*" = -unsharp 0x.5 = images/1354764682549_th.jpg[/shell]

Haven't tried it over at the = actual server, but I'm guessing it might behave the same way... I'll = revisit that a bitb later today.


Regarding my issue with = those thousands of images and the w&h ....

I downloaded ExifTool, and = even though the docs are real messy I finally got it to read and write = to an output file the filenames and the width and height of images..... = Works pretty darn quick too.









On Saturday, March 26, 2016 = 12:16 PM, Terry Wilson <terry@terryfic.com> = wrote:


Rich - Go here:


And = download my ImageMagick module. It will do what you want.

Thanks Chris for putting the credit field back = on the page!

Terry

On Mar 26, 2016, at 6:28 AM, Rich Kwas = <richkwasniewski@yahoo.com>= ; wrote:

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 to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webdna.us/l= ist/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/l= ist/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/l= ist/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 --Apple-Mail=_BD92A75E-0DDC-44EE-AA09-CDC345454F8D-- . Terry Wilson

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:

Emailer (WebCat2) (1997) Form/HTML Help (2000) Which is Faster (1998) Online reference (1997) % (mod) was looping table rows (1999) Sorting error (1997) problem with applets embedded in tpl files (1997) ThreadMem ignored? (1998) Fishing: anyone on this group willing to do support? (1998) WCS Newbie question (1997) Sku numbers (1997) Forms Search Questions (1997) WEBCAT HIERARCHY (1999) Searching for foreign chars (2004) [WebDNA] Gulf Coast WebDNA programmers (2010) Updating a database once per day - An example (1998) WebCatalog for Postcards ? (1997) Re(8): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) Image Pirating [protecting against] (2003) Timeout question .. (2003)