General discussion

I'm adding errorhandlers to a series of pre-existing scripts.  These scripts are for analysts with a wide variety of technical ability to use so I'm trying to keep them simple.  One thing I've been unable to find is a list of the properties IDEA makes available for an error object (.number, .description, .WhatElse?).  The two scenarios where I need more information than I have are as follows:

Hi everyone,
I wanted to know if there is any way to export my tables as Excel format (each should be in a separate sheet) into a single Excel file. Tables a, b, and c should be exported as different sheets into an Excel file named "X".
 
Thanks,
 

Hi everyone,
I have a source data (an IMD table) in a project and I am updating this data every month. Generally, I was wondering if there is a way to import the IMD file from another project to a prjoect! I know I can copy and paste into the project but I am looking for another way.
Thanks,

I just uploaded a vidoe on my YouTube channel on using User Types in IDEAScript.  Here is the link to the video and I have attached the script that I used for the demo - https://youtu.be/B56E8LYIuZM

Hello,
I converted a xls file to xlsx file to import itnto IDEA. It seems IDEA does not support xls, right?
Then, I tried to import xlsx (Excel 2016) but question marks appear at the beginning and end of each string (character) cell!
How can I import the data without having question marks?
Please see the images

Hola quisiera de su ayuda deseo llamar un Scrip cuando finalice uno para evitrar tener tantas lineas de codigo en uno solo 

SO, has anyone ever had idea installed on a vm? 
I'm presuming it'd be similar to local install - 1 macine:1 license.
But -
1) Has anyone done it? , and 
2) Was performance acceptable?
 
Thanks in advance!
Rob
 

Hi,
I've attached an example of the spreadsheet that I'm working on. I'm trying to clean up this spreadsheet so that it does NOT show instances when Procedure Code 80307 is billed with G0480, G0481, G0482, or G0483 for the same ID and Service Date. For example, lines 6 and 7 would stay and lines 8 and 9 would be removed from the results. I was trying to use duplicate exclusion function in IDEA, but I'm educated enough with scripting to figure this out. Thanks for any help.

Hello,
Unfortunatelly, I could not find any tasks in IDEA to merge two tables which has two or more keys (multi-index). Visual Connector has limitation and just accepts one key (index) which does not work in my project. Is there any way to do that
Please take a look at Python (Pandas) example attached
 

Hello,