excel file import problem (image in cell)

[stan111]

Gents, 

there is a price list in Excel with images embedded. Do you have an idea how to import those records into DB with corresponding images preserved?

Note that I've attached only two records, there are 600 of them. Any manual manipulations with the images is not an option.

 

price.xlsx

Edited July 3, 2020 by stan111

[Wim Decorte]

Note that in excel, the picture doesn't belong to the cell, it just 'floats' on top of the worksheet.  The only way to get those out is to write code inside excel or that can talk to the excel APIs to try and save the pictures to the hard disk to then insert them into FM.

[stan111]

*******, it's a monkey job

[Wim Decorte]

Or go find the system where they get this data from and see if you can integrate directly with the source?

[stan111]

Wim, 

I'm not sure I can find it. In the meantime, is it possible to scrape data from a website using FM?

[comment]

You CAN import the images independently, but you will have to manually re-associate them with their original records. Here is one way to do it:

1. Make a copy of the Excel file; 
2. Rename the copy with .zip extension;
3. Unarchive the .zip;
4. Inside the archive, there will be a folder named media inside a folder named xl. Import the images from this folder.

 

4 minutes ago, stan111 said:

is it possible to scrape data from a website using FM?

Depends on the web site. 

Edited July 3, 2020 by comment

[Wim Decorte]

13 minutes ago, stan111 said:

is it possible to scrape data from a website using FM?

Sometimes; but:

1) it is usually very fragile - any small update to the website can totally break your 'integration'

2) very often it is not allowed

[stan111]

Thanks, gentlemen!