Error: schema cannot be greater than 40 characters in length

[jhaueter]

Hello,

I'm new to Analytics Dataset Utils. I downloaded and am using the most recent version, but my first several attempts to upload files failed with this (or a similar)

• error message: com.sforce.dataset.loader.DatasetLoaderException: object name [Testcsv_5bb82275_26f6_4415_8fee_348d6ad391ba] in schema cannot be greater than 40 characters in length.

My file name was Testcsv, the rest was appended/created through the process (_5bb82275_26f6_4415_8fee_348d6ad391ba). So that alone takes up 37 of the 40 characters allowed. My work around was to name my file "a" so that I could get the name under 40 characters. Is there a way to allow more than 40 characters, or to append less than 37 characters to the end of the file name so that I can create files with meaningful names?

Jodi_Test_Listener_5bb82275-26f6-4415-8fee-348d6ad391ba.log

[N28Team]

Hi Team,

Even I am facing the 40 character limit issue on the object/file name. The workaround is to use one character file name.

Also, Is there a way to auto-start the dataset-util service in windows 10?

Please advice.

[elk-gh]

I am facing the 40 character limit issue

[MsCanadian]

Hello, has anyone figured a workaround other than renaming the file? I also couldn't use the listener because of this.

[TerenceJWilson]

If you add a json schema file with the upload then it will not error out. In the listener directory add a file with the same name _schema.json. So if you have a file called Complaints.csv then place the json schema file Complaints_schema.json in the same directory . I am looking at a rewrite of the utils to move from SOAP to REST and other issues that have arisen over time as some of the error trapping was due to older constraints which are no longer valid - the 40 character check for example.