Bulk upload via MySQL

  • Resolved goldenmoon

    (@goldenmoon)


    7 years, 9 months ago

    Hi Jacob,

    I am shifting my gallery to wordpress (a long pending process which i am picking up again) and using your wonderful creation WPPA. My current website has thousands of images, so adding them manually with all data would be too painful.
    As there are no standard import scripts I was thinking of using a csv file and importing via PHPMyAdmin the table “wp_wppa_photos”. I think there should not be a problem in that.
    Would like to know in what format are the dates in the “timestamp” and “modified” field?

    Please do advise.

    Thanks in advance.

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

    (@opajaap)

    Copied the files again and imported again, this time pressing the ‘update’ button
    the other fields got added.

    Not needed. Importing photos (files) is totally independant of importing their metadata.
    You can import metadata (.csv files) only on existing photos.

    What the difference between the 2 buttons “update” and “start import”

    – Import imports new photos.

    – Update updates the photofiles with possibly new versions.

    You can import or import/update as many times as you want until your web space is full.

    Thread Starter goldenmoon

    (@goldenmoon)

    One hitch, how do you escape the delimiter?

    I have some “,” in the custom fields. If I add them as is in the csv file then there would be and error in the data updates as csv uses “,” as a delimiter.
    How do i work around this?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Items containing , should be enclosed in double quotes “. Example:

    one,two,"three,four",five is 4 items

    Double quotes inside items must be doubled end item enclosed in double quotes

    "this is an item wit a "" inside it"

    ""Double quoted item""

    See also:
    https://en.wikipedia.org/wiki/Comma-separated_values

    Thread Starter goldenmoon

    (@goldenmoon)

    Thanks.
    Didnt realise it would be a csv formatting issue

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘Bulk upload via MySQL’ is closed to new replies.