0

Importing Image Files

I have a very simple table that contains an image field and a number field.  The images are intended to be scans of magazine covers (120 of them) and the number field is the "issue" number.  I have all the magazine covers scaned as jpg files and located in a single folder.  I'm looking for a way (short of doing it manually record by record) to get Ninox to import all the image files, making a new record for each.  Let me apologize beforehand if this has already been addressed here, but I've tried to find it and have only found references to importing tabular data and "attachments," neither of which seems applicable to what I'm attempting to do.

Thanks,

Gary

11 replies

null
    • Leonid_Semik
    • 5 yrs ago
    • Reported - view
    • garytreible
    • 5 yrs ago
    • Reported - view

    Thank you, but this imports image files into something called an "attachment".  What I want is to import image files into an image field.  Can attachments be block-copied into image fields?

    I have to confess to being a bit confused at this point.  Batch importation of image files seems to me to be a very standard and common database activity.  It shouldn't require downloading a special program and understanding regex file searches.  This leads me to believe that I'm not asking the question properly.

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    I am not a developer, only a user. As far as I know, there is only one way to perform the file import. I suppose you've got it. The pictures are now in Ninox as an attachment.

    1. Create a textfed Filename
    2. Create a list in Excel (Ninox ID, Filename)
    3. Import this list to Ninox, leaving Ninox ID as the key
    4. with Update multiple records you can now assign calculate value:

    ---

    Image := Filename

    ---

    Regards

    Leo

    • garytreible
    • 5 yrs ago
    • Reported - view

    Thank you Leo!  Much appreciated.

    • Wireditpro
    • 5 yrs ago
    • Reported - view

     I am trying to update an image feel using the parameters from a number field Using logic formula. Here is the formula that I am using but the only thing that it is putting into the image file is a text string. I do know that I have the image file represent it as a text  string  but is the only way that I have been able to put it in that  it does not come back as an error.  Below is the code I have written. If anyone knows how to represent an image correctly so that it’s at places  it in the image Field that would be great. 

    if 'Tomatoe Rating' <= 59 then
    Image := "A7/Splat.jpg"
    else
    if 'Tomatoe Rating' >= 60 and 'Tomatoe Rating' <= 79 then
    Image := "A7/Fresh.jpg"
    else
    if 'Tomatoe Rating' >= 80 then
    Image := "A7/CertifiedFresh.jpg"
    end
    end
    end

    • Wireditpro
    • 5 yrs ago
    • Reported - view

     I forgot to mention a7/is the directory that was returned when I used the raw function. 

     

     Thanks in advance 

    R Michael Walker

    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    Hi Michael,

    you can display images only if they are attached to the record. If you attach the three files to all records this would work.

    Attached images are displayed in the image field if it contains the file name. This could be done via a trigger and your formula. But it will be only displayed if you have attached the image file.

    Another method would be to display the image in a formula. There each record should be linked to another table and record where the images are attached.

    Let me know if this helps.

    Best regards, Alex

    • Wireditpro
    • 5 yrs ago
    • Reported - view

     So another words, I could set up a table named tomatoes ratings images and have and it only the field with images in it  named TImage. It would only have three records in it. One for each of the images that I want to use.  Then all I would have to do as reference the particular record ID  of that particular image I wish to display, in  The formula that are used in the  table that I want the image to display in. I of course would have to say for instance; Image := ‘tomatoes ratings’.

    • Wireditpro
    • 5 yrs ago
    • Reported - view

    TImage

    • Wireditpro
    • 5 yrs ago
    • Reported - view

    Sorry about the two different postings, I accidentally hit the post button before I was finished. Anyway Am I understanding your suggestion correctly?

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Hi Michael,

    Your Images are all attached?
    try your formula without "A7", so:

    if 'Tomatoe Rating' <= 59 then
    Image := "Splat.jpg"
    else
    if 'Tomatoe Rating' >= 60 and 'Tomatoe Rating' <= 79 then
    Image := "Fresh.jpg"
    else
    if 'Tomatoe Rating' >= 80 then
    Image := "CertifiedFresh.jpg"
    end
    end
    end

    ---

     

    Regards

    Leo

Content aside

  • 5 yrs agoLast active
  • 11Replies
  • 8988Views