Conditional logic when importing the CSV?

  • Resolved DTECHNZ

    (@deardevils)


    5 years, 11 months ago

    I love this plugin, so powerful and everytime when new release comes, more featured functions come too. Great job team.

    Just asking, is it possible to have a conditional logic to filter the column when importing?

    For example, if a column value = “xxx”, skip this row.

    Also, is that possible to mapping the heading? For example, mapping the meta tag name in the heading and match the csv file heading, so that we don’t need to change the csv’s heading everytime before uploading?

    Hope can hear from you soon.
    Cheers

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Javier Carazo

    (@carazo)

    5 years, 11 months ago

    @deardevils,

    I answer you inline:

    Just asking, is it possible to have a conditional logic to filter the column when importing?

    For example, if a column value = “xxx”, skip this row.

    No, maybe you can use some of the hooks we provide but we do not implement nothing like it.

    Also, is that possible to mapping the heading? For example, mapping the meta tag name in the heading and match the csv file heading, so that we don’t need to change the csv’s heading everytime before uploading?

    I don’t understand it very well. What you need is to able to maps head in order to avoid changing the headers to the one which appear in the database?

    Is that right?

    Thread Starter DTECHNZ

    (@deardevils)

    5 years, 11 months ago

    I have figured out the top questions.
    Just another question sorry.
    My CSV exports from a local system, and it cannot be re columned.
    Because it will be a cron job, so I am having trouble to put the email column to the 2nd column as described.
    It there any way to archive this?
    Thanks heaps for your help.

    Plugin Author Javier Carazo

    (@carazo)

    5 years, 11 months ago

    @deardevils,

    No sorry currently there is no possibility to do it.

    But yes, this is a feature that we should achieve in a future.

    Regards,

    Javier

    Thread Starter DTECHNZ

    (@deardevils)

    5 years, 11 months ago

    Thanks.

    Thread Starter DTECHNZ

    (@deardevils)

    5 years, 11 months ago

    I hardcoded the email to read column 13, $email = $data[12];, which matches my CSV, now all good.

    Last problem is I cannot generate an empty column for password from the PC software, so I need to find a work around.

    Plugin Author Javier Carazo

    (@carazo)

    5 years, 11 months ago

    Stay tuned to updates because we will solve it soon.

    No need to have always username and emails in first two columns.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Conditional logic when importing the CSV?’ is closed to new replies.