Hello all has anyone come across this one? I have plenty of space. Other files can load and this file looks like a completely ordinary 1.6k lines of tab delimited text. No column headers are very long or contain spaces or odd characters. If something was wrong with the file I would expect to see an error message from Campaign? I upload new file from local machine and all I then get is the Uploading "xxx.txt" message and nothing at all happens. If I click on "Confirm" the file has not been uploaded. Anyone have any clues as to what needs to change with file or settings? Thanks.
Solved! Go to Solution.
Hi Sukrity. In the end we did not really get to the root cause of it. In itself the file size was not an issue as both a colleague and myself had the issue in the end with the same sort of number as text (with leading zeroes needed). With that field altered the files loaded. with very small files it loaded but big files with that field failed to load. something else was happening.
However we do not no what Adobe was doing differently to that field. Our support could not reproduce it but after he had successfully loaded a test file that failed for more I could then after load it successfully too - as if being in cache in our campaign instance skipped the error.
Not really workable though as a solution. My colleague tried using a work around route outside of our company's Citrix network. This is not ideal - but when we did this, i.e. took out of the equation the slower network and Citrix - all the files loaded. Including those that failed before.
Because we think this is fairly rare we are happy with this work around. Hopefully sharing might save some time for others.
(I still speculate that Adobe campaign is trying to convert that field to another data type and running out of time / memory over the network connection. Given the number of test files and scenarios we went through there must be something there with that field. So if you know anything more find anything please let us know.)
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
But you can upload other txt files with no issues?
Views
Replies
Total Likes
Views
Replies
Total Likes
Can you share the file? also have you tried uploading it as .csv
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Hi @icoggin - Could you try to change the datatype of that column to integer as the values and datatype is string. Give a try incase this works for you.
You can change the format by
1.Click on the change the file format
2. Then change the datatype of the field from this drop down
Thanks
Views
Replies
Total Likes
Thanks for the suggestion minakshis868318. I see something slightly different in the web interface but it does not get as far as allowing me to change the datatypes of the fields in file structure. It hangs when uploading the file and never gets as far. Also I need to keep it as string. It holds digits but some of them have a leading zero which is valid so it needs to remain as a text datatype.
Views
Replies
Total Likes
Hi @icoggin,
Were you able to resolve this query or do you still need help here? Do let us know.
Thanks!
Views
Replies
Total Likes
Hi Sukrity. In the end we did not really get to the root cause of it. In itself the file size was not an issue as both a colleague and myself had the issue in the end with the same sort of number as text (with leading zeroes needed). With that field altered the files loaded. with very small files it loaded but big files with that field failed to load. something else was happening.
However we do not no what Adobe was doing differently to that field. Our support could not reproduce it but after he had successfully loaded a test file that failed for more I could then after load it successfully too - as if being in cache in our campaign instance skipped the error.
Not really workable though as a solution. My colleague tried using a work around route outside of our company's Citrix network. This is not ideal - but when we did this, i.e. took out of the equation the slower network and Citrix - all the files loaded. Including those that failed before.
Because we think this is fairly rare we are happy with this work around. Hopefully sharing might save some time for others.
(I still speculate that Adobe campaign is trying to convert that field to another data type and running out of time / memory over the network connection. Given the number of test files and scenarios we went through there must be something there with that field. So if you know anything more find anything please let us know.)
Views
Replies
Total Likes
Thanks for the update on your query and for sharing your workaround to help the Community.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies