Agent for information

Ask for Help
42

Thank you. Will look into it.

43

How about extracting info from an image, any clues? Been trying to look for a JavaScript for it but Iā€™ve not been ableā€¦:frowning:

44

What type of info do you want to extract?

I suspect if you pass it from URL then you will get into massive troubles with CORS.

45

Youā€™ve not been looking hard enough :stuck_out_tongue:

Has Mark asked you to replace my exif extraction code with a YC column? (would be a good idea, if it can be done)

46

I have, Iā€™m just not good at coding, I did that exact search, but I just donā€™t get it!! :grinning: And no, he hasnā€™t

47

Camera used to take the image, location, time, etc

48

Well, with Apps Script, itā€™s as simple as:

var metadata = file.imageMediaMetadata;
49

Take a look at this page:

50

Are you serious?

51

Hey Manu, I looked at that specific thing, but itā€™s over a 1000 lines of code, and itā€™s too much for a little understanding of js

52

Yes.
For the Covessa app, the images are stored on GDrive. Here is the entire routine that I use for extracting the image metadata:

function get_image_metadata(id) {
  var file = Drive.Files.get(id);
  var metadata = file.imageMediaMetadata;
  return metadata ? metadata : {};
}

See Files Ā |Ā  Google Drive API Ā |Ā  Google Developers

53

He showed me the integromat scenario that you created, which I guess is what you are mentioning. Iā€™ll try to put your script in the yc column

54

Update,
I added the language used by the browser.

image

55

you are the bestā€¦ already using that!

56

Yes I use it to define the date format and for the translation

57

Iā€™m using it to translate my apps for usersā€¦ time format might be tricky for big countries with many time zones

58

Hola Manu,

I have been working and improving my codes base on date format (sorting arrays) and this map and info were very useful to me.

Try to use the browserā€™s language is a good point and tool but I think that working with Endianness order is the final solution to date format sorting.

B ā€“ big-endian (year, month, day), e.g. 2016-04-22 // 2016.04.22 // 2016/04/22
L ā€“ little-endian (day, month, year), e.g. 22.04.2016 // 22-04-2016
M ā€“ middle-endian (month, day, year), e.g. 04/22/2016

Saludos!

59

Hi, Thank you for the information. I published a script on the topic of dates.
The idea is to convert the glide date (whatever the language and format) into a JS date to be able to easily sort or compare.

60

Yes I know, I shared my own code in that thread as well :rofl:

Now I have a new version able to sort any date array if the user has the following format:
1- mm/dd/yyyy
2- dd/mm/yyyy
3- dd-mm-yyyy
4- dd.mm.yyyy

I havenā€™t included other formats (e.g. yyyy-mm-dd) in order to not complicated the code but if I have to do it, I would use the Endianness code (B/M/L) to know the right date format used by user.

Feliz dĆ­a

61

I meanā€¦

image
image745Ɨ546 36.6 KB 

let f = s=>['B','L','M'].map((v,i)=>
  [b<13&c<32,b<13&a<32,a<13][i]?v+'':'',[a,b,c]=s.split`/`).join``

return(f(p5))

In my case, all my date values are L ā€“ Little-endian therefore, my current date format is dd/mm/yyyy (day/month/year).