stephan schneider
Gold Membership
Ventrian Addict
Posts:73
 |
| 6/14/2009 5:29 AM |
|
Hi I have a little problem with the Upload of files, which have long file names (more than 100 signs).
I can Upload the files, but the Name is cut after 100 signs and the "Date Modified" is set wrong to 1/1/0001 12:00:00 AM. Is there any change to handle/fix this?
A great enhancement would be to have an optional, additional description text for the uploaded files.
Thank you for your help! |
|
Greetings from Germay,
Stephan Schneider
Schneider-IT
 | partner of:
 | partner of:
 | member of:
 |
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 6/14/2009 7:47 AM |
|
The date modified comes directly from the file - what does it have on it?
I haven't tested a 100 characters on a file item, the database column may need to be extended. |
|
Scott McCulloch
Site Administrator |
|
|
stephan schneider
Gold Membership
Ventrian Addict
Posts:73
|
| 6/14/2009 12:59 PM |
|
The modified date was today. I also tested this with older files. When the name hast more than 100 characters the filename is cut an the modified date is set to 1/1/0001 12:00:00 AM.
Which colums do you mean? dbo.files? I set this from nvarchar(100) to nvarchar(max), but the problem still is there. It would be no problem if the name was cut after e.g. 90 characters if the rest would work. |
|
Greetings from Germay,
Stephan Schneider
Schneider-IT
| partner of:
| partner of:
| member of:
|
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 6/15/2009 4:36 AM |
|
| The stored proc would have nvarchar(100) in it (likely). You would also need to change this. |
|
Scott McCulloch
Site Administrator |
|
|
stephan schneider
Gold Membership
Ventrian Addict
Posts:73
|
| 6/15/2009 8:18 AM |
|
I also changed the stored Procs I found for the files, but still the same problem. Ieverythings to nvarchar(MAX). Maybe I just did not get everything I needed? |
|
Greetings from Germay,
Stephan Schneider
Schneider-IT
| partner of:
| partner of:
| member of:
|
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 6/16/2009 8:04 AM |
|
| Ok - I'll need to look at the issue to see what is missing. |
|
Scott McCulloch
Site Administrator |
|
|
stephan schneider
Gold Membership
Ventrian Addict
Posts:73
|
| 7/06/2009 3:19 AM |
|
Anything new about this? |
|
Greetings from Germay,
Stephan Schneider
Schneider-IT
| partner of:
| partner of:
| member of:
|
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/06/2009 7:46 AM |
|
Hmm, looking at the module it uses the DNN core API to list files:-
Dim objFiles As ArrayList = FileSystemUtils.GetFilesByFolder(PortalId, _folderID)
For Each objFile As DotNetNuke.Services.FileSystem.FileInfo In objFiles
I think I have found the problem, DNN only stores 100 characters for file name. How do they appear in your file manager? |
|
Scott McCulloch
Site Administrator |
|
|
stephan schneider
Gold Membership
Ventrian Addict
Posts:73
|
| 7/06/2009 8:00 AM |
|
The filenames are cut exactly after 100 characters. I think this is not the best way to handle this. I am aware that such long filenames are not very good, but now we habd several clients which have file with longer names. It would not be such a great problem, if only the name was cut, but also the file-extension is cut. If you would find any solution which can handle this without touching the DNN Core, this would be great. |
|
Greetings from Germay,
Stephan Schneider
Schneider-IT
| partner of:
| partner of:
| member of:
|
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/06/2009 8:11 AM |
|
The only way I could think is to store it in a meta data table that stored the full name and linked across to the file in the DNN table.
The problem with this approach is that if the file was renamed elsewhere in DNN, the file name might no longer be applicable. |
|
Scott McCulloch
Site Administrator |
|
|
stephan schneider
Gold Membership
Ventrian Addict
Posts:73
|
| 7/06/2009 8:52 AM |
|
Why not? This could open another feature. By a renaming of the files in the library to an extension that is not directly accessible through a browser (e.g. resx) the files could be protected from direct download. I saw this in other Modules as well as optional function. |
|
Greetings from Germay,
Stephan Schneider
Schneider-IT
| partner of:
| partner of:
| member of:
|
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 7/07/2009 8:36 AM |
|
The file extension in the core tables is 100 characters which should be OK.
I'll need to re-look at this item. |
|
Scott McCulloch
Site Administrator |
|
|