Bablosoft

Clear database after date added?

Support
  • R

    Can anyone give me an example of what i could possibly do to remove entries in my database (local) by time passed?

    for example: If i added an entry to the database 5 days ago then i want it to be cleared if 5 days has passed if not, keep it. Possible or not?

    Thanks so much in advance!

    0

  • E

    When I select the "Export Xls" option while transferring my data from the database, it saves the file as xml.

    Support
    0 Votes
    8 Posts
    814 Views
    m4zuperM

    @ensdmrlq
    321(2).webm

  • G

    database search

    Support
    0 Votes
    1 Posts
    250 Views
    No one has replied
  • SentientS

    There is A Bug With Subtract Date

    Support
    0 Votes
    3 Posts
    606 Views
    M

    I have the same problem with "Subtract Dates" action.

  • DasiumD

    How to save all the logs in database together with created accounts information

    Support
    0 Votes
    3 Posts
    749 Views
    DasiumD

    @tet-vivi I didn't understand.

    Let's say I want to create 10 different website accounts, one after an other, using 2 Threads, so each Thread will create 5 accounts.

    Let's say After creation I will have in the database 9 accounts, because there was an error with the creation of 1 account.

    How can I save on the database the Logs for each website account together with the account email and so to find what happened to the 1 account not created?

    Because in the logs windows that I see, all the logs are shown together of all the 10 accounts.

    And I cannot identify what are the logs for each account creation and save

    Database:
    Column A - column B
    abc@mail.com - LOGS

  • M

    How to Avoid Duplicates in Database?

    Support
    1 Votes
    7 Posts
    2257 Views
    BAS Viet NamB

    There are many ways to handle this issue. I'll show you one way.

    For a news website, it's almost impossible for recently added articles to have 100% identical content. Therefore, you just need to compare the latest data added to your database with the data you're checking. If they are 100% identical, then the data has already been added, so you can skip it and check the next piece of data using the same process.

    So, for your request, you can convert the database to a list format, then retrieve the last element corresponding to the latest data added (or you can retrieve the latest data directly from the database if you know how to work with databases). Use Parse CSV string to parse the string into article title and content.

    You can compare the title of the latest article with the title you're checking. If they are 100% identical, then it has already been added to the database. If you want to be more certain, you can also compare the content (although this may not be necessary).

    I hope you understand what I'm saying.