I've imported the attached CSV file using node import and it does not import all of the lines. While there are 102 lines in the file, only 91 of them are imported and no matter how I try to change the import file, the same 91 lines are imported and the same 11 are left out. I have multiple other CSV files with the same experience of importing only some of the lines and this is representative of the batch, but I cannot determine why some lines are imported while others are not. I thought it may have been due to the BuNo field that restricts the list to certain numbers, but lines that have been excluded are lines with valid numbers.
I realize you want only a small CSV file, but there seems to be no way to tell is such a small sample why this is occurring.
Another Attempt is the zip file containing the CCK content to which I am attempting to import the data.
Thanks in advance.
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | 160241.csv_.zip | 4.81 KB | geneatwell |
| #1 | Another Attempt .zip | 8.94 KB | geneatwell |
Comments
Comment #1
geneatwell commentedFiles did not seem to upload the first time.
Comment #2
Robrecht Jacques commentedCould you try -dev version? It has some fixes for the CSV parsing. If it is still an issue, I look into it further.
Comment #3
geneatwell commentedWill be happy to do so. Will let you know.
Update: The import using the -dev module brought all of the files over to my Drupal site and did not leave any out. Problem solved.
Two things I noted:
1. When I uploaded a file and proceeded to page 2 of the process, there are two files listed for each file I uploaded. One line shows the 'uploaded by' column with the name of the user who uploaded it and the second file with the exact same name shows 'Public FTPd file' in that column. Both files have the same upload date and time. The only difference is what's in the 'uploaded by' column. I uploaded 4 files and the results were the same for them all. It also made no difference whether I uploaded the file shown with the user name or the one shown as a Public FTP.
2. By having one of the fields in my CSV file listed as the file name of the photograph I want to upload, I am able to then access the page I created and the photo is shown correctly in my content. If I fail to put the files in the appropriate directory, then your wonderful program will not even attempt to upload that line of data and will continue to the next line, but if the file is in the correct directory, then everything is fine. Thus, I think, your warning about 'No upload (attachments)' under what does not work can be resolved.
UPDATED UPDATE:
Concerning number 1 above. The duplicate files were present on my local host using my MacBook with MAMP. When I used the same -dev module on my service provider's site, there was only a single file uploaded by the username and it imported all rows from the CSV file properly. Merci!
Comment #4
Robrecht Jacques commentedConcerning (1) : there was a bug in generating the list of "Public FTP'd" files that caused duplicated files to be present. This has been fixed.
Closing this issue.