![]() Alternatively, drag and drop it from the Connection Tree.ĭo the same for Target collection. Then, choose an insertion method from the dropdown menu. This will open the Collection Import tab.ĭefine the Target database by typing its name and choosing it from the auto-detected list. Open the Import Wizard and select Another collection as the import format. Looking to copy MongoDB collections to another database? Here’s a quicker way. Once done, you can save the export as a task, which you can run on-demand or schedule for later, or execute the task immediately. Choose this option to disable array detection.Ĭhoose which fields to import by checking/unchecking the boxes in the Import options view, and double-check that all looks good in the JSON output preview. Don’t detect arrays – Header names such as arr.0, arr.1, arr.2, etc.Choose this option to replace all dots with underscore (_) and make all documents flat. Don’t infer document structure – By default dots (.) in header names are interpreted as embedded documents. ![]() Unescape control characters in strings (with ) – Control characters \r, \n, delimiter (,), escape () will be prepended with \.Trim spaces – Choose whether to trim no, leading, trailing, or all spaces.Empty fields – Choose how to treat empty fields (Import as Null, Import as Empty String, or Exclude).Insertion mode – Choose an insertion mode from the dropdown.If the target collection doesn’t exist, Studio 3T will automatically create one with the same name. If the target collection already exists, the imported rows will be added to that collection. Configure the other settings as needed.Ĭlick on the Target options tab to further configure the CSV import. File contains header with field names – Check/uncheck as needed.Ĭlick on the folder icon and locate the CSV file to be imported.Usually this is set if the file contains a preamble or leading comments. Skip first lines – Skips the first lines from the beginning of the file.Text qualifier – All symbols between the text qualifiers will be parsed as one field.Delimiter – Character that separates values in a row (e.g.delimiter, text qualifier) in the top-right to configure your import. If you already have copied data, click on Import from Clipboard and Studio 3T will automatically show a preview of the detected rows. This will open up the two sub-tabs, Source options and Target options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |