Bablosoft

How to copy list and paste into database

Support

  • J

    Database issue

    Moved Support
    0 Votes
    4 Posts
    507 Views
    J

    Thanks. Did not see that in the docs. It has to be from TXT or from Google sheets since excel likely attaches other elements unseen.

    Also, other issue is it's posting data to 2 groups on CSV import. If there are 2 empty groups, you upload CSV, it will upload data into both data group and append to any existing data, unlike before where it creates new group. https://www.loom.com/share/8927dd100dcf49dfacf6442d5da00642

    I have been having more freezing and crashing than prior to update. Not really sure how to give you info on this. My script is very big. Are there crash logs or something?

  • loclan6879L

    How to make multiple computers work on the same BAS database???

    Support
    0 Votes
    4 Posts
    830 Views
    sergerdnS

    @loclan6879 said in How to make multiple computers work on the same BAS database???:

    @morpheus93 but my sql to dificult to use. i need db orginal of BAS. Can i???

    Using a database in any software is a common practice in development. I don't see any difficulties here.

    In any case, you don't have many options except to set up a database server on your local network, like MongoDB, MySQL, or something similar, and then connect your script to that database server.

    Another approach is to implement web app with an API for CRUD operations, such as Swagger, and create a simple BAS module to manipulate account data during registration or similar tasks. I use this method very often because it simplifies BAS coding, as all logic is implemented in the web app.

  • T

    How do I extract MD5 hashes from a list/string?

    Support
    0 Votes
    3 Posts
    587 Views
    T

    I figured it out nvm. I just set this "\w{32}" as the regex but I actually clicked on the w/ button and then typed in the 32. Seems to work fine

  • Y

    How to use one database in several projects?

    Support
    0 Votes
    1 Posts
    934 Views
    No one has replied
  • M

    How to Avoid Duplicates in Database?

    Support
    1 Votes
    7 Posts
    2344 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.