I am creating an search engine optimization database website where I will be storing all the website URLs submitted by vendors in my database and display it in a repeating group in a page where I can add various other details to it, If two vendors upload the same website URL more than one time. The …

Do a search for the data type with that website URL If first item is not empty, display that Thing on your page or whatever to prefill the inputs.

Yes, but after I do a search for that particular website URL in the database, and a match is found, how do I copy the DA, Spam Score, etc from the existing Web URL in the database to the new Website URL which is uploaded recently in the database!?

[image] hitesh: the new Website URL which is uploaded recently in the database!? You shouldn’t have created the duplicate website URL. Let’s say I upload ‘ google.com ’ as an example to a data type Website that contains a URL field (text). Now let’s say I try to upload ‘ google.com ’ again. In …

No, I need to add the same google.com again to my database as the person who is uploading the same google.com again is different, so I need to keep track of that in my database, so that’s the complication, if both website URLs are same then I need to copy paste the corresponding details from the exi…

Then ‘Copy a list of things’ Search for Website (with URL constraint):first item:converted to a list :slight_smile:

Could you kindly explain the functionality of this expression? Additionally, there is the matter of uploading website URLs not one at a time, but rather as a list within a CSV file. Each URL from the newly uploaded CSV file needs to be compared to the existing domain URLs in the database. If a match…

It searches for a Thing where the URL is the URL that the user has uploaded It then takes the first result of that search, and converts it to a list (for the action). The action ‘copy a list of things’ then duplicates exactly the Thing that you found

Kindly read my previous response again, I’ve edited it now!

[image] hitesh: This process should be executed within a loop. It involves checking the first website URL from the newly uploaded CSV file and cross-referencing it with the existing domain URLs in the database. In the event of a match, the relevant details from the existing website URL should be…

:joy: Yes exactly, I am clear with the logic, but I am struggling with the execution part, help me with the execution part with a sample expression please, It’ll be very helpful for me!

Efficient Duplicate Website Handling for Database: Need Help with Data Migration

Need help App Organization

georgecollier September 11, 2023, 11:47am 12

Topic		Replies	Views
How to delete double entries in the database? Database	8	1599	November 28, 2024
I want to update and create new data in the database by importing an excel csv Database	3	177	June 24, 2024
Check Duplicate entries when performing CSV upload Need help	0	38	February 26, 2025
Duplicate entries Need help	2	1151	June 2, 2018
Dealing with Duplicate data Database	0	92	February 7, 2024

Efficient Duplicate Website Handling for Database: Need Help with Data Migration

Related topics