Questions on Importing
Assign a unique ODBCImport result to a variable
Forums
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
Forums
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?
- Read more about Importing dates
- 13 comments
- Log in or register to post comments
Any difference in importing using Import Assistant and drag and drop?
Forums
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
Importing numeric field with a different decimal mark
Forums
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.
Large Data Analysis slow
Forums
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
- Read more about Large Data Analysis slow
- 1 comment
- Log in or register to post comments
Style: Textbox property
Forums
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?
- Read more about Style: Textbox property
- 2 comments
- Log in or register to post comments
Append a column in the imported file with its file name
Forums
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
Automatic insertion of field descriptions for standard tables
Forums
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.
Importing a EBCDIC File
Forums
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
- Read more about Importing a EBCDIC File
- 10 comments
- Log in or register to post comments
Importing of PDF Files
Forums
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.
- Read more about Importing of PDF Files
- 5 comments
- Log in or register to post comments