Issue with Jackcess ExportFilter

╰半夏微凉° 2022-05-16 09:28 269阅读 0赞

# [Issue with Jackcess ExportFilter][] #

[Ask Question][]

up vote2down vote[favorite][]

I found a great library called **Jackcess**, allows you to convert, parse create, etc with Microsoft Access.

The aim is to convert, which this code does successfully.

There is a **Filter functionality** upon export, this can be seen on the link to the documentation below. The aim is to use the **first 3 columns**, exclude the rest of the data.

[ExportUtil Documentation][]

Applying the filter object doesn't work, does anyone know if there's something else that needs to be ahcieved first... \* scratching my head here \*

[Export Filter Documentation][]

public void db_dump(String mdbFile, String outputDir) {
        File file = new File("/Users/testUser/Downloads/example.mdb");
        if(file != null) {
        File outDir = new File("/Users/testUser/Desktop/output123");
        boolean success = outDir.mkdir();
            if (success) {
                Database db = null;
                try {
                    db = DatabaseBuilder.open(file);
                    Table t = db.getTable("MappedCHTCP");
                    List<Column> cols  = new List<Column>() 
                        @Override methods for list ommited .... size(), contains(), etc
                    System.out.println(t.getColumns());
    
    //                  cols.add(0,t.getColumn("word"));
    
                     for (Column c : t.getColumns()) {
                          if((c != null) && (c.getColumnIndex() < 3)) {
                              System.out.println(c.getName());
                              cols.add(c);
                          }
                     }
    
                    SimpleExportFilter ef = new SimpleExportFilter(); //THIS IS THE PROBLEM
                    ef.filterColumns(cols);
    
                    File csvFile = new File(outDir+File.separator+"MappedCHTCP.csv");
                    ExportUtil.exportFile(db, "MappedCHTCP", csvFile, false, null, '"',ef); //NOT ABLE TO APPLY FILTER
    
                } catch (IOException e) {
                    e.printStackTrace();
                }
    
            }
        }
    }

[java][] [ms-access][] [csv][] [jackcess][]

[share][][improve this question][]

[edited Apr 15 '14 at 13:41][edited_Apr 15 _14 at 13_41]

[![6QjmY.jpg_s_32_g_1][]][6QjmY.jpg_s_32_g_1 1]

[Gord Thompson][6QjmY.jpg_s_32_g_1 1]

73.6k1180191

asked Apr 15 '14 at 8:58

[![e13d6a5e3259a229d76549844895d089_s_32_d_identicon_r_PG][]][e13d6a5e3259a229d76549844895d089_s_32_d_identicon_r_PG 1]

[RST][e13d6a5e3259a229d76549844895d089_s_32_d_identicon_r_PG 1]

352621

*  Thanks for looking... it's really strange! It doesn't matter weather you construct the object inside the `exportFile` function. – [RST][e13d6a5e3259a229d76549844895d089_s_32_d_identicon_r_PG 1] Apr 15 '14 at 17:54

add a comment

## 1 Answer ##

[active][][oldest][][votes][]

up vote3down voteaccepted

Based on what I found in the unit test code [here][], the following sample code seems to work. It exports only the first three (3) columns of the table named \[Members\]:

package jackcessTest;
    
    import java.io.File;
    import java.util.*;
    import com.healthmarketscience.jackcess.*;
    import com.healthmarketscience.jackcess.util.ExportFilter;
    import com.healthmarketscience.jackcess.util.ExportUtil;
    import com.healthmarketscience.jackcess.util.SimpleExportFilter;
    
    public class JackcessTest {
    
        public static void main(String[] args) {
            try (Database db = DatabaseBuilder.open(
                    new File("C:/Users/Public/mdbTest.mdb"))) {
    
                ExportFilter eFilter = new SimpleExportFilter() {
                    private List<Column> _cols = new ArrayList<Column>();
                    private int _colIdx = 0;
                    @Override
                    public List<Column> filterColumns(List<Column> columns) {
                        for (Column c : columns) {
                            if (_colIdx++ < 3) _cols.add(c);
                        }
                        return _cols;
                    }
                };
    
                ExportUtil.exportFile(
                        db, 
                        "Members", 
                        new File("C:/Users/Public/zzzJdump.csv"), 
                        true, 
                        ",", 
                        '"', 
                        eFilter);
            } catch (Exception e) {
                e.printStackTrace(System.out);
            }
        }
    }

[share][share 1][improve this answer][]

[edited Apr 16 '14 at 20:55][edited_Apr 16 _14 at 20_55]

answered Apr 16 '14 at 16:16

[![6QjmY.jpg_s_32_g_1][]][6QjmY.jpg_s_32_g_1 1]

[Gord Thompson][6QjmY.jpg_s_32_g_1 1]

73.6k1180191

*  That's brilliant, thank you ever so much! Not very clear is it :). Hopefully this will help someone in the future.– [RST][e13d6a5e3259a229d76549844895d089_s_32_d_identicon_r_PG 1] Apr 17 '14 at 8:41

[Issue with Jackcess ExportFilter]: https://stackoverflow.com/questions/23078954/issue-with-jackcess-exportfilter
[Ask Question]: https://stackoverflow.com/questions/ask
[favorite]: https://stackoverflow.com/questions/23078954/issue-with-jackcess-exportfilter/23114857#
[ExportUtil Documentation]: http://jackcess.sourceforge.net/apidocs/com/healthmarketscience/jackcess/ExportUtil.html#exportAll%28com.healthmarketscience.jackcess.Database,%20java.io.File,%20java.lang.String,%20boolean%29
[Export Filter Documentation]: http://jackcess.sourceforge.net/apidocs/com/healthmarketscience/jackcess/ExportFilter.html#filterColumns%28java.util.List%29
[java]: https://stackoverflow.com/questions/tagged/java
[ms-access]: https://stackoverflow.com/questions/tagged/ms-access
[csv]: https://stackoverflow.com/questions/tagged/csv
[jackcess]: https://stackoverflow.com/questions/tagged/jackcess
[share]: https://stackoverflow.com/q/23078954
[improve this question]: https://stackoverflow.com/posts/23078954/edit
[edited_Apr 15 _14 at 13_41]: https://stackoverflow.com/posts/23078954/revisions
[6QjmY.jpg_s_32_g_1]: https://i.stack.imgur.com/6QjmY.jpg?s=32&g=1
[6QjmY.jpg_s_32_g_1 1]: https://stackoverflow.com/users/2144390/gord-thompson
[e13d6a5e3259a229d76549844895d089_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/e13d6a5e3259a229d76549844895d089?s=32&d=identicon&r=PG
[e13d6a5e3259a229d76549844895d089_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/1695807/rst
[active]: https://stackoverflow.com/questions/23078954/issue-with-jackcess-exportfilter?answertab=active#tab-top
[oldest]: https://stackoverflow.com/questions/23078954/issue-with-jackcess-exportfilter?answertab=oldest#tab-top
[votes]: https://stackoverflow.com/questions/23078954/issue-with-jackcess-exportfilter?answertab=votes#tab-top
[here]: http://jackcess.sourceforge.net/xref-test/com/healthmarketscience/jackcess/util/ExportTest.html
[share 1]: https://stackoverflow.com/a/23114857
[improve this answer]: https://stackoverflow.com/posts/23114857/edit
[edited_Apr 16 _14 at 20_55]: https://stackoverflow.com/posts/23114857/revisions