gary.chan@e-crusade.com
-
8/17/2008 10:37:09 PM
File Import Module problem
Hi,
I have problems using the File Import module, will appreciate any help
What I wanted to do is to import a folder B with two javascript files into the CMS, under an existing folder A
Before import Root -- Folder A
After import Root -- Folder A -- Folder B -- script01.js -- script02.js
Problems (refer to attached images) 1. always return database error message : Some files can't be imported to given target. ([DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_VersionHistory ( [NodeSiteID], [DocumentID], [DocumentNamePath], [NodeXML], [ModifiedByUserID], [ModifiedWhen], [VersionNumber], [VersionComment], [ToBePublished], [PublishFrom], [PublishTo], [WasPublishedFrom], [WasPublishedTo] ) VALUES ( @NodeSiteID, @DocumentID, @DocumentNamePath, @NodeXML, @ModifiedByUserID, @ModifiedWhen, @VersionNumber, @VersionComment, @ToBePublished, @PublishFrom, @PublishTo, @WasPublishedFrom, @WasPublishedTo); SELECT @@identity AS [VersionHistoryID]: caused exception: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__CMS_Versi__Modif__72C60C4A'. The conflict occurred in database 'KenticoCMSDev', table 'CMS_User', column 'UserID'. The statement has been terminated.)
2. although error occured, can see the imported files in content tree, but with invalid property value on Page tab (blank file name and file size)
3. On property tab, the url of imported js file is a bit confusing, an .aspx ext added to the .js, such as "xxxxx.js.aspx" ? or has anything to do with setting site as DB mode only instead of local file? What url I should use if I want to include the js in other html head section?
4. furthermore, if copied the folder B (with files in it) to the "cmsimportfiles" folder and select to import both js script at once, it ends up something like following in content tree which is not right. Root -- Folder A -- Folder B -- script01.js -- Folder B -- script02.js
System Information CMS version : 3.1 Build : 3.1.3078 OS version : Microsoft Windows NT 5.2.3790.0
Thanks
|