Exporting My Upc Bar Code Images

[Ashal]

Hello Everyone,

I've created an inventory database that manages all my products and will generate my new UPC codes. I've created a container and have pulled the Bar Codes i.e. the image of the bar code, from a url into FM. I now need to export the images into excel along with their corresponding SKU and UPC Code so that I can send this information off to the factories. I'm not a programmer but I'm not completely FM ignorant. I've just never dealt with images before so I'm lost on how to do this. I've read that I need to do a Script (which I've very familiar with within the scope for what I've had to do thus far) using Set Variable and Export Contents but when I went to do this, it was total Greek. Never done Set Variables or Export Contents before. I read what was in the Help section and again, Greeek. Is there anyway someone could please walk me through this a little slower?

Chad

[tachyon]

I have a similar situation - I generate my barcode labels within filemaker using a barcode plug in and need to save the individual formatted labels as pdf for our factory/printer. I cannot save/send the codes as pdf because the codes do not save correctly - they get broken up. I can, however, print the codes to pdf. Printing a group of labels to pdf makes a single multi page pdf which I split in acrobat giving me a bunch of files named g_Part1.pdf, g_Part2.pdf... g_Part42.pdf &c. To rename the files to their product code or barcode number I have built a fmp utility which works as follows:

Firstly, I have a record number field in my barcode labels database which I set with a simple script to number each record consecutively from a preferred start number ending in '01'; these numbers must be unique within the database and the last digit of the first record must be '1'. Then, after I split the multi page pdf I import the files to the utility which has a calculation field that filters the number out of the imported file name and adds the previously mentioned starting number minus one to it. This field has a relationship to the record number field in the barcode file which provides the product code or other information as required to rename the labels to which is added '.pdf' (barcode name changer::export_file_name). The resulting field contains the required file name for each of the barcode label records. After that I export the files to a desktop folder (to save building complex export paths) with a scripted path that looks like:"filemac:" & Get ( DesktopPath ) & "/" & barcode name changer::export_folder_name & "/" & barcode name changer::export_file_name. The 'export_folder_name' is a field that I enter the name of the folder I want to export to (which in this example must be on the desktop)

I have all that scripted into an import button and an export button - two clicks and the job is done. Even so, it still seems a bit longwinded.

I don't suppose that helped you one bit as it seems to me there must be an easier way and if anyone knows what it is I'd be delighted to hear from them.

I'll give the export to excel thing a go and let you know if I have a win.

Cheers

Roger