Is it possible to past a list of 500 items into th...
# generalc
Craig
02/03/2022, 10:18 PMIs it possible to past a list of 500 items into this list in a saved search?
k
KevinJ of Kansas
02/03/2022, 10:48 PMWhy are you doing this?
KevinJ of Kansas
02/03/2022, 10:49 PMI'd be tempted to create a custom field on my item records and then use that as a filter in my search instead of manually copy/pasting 500 items in. I'd expect that there's an issue with your 6th or 7th row, and if you change it it will work to copy paste.
You will be limited to 1k characters though
m
michoel
02/03/2022, 10:57 PMMuch easier to paste a list with analytics
michoel
02/03/2022, 10:59 PMFor a saved search, you can create a formula in Excel
="'" & A2 & "',"CASE WHERE {field} IN (<paste here>) THEN 1 END✔️ 2
z
Zack
02/03/2022, 11:23 PMEditting the search in the console by passing in an array of values in the criteria is how I would try doing that.
Zack
02/03/2022, 11:24 PMOtherwise Kevin's answer is easier to manage and report on.
m
michoel
02/03/2022, 11:25 PMI've found that formula WHERE IN is magnitudes faster than any of
c
Craig
02/03/2022, 11:40 PMWe can't change anything on the production env so we're stuck with searches, SuiteTalk, and ODBC
Craig
02/03/2022, 11:40 PMI just created an analytics workbook, that might be easier than searches
Craig
02/03/2022, 11:41 PM@KevinJ of Kansas because I need to get a lot of data out that's being sold to another company
Craig
02/03/2022, 11:41 PMthey're divesting a subsidiary so all related data needs packaging up and sending.
r
redfishdev
02/04/2022, 12:04 AMif you have ODBC could you not perform there easily with a joined table on your side of odbc?
a
AK47
02/04/2022, 12:06 AMGo with @michoel’s advice. You make a long formula. You can easily get the items in the format 'ITEM1','ITEM2', etc. using a macro in notepad++ or transposing the list in excel and saving as csv
AK47
02/04/2022, 12:06 AMbut basically you're saying where item in (the list) then 1 else 0 is greater than 1...it will return everything in your list
AK47
02/04/2022, 12:07 AMotherwise....make a custom list\record, import the items there...and then make your search off of this joined to the item
AK47
02/04/2022, 12:07 AMnot ideal...
r
redfishdev
02/04/2022, 12:08 AMak47, I thought he said he is limited to searches and not creating records
redfishdev
02/04/2022, 12:09 AMhopefully soon NS will allow the ability to upload data into analytics via excel or other means on the fly
redfishdev
02/04/2022, 12:09 AMthis would make it super easy
redfishdev
02/04/2022, 12:10 AMthe big BI players allow data connections and uploading flat or structured files. 2028. R2
redfishdev
02/04/2022, 12:11 AMbut you also said you have suittalk, so you can drop in a restlet fast to export saved searches and join in you favorite tool, even excel if you prefer
3 Views