Publish Logs - Update GSAK User Notes too

[+wasillian]

I'm using the Publish Logs feature in GSAK 8.1.1.66 and saw an example of a macro I want to run for each log in the GSAK help file. It is Example 1 - update the GSAK user notes with the log text (that you just published) from Geocaching.com. I created the macro shown in Example 1:

 

If seek($_PublishCode)

$result = sqlite("sql","select lText from logsall where rowid = $_PublishId2","SqlGet=Yes")

$d_UserNote = sqlGet("lText")

SqlGetClose

Endif

 

The problem I have with the macro is it erases all of the existing information I've stored in the GSAK user notes instead of appending it to the existing GSAK user notes. Do you have a macro command to append the published log information into the GSAK user notes?

 

What about a similar macro that puts the data in the GSAK Log Section instead of the GSAK user notes?

 

Thanks,

 

Chris

[+Triple Crown]

I'm using the Publish Logs feature in GSAK 8.1.1.66 and saw an example of a macro I want to run for each log in the GSAK help file. It is Example 1 - update the GSAK user notes with the log text (that you just published) from Geocaching.com. I created the macro shown in Example 1:

 

If seek($_PublishCode)

$result = sqlite("sql","select lText from logsall where rowid = $_PublishId2","SqlGet=Yes")

$d_UserNote = sqlGet("lText")

SqlGetClose

Endif

 

The problem I have with the macro is it erases all of the existing information I've stored in the GSAK user notes instead of appending it to the existing GSAK user notes. Do you have a macro command to append the published log information into the GSAK user notes?

 

What about a similar macro that puts the data in the GSAK Log Section instead of the GSAK user notes?

 

Thanks,

 

Chris

 

I think if you ask the question on the GSAK forum you'll get an expert response really fast...

[+wasillian]

I'm using the Publish Logs feature in GSAK 8.1.1.66 and saw an example of a macro I want to run for each log in the GSAK help file. It is Example 1 - update the GSAK user notes with the log text (that you just published) from Geocaching.com. I created the macro shown in Example 1:

 

If seek($_PublishCode)

$result = sqlite("sql","select lText from logsall where rowid = $_PublishId2","SqlGet=Yes")

$d_UserNote = sqlGet("lText")

SqlGetClose

Endif

 

The problem I have with the macro is it erases all of the existing information I've stored in the GSAK user notes instead of appending it to the existing GSAK user notes. Do you have a macro command to append the published log information into the GSAK user notes?

 

What about a similar macro that puts the data in the GSAK Log Section instead of the GSAK user notes?

 

Thanks,

 

Chris

 

I think if you ask the question on the GSAK forum you'll get an expert response really fast...

 

Thank you for pointing me to the right location to post the question.