I have a fairly complicated import routine for one of my sites, with children, grandchildren & sibling steps importing various things from a spreadsheet. Whilst easy to set up and get the steps correct, despite a fairly complicated structure to import the data into, it's a pain to change the datasource accross all steps. I initially uploaded a local file as I was in early testing stages, and found it quite annoying to have to keep selecting the correct file.
Would it be possible to have child steps inherit the datasource (optionally of course) from it's parent / ancestors?
In my case the import steps can be used to import to more than one location and the datasource will keep changing (I am importing complicated restaurant menus, including categories, sub categories, headings, sides, upgrades and options for all of these..), it's just a pain to have to go through and change the datasource each time. I could just set it to import form a URL, but then I have to upload over the top of the same spreadsheet each time with my new import data.
I have probably rambled enough there, hopefully it made sense?
Because a lot of other things can go wrong, I decided this structure. What you can do in your case is either upload the excel file to a folder and reference this file via the url option.
Or you can configure the dashboard control and upload the excel sheet there then it will use the uploaded version for parent and children.
Inherit Datasource from parent
I have a fairly complicated import routine for one of my sites, with children, grandchildren & sibling steps importing various things from a spreadsheet. Whilst easy to set up and get the steps correct, despite a fairly complicated structure to import the data into, it's a pain to change the datasource accross all steps. I initially uploaded a local file as I was in early testing stages, and found it quite annoying to have to keep selecting the correct file.
Would it be possible to have child steps inherit the datasource (optionally of course) from it's parent / ancestors?
In my case the import steps can be used to import to more than one location and the datasource will keep changing (I am importing complicated restaurant menus, including categories, sub categories, headings, sides, upgrades and options for all of these..), it's just a pain to have to go through and change the datasource each time. I could just set it to import form a URL, but then I have to upload over the top of the same spreadsheet each time with my new import data.
I have probably rambled enough there, hopefully it made sense?
Thanks for a great package already!
Mark
Hi Mark,
Because a lot of other things can go wrong, I decided this structure. What you can do in your case is either upload the excel file to a folder and reference this file via the url option.
Or you can configure the dashboard control and upload the excel sheet there then it will use the uploaded version for parent and children.
Hope this helps,
Richard
Ok, fair enough, I thought that may be the case.
I'll stick to uploading to a folder for now and just overwriting the import file as it's the simplest solution.
Thank you!
is working on a reply...