Custom Fields Bulk Import

  • Resolved johnny mosaic

    (@johnny-mosaic)


    6 years, 1 month ago

    I understand how to do custom fields bulk import. it keeps skipping my import. please advise.

    photoname, My Row, My Column
    Samuel Dunn Loves Learning.jpg, 1, 18
    Aaliyah Herring.jpg, 3, 17

    Some of my files were imported before the hyphen issue, others after. In my photoname space they all look like this “Samuel Dunn Loves Learning”. In filenames some look like Aaliyah-Herring.jpg and others look like Samuel Kuszniaj.jpg

    I also tried it by removing the .jpg extension from the csv file. Still skips.

    I tried name as the search, still skips.

    Why is it skipping them all?

    The page I need help with: [log in to see the link]

Viewing 15 replies - 1 through 15 (of 19 total)
  • Plugin Author Jacob N. Breetvelt

    (@opajaap)

    The Photoname: as seen on the Photo ALbums -> Album Admin -> Edit -> Manage Photos – Edit photo information, must be identical to the the photoname in the csv file.
    If the photo name in the .csv file contains spaces, it must be enclosed in double quotes:
    e.g: the line in the csv file reads: "Samuel Dunn Loves Learning.jpg",1,18 if the photoname is Samuel Dunn Loves Learning.jpg

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    I did that and it still skips all files…

    i tried changing criteria to photoname and also tried name. Both still skip.

    photoname,My Row, My Column
    “Samuel Dunn Loves Learning.jpg”,1,18

    Skips all.

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    i also tried it as “Samuel Dunn Loves Learning”,1,18
    without the .jpg extension

    still skips all

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    – Run the proc in Table VIII-B8: Remove file-ext
    First, to get your database consistent:
    – Run the proc in Table VIII-B20: Remove hypens from photonames
    – Set Table IX-D13: Default photo name to Filename without extension spaces for hyphens

    Now, to get your .csv file consistent: remove the file-extensions like .jpg

    Then:

    photoname,My Row, My Column
“Samuel Dunn Loves Learning”,1,18

    should work now.

    I tested it on my dev site and it works, even without double quotes (they are only needed when the item itsself contains comma’s (,) or double quotes (they should be doubbled as well, like “This is a “” quote in a field”. However, double quotes around an item are always allowed, so you do not need to remove them as long as you are sure they are simple double quotes, not the textified ones like “”, but ""

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    i did all you directed and still it skips all files when import.

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Does it skip files or lines from the .csv file?
    Is there an errormessage (also see the wppa log in Table VIII-C1)

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Another question:

    Where is the .csv file located?

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    Processing files, please wait… If the line of dots stops growing or your browser reports Ready, your server has given up. In that case: try again

    Done processing files

    1 CSVs imported, 0 items processed. 606 items skipped.

    Csv is in the depot

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    Processing clar8888888888888888888888888888888.csv
    Read header: Photoname,My Row,My Column

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    There isn’t any errors today on this…

    The last entry log is as follows…

    Obs: on:12.10.2018 07:13:24: faces: Maintenance proc wppa_remove_file_extensions started. Allowed runtime: 5s.
    Obs: on:12.10.2018 07:13:26: faces: Maintenance proc wppa_remove_file_extensions completed
    Obs: on:12.10.2018 07:13:45: faces: Maintenance proc wppa_photos_hyphens_to_spaces started. Allowed runtime: 5s.
    Obs: on:12.10.2018 07:13:47: faces: Maintenance proc wppa_photos_hyphens_to_spaces completed

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    Is there a way I can email you my CSV excel file? maybe you’ll see something in it that I’m missing..

    Where should I send it or upload it? If you want it?

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    i sent you the file to [email protected]

    check spam folder? from facesof…

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Thanx, i received the file, and will have a look tomorrow.

    Thread Starter johnny mosaic

    (@johnny-mosaic)

    ok ??

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Is the photo name really "Samuel Dunn Loves Learning"
    or is it Samuel Dunn Loves Learning

    What is the filename in this case? Is it Samuel-Dunn-Loves-Learning.jpg ?

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘Custom Fields Bulk Import’ is closed to new replies.