my autocrat jobs disappered on googlesheet

[mauro forte]

How is it possible

It worked since Yesterday, two jobs on https://docs.google.com/spreadsheets/d/1kZrbiaH3vUbnGNgZ9N34BiyHgvPdYUbLDcKRvuew8kA/edit?usp=sharing

Now no works is found

Thanks 

Mauro Forte

[mauro forte]

my user key

AA4ipIWPW6xlV+OszjSJHhuedUQ/o6/Ke+YrpiQPcUWLAsPrDMcNfXwbE7BcNyTgsXQb3FqQZ4qK

[Satya Eka Nawa PT.]

Ensure you only Login with 1 email address when you lunch autocrat.

[mauro forte]

i did what you asked me BUT Nothing :(

I have more autocrat jobs in other googlespreadsheet files still working regularly 

This is  file rec what happen:

https://drive.google.com/file/d/18NPhAvw06fdXZe6kVZMeGRzSyTtNzZyg/view?usp=sharing

Maybe it will help 

It's relly important for us solve this bug 

 Thank you

--
You received this message because you are subscribed to a topic in the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-autocrat-add-on/-p_AE4j4agc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/5025f2bd-1491-48b8-9592-4819a6a9e13en%40googlegroups.com.

[Joseph Schmidt]

It can get complicated.

Make a copy of your current spreadsheet.

Look through the revision history until you find a hidden sheet called DO NOT DELETE - AutoCrat Job Settings.

Restore that version of the spreadsheet and make a copy of DO NOT DELETE - AutoCrat Job Settings

Restore the most recent version and copy DO NOT DELETE - AutoCrat Job Settings into it.

Information about the autocrat merge jobs is contained in DO NOT DELETE - AutoCrat Job Settings

If you have an active Form feeding the spreadsheet, you need to turn the form off first.

Think through the steps before you start. You should always have your backup copy.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

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 on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAO6QP0dY91AHxyn%3Dqgj%3DVB0%2BkguqxZjRpNuks6YR5GLNKJjqrw%40mail.gmail.com.

[mauro forte]

Thanks to Joe and comunity all: i solved my problem...even i didnt know why it happened. REALLY THANK YOU 

[Joseph Schmidt]

I'm so happy that we solved the problem.  For information to all, the last four rows had errors in the status column.  Bad Email information and URL to photos not working.  I think the Autocrat script failed to handle that many errors and stopped before it could update the records in the hidden file.

I know NewVisions is very busy but I wonder if changing the script to not rewrite the rows in the hidden sheet, Autocrat would just update the status columns on the far right.  That way when Autocrat failed, at least the hidden file would still be there.  

I must admit, I have no idea how much work it would take to change that but from time to time the hidden records disappear.  In this case, I think the error handling caused the problem.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/d9828ff0-959c-45b7-8d7f-cf090bf5c13cn%40googlegroups.com.