IDmap __map.db file

[matthe...@gmail.com]

any pointers as to the format of this db file? 

I would like to dump our 12GB file to a csv file at the command line.

possible?

[matthe...@gmail.com]

ok i found the answer in an older post..... JDBM

revised question: 

has anyone figured out a way to programmatically pull maps from CTP web portal? 

since the links are all javascripts and not URL-based, I guess curl is out of the question.

plus there is the login page.....

[John Perry]

There is no way to access the database file of the IDMap stage from the command line.

The best I can offer is this:

1. Upgrade your CTP to the latest one (dated 3/18/2024) on:

    https://github.com/johnperry/CTP/blob/master/products/CTP-installer.jar

2. On the CTP home page, click the IDMap stage in the left pane to get to the Search IDMap page:

In the Select Key Type field, select the map you want to export.

Leave the Enter Keys field blank.

In the Select Return Format field, select the format you want for the output (HTML, CSV, or XML).

Click the Search button.

If you have selected CSV or XML, it will download the data into a file.

XML will look like this:

CSV will look like this:

If you have multiple gigabytes of table data, I fear that you will run out of heap space unless you run CTP with a large Maximum memory pool parameter on the Launcher General tab.

JP