Bablosoft

importing csv to database with colons and breaklines : in it

Support

  • sanyaS

    Pls how do we export profiles to external database or server?

    Support
    0 Votes
    1 Posts
    320 Views
    No one has replied
  • S

    Reading input data from csv file of non english

    Support
    0 Votes
    4 Posts
    680 Views
    FoxF

    @spa3212 said in Reading input data from csv file of non english:

    @Fox so don't know for csv file this doesn't work, but for txt file it does :) anyways thans.

    This works for any text file. Attach the file for the test

  • E

    how to fix failed to run database

    Support
    0 Votes
    5 Posts
    936 Views
    I

    Спасибо за ссылки на похожую тему, но к сожалению мне не помогло, возможно я, что то делаю не так. Удаление mongod.lock действительно убрало надпись вначале об ошибке, но базы не работают. Переустановка BAS тоже не решила проблему.

    @Fox said in Глюкнула БД прошу подсказать:

    @dobrok said in Глюкнула БД прошу подсказать:

    @UserTrue said in Глюкнула БД прошу подсказать:

    @dobrok я с таким не сталкивался

    Ни одна из БД не работает, даже новую создаю, после перезагрузки не коннект.

    Удалите файл C:\Users%USERNAME%\AppData\Local\BasDatabases\НАЗВАНИЕ БАЗЫ\current\mongod.lock Запустите mongod --dbpath C:/Users/%USERNAME%/AppData/Local/BasDatabases/НАЗВАНИЕ БАЗЫ/ --repair. mongod есть в папке с BAS.

    Данный метод сделал с помощью командной строки, получив вот это:

    PS C:\Users\ilyaa> C:\Users\ilyaa\AppData\Roaming\BrowserAutomationStudio\apps\24.7.1\mongod.exe --dbpath C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket/ --repair
    2022-03-14T17:45:25.775+0300 [initandlisten] MongoDB starting : pid=34756 port=27017 dbpath=C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket 64-bit host=DESKTOP-A70S6NA
    2022-03-14T17:45:25.775+0300 [initandlisten] targetMinOS: Windows 7/Windows Server 2008 R2
    2022-03-14T17:45:25.775+0300 [initandlisten] db version v2.6.6
    2022-03-14T17:45:25.775+0300 [initandlisten] git version: 608e8bc319627693b04cc7da29ecc300a5f45a1f
    2022-03-14T17:45:25.775+0300 [initandlisten] build info: windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49
    2022-03-14T17:45:25.775+0300 [initandlisten] allocator: system
    2022-03-14T17:45:25.775+0300 [initandlisten] options: { repair: true, storage: { dbPath: "C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket/" } }
    2022-03-14T17:45:25.838+0300 [initandlisten] finished checking dbs
    2022-03-14T17:45:25.838+0300 [initandlisten] dbexit:
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to close listening sockets...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to flush diaglog...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to close sockets...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: waiting for fs preallocator...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: closing all files...
    2022-03-14T17:45:25.838+0300 [initandlisten] closeAllFiles() finished
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: removing fs lock...
    2022-03-14T17:45:25.838+0300 [initandlisten] dbexit: really exiting now
    PS C:\Users\ilyaa>

    Но базы не заработали. Если же просто запустить отдельно файл mongod.exe, то увидим:

    C:\Users\ilyaa\AppData\Roaming\BrowserAutomationStudio\apps\24.7.1\mongod.exe --help for help and startup options
    2022-03-14T18:02:16.828+0300 [initandlisten] MongoDB starting : pid=39768 port=27017 dbpath=\data\db\ 64-bit host=DESKTOP-A70S6NA
    2022-03-14T18:02:16.843+0300 [initandlisten] targetMinOS: Windows 7/Windows Server 2008 R2
    2022-03-14T18:02:16.843+0300 [initandlisten] db version v2.6.6
    2022-03-14T18:02:16.843+0300 [initandlisten] git version: 608e8bc319627693b04cc7da29ecc300a5f45a1f
    2022-03-14T18:02:16.843+0300 [initandlisten] build info: windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49
    2022-03-14T18:02:16.854+0300 [initandlisten] allocator: system
    2022-03-14T18:02:16.863+0300 [initandlisten] options: {}
    2022-03-14T18:02:16.863+0300 [initandlisten] exception in initAndListen: 10296

    ERROR: dbpath (\data\db) does not exist.
    Create this directory or give existing directory in --dbpath.
    See http://dochub.mongodb.org/core/startingandstoppingmongo

    , terminating
    2022-03-14T18:02:16.863+0300 [initandlisten] dbexit:
    2022-03-14T18:02:16.863+0300 [initandlisten] shutdown: going to close listening sockets...
    2022-03-14T18:02:16.868+0300 [initandlisten] shutdown: going to flush diaglog...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: going to close sockets...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: waiting for fs preallocator...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: lock for final commit...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: final commit...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: closing all files...
    2022-03-14T18:02:16.870+0300 [initandlisten] closeAllFiles() finished
    2022-03-14T18:02:16.870+0300 [initandlisten] dbexit: really exiting now

    [процесс завершил работу с кодом 100 (0x00000064)]

  • S

    How to work with CSV rows and columns

    Support
    0 Votes
    2 Posts
    736 Views
    FoxF

    @spa3212 said in How to work with CSV rows and columns:

    I have a csv file with col and row, I want to show log
    from a specific cell let say B3 how this possible.
    I mean is there any way we can choose from where to start a list. Like we can do in ubot, there we could use table cell or row, and increment etc which is very handy can't we use here.

    BAS doesn't have a ready-made tool for working with tables, you can use node js modules to work with them. A Csv file is just text, you can read it in a list, take a string from the list by index, and parse it with the "Parse Line" action
    18545d0b-8191-40f1-aba2-49db16bd4ebc-изображение.png

  • A

    Select Database Table as Resource

    Support
    1 Votes
    4 Posts
    1963 Views
    AllisterA

    @andykaufseo

    Hope that really answered your problem. Can also use the "Select Records" command, change the Table to the second one and add any filters you need. This will return all records in a list and using the Foreach will get the job done.

    Allister ☯