US and Worldwide: +1 (866) 660-7555

Search Forums:

Type: Posts; User: darrell.nelson; Keyword(s):

Page 1 of 16 1 2 3 4

Search Forums: Search took 0.06 seconds.

  1. Even the JavaScript conversion can be vastly...

    Even the JavaScript conversion can be vastly simplified (down to a one-liner!) with that Apache POI Util class:

    var converted_AD_time = org.apache.poi.hpsf.Util.filetimeToDate(AD_time);
  2. Replies
    2
    Views
    43

    Try using the Filter rows step to separate the...

    Try using the Filter rows step to separate the aging from the non-aging passwords.

    http://wiki.pentaho.com/display/EAI/Filter+Rows
  3. Yep, here's an even easier and more efficient way...

    Yep, here's an even easier and more efficient way to convert Active Directory time values to Kettle/Java Date values. Since Apache POI is already an integral part of Kettle, a User Defined Java...
  4. I found another way to handle the conversion! I...

    I found another way to handle the conversion! I knew someone had already done the math on this but I didn't find it on my first cut. I'll post a sample using this class tomorrow if someone hasn't...
  5. You are encountering three different time...

    You are encountering three different time formats, which are roughly:
    1. AD is using the number of 100-nanosecond intervals since 1/1/1601
    2. Excel is using the number of days since 1/1/1900
    3....
  6. I have attached a modified version of your...

    I have attached a modified version of your transformation that parses your attributes field using the Split fields to rows and Split fields steps. Here is a preview of the output. If you want the...
  7. Hmmm. You don't seem to have JSON-formatted data...

    Hmmm. You don't seem to have JSON-formatted data (basically, name-value pairs separated by colons and enclosed in curly braces) so it stands to reason that the Json input step won't handle it very...
  8. Replies
    1
    Views
    47

    I may have a few answers to your questions. 1....

    I may have a few answers to your questions.
    1. Columns outside the schema should not be fetched. The should not be in the SQL statements.
    2. You can "put load" on a separate DB server by enabling a...
  9. 1) Your are not specifying a 'Format' string so...

    1) Your are not specifying a 'Format' string so no currency formatting will be inserted.
    2) The 'Group' symbol should be either a '.' or a ',' but you are not providing a 'Format' string so...
  10. That seems unusually slow. How wide are the rows?...

    That seems unusually slow. How wide are the rows? Are you dependent on a slow network?

    For further troubleshooting, try reading the source data from Oracle and dumping it to a local CSV file. Then...
  11. It's not a totally crazy approach but was it...

    It's not a totally crazy approach but was it available in 3.2.5? That's so far back I have no idea!
  12. You could use a JavaScript step. Be sure to sort...

    You could use a JavaScript step. Be sure to sort your rows on the STUDENT_ID first though.


    var ROW_ID;

    if (ROW_ID == null) {
    ROW_ID = 0;
    _previous = -1;
    }
  13. No. It is the step just below the Add sequence...

    No. It is the step just below the Add sequence step, in Spoon version 4.4.0-stable anyway.

    13158
  14. Replies
    1
    Views
    69

    You will probably have to write a User-defined...

    You will probably have to write a User-defined Java Class to perform a transpose. Obviously, you will have to accumulate all the input data rows before transposing and writing the output rows. Look...
  15. Try using the "Add value fields changing...

    Try using the "Add value fields changing sequence" step.
  16. You may have to dig into the source code to...

    You may have to dig into the source code to determine what happens at cube initialization. I was thinking it was the fact table that was being scanned. Or you could probably increase the query...
  17. Yeah, 35 flags is a bit more involved than 3. ...

    Yeah, 35 flags is a bit more involved than 3.

    For the handling of the description, I think you could do it either way - degenerate dimension or regular dimension. My preference is to keep my fact...
  18. Yes, a WHERE clause in the SQL query of a Table...

    Yes, a WHERE clause in the SQL query of a Table input step should work.

    You can compute the time for the WHERE clause in several ways. Here's one way utilizing JavaScript:


    calendar =...
  19. Replies
    3
    Views
    106

    That's good detective work! If this is not...

    That's good detective work! If this is not already reported as a bug, you should do so.
  20. Can you clarify your data a little? Is it...

    Can you clarify your data a little? Is it acceptable for more than one of those flags to have a value of 1 in the same event?

    If No: Change those flags to "enumerated" and move them into a normal...
  21. I have used the JDBC-ODBC bridge driver on Access...

    I have used the JDBC-ODBC bridge driver on Access files in the past with some success. I recall getting this type of error when the data was corrupt or invalid but I don't remember getting different...
  22. Replies
    7
    Views
    157

    You have to add a Hierarchy to your Dimension...

    You have to add a Hierarchy to your Dimension first. Then you can add Levels to the Hierarchy. I think what you are calling attributes (in the first half of your xml fragment) are actually Levels....
  23. You can easily write the data out from within the...

    You can easily write the data out from within the transformation you read it with; just add a Microsoft Excel Output step or a Table output step as the next step.

    Ultimately, you will probably...
  24. Replies
    10
    Views
    199

    Ah, I didn't realize the folder structure was...

    Ah, I didn't realize the folder structure was changed from 4.4.
  25. Replies
    10
    Views
    199

    I think you want to put the jar in the...

    I think you want to put the jar in the libext/JDBC folder and then restart Spoon. That's where all the rest of the jdbc driver jars are located.
  26. Your are on the right track. Here are my comments...

    Your are on the right track. Here are my comments and recommendations:

    The lookups will always add new fields to each row. If you have duplicate names, the lookup will actually modify the name...
  27. Another Get data from XML step and then a Stream...

    Another Get data from XML step and then a Stream lookup step should do what you are looking for. The attached sample2.ktr performs a lookup into the configuration data based on an ID in the...
  28. Whew! I have dozens of transformations that use...

    Whew! I have dozens of transformations that use that step. So attached is a whopping one-step sample transformation the uses Get data from XML on your data. Doesn't get much easier than that. (Note...
  29. Sure, security should be considered. In either...

    Sure, security should be considered. In either case, PDI will work well to populate the data warehouse. In the XML case, I would most likely use the Get data from XML step - just select the file on...
  30. Okay then, do you really even need to go through...

    Okay then, do you really even need to go through XML files? Is there any reason you can't just use Kettle to pull the transaction data directly from the MS SQL Database(s) and populate a Data...
  31. Do you even need Kettle? There are reporting...

    Do you even need Kettle? There are reporting tools, such as Pentaho PRD and BIRT, that can read XML directly and produce reports.
  32. Replies
    2
    Views
    117

    Each step in a transformation is a "row...

    Each step in a transformation is a "row processor". The Table Input step, in your case, will send 12000 rows (with 1 column in each) to the downstream-connected step(s). Each downstream step (such as...
  33. Did you try placing the jar in the folder...

    Did you try placing the jar in the folder ..\data-integration\libext\? I believe you will have to restart Spoon in order for it to pick up new jars.
  34. Do you really need to use PDI to clone database...

    Do you really need to use PDI to clone database A? I would simply use mysqldump.exe (because I use MySQL databases, of course) on database A and then restore it to database B. PDI is not the best at...
  35. You need to account for the time zone offset...

    You need to account for the time zone offset that's included in your input data. Change your date format string to "dd/MMM/yyyy:HH:mm:ss Z".
  36. Thread: replace

    by darrell.nelson
    Replies
    4
    Views
    256

    If you try to replace a string that isn't there...

    If you try to replace a string that isn't there it will do nothing and proceed. Why do you think you need to search first?

    Also, what is all this "pms" you keep referring to? That's an English...
  37. You could try editing Spoon.bat and adding the...

    You could try editing Spoon.bat and adding the -verbose option to the java command in order to troubleshoot further. You will probably want to redirect the output to a file because there will be a...
  38. From the folder with Spoon.bat in it, is there a...

    From the folder with Spoon.bat in it, is there a sub-folder libswt\win32 with the following files in it?

    12555
  39. Try removing the "\bin" from your JAVA_HOME...

    Try removing the "\bin" from your JAVA_HOME environment variable.
  40. I still think denormalizing is not necessarily...

    I still think denormalizing is not necessarily the best way to go but I have a few questions/concerns to help the thought process along:

    You say you have 155 lines to denormalize but do you...
  41. Do you really need to denormalize? Is it possible...

    Do you really need to denormalize? Is it possible to just update each field one-row-at-a-time with a carefully crafted Execute SQL Script step?
  42. Can you attach to your post the text file or at...

    Can you attach to your post the text file or at least a portion of it? You will have to "Go Advanced" to do so.
  43. Replies
    4
    Views
    232

    Hey that's nice! Thinking back, I'm sure I didn't...

    Hey that's nice! Thinking back, I'm sure I didn't use the quoting of the table identifier in the manner that you did.
  44. There is a Delay Row step that can be inserted in...

    There is a Delay Row step that can be inserted in order to slow down the processing of the rows by a fixed time value.

    Another option would be to build up the rows in a job and then execute them...
  45. This can be done in two steps: Calculate a...

    This can be done in two steps:

    Calculate a group number that increments every time Col1 is 1. The Modified Java Script Value step will work nicely for this.
    Use the Group By step with the...
  46. Replies
    4
    Views
    232

    I've tried a few times but haven't been able to...

    I've tried a few times but haven't been able to make views work in Schema Workbench. However, when I define the view on the database itself, i.e., using MySQL Workbench, the views appear the same as...
  47. Replies
    2
    Views
    282

    No, you aren't. You are setting it to an empty...

    No, you aren't. You are setting it to an empty string. There is a difference.

    Try using this for your test:

    if (man_date_val.equals(""))
    {
    ...
  48. I normally use that connection pool class for my...

    I normally use that connection pool class for my data in a standalone instance of Tomcat. I'm not an enterprise console user. Hopefully, increasing the timeout parameter will solve your problem.
  49. I normally use this connection pool class:...

    I normally use this connection pool class: org.apache.tomcat.jdbc.pool.DataSourceFactory. Perhaps your issue is a hibernate issue? (which I have absolutely no experience with.)

    Have you tried...
  50. Using SchemaWorkbench, Mondrian doesn't seem to...

    Using SchemaWorkbench, Mondrian doesn't seem to allow multiple JDBC connections. You can see the full stack trace in the .schemaWorkbench\workbench.log file located in your "home" directory.
Results 1 to 50 of 754
Page 1 of 16 1 2 3 4