Importing & Exporting

joselv

I have been trying to use the import export features of Aware IM but have had mixed success.

I have a relational database in MySQL with about 500k records. I need to import those records and their accompanying relationships into my Aware IM application.

I have not even been able to import simple relationships such as U.S. states and their related counties.

At this point, I would rather do direct import from MySQL to MySQL (I am using MySQL within Aware IM) but AIM has other columns that I do not know what they are (_REM, RMA, _RID, etc) that are not making it possible.

Can someone please help me understand exactly how one can import lots of data from an existing MySQL db into AIM? I have already watched the tutorial on import export templates and it was not helpful.

This is a critical step for me in evaluating AIM and if I spend anymore time trying to figure this out I will look at other offerings. Data import/export should be the easier part of this process.

Thanks!

joselv

Also, one particular problem I am having is that when I try to import existing data with existing ID's into AIM the ID's are not kept and instead new ID's are being created.

When I import existing data, the ID's MUST be respected and kept, as I have too many records that depend on those ID's to maintain relationships.

aware_support

Aware IM always maintains it's own ID's but it also respects all existing values as long as you don't call them ID when you import. (ID is a reserved name in Aware IM)
You should NOT import directly into the REM, RMA and RID fields - these are fields used internally by Aware IM
If you want to import a related record you need to either use the Aware IM relationships or import raw values and manage relationships manually.

Please attach an example of the record you need to import into Aware IM and we'll explain what you need to do.

joselv

Support,

Yes, I understand that AIM uses ID for values. What I am trying to do is import my existing MySQL database into AIM without having to replace my existing ID values. So for example, if several tables in my DB use specific ID values to reference a state or county, then when I create new BOs in AIM for state and county and import the data, the IDs MUST stay the same; otherwise I will have problems.

I know you mentioned that I should NOT import directly into AIM but that is exactly what I am doing because it is the only way I am getting the data in the way I want it.

I have a database with close to 100 tables and many relationships that need to be kept in tact. The import/export process outlined in the manual and in the video really did not help me.

So far, it has been MUCH easier to work directly through MySQL to import the data from my DB into AIM's MySQL instance. It is working fine so far. I am taking note of the REM, RMA and RID fields as well and updating those as they need to be.

At this point, I think I have managed to solve my original problem. As I add more tables (BOs) and the attendant relationships, I will know quickly if I am doing something wrong.

Thanks!

Jose

Thanks!