Questions on Importing
Multi-line Floating Traps?
Forums
Thanks again in advance for the help, all.
I've got a PDF that I need to import that is a form letter with user-selected check boxes. I had no problem building a standard layer that worked on my example file, but I thought it would be better to build it with floating traps since I'm not optimistic that each of the 2000 letters I need to read will be recognized identically by the report reader.
- Read more about Multi-line Floating Traps?
- 2 comments
- Log in or register to post comments
XML import with typedefinition
Forums
Hello everyone,
i'm trying to import an XML File with the correct data types (Date,Number...).The Import works but the datecolumn does not get recognized.Only when i set the type in idea to date and set a dateformat manually.
Is there any way to automate this?I also have the XSD File but IDEA does not import XSD Files only XRDF as far as i know.In the sample XRDF Files are no format attributes only fieldnames and context.Does anyone know what the <XML_FIELD_CONTEXT> is for?
I really don't understand why i can export an XSD File but not import it.
Regards
- Read more about XML import with typedefinition
- 3 comments
- Log in or register to post comments
Default Table selected
Forums
Hello,
I am trying to use a SQL Query with an OBDC connection to call data from a particular DB. Whenever I reach to the step where I have to enter the query by clicking on the advanced tab, I paste the SQL Query and then as I click 'OK', the query disappears, and the default table query reappears. I cannot remember if there's a way where we could avoid the default table selection.
Please refer to the following images as step 1 and 2.
step 2 is actually the reappearing of the default selected table.
Please help.
- Read more about Default Table selected
- 1 comment
- Log in or register to post comments
A Couple of PDF Importing Questions
Forums
I have to convert a lot of the same PDFs. I will get 1 to work and make sure to save the template so I can use it on the others. However I've run into an issue. It looks like each and every PDF has slightly different positioning by a couple of characters. Therefore when I use a trap in one, it may be blank/not match location exactly in the next such as this:
PDF1: Name
PDF2: Name
- Read more about A Couple of PDF Importing Questions
- 2 comments
- Log in or register to post comments
importing date formatted column names
Forums
Hey there.
I'm trying to import a data table from sql server which has at least 42 columns. These columns represent the date of the last of 36 months. Now every column title has its name like this 2015-02-28,...,2018-08-31.
In my first run I just paste Select * from table in Idea to import the data, all the columns got imported, but the 42 columns was titled Column1, Column2,..., Column42.
So I tried to import the data again whith this query:
- Read more about importing date formatted column names
- 2 comments
- Log in or register to post comments
Converting Difficult Formatted PDF
Forums
I'm having trouble converting a PDF with more difficult formatting. It is formatted similar to below for example. I can grab the personal info first line easily. I just need the Number total for both before tax and after tax as seperate columns. The issue is there is nothing different in either line to differentiate them. So I've grabbed the Number Total using a blank trap in the start of the line + a number trap where there is always number. This highlights both totals. However when you import this, it only takes the first total and ignores the second.
- Read more about Converting Difficult Formatted PDF
- 4 comments
- Log in or register to post comments
Importing csv file separated with "Other" delimiter
Forums
Hi,
I'm trying to import .csv file into IDEA (database around 2,5 GB) where is used separator ";?;" = more than 2 characters.
Is it possible to use some Script or something which is able to use more than 2 character delimiter?
Thanks in advance.
Importing Time-Field Type Datas which includes NULL-Values
Forums
Dear ideascripting.com users,
as I am working with IDEA, an error occurs if I convert a Char-Field Type to TIME-Field Type after importing from Excel. The problem further explained:
Importing an Excel File
Forums
Hi
I am just starting out on my IDEA scripting journey and was wondering if anyone could help me with some script for importing an Excel file. I am creating a macro which will be used by a colleague and I would like the macro to give the user the abilty to select the file that they wish to import. The import script in the history explicitly states the working folder and file name so this will not work when the file name changes.
I hope this makes sense!
Thanks
Chris
- Read more about Importing an Excel File
- 3 comments
- Log in or register to post comments
Importing Subheaders in a print report file
Forums
Hi
What would you do to achieve bringing in print reports that have multilevel subheader. In the example below there's a sub header will fill in all blanks lines below it should the "use value from previous record" option is selected. Picking you brain on this matter. Any suggestion is much appreciated.
Accounts Payable
- Read more about Importing Subheaders in a print report file
- 5 comments
- Log in or register to post comments