Tinderbox User-to-User Forum (for formal tech support please email: info@eastgate.com)
http://www.eastgate.com/Tinderbox/forum//YaBB.cgi
Tinderbox Users >> Agent, Actions, Rules & Automation >> Automatic import of spreadsheet (+ aTbRef typo)
http://www.eastgate.com/Tinderbox/forum//YaBB.cgi?num=1478114722

Message started by B.Moreira on Nov 2nd, 2016, 3:25pm

Title: Automatic import of spreadsheet (+ aTbRef typo)
Post by B.Moreira on Nov 2nd, 2016, 3:25pm

Hi !
I was experimenting with the spreadsheet import feature. I think it's great to be able to work on a good old effective spreadsheet and then just drag it and import it to TBX with attributes.

But I would like to automate things. For example, would it be possible for us to select the container note and have it's children automatically updated from the CSV file through a script?

Thanks!

PS: on aTbRef (http://www.acrobatfaq.com/atbref6/index/Import/SpreadsheetTab-Delimited.html), where we find "From v6.6.0, if there is a 'Prototypes' column and appropriately (...)" we should find "From v6.6.0, if there is a 'Prototype' column and appropriately (...)". Prototype, singular, otherwise the auto-assignment of prototypes will not work.

Title: Re: Automatic import of spreadsheet (+ aTbRef typo)
Post by Mark Anderson on Nov 2nd, 2016, 5:25pm

:-[ Sorry, Fixed! Of course, the default container in a TBX for prototypes is 'Prototypes' but here we are trying to match $Prototype. Good spot. Do please report any such typos/errors so i can fix them.

As the the main question, I don't thing this is possible via Tinderbox itself. You could use a runCommand to call a shell script (or Automator/AppleScript) task to drop the data file on to TB but I'm not sure you'd then control where in the TBX the import would happen.

More problematic, even if the target exists is the merge problem. If a data row of source already has a note of that name is it replaced. If not what is merged/replaced. I'd love to be able to use a merge to import additional fields/attributes to existing notes but I expect its complex and an engineering cost for a neat feature only a few of us would use.

At this point someone whose good at inter-app scripting will probably step forward and point out I've missed a simple and obvious solution!

Title: Re: Automatic import of spreadsheet (+ aTbRef typo)
Post by B.Moreira on Nov 3rd, 2016, 5:54am

Thanks for the clarification Mark.

Tinderbox User-to-User Forum (for formal tech support please email: info@eastgate.com) » Powered by YaBB 2.2.1!
YaBB © 2000-2008. All Rights Reserved.