This old help db article might offer some light:
pay attention to: GetAsText ( Images); which returns a file path of the reference stored in that field, looking something like: imagewin:/Z:/Employees-Personnel/Photos employee linked to fm/HILPAL - Palmer Hill 09.25.11.jpg
To get the true path, all you need to do is trim the left part off:
Right ( GetAsText ( Images) ; ( Length( GetAsText(Images) ) ) - 10 )
So, basically I think the process would be (and easier if you started in 11 before you convert to 12):
1) Import all the files into the database container fields itself for each record.
-This can be done with the "insert file" script step, inserting from the calculated reference above:
2) Convert the file to v.12 (all the files stored internally will convert to the new container format)
3) Once hosted in 12, THEN you can change the container data to be stored externally again.
Thanks for the help. When I do get as text for the image I get three lines of info separated by returns. I'm not sure how to parse out the third line "imagewin:/Z...." so that I can trim off the "imagewin:.." part.
I'm sure that collecting the third line only is a pretty basic step...just not sure how to do it.
In our case, all of our files are stored on the "Z" drive. Is there a way to collect text from the Z and whatever is to the right?
You can get a single line of a return delimited list with GetValue(). I've also split it to a let function below, which is useful for spreading things out so they make sense, make sure to learn Let(), it's super useful.
Let ( [
line = GetValue ( GetAsText ( Images) ; 3 );
length = length (line)
right ( line ; length - 10 )
yes, the above does that.