Database import Primary key duplicate issue
$15-25 USD / hour
ok so, i need to change the frequency of the email user, currently its empty - as i have so many emails, i want to update these within SQL otherwise it will take a long time, - I’ve previous thought about updating these for the import method within PHPLIST but this hasn’t worked.
within the database there are two main tables:
phplist_user_user
&
phplist_user_user_attribute
in order for the RSS frequency to be updated to daily for each email address, an entry must be made into this last table, - the RSS frequency attribute id is 39 & 40 = the userid ( is the customer id which relates to their email address) and the Value needs to be set to 1 for the attribute id 39 & 40, please see the image [login to view URL]
if i manually update these details within SEQUEL PRO for this table, then it works, but I’m not able to import a .cv directly due to a Primary Key issue, i need this table (file will be given upon awarding the project) importing and i think it should then work ok, alternatively - if your able to select all user id in table phplist_user_user and create a record for then in phplist_user_user_attribute with attribute 39 and a value of 1 and repeat this for attribute 40 then that should also work ok.
Project ID: #8473922
About the project
18 freelancers are bidding on average $19/hour for this job
Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors. see my recent More
Hi Dear, Hope you are doing well !! I have gone through your project description. I can understand that you are looking for importing Primary key duplicate issue therefore I am looking forward to discuss and mo More
Hello sir,, i have read the project description and requirements carefully and i am confident that i am able to do it..I have checked the Dropbox link .. please talk to me once then we will discuss about the project, More
Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More
Dear Sir/ Madam, My name is Henry - the owner of PHAMTECH Co. My team is really interested in this project as it is exactly within our scope of expertise: We are web/ app design & development company located in More
hi sir, im expert in php. i have read your problem. i can do this project without a glitch.. thank you odel
I am sql expert certified by Oracle corporation and having more then 5 yrs of experience in sql Oracle and mysql as database administrator
Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : MS Access,Oracle,MySQL, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Config More
Hi Dear, I am having 7+ yrs of exp in PHP/MYSQL. I can help you in data import from CSV and help you sort out your issue
I can use a loop function to go through the records in the first table and create one record of each user_id in the second one.
I am bidding it to build my history. I will make sure that this is done within planned time. Please share the details to move forward.