Import script as stopped working, but the manual import runs succesfully

I am importing data from Snowflake and successfully saving the csv file, this has worked for about 2 years

They changed their column headers, I then downloaded the new format csv, and created a new import using this file, which works 100%

However, when i add the new import to the script it crashes at the import stage

Transferred 1689 records to storeStock.csv

Running Process: updateStoreStock

Run Status: Failed.

Property-based import has one of the key properties unmapped - cannot proceed

There are 3 fields in the import and all of them are mapped, so I am confused, did i not map the new file correctly, should it be set to Admin, Private or Everyone, or am I missing something else?

Thanks

Accepted answers

All comments

rob_marshall

@DeveloperCYT

A couple of thoughts and questions:

When you uploaded the new file, what was the permissions on it? You would put this as Everyone.
When you uploaded the new file, were you logged in using your ID or the Integration user ID? Is there an integrations user ID?

DeveloperCYT

Hi,

I set it to everyone (i actually tried all 3 just in case)

There is not an integrations user ID, and I have 5 other scripts that work using this method, but the Skutrak(Snowflake) changed a file structure and now I cant get it to work using the script, but I can manually download from Skutrak and manually import the same file ok.

So I am guessing it's a small thing I have missed

rob_marshall

@DeveloperCYT

Interesting...Have you tried to using the "sledgehammer" approach and deleting the action and recreating it with the new columns?

DeveloperCYT

I will give it a go, and build from scratch.... back soon

Sherrieward

If your script for importing data has stopped working, but manual import is successful, it may be due to an issue with the script itself. You can try debugging the script by checking for any errors or inconsistencies in the code.

Some possible reasons for the script not working could be:

Incorrect syntax or formatting in the script

Changes to the data source or format that the script is not handling correctly

Permissions or access issues with the data source

To troubleshoot the issue, you can try the following steps:

Check the script for any errors or syntax issues that could be causing it to fail.

Make sure that the data source is accessible and that the script has the necessary permissions to access it.

Verify that the data format or structure has not changed and that the script is still able to handle it correctly.

Test the script with a small sample of data to see if it is working as expected.

Consider using a different import method or tool if the script continues to fail. SkyWard Alpine

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…