Automate away Export/Import with Pipelines?
Hi All,
I'm trying to understand if it's possible to create a record in a child table that would trigger a Pipeline to export parent records based off the fields entered in the child table, then, change the values in those fields, then import the resulting records. The scenario is we have project sources related to projects, sometimes numbering in the hundreds, that would be suitable for use on other projects. Those project sources all have master sources so that the same base data can be used on multiple projects while keeping track of key events that we can track of the lifetime of the master source. At the moment, if a new project is similar to an old project, then I export those project sources to CSV, change the related project values to equal the new project, and change the name of several fields because they weren't automatically matching upon import. Then I go through the import process in QB. What I would like to do is create a new child table where I would input the old project, the categories of sources I want to keep from that project (and possibly one other field in the project source table like status), then input the new project and the new category to put those sources in, and when I save and close that would trigger the Pipeline to grab project sources from the old project based on the values in that new record, change some of those values based on the values in that new record, and then import those newly modified records back into the parent table.
What do we think? Possible? At the moment I'm getting tripped up on how to make two different selections for old and new projects in the same child record.
Thanks
------------------------------
Daniel Johnson
------------------------------
I'm trying to understand if it's possible to create a record in a child table that would trigger a Pipeline to export parent records based off the fields entered in the child table, then, change the values in those fields, then import the resulting records. The scenario is we have project sources related to projects, sometimes numbering in the hundreds, that would be suitable for use on other projects. Those project sources all have master sources so that the same base data can be used on multiple projects while keeping track of key events that we can track of the lifetime of the master source. At the moment, if a new project is similar to an old project, then I export those project sources to CSV, change the related project values to equal the new project, and change the name of several fields because they weren't automatically matching upon import. Then I go through the import process in QB. What I would like to do is create a new child table where I would input the old project, the categories of sources I want to keep from that project (and possibly one other field in the project source table like status), then input the new project and the new category to put those sources in, and when I save and close that would trigger the Pipeline to grab project sources from the old project based on the values in that new record, change some of those values based on the values in that new record, and then import those newly modified records back into the parent table.
What do we think? Possible? At the moment I'm getting tripped up on how to make two different selections for old and new projects in the same child record.
Thanks
------------------------------
Daniel Johnson
------------------------------
