Qlik data transfer uploads files with dollar sign in filename

[tanelio]

Hi!

We have excel files that are imported to SaaS via Qlik Data Transfer. Originally I have created and loaded the files to the server/folders. Customer has updated the files but for some reason the files are now imported to SaaS with dollar sign. The folder name is "Excels". Files are uploaded to SaaS with default prefix.

Example:

Original files in space:
Excels_ProductFile.xlsx
Excels_NewNamesFile.xlsx

Space files now:
Excels_ProductFile.xlsx
Excels_NamesFile.xlsx
Excels_~$ProductFile.xlsx
Excels_~$NamesFile.xlsx

New files have the "~$"  mark. Is this something to do with the file owner? In my case only the files with "~$"  mark includes the updated data.

Any idea what might cause this?

Regards,
Taneli

[Luis_Arocho-LLantin]

Hi Tanelio

You still having this issue with the files naming?

Thanks,

Luis A

[Eugene_Sleator]

HI @tanelio  what is the prefix setting in QDT? There are three options Default, Custom and None. 

If you change it to None what happens? 

Also refer here;

Qlik-Data-transfer-new-prefix-behaviour 

[Qlik_Eric_Thomas · Accepted solution]

Looks like this could be caused by Microsoft Office functions: 

https://superuser.com/questions/901730/why-do-i-see-filename-hidden-excel-files

https://support.microsoft.com/en-us/topic/description-of-how-word-creates-temporary-files-66b112fb-d...

Check for Hidden Items in the folder containing the Excel files and see if these hidden versions exist.

[tanelio]

Hi all and thanks for the replies! 

We found a way to solve this(kind of). When excel file needs updating/editing - files are copied to other folder location, and after editing - we replace the old file with the new one. At least  this was easy way to avoid the dollar-sign problem.

-Taneli