All Apps and Add-ons

Sideview Utils Lookup Updater

dcparker
Path Finder

Hey all,

I am trying out this new lookup updater in sideview and am loving it. However, it seems to not work very well with a large table (12 columns.) I can add a new row, after changing the view to show all columns at once. However, when I try to update a row or delete one, I get this error:

Error in 'eval' command: The expression is malformed. Expected ).

I can't even find the eval command that is being run. Any help is greatly appreciated!

Here is a sample of a row:
*/v1/lists* FindList lists v1.0 lists 1 0.5 1.5 0.2 36.3 TRUE Get List - View List - ES NO

sideview
SplunkTrust
SplunkTrust

It turned out that the space characters in the field names are causing the problem.
I have a plan to fix the Lookup Updater so that you can have space characters in your lookup's field names, but for now it's a known issue.

Also if you're using the Lookup Updater make sure you're always on the latest version. Several other improvements and bugfixes have been made along the way and new releases of Sideview Utils come out pretty often.

In particular if you only have an earlier version you might only have edit/delete rows, and not the 'add new row', or 'reupload entire lookup' modes.

You can read the release notes here, and if you want to get a little email whenever there's a new version, get on our mailing list.

0 Karma

ConnorG
Path Finder

A recommendation for something to add to the Lookup Updater is the ability to update all changes. Only being able to change one row at a time is rather a pain when you need to make many changes.

Really love the view though. Thanks for putting this out there.

0 Karma

ConnorG
Path Finder

I went ahead and threw together a modification to the update_lookup.js file. The addition is an UpdateAll button that when pressed will update all visible rows.

Though I need your help. I'm having an issue.

Once the updates are pushed the rows don't actually show the changes until the web page is reloaded. I believe this is due to the context being pushed to only the children of the row that the button was clicked. Any assistance will be great.

View my code here:
https://github.com/ConnorRules/SideView---Lookup-

0 Karma

dcparker
Path Finder

There shouldn't be any special characters or anything (maybe a space or two.) The eval error only shows up when I try to delete really, once I edited the view to show all the rows at once (rather than the default of 10.) I update the question with a sample row, however.

0 Karma

sideview
SplunkTrust
SplunkTrust

Can you update your question with the values from the given row? There must be a bug around certain characters, like double quotes or parentheses in the actual values. I'll get it fixed.

0 Karma

cramasta
Builder

I don't have a answer for you but thanks for pointing me to this little hidden gem

0 Karma

kmattern
Builder

With all due deference to Sideview Utils and Nick. I can't live without Sideview, you might want to look at this http://wiki.splunk.com/Dynamically_Editing_Lookup_Tables
wiki article that I posted. It will give you the information you need to write your own lookup table editor.

dcparker
Path Finder

Thanks! It doesn't seem like this can add rows to the lookup table, can it? That's most important to me, is adding new rows. Thanks for the example though - maybe I can figure something out using what you've started.

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...