Questions on Importing
Importing Excel that contains blank Rows
Forums
Hi Brian,
We have a spreadsheet that is generated monthly by HR and is dumped into a shared folder in .xlsx format. Unfortunately the top 2 rows of the .xlsx file is used as a header which is throwing IDEA when I try to import the file.
My first guess is to have Excel grab the file open it, remove the rows and re-save the file then import with IDEA. Second is to use Excel to convert the .xlsx file to a .txt and import (ignoring the first few lines).
- Read more about Importing Excel that contains blank Rows
- 1 comment
- Log in or register to post comments
Importing using SQL Script
Forums
Using "advanced" to enter SQL for ODBC connections, Is it possible to declare SQL variable?
I.e (Declare @table TABLE (*fields*); *code to populate table*; select * from @table )
Pulling my data through first, then manipulating it isn't viable in this case
- Read more about Importing using SQL Script
- 5 comments
- Log in or register to post comments
Multiple file import from report reader
Forums
I have a text file, which I have imported through report reader.
There is a template set up to recognise the columns.
I have 12 monthly sales reports.
How can I import, apply template and merge results into one database?
The multiple import function built into idea only allows files of the same type to be imported.
Due to a two step process (taking text file and converting to pdf), I cannot do a multiple file import.
What are the shortcuts I can apply (if any)?
- Read more about Multiple file import from report reader
- 10 comments
- Log in or register to post comments
How to import polish text
Forums
Hi,
I am trying to import some text in Polish.Idea does not recognize Polish character.
I have added some font in polish in my os (windows 7) without any result.
Do you know a way that it could allow IDEA to detect polish language ?
Thank you for your help.
Kind regards,
Mourad
- Read more about How to import polish text
- 3 comments
- Log in or register to post comments
Importing Excel file, blank cells
Forums
I am importing an Excel file, but some of the cells from the original spreadsheet are coming up as blank in IDEA after the import. It happens in various fields for various records with no apparent rhyme or reason. Do you know why this might occur? We are on version 8. Thanks.
- Read more about Importing Excel file, blank cells
- 3 comments
- Log in or register to post comments
HL7 importing?
Forums
I'm looking to import files of HL7 messages. HL7 is a heirarchical message format specific to healthcare. Has anyone flattend a hl7 file, or know of any tools to flatten them prior to import? Or any generaladvice for flattening a heirichacal dat file in general...as you can see, i need your help! :)
hl7 on wikipedia for the curious: https://en.wikipedia.org/wiki/Health_Level_7
Rob
- Read more about HL7 importing?
- 1 comment
- Log in or register to post comments
Automatic RDF Creation
Forums
Hi Brian,
I am new in this Forum. It is very helpfull, thank You!
I have got some experience using ACL and IDEA Script. For automatic IDEA import purposes (eg. plain text- or delimited files) I often use RDFCREATOR functions. Unfortunately there are only few information about the procedures into the RDFCREATORLIB. Do you know, if it is possible to get a better or complete documentation?
kind regards
Roger
- Read more about Automatic RDF Creation
- 3 comments
- Log in or register to post comments
Importing Excel File
Forums
Hello everybody,
it is actually the first time that I use IDEA for programming. Brian, I have had a look at your script which allows to import multiple Excel files from one folder into IDEA. Unfortuately, I could not solve my problem.
I recorded a macro in IDEA allowing to import just a single Excel file.
- Read more about Importing Excel File
- 6 comments
- Log in or register to post comments
Linking to IBM DB2 replicated database using ODBC
Forums
I tried running my data query in excel and in idea.Neither are correct - Any thoughts on what I am seeing. I was hoping with only 4 fields that either Idea or Excel could import the data correctly, but no luck.Thanks!
Excel
Comment = text = correct
Comment id = column is missing = wrong
Created by = alphanumeric = correct
Reg note id = column is missing = wrong
Idea
Comment = numeric (character) = wrong
Comment ID = hexadecimal (character)= wrong
Created by = alphanumeric (character)= correct
Importing a file with blank rows
Forums
Every month I have a file that is automatically generated by another department and saved to a shared drive as an .xlsx file. The problem is the top few lines of the file are loginfo such as file title, ID, run time etc., but causes an issue with importing into IDEA since the first row is not the data header row. More specifically, the header starts on row 4, with information on rows 5+
- Read more about Importing a file with blank rows
- 2 comments
- Log in or register to post comments