delimited files), one each for the three Axapta tables: InventTable,
InventTableModule, and InventTxt. These CSV files contain the data to
be imported.
Then we created a 'custom' Definition Group in Administration module,
Periodic folder, Data Export/Import folder, Definition Groups. Add a
record, make an entry for Definitions Group and Name and then
select 'Custom' for the Type. Then click on the Table Setup button.
For the Inventory data, we created three records in the Table Setup
screen, one for each of the Axapta tables to be populated. You can
also create a separate Definition Group for each table with only one
record each in Table setup. Seems to work fine either way.
For each record in the table setup screen, you must supply the name
of the Axapta table to be populated, set the status, and supply the
path and name of the CSV file containing the data to be imported.
Status is a little tricky. After each import attempt, the Status is
set to 'Imported in part' or 'Imported in total'. In order to do
another import for this same table, you must change the status
setting either to 'Delete and import' (to erase any existing data and
import the data in the CSV file) or to 'Import' which will append the
data in the CSV file to any existing data in the Axapta table. If you
do not change this status setting to 'Delete and import' or 'Import'
before clicking on the Import button, nothing will happen and you
will not get any message from Axapta telling you why!
For each record in the table setup screen, you must click on the
field setup button and create a record for each field in the Axapta
table that is to be populated. The field number column is the
corresponding column in the CSV file. Select the check box in the
Active column for the fields in the Axapta table that you want
populated; deselect the checkbox for those fields for which there is
no data.
After all the Field setups are ready, you can close that screen and
close the Table Setup screen and click on the 'Import' button on the
first screen. Don't expect it to work correctly the first time. You
will probably have to make corrections to the field setups and try
again. If there is no data currently in the table you are importing
to, then there is no problem. You can select a status of 'Delete and
import' before each attempt and it will wipe out the previous
unsuccessful attempt. If there is existing data in the table, then
you may want to first export it or in some other way back it up so
that it is not lost.
Hope this helps,
Stan
--- In [email protected], "shergillsuki"
<[EMAIL PROTECTED]> wrote:
>
> Hi,
> I'm new to Axapta.
> I'm developing an import.
> I've got my text file handling logic working.
> But can find any examples of populating the InventTable and
BOMTables.
> Can someone send me an example.
>
> Thanks,
> Suki
>
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
