Questions on Importing

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!

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?

Hi,
 
Is there any difference in functionality if we import an excel sheet using Import Assistant window and drag and drop file? Any open issues or limitations on using drag and drop option? 
 
Thanks,
Shafeer

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.

Im  using Idea 10 on a Citrix Server (Windows 2008 r2, XenApp ).  Data analysis is sluggish on Large Data files.  What is suggested, migrate to SQL, Oracle ?
And if so , how to migrate SQL Platform

Hey there, Brian. Sometime ago I asked you about  using a login form in ideascript, with the style property for masking password as ******. You answered me, as always, but I've lost all my messages in my account. Could you please tell me wich value has to take STYLE?

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

Hello everybody,

I will keep it short:

General:
I have to provide files (that have to follow a specific format) to the tax authorities on a regular basis.

Hi There
I am currently using IDEA 10. I am trying to import a EBCDIC File that has an extension (.txt) I have attached a picture. Any idea's?
Thank you
Regards
Aveen

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.