and more in a single search tool across platforms. Read the announcement here. |
09/28/2022 04:50 AM
Hi Team,
We are trying to Import Accounts and associated Entitlements using Schema Upload in v2021,
I have this SAV file(SN_Accounts.sav)
The data file is as follows (ServiceNow_Accounts_01.csv):
endpointname,ACCOUNTNAME,username,Permissions,status
The SAV and data files were loaded to the corresponding directories on the UI /Datafiles and /SAV
When the schema based import job is run with the below configuration:
the job history shows the below error:
Job ends up with error, and the data file (.csv) is being moved to the /Fail folder.
Is something wrong with the files ?
Can anyone help me out if you have faced the same issue before or know something about it?
09/28/2022 05:21 AM
Open csv file in notepad & check if any extra column exists
Please share logs
09/29/2022 12:28 AM
09/29/2022 04:46 AM
Can you remove all special character from file name
like ServiceNowAccounts01.csv
also update sav file
09/29/2022 11:27 PM
Hi Rushikesh,
Removed special character from file name(csv file) and updated the Sav file as well. Observing same error after running the Job.
09/29/2022 07:07 AM
For a start, try and keep the column names same across both files.
Secondly, try and delete the existing job and re-create a new one and then try.
Lastly, download the logs from the import in a csv format and upload.
09/29/2022 11:35 PM - edited 09/29/2022 11:37 PM
Hi Avinash,
Thanks for replying!
1. Changed the column name to endpointname and created a new job and tested, facing same error.
2. Downloaded the sample files from Freshdesk and updated the attribute values accordingly without doing any changes to the files and tested, again same error.
Here's the sav file(SNAccounts.sav) ,
Attaching csv and log files.
09/30/2022 02:27 AM - edited 09/30/2022 06:58 AM
Change job name in api & dont keep _ also & attach sav file
10/02/2022 11:31 PM
Hey Rushikesh,
Changed job name in api & removed _ from Sav file name and Job name as well, still same error
10/03/2022 01:25 AM
Please share api screenshot from postman
09/30/2022 07:06 AM
10/02/2022 10:56 PM
Yes @avinashchhetri
12/12/2022 11:30 PM
Hello! I have the same issues. Is this resolved? If yes, how?