bbdesign

I printed out the listing of IEM's import order file fields and used that to create my file. I am using a fixed-field format.

When I tried my first import, data was shifted all over the place. I looked at the import preview screen and discovered the reason... the fields IEM is importing into are different from what is in the documentation! What's up with that?

For example, the first field in the preview screen is a logical field called MULTISHIP. This field is not identified in the documentation.

There is a field called INTERNET_ID at field position 71 (it is in the documentation, but at field position 105).

After field position 93 things really get crazy, its completely different.

Does anyone know when these changes occured? I thought my documentation was up-to-date, but maybe Dydacomp never released a newer version? What confidence should I have that the next time we upgrade MOM the format will not change again, making my import files useless?

Thank you.

The ENDSHARE table contains information about shipped packages, including tracking numbers. However, the order number is MOM's order number. I am trying to find a way to pull up ENDSHARE records based on one of the fields in my IEM import file. For example, I am populating ODR_NUM in my import file with my temporary order number, as suggested in the MOM manual.

There is a field called THIRDPARTY, then TPSHIPACCT, although I'm not sure what that field is. Also TPCARDNUM and TPEXP, although I'm not sure if any of these will do what I want.

Anyone have any experience with this?

Thanks!

I'm setting up IEM imports for the first time and am stuck on just a few fields...

CARDTYPE = I assume this is Visa, MasterCard, etc. Where can I find the list of valid codes? Field length is only two, so I assume its an abbreviated code (VI, MC, something like that)

COUNTRY = MOM appears to be using a 3-digit country code. Where can I find the code list? Could not find it in the MOM manual or on this website

INTERNET = In my Excel file, some of the cell data is corrupted... I cannot read the description of this field, but it sounds like it might be important. Says its a LOGICAL type field, but I'm not sure what this field means.

CC_OTHER = Not sure what this is, description says "credit card ID"

Considering there are 130 fields, only needing help with 4 isn't too bad, I guess! I would appreciate any assistance with finishing this up. Thanks!

-Brad

I'm a complete newbie to MOM. Yet, I've been assigned the task of creating a custom shopping cart system. I need to export out the product/pricing data to a web server. I was hoping to be able to look in the MOM directory and easily spot a table with this information. Instead, I found dozens of DBF files, one of which was over 650mb!!! Anyway, is there posted somewhere a reference as to what all these tables are, and how I might understand which ones I need, how they interact, etc.? My needs are very simple for now, just need product titles, descriptions, item numbers, prices, etc.

Any help would be greatly appreciated!