Data import issue with SFTP file retrieval method

[KamranAftab]

Hi

I am importing data from a remote file using SFTP file retrieval method. All the available data gets loaded except the first column, the same thing works when i use file retrieval method as Attachment & attach the file to the Data source locally.

Data Source details:

Type - File

Format - CSV

CSV delimiter - I

Data format in file:

Company|Address|City|Country

company1|address1|city1|country1

company2|address2|city2|country2

company3|address3|city3|country3

Company is the coalesce field. Now there are 2 cases-

Case 1 -

File retrieval method = Attachment

Data gets loaded successfully into the import set table:

Company             Address             City               Country

company1         address1         city1             country1

company2         address2         city2             country2

company3         address3         city3             country3

Case 2 -

File retrieval method = SFTP (File path & server credentials are correct)

All the Data loads into the import set table except the first column:

Company             Address             City               Country

                                              address1         city1             country1

                                              address2         city2             country2

                                              address3         city3             country3

It seems that service-now does not copy first column while importing CSV files with delimiter from SFTP locations.

Any suggestions would be highly appreciated.

Thanks

Kamran

[KamranAftab · Accepted solution]

The issue is found to be with creation of a new field (u_í¯__company) while loading data from file at FTP location & copying 1st column in 'u_í¯__company' instead of 'u_company'.

[yogesh15dd]

Hi Kamran,

My question related to your post is, before the data comes in to Service Now import set tables,   i would like to know how will you upload the data file to SFTP path given?

and if in case you have used direct web services method to post data in to service now import set tables! what is the url foramt of service now you use to post data into service now? and what is the procedure to do it(like programming languages etc..?)

Thank you in advance

Yogesh

[sindhumahadevap]

One of the customer has same issue root cause was   "file on the external FTP was not there yet when testing"