Disappearing merge jobs.

190 views
Skip to first unread message

Roger Banister

unread,
Nov 14, 2024, 2:55:00 PM11/14/24
to NV Autocrat Add-on
Hi Joseph,
It would seem that I am not the only one to suffer from this. 
I use Autocrat for about six different routine bookings eg for training or assessment sessions and Autocrat has been doing a great job for several years. In the last couple of weeks I have found:
  • when I open autocrat it says there are no jobs set up
  • Some jobs have lost all the links between the template and spreadsheet columns.
I have tried to follow steps you have suggested to others with similar problems but not successfully. For example, you suggested: 
"Look through the revision history until you find a hidden sheet called DO NOT DELETE - AutoCrat Job Settings."
When I look at "Version History" I do not see details such as the DO NOT DELETE tab
That tab is present on the spreadsheets but mostly it appears to be blank.

I really hope that we can get Autocrat back on track. It is the BEST when it works!
Thank you.
Roger

Joseph Schmidt

unread,
Nov 14, 2024, 6:21:50 PM11/14/24
to nv-autocr...@googlegroups.com
Go back to the last time Autocrat worked.  There should be a sheet and there will be a row for each merge job.

Once you have Autocrat working, duplicate the sheet as a backup.  That will eliminate the need to search history.

I didn't write Autocrat.  I just know a little about it.  Autocrat reads the sheet, then deletes the sheet and at the end of the job writes the sheet again.  The only thing that changes is some of the status columns.

If an Autocrat job should fail before the last step, you have the situation you are having.

I hope the above helps.  If not, tell me where I have confused you.




--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/79705423-ca5b-4c3f-8192-a19062bc291bn%40googlegroups.com.

Roger Banister

unread,
Nov 15, 2024, 4:57:39 AM11/15/24
to nv-autocr...@googlegroups.com
Thank you Joseph. I'm away at the moment so will follow your suggestions when I get home.
Best wishes 
Roger 

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTORz2DT14QX3kYg%3D%2B5cpvk-%3D2dC0KnzGo01z5gjuYV5S%3Dg%40mail.gmail.com.

Anabela Martins

unread,
Nov 15, 2024, 5:47:46 AM11/15/24
to nv-autocr...@googlegroups.com
Dear Joseph

When I try to create a new job, there is this warning. Could you help me, please?

ERROR

Error: Tags fetching failed. Please make sure type in all tags in your template manually. AutoCrat won't fetch tags that are from copy & paste.


Thanks

Kind Regards
Anabela

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTORz2DT14QX3kYg%3D%2B5cpvk-%3D2dC0KnzGo01z5gjuYV5S%3Dg%40mail.gmail.com.

Joseph Schmidt

unread,
Nov 15, 2024, 8:48:19 AM11/15/24
to nv-autocr...@googlegroups.com
Autocrat is unable to locate any merge tags. This happens most often when the template is a slide.

Make sure the merge tag is in a text box and don't get too fancy with the background. 

Do what is says, which is to delete and retype the merge tags.

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CA%2Bq23UzyWebO18YttdgpLn86xu4pHGRH2Thf3Rs7025z6L5oJg%40mail.gmail.com.

Katherine Friedel

unread,
May 1, 2025, 10:15:29 AM5/1/25
to NV Autocrat Add-on
I am in Google Sheets, and I went to extensions, Autocrat and 'open' (launch isn't on there).  When I open Autocrat in Google Sheets, there is this error message:  Error: Tags fetching failed. Please make sure type in all tags in your template manually. AutoCrat won't fetch tags that are from copy & paste.

I am not in the Google Slide I am going to merge with- I haven't started a 'new job.'  There are no merge tags in the Google Sheet because this is the spreadsheet from which the information is coming. The tags are in my Google Slide. 

How do I resolve this?

This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments. Please be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited.

Joseph Schmidt

unread,
May 3, 2025, 3:03:31 PM5/3/25
to nv-autocr...@googlegroups.com
Check the template and retype any merge tags.  Are the merge tags in a table?  

It is best to use merger tags within a text box.

Don't get too fancy template.

I would have to see the template.

Remove the hidden sheet and try again.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/1d7990fd-7f96-48ee-9864-76091b57bc80n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages