Categories
Add a reply View Replies (7)

Resolved Run action on newly uploaded email addresses

  1. webstar
    webstar
  2. Pre-sale questions
  3. Friday, 23 June 2023
  4.  Subscribe via email
Hi I was wondering If I could user ROCSVI to upload a list ofer emailaddresses. Once uploaded Id like to execute some db queries on each email address. Eg I want to update a virtuemart user infos table for the corresponding userID for each emailaddress.
I dont want to actually import anything.

What should be my first step - do I simply create an import override file? that prevents an import from happening? then inject my code?
0
Accepted Answer
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

This is quite an intriguing question :)

What should be my first step - do I simply create an import override file? that prevents an import from happening? then inject my code?
What I would imagine is that you would set the Overwrite existing data to No, and Skip new Items to Yes so no new items are created. You write your own rule plugin and assign that to the emailaddress field in your list.

In this rule you can write the queries that you want to perform.

Which import you choose does not really matter because nothing gets imported anyway.

Is that something you can work with?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # Permalink
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I was wondering If I could user ROCSVI to upload a list ofer emailaddresses.

Are you are uploading these email address to a custom table? If yes you can use RO CSVI custom table import to import email address.

What should be my first step - do I simply create an import override file? that prevents an import from happening? then inject my code?

Yes you need to create an override file and write custom code. But If I may ask you why do you need to use RO CSVI if it about running custom queries and nothing to import? Why not use standalone script to run these queries?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 1
webstar
webstar
Accepted Answer Pending Moderation
I'm not really uploading to a custom table. More that I'm using the email addresses uploaded to then lookup joomla users to get the user Ids. Then use that user Id to update the vm_userinfos table for that User ID

"But If I may ask you why do you need to use RO CSVI if it about running custom queries and nothing to import? Why not use standalone script to run these queries?"


Yes, Its just really a mechanism for uploading the CSV and processing it. There may be more uploads in the future - I'm not much of a developer. so I was hoping to just piggyback on ROCSVI.


I realise there mush be a better way of doing this but wanted something drag and drop almost for my client
  1. more than a month ago
  2. Pre-sale questions
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
More that I'm using the email addresses uploaded to then lookup joomla users to get the user Ids. Then use that user Id to update the vm_userinfos table for that User ID

You can use RO CSVI Joomla user export template to export email address and user ID. You can then edit the export file and update vm_userinfos table using RO CSVI custom table import. Did you try that? Won't that help?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 3
webstar
webstar
Accepted Answer Pending Moderation
No I already have CSV of users emails I just want to upload 1 file and have the action happen on that
  1. more than a month ago
  2. Pre-sale questions
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
In that case you can create an override file for RO CSVI import and write your queries or create a Joomla standalone file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 5
webstar
webstar
Accepted Answer Pending Moderation
Thanks Roland - Yes that could work
  1. more than a month ago
  2. Pre-sale questions
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,jpeg,zip,rar,pdf,csv,txt,tsv,xml,docx,doc,xls,xlsx,ods,tgz
• Insert • Remove Upload Files (Maximum File Size: 4 MB)
Cite your Sources with a URL link to help readers verify facts or find more details.
Add Another Link
In this section you can provide your site details at here and it visible to the moderators only.