2020 - Page 3 of 25 - File transfer tool from Limagito

04 Dec
Export Chinese Text Data from SQL server database to CSV file
Q: I want to export Chinese Text data from an SQL server database to a CSV file. Setting up the Limagito rule was simple: SQL input and an output directory. I am actually using an SQL Select because the data that I want to export results from a join. Unfortunately the exported file is in ANSI encoding. Since my SQL Server source has nvarchar fields, some of them with Chinese text in them, I cannot use the CSV. Is there any way to tell Limagito to output CSV from an SQL Server source as UTF-8?
A: We had to add some new options in version v2020.12.4 to achieve this.
We added a basic example to get you started:
Added SQL as Source
We’ll be using a simple QRY to get all the date from a database table:
We are using a MS SQL Database, connection Setup:
Some info about the Database table (Demo_10
) we’ll be using:
Add the query, simple seclect all statement:
Important, Add the encoding you need. In this example we added UTF-8.
Destination Setup, WIN as Destination:
Destination File Result:
RunTime Log Result:
If you need any help with this ‘Export Chinese Text Data’ question, please let us know.
Best Regards,
Limagito Team
By Limagito-Team SQL chinese, csv, SQL

29 Nov

Q&A 32: Error during sftp file upload with Limagito File Mover

Q: We have installed Limagito version v2020.11.21.0 with the Site+ license on a W2K19 server. When we try to transfer files to an external sftp server it doesn’t work out fine (Error during sftp file upload). The SSH connection seems fine to me , but the files won’t be uploaded. Unfortunately the other side can’t help me out and I can’t find out what is happening and why.

25-11-2020 19:39:31 [SFTP] SFTPUploadFile, CK UploadFileByName Error, ChilkatLog:
 
[SFTP]   UploadFileByName:
[SFTP]     DllDate: Jul  2 2020
[SFTP]     ChilkatVersion: 9.5.0.83
[SFTP]     UnlockPrefix: CPSFTB.CB1062022
[SFTP]     Architecture: Little Endian; 64-bit
[SFTP]     Language: Delphi DLL
[SFTP]     VerboseLogging: 0
[SFTP]     SshVersion: SSH-2.0-XpertSuite
[SFTP]     SftpVersion: 4
[SFTP]     Component successfully unlocked using purchased unlock code.
[SFTP]     uploadFileByName:
[SFTP]       remoteFilePath: /XX/XX_2020-11-24_08-00-00-werknemers.xml
[SFTP]       localFilePath: \\MyDomain\proces\XX_2020-11-24_08-00-00-werknemers.xml
[SFTP]       localFileSize: 4485
[SFTP]       sftpOpenFile:
[SFTP]         remotePath: /XX/XX_2020-11-24_08-00-00-werknemers.xml
[SFTP]         access: writeOnly
[SFTP]         createDisposition: createTruncate
[SFTP]         v3Flags: 0x1a
[SFTP]         buildLongPath_xFilePath: \\MyDomain\proces\XX_2020-11-24_08-00-00-werknemers.xml
[SFTP]         Sent FXP_OPEN
[SFTP]         StatusResponseFromServer:
[SFTP]           Request: FXP_OPEN
[SFTP]           InformationReceivedFromServer:
[SFTP]             StatusCode: 5
[SFTP]             StatusMessage: Error while parsing request.
[SFTP]           --InformationReceivedFromServer
[SFTP]         --StatusResponseFromServer
[SFTP]       --sftpOpenFile
[SFTP]       Failed to open file.
[SFTP]     --uploadFileByName
[SFTP]     Failed.
[SFTP]   --UploadFileByName
[SFTP] --ChilkatLog
 
25-11-2020 19:39:31 [SFTPPUT] Copy Error \\MyDomain\proces\XX_2020-11-24_08-00-00-werknemers.xml

A: It’s look like the SFTP server is trying to use SFTP Version v4 but .. not correctly. The solution here is to only allow SFTP Version v3.

FYI: The customer is using our Second SFTP Vendor (CK).

Limagito File Mover SFTP v3 Only

Feedback from customer:

Great !! that did the trick. J J J
Thanks for your support !!!

If you need any help with this ‘Error during sftp file upload’, please let us know.

Best Regards,

Limagito Team

By Limagito-Team Error Q&A SFTP error, SFTP, upload

25 Nov
Added SharePoint OAuth2 Authentication in Limagito File Mover
Added SharePoint OAuth2 Authentication
Update 28th September 2023, our advice is to use Oauth v2.0 Authentication instead
In version v2020.22.25.0 we added OAuth2 Authentication as a fourth method for connecting to SharePoint.
Please select ‘Online Authentication using OUath2’ as Authentication Type (Setup Tab). After selection the OAuth2 Tab will be visible.
We received the following information from the customer (thank you Brad):
Client Id
Client Secret
Redirect URI

Update March 2022
We had a user getting the following error when trying to Get the OAuth2 Token: AADSTS70000
He had to change App Domain to: www.localhost.com
and
Redirect URI to the Site url (without the default.aspx at the end) in the SharePoint Application setup AND Limagito OAuth2 setup
We used the information from the customer and added them in the OAuth2 Setup:
Client ID
Client Secret
Scope, we used Web.Manage
Redirect URI
Next, click <GET>
At this moment we’ll start a request for the Realm and Principal ID of the SharePoint Site. A Dialog will appear with information about the next step.
Now you’ll need to click ‘Trust It’ to continue to the next step:

The Authorization Code will appear in the address bar of your browser.
Please COPY / PASTE this complete URL (https://…) in the ‘Auth Code’ field of the OAth2 Setup screen. We’ll strip the part we need and trigger a request for a Refresh and Access token. The response will be added to the ‘Refresh Token’ and ‘Access Token’ field of the OAuth2 setup.
Please click <Save> to save these Tokens which we’ll need to connect.
If you need any help with our ‘SharePoint OAuth2 Authentication’ option, please let us know.
Best Regards,
Limagito Team
By Limagito-Team SharePoint AADSTS70000, OAuth2, SharePoint