Skip to main content

Questions on Importing

Assign a unique ODBCImport result to a variable

Hi there.
I'm working on a script that receives at least 6 input values: login, password, initial date, final date, main office, and local office.
The last 2 variables get a number (office identifier), but I only care about one of them: main office. I would like to query the description associated to that office number (unique value) and assign it to a variable in order to concatenate that value to every name of database or file  I generate by executing my script.
Any advice or sample would be more than welcomed.  Thanks a lot!

Importing dates

Hi, I'm importing information from my state's vital records agency. The data was given to me in Notepad format. Birth dates are listed as MMDDYY. It appears that when importing, birthdates between 1900 - 1929 are being displayed as 2000, 2010, 2029, etc. Everything later than 1929 is importing correctly. Any ideas on how to get the birthdates between 1900 - 1929 to display correctly?

Importing numeric field with a different decimal mark

Hi Brian!
I need your help againg! Thank you very much in advance!
I´m importing a plain text file with numeric files where their decimal mark is different from my computer setting´s. My computer´s default decimal mark is a comma, while numeric fields in this file have a point.   So when I try to import, IDEA recognize that fields as a text ones.
I guess I could change the regional settings, restart the computer, try to import the file and change the setting and restart. It seems a little bit of a mess.

Append a column in the imported file with its file name

Hello everyone,
Hope you all are doing great.
I have a question regarding data importing. Is it possible to append a column with its file name when it is importing to IDEA? for example, My file name is XXX and i want to import the file into IDEA and after that i need to append the file name (i.e. XXX) to that database as a seperate column. I use to utilize multiple data import macro which i sdeveloped by Brian and that is really amazing. Is it possible to incoporate this option to that?
Eagerly waiting for valuable suggestions
Thanks,
Bibin K B

Importing of PDF Files

Hello everyone.
I am working on importing a PDf file into IDEA for a client.  When I open up the file in Adobe Reader, the columns align under the column titles and the report looks nice and formatted.
However, when it goes through the Report Reader in IDEA, the data in the columns appears to shift and it does not looks as aligned as it was in Adobe Reader.  I tried to use the floating trap approach with this file, but did not have much success.