Runtime and changing File reference

[AudioFreak]

Hey Guys,

We have a Inventory file that I need to send off to a few engineers as a runtime so they know what electronic components we have in stock. Creating the runtime is easy but within the inventory I also have the Components PDF stored as a reference for each component.

How can I change the reference that is stored in the container field? I tried to do a replace and change it that way, but can't do that on a container field. The file has approx 3500 records with about 1000 pdf's referenced. Current mapping looks as follows,

filewin://Hd-htgl5e9/share/PDF LAND/SemiConductors/1N4728_1N4764_Zeners.pdf

Maybe import the actual pdf into another container field so it lives within the runtime?

Just basically want to tell them put the runtime on your desktop and put the pdf folder in your C drive. Or maybe as I mentioned maybe importing the actual file is best way.

This isn't something we have to do daily but will need to be done 2x a year or so.

Any ideas are greatly appreciated.

Thanks,

Michael

[AudioFreak]

No takers huh....lol.

The pdf either needs to be imported to a field and stored within the file(Before I make the runtime). Or change the reference so that the pdf can be moved to another location.

The pdf is currently being opened via a script using select/perform on the container field.

I have an idea I will try tomorrow, but any suggestions can't hurt

Michael

Edited August 8, 2007 by Guest

[AudioFreak]

Well for what it's worth I did manage to fix this problem. I used a calc that Shadow posted helping someone else on these forums. I altered the calc as below and added it to a field named Local_Filepath

Let( eqPos = Position ( File_Path_calc ; "/p" ; 1 ; 1 );

Right( File_Path_calc; Length(File_Path_calc) - eqPos )

)

That returns a value in the Local_Filepath Field as

PDF LAND/SemiConductors/1N472 8_1N4764_Zeners.pdf

Which I then created a script that looped through the file setting the container field with this

Set Field[inventory::PDF_Location; "C://" & Inventory::Local_Filepath]

They then just need to put the PDF folder in their C drive. They can now open the pdf using the Open URL script step.

Might not be the easiest way to do it but it worked.

Michael