Questions on Importing
Extra letters between words when importing .txt files
Forums
Good Morning/Afternoon,
I have encountered some instances of extra spaces occuring between letters in words when attempting to import .txt files utilizing the Print Report and Adobe PDF Import Assistant.
Save credentials to execute scheduled tasks
Forums
I have managed to improve three queries to avoid input of data, because I need to automate those to generate data every first day of the month. I have a clear idea about what to do about windows schedule manager, but the problem comes with the following situation.
Everytime I need to import data and select the odbc connection, I need to provide my credentials (user and pass), by the way we use SYBASE.
Is there a way to save credentials in other place and load it to run the schedule task on windows?
- Read more about Save credentials to execute scheduled tasks
- 1 comment
- Log in or register to post comments
Connect to postgresql
Forums
Hi guys,
I want to import my data to a postgresql database so then Access it using IDEA.
It's hard to find a tutorial showing how to Setup The connection.
Someone can help me?
I don't use IDEA, but I'm responsible for taking data from severa sources (including webscraping) and delivery it to IDEA users.
- Read more about Connect to postgresql
- 2 comments
- Log in or register to post comments
Importing limited portion of multiple PDF having different lenght.
Forums
Good morning I am trying to import just a specific portion of the PDF file that have the same structure but different lenght due to the number of paycodes used by the clients.
I need to retreive the transaction as per layer in the picture 1 and stop doing at the point of the picture 2
I have created the a two layers template to get a file with an indicator, the layer of the picture 2 was meant to give me some marking point as to where to split the outputfile and get only transactions needed. Picture 3
CANNOT define field anchors
Forums
I've been trying to define field anchor, but the IDEA program stops running whenever I highlight the information.
Does anyone know how to deal with it??
- Read more about CANNOT define field anchors
- 1 comment
- Log in or register to post comments
Importing Messy TXT Data
Forums
Good morning,
I have searched for topic like this but I did not find it.
I have a quite messy txt I am trying to import. I attach a small excerpt.
The best try was delimiting by Tab and modify the type of data field but it still not workable.
File too large to be imported in excel, but it looks like it is able to split it and import the data even though it doeas not convert dates properly.
Do you know how overcome the issues?
Many thanks
Vito
- Read more about Importing Messy TXT Data
- 2 comments
- Log in or register to post comments
Importing multiple text/csv files without using the RDF file.
Forums
Hello Everyone
I hope all is well.
Is it possible to import many text or csv files at once without using the RDF file?
Can't get report reader to read a pdf
Forums
Hello,
I'm having an issue getting IDEA to recognize the text in PDFs, I've had it happen across multiple different files.
The PDF looks fine when I open it in Adobe Reader, the text is highlightable, I can't use OCR because the text is already selectable.
But when I go to import the PDF into IDEA, it just gives me blank lines. Any idea why that is?
- Read more about Can't get report reader to read a pdf
- 4 comments
- Log in or register to post comments
work around 1024 character limit for text fields
Forums
Hi,
is there a way to work around the 1024 character limit during the import?
For example split the field with more than 1024 characters into two or mor fields.
Background:
I have to import Log-Files and some fields are definitive longer than 1024 characters.
Due to the amount of files I'm not able to split them manually.
Thx in advance
Norbert
Importing ODBC excel file
Forums
Hey Brian.I am trying to prepare a script which lets user to open a excel file with ODBC. I uploaded my sample excel and this is my code so far. I looked some of your codes in different examples but I couldn't achieve the result. I am getting an error at ";DefaultDir=" part which wants me to specify folder location. There is a syntax error at that part. Any help is appreciated. Have a nice day.
Dim sFilename As String
Dim workingFolder As String
Sub Main
- Read more about Importing ODBC excel file
- 1 comment
- Log in or register to post comments