transferring file only to database
hello, i want to upload file only to database excluding the subfolders. is there a way to do it? i tried using assign activity (path = "filepath) then i paste there the path of the file that i want to upload but after uploading it to my database the folder was also transferred and i want the file on…
hi [@gus\_fring](/u/gus_fring)

welcome to community :slight\_smile:

you have to set the path with the file name. not only the path of folder.

for example you have the folder temp in c and the file name is inputdata.xlsx

your path should be then: c:\temp\inputdata.xlsx

best regards

mahmoud
well, transferring your data and transferring that and your settings are different. data, such as music, letters, video, pictures can burn to disk or copy/move to external drive. installed applications won't go, you'll have to reinstall from disk or download. on the other hand, you can transfer settings, favorites etc. use files and settings transfer wizard. or laplink software and cable. If your intent is to move a file from one iSeries (or System i) to another iSeries/System i then I’m not sure why you are going through the intermediate step of a text file. But in any case, if you have TCP/IP up between the two systems then FTP is the way to go.


If you just want the data, ftp the file.


If you want the database:  

Create a save file on the source system  

Save the database to the save file  

Create a save file on the target system  

FTP the save file to the target system in binary mode  

Restore the database on the target system


If you’re not familiar with FTP let us know. We can guide you through the steps (there aren’t many). If you don’t have TCP/IP between the two systems, let us know what options you do have in transferring data between the two systems (SNA, tape, etc).


Bruce Vining you can only attach one using the upload file option but you can "insert" or "drag and drop "as many files as you want.  see below



![ ](/resized-image/__size/320x240/__key/communityserver-discussions-components-files/2626/pastedimage1575581012041v1.png) Open SQL Enterprise Manager and expand the Databases tree. Right click on the database name and select All Tasks, then select Detach Database. Move the physical files from the D drive to the H drive. Right click on databases and select All Tasks > Attach Database. Browse to the new location and select the mdf file. Click OK, then OK again (you may need to correct the path to the log file). You can provide an optional parameter to the scaffolding command to update only the table you target.



```
Scaffold-DbContext "Server=(localdb)\mssqllocaldb;Database=DatabaseName;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir DirectoryNameOfYourModels -Tables employee -f

```

If you are using .net core cli then use.



```
dotnet ef dbcontext scaffold "Server=(localdb)\mssqllocaldb;Database=DatabaseName;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -o DirectoryNameOfYourModels -t employee -f

``` Not currently, but there's an idea thread for it! Be sure to upvote it here: [Workspace to FTP](https://forums.adobe.com/ideas/10411) 




[View solution in original post](/t5/adobe-analytics-questions/export-workspace-csv-to-ftp/m-p/302396#M15303) nothing missing - just different:

1.  transfers are still linked.  enter one side of the transfer and in the category drop-down, select transfer > [other account].  changing either of the two entries modifies the other.

2.  multiple registers at the same time.  you can have every register open at once in its own window.  only one register at a time shows in the main window.  just double-click the account in the left panel to open a floating register window.

3.  move transactions between accounts.  with both registers displayed, drag the transaction from one to the other.  if it is a downloaded transaction, you'll get a warning.  you cannot, however, move transactions between investment accounts. you could download each fex submission to a separate folder and then create links (hard or symbolic) to the matlab files (m, p, mex, etc.) in a single common folder for all fex submissions. this might cause problems with name collisions to common files (e.g., contents.m). you need a macro. a small extract of the four sheets may be uploaded to 
  
www.speedyshare.com without password. [The /2/sharing/remove\_folder\_member endpoint](https://www.dropbox.com/developers/documentation/http/documentation#sharing-remove_folder_member) (or corresponding native method) would be the right way to remove a member from a folder, whether or not they've mounted it. (Or, if operating on the recipient themselves, [/2/sharing/relinquish\_folder\_membership](https://www.dropbox.com/developers/documentation/http/documentation#sharing-relinquish_folder_membership).)


That 'no\_explicit\_access' error should indicate "The target member only has inherited access to the shared folder". For example, they only have access by virtue of having access to a higher level folder, meaning you can't remove just the lower folder.


Can you print out the full error object/message? The nested `MemberAccessLevelResult` may contain more useful information.


If that doesn't seem to be the case though, please share some sample calls that produce this unexpected error though so we can look into it.


Also, sharing individual files is a different piece of functionality than sharing folders, and sharing individual files does only support view-only access. For that, you can add members to files using [/2/sharing/add\_file\_member](https://www.dropbox.com/developers/documentation/http/documentation#sharing-add_file_member), and remove them using [/2/sharing/remove\_file\_member\_2](https://www.dropbox.com/developers/documentation/http/documentation#sharing-remove_file_member_2). 




[View solution in original post](/t5/Dropbox-API-Support-Feedback/Remove-Shared-Folder-Invitee/m-p/371583#M20937)