Questions on Importing
Issue with importing date field from text file
Forums
Hi ,
I am trying to import data from a delimted text file which is produced as a result of Sql server bulk copy. After importing, date fields are showing as 'Error'. If I set rawDataType as RawDataType.it_asciiCharacter, then it is working. But data type of the column is shown as Char.
Example date value in the text file: 2/6/2012
A row in the text file will be like this
IN 00059|9082|Purchase ledger|7|2012|7|7/26/2012|7/26/2012|20|tax.pay|1000|0|346.62|C|False
Column delimeter is pipe (|)
Importing EBCDIC Files
Forums
Hi There
I need some assistance please. I have a file with the extension IBM File. I understand that it could be an EBCDIC Fixed Length "File Type." Any ideas on how to import?
Thank you in advance?
Regards
Aveen
- Read more about Importing EBCDIC Files
- 2 comments
- Log in or register to post comments
The alignment of a PDF file changes in report reader
Forums
I found this question on the IDEA linkedin site and thought I would copy it here as it is interesting.
I have a PDF file that looks straight forward and would appear to be an easy file to import. When I import it into report reader the alignment changes and what I believe to be an easy task becomes more difficult. For example, columns don't line up and spaces are inserted into the data. Any ideas for addressing this?
I reprinted the file using a PDF printer, and changed the "Default" properties to "High Quality". The new file worked like a charm!
- Read more about The alignment of a PDF file changes in report reader
- Log in or register to post comments
Importing Data using XML
Forums
Importation EXCEL x IDEA
- Read more about Importing Data using XML
- 16 comments
- Log in or register to post comments
Importing with the file name
Forums
Hi Brian,
I´ve using your fantastic script for importing multiples files but I´ve a found a difficulty that I don´t know how to solve.
When importing multiple files I would like to create a new field so it could show the original file name. This way, when I join the files ( a few hundred) that I´m importing I can track any item to the original file.
Any ideas for that?
Thank you in advance.
- Read more about Importing with the file name
- 2 comments
- Log in or register to post comments
ODBC driver
Forums
Hi,
When importing QuickBooks tables into IDEA via the ODBC driver in the IDEA import window, i sometimes get tables that either have missing information in certain tables or tables that dont have transactions at all. When i go directly into QuickBooks, those transactions are there in the reports.
Questions:
Does IDEA have it's own built-in ODBC drivers?
Is it a known issue that some information may not be imported when using IDEA's ODBC driver?
Any suggestions on how to fix this? New driver download?
Thanks
Marc
- Read more about ODBC driver
- 3 comments
- Log in or register to post comments
Building an XRDF file to import an XML file
Forums
I received an XML file from a client. I attempted to go through the import wizard and import the file. I followed the prompts and told it to import all of the fields. The result was not usable (no surprise there).
So now I am trying to create an XRDF file with the field definitions and I have no idea what the file should look like and I have been unable to find any guidance on what it should contain. I've spent quite a while on Google trying to locate it (perhaps using the wrong search terms) and I'm coming up dry. Any help?
- Read more about Building an XRDF file to import an XML file
- 7 comments
- Log in or register to post comments
Importing Data using ODBC connection
Forums
Hi,
I have the Mastering IDEAScript manual (by John Paul Mueller) and I can't seem to find any examples of importing data using an ODBC connection to Oracle within a macro. It is quite simple using the import assistant but my users have no SQL knowledge. Essentially what I would like to achieve is to create a dialog box which allows the user to enter an ID number and a fiscal year. Using those values as parameters I would like to import the data into IDEA.
SQL Example:
- Read more about Importing Data using ODBC connection
- 26 comments
- Log in or register to post comments