Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX 18.2 Data Load Wizard w date format - no data found

K Cannell TH TechJan 21 2019 — edited Feb 13 2019

Anyone working with the APEX 18.2 Data Load Wizard?

Working with a vanilla data load wizard - no transformations, no rules, straight upload against a table -

whenever I enter a date format for a field - i.e. DD/DD/YYYY for a BIRTH_DATE filed, I get  "no data found"  when I click Next on the Column Mapping page.

When I remove the date format, all works fine.

When I enter the data format in double quotes, I get to the next page,  then get a literal date format error upon data load.

Has anyone gotten past this?

What Is the data load wizard expecting for a Date format?  It used to be no quotes, just the format.

For our application we  need the date format - our different users send us data in different date formats.

Yeah, we could preprocess the file but … this is an APEX feature that is supposed to work, and has worked in the past.

Does anyone have any insights here?

Thank you,

Karen

This post has been answered by K Cannell TH Tech on Jan 26 2019
Jump to Answer

Comments

darrylburke
Probably not very efficient, but seems to work ... fairly clean imho :-)
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.Graphics;
import java.awt.Rectangle;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTextPane;
import javax.swing.SwingUtilities;
import javax.swing.event.CaretEvent;
import javax.swing.event.CaretListener;
import javax.swing.plaf.basic.BasicTextPaneUI;
import javax.swing.text.BadLocationException;

public class LineHighlightTextPane {
   
   public LineHighlightTextPane () {
   }
   
   void makeUI () {
      
      JTextPane textPane = new JTextPane ();
      textPane.setUI (new LineHighlightTextPaneUI (textPane));
      
      JScrollPane scrollPane = new JScrollPane (textPane);
      
      JFrame frame = new JFrame ("Line Highlight Text Pane");
      frame.setDefaultCloseOperation (JFrame.EXIT_ON_CLOSE);
      frame.setSize (300, 300);
      
      frame.add (scrollPane, BorderLayout.CENTER);
      frame.setVisible (true);
   }
   
   public static void main (String[] args) {
      SwingUtilities.invokeLater (new Runnable () {
         public void run () {
            new LineHighlightTextPane ().makeUI ();
         }
      });
   }
}

class LineHighlightTextPaneUI extends BasicTextPaneUI {
   
   JTextPane tc;
   
   LineHighlightTextPaneUI (JTextPane t) {
      
      tc = t;
      tc.addCaretListener (new CaretListener () {
         public void caretUpdate (CaretEvent e) {
            
            tc.repaint ();
         }
      });
   }
   
   @Override
   public void paintBackground (Graphics g) {
      
      super.paintBackground (g);
      
      try {
         Rectangle rect = modelToView(tc, tc.getCaretPosition ());
         int y = rect.y;
         int h = rect.height;
         g.setColor (Color.YELLOW);
         g.fillRect (0, y, tc.getWidth (), h);
      } catch (BadLocationException ex) {
         ex.printStackTrace();
      }
   }
}
Is that what you wanted or have I misread the requirement?

db
camickr
Or some code that should work on any JTextComponent:

http://www.discoverteenergy.com/files/LinePainter.java
843806
Thanks a lot for the help guys! I was able to do exactly what I needed.
1 - 3

Post Details

Added on Jan 21 2019
9 comments
4,081 views