Forgot password? | Forgot username? | Register

Multimedia Import - long file names causing error

Multimedia Import - long file names causing error

Hi -
I am importing a few thousand photos and I am encountering the issue (I think) where if an image filename (and therefore filepath) is too long - the system cannot read/locate it. It then spits out the error message that those particular files do not exist. I have moved the files to a top-folder drive location to remove excess characters in the filepath and I am still getting the error. How many characters is the import search limited to - and what can I do to extend that or what options do I have to rename a few thousand image files and corresponding lines on the import sheet? thanks!

Zenobia Kozak
Data Collections Manager
useravatar
Offline
4 Posts
Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Multimedia Import - long file names causing error

Hi there

I'm interested in this as well - we are currently not using import for multimedia as staff find it too time-consuming to develop the sheet - any tips would be appreciated.

Ngā mihi,

Kirsty Cox
Research Librarian, Digital Materials (Arrangement & Description)

Kirsty Cox
EMu Administrator
useravatar
Offline
2 Posts
Female  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Multimedia Import - long file names causing error

Hi Zenobia!

I've imported lots of images and have never experienced this problem. How long are the file names? Have you had success with imports before? (It sounds like maybe some are working and others aren't but I didn't want to assume.)

Cheers,
Travis

Travis Snyder
Collections DB Admin
useravatar
Offline
6 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Multimedia Import - long file names causing error

Hi Zenobia and Kirsty,

The field used for the file name has a field length limit of 255 characters. This limit is retained for compatibility with Crystal Reports as longer fields are treated as LONGCHAR (memo).  Such field types have limited usage in Crystal Reports and cannot be used in formulas and cannot be formatted.  The field length can be increased but may cause reports to no longer work.

Could you please provide examples of filenames that are proving to be problematic or email the csv file to me, Gulhan.Atlihan@axiell.com?

Kind regards,
Gülhan

Gulhan Atlihan (Axiell Melbourne)
useravatar
Offline
11 Posts
Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Multimedia Import - long file names causing error

Hi Travis!

Thanks for the response. I have had success with smaller imports before...and it's strange that SOME of the imports on this particular import sheet are working and others are coming back with this error - despite all the files sitting in the same location on the drive and the file names matching up. The filepath/filenames are under 255 characters so my colleague's theory about EMu truncating the filepath during it's search doesn't make sense now...Going to try it again this week. Wish me luck!

Zenobia Kozak
Data Collections Manager
useravatar
Offline
4 Posts
Website 
Administrator has disabled public posting. Please login or register in order to proceed.
There are 12 guests and 0 other users also viewing this topic

Board Info

Board Stats
 
Total Topics:
599
Total Polls:
0
Total Posts:
1362
User Info
 
Total Users:
814
Newest User:
Paul
Members Online:
3
Guests Online:
201