DataShuttle Source

Dakota Haeffner

Hello,

I am working on having SQL load a sheet into a folder on my OneDrive to load data into a sheet on a weekly basis. While using DataShuttle, I get to the Mapping section and it says, 'Please select a Source in order to see dropdown options,' but I've already selected my source from my OneDrive.

Any idea what I am doing wrong here?

Mapping Screen:

Source Screen:

Kelly Moore

Hey @Dakota Haeffner

Try taking a copy of the excel or .csv file that eventually will be uploaded by DataShuttle and attaching it manually to your sheet. Make sure your DataShuttle browser window is newly opened or completely refreshed since the manual attachment.

Did this make the mapping columns available for you?

Kelly

Dakota Haeffner

I don't know what's fixed it but it has started loading today after 3 weeks.

che.rabajante

Hello @Dakota Haeffner

Does you workflow action is to Update the dropdown choices for the selected columns? Seems like the source file doesn't have a dropdown options.

Dakota Haeffner

Source File doesn't have any dropdowns. I've tried all three Workflow Actions.

Kelly Moore

Hey @Dakota Haeffner

Try taking a copy of the excel or .csv file that eventually will be uploaded by DataShuttle and attaching it manually to your sheet. Make sure your DataShuttle browser window is newly opened or completely refreshed since the manual attachment.

Did this make the mapping columns available for you?

Kelly

Dakota Haeffner

I don't know what's fixed it but it has started loading today after 3 weeks.