Exporting pics to excel from Navision

ramsay18477

Hi All,

Can we export pictures from Navision to excel similar to exporting data ?

Also, can we export formula instead of value from Navision to excel ?

If the answer to any or both of the above queries is yes, please guide me.

Thanks.

garak

yes it's possible. Export the picture (Picture.export(PATH)) to a specific folder and import these in your excel sheet.
Also the furmula (Like B5 = SUM(A1:A5)) is possible.

Do you have take a look into the source of table "Excel Buffer" :?:

Regards

Savatage

another post
viewtopic.php?t=682

ramsay18477

Hi Garak,

Thanx a lot.

Export the picture (Picture.export(PATH)) to a specific folder and import these in your excel sheet.

But, I have to export the pics of many items (maybe 50 or 100) since Iam trying to generate a price list in excel from Navision.

Do you have take a look into the source of table "Excel Buffer"

I did look into the "Excel buffer" table design and since I couldn't find any field with datatype BLOB, I posted this query here.

Do I Have to add a BLOB field to the excel buffer ?



Hi Harry,

Thanx to you too.

I went thro' the post.

Iam using automation to generate excel sheet using the excel buffer.

But, I cannot figure where exactly do put the code that is mentioned in the post.

Anyway, we would need a BLOB field in excel buffer and a BLOB parameter in the function which does the export to excel, right ?

As I mentioned earlier, Iam generating a price list in excel by exporting data from Navision in many columns and trying to export pics as well simultaneously with the data.


Thanx again.

Savatage

Check all these - they all mention exporting pics/images &/or logos using the buffer
viewtopic.php?t=927
viewtopic.php?t=8356
viewtopic.php?f=14&t=11505
viewtopic.php?t=682
viewtopic.php?f=1&t=661

I assume all your pics are stored in Item.picture blob field??

I've never got it towork myself - I pulling into different projects. I've never seen a step by step explanation just code snipits. It would be nice to know where to put the code and how to call it correctly.

garak

Hey "Sava", you forgott this post ;-)

viewtopic.php?f=23&t=27187

@ramsay18477:
To learn more about the table EXCEL Buffer, take a look into Report "Export Acc. Sched. to Excel" (its behind Form 490).
Your pictures are stored in the item table in field picture. So, this field you must calculate and store in a folder. Follow the link which i've posted.
An other user ask this some times ago and he become the solution ....... ;-)

Regards

ramsay18477

Hey Thanks a lot guys!!!