ComboCurve: ARIES Export - (Blocked) When Daily Production Data Exceeds 480k Lines

If you receive an error such as this when export to ARIES .accdb:

This article describes a workflow in Excel using VBA to allow export of CC daily prod data to .csv so that it can be imported natively into ARIES.

Reason:

Excel csv can't handle more than 1.048mm lines of prod

CC exports truncate over 480k lines of daily data

CC prod exports to a csv with extra info Access can't handle

Superfluous columns need to be removed.

Headers need to jibe with AC_DAILY in Access

Date format yyyy-mm-dd needs to be converted to mm/dd/yyyy

Steps:

Step 1 Save the file linked below to a folder

Step 2 Put a csv file export from ComboCurve in that folder

Step 3 Press the "RUN" button to pick that file and convert

Step 4 Wait - This may take some time if the csv is large (many lines of data). File will be named "AC_DAILY.txt"

Step 4 Import to ARIES via Access

Note: The file selector no longer requires the file be named AC_DAILY or even be in the same folder as the converter, etc.

Note: ARIES exports strip out "INPT" from Chosen ID when a well is created in CC for instance.  So this macro also strips out "INPT" from Chosen ID to allow it to match up to ARIES db exported from CC.

• Related Articles

• ComboCurve: ARIES Import/Export Conversions – Currently Unsupported Items

  The current version of the front-end ARIES import interface handles the majority of ARIES database imports and exports. Some of the more complex and less commonly used syntax, especially certain overlay definitions, might not be currently handled, ...

• ComboCurve: ARIES Import - Scenario and/or Forecasts Methods

  ComboCurve: ARIES Import - Scenario and/or Forecasts Methods Initializing Click on the hamburger icon at the top of any ComboCurve screen and then select Data Import Next, select CREATE DATA IMPORT ==> New ARIES Import (.accdb or .mdb) Note on the ...

• ComboCurve: ARIES - Importing and Exporting Forecasts via .txt in the Forecast Module

  Importing and Exporting Forecasts to ComboCurve from ARIES Importing Forecast to ComboCurve From ARIES ComboCurve has a method to ingest forecasts (only, without doing a full db import) from ARIES. This involves exporting your forecasts from ARIES ...

• ComboCurve: ARIES - Preparing and Transferring Access databases (.accdb or .mdb)

  Preparing and Transferring ARIES Access databases (.accdb or .mdb) General Size Limits ComboCurve has full support for ARIES (MS Access databases) and PHDWin imports. Feel free to submit a ticket and a Customer Success Representative can help in the ...

• ComboCurve: Creating Single Segment (by x Segments) Arps Imports from Volumetric (ARIES, PHDWin, Spotfire, etc) through csv

  ARIES has volumetric forecasting by LOAD lines. This brings in table data to the economics editor by substitution instead of or in addition to Arps parameters. PHDWin and ComboCurve also have volumetric forecasting where you load production data into ...