+5Hi everybody,
I have a shapefile (line) and it includes fields:year, time, commune, province... and I have a .mdb that has a table empty have fields: a_xa, b_ti.
I want to get spatial data from shapefile to table in .mdb and get attribute (commune = a_xa, province = b_ti). How can I do?
Thank you
+49You can create a new workspace, add the shapefile as a reader and a writer for the mdb. When you create that writer you have the option to import the feature type (table) definition from an existing dataset, so do that. Connect the shapefile reader to an AttributeManager transformer to rename the attributes and then connect that to the MDB writer.
+5You can create a new workspace, add the shapefile as a reader and a writer for the mdb. When you create that writer you have the option to import the feature type (table) definition from an existing dataset, so do that. Connect the shapefile reader to an AttributeManager transformer to rename the attributes and then connect that to the MDB writer.
I want to ask some questions:
1. In the attributeManager, when I import the feature tye (from .mdb), the fields seem mixed sort. I want to keep the sort the same .mdb table.
2. In writer, I want to remove all field from shapefile, only keep in mdb fields. How to the way to move automatically?
Best regards,
+49You can edit the writer properties (the little cog wheel icon) and add or remove any attributes you like there.
As for the sorting, the AttributeManager should maintain the attribute order of the input data, can you post a screenshot?
+5You can edit the writer properties (the little cog wheel icon) and add or remove any attributes you like there.
As for the sorting, the AttributeManager should maintain the attribute order of the input data, can you post a screenshot?
+49
+49
+5
But I got a problem. My .mdb have attribute some field, but when I give it into AttributeManager, it has not attribute (empty). I think the problem is in AttributeManager when Import .mdb.
Could you tell me how to fix it to get attribute information?
+49Can you post your entire workspace? That would make it a bit easier to give some advice.
+5Can you post your entire workspace? That would make it a bit easier to give some advice.
join-geometry-fields-to-gdb.fmwt
+5Can you post your entire workspace? That would make it a bit easier to give some advice.
template-aspen.zip
+49template-aspen.zip
Instead of the AttributeManager you can use a DatabaseJoiner to match the MDB with the shapefile. It looks like the column NAME in the shapefile matches the bus_name in the MDB, so enter that. In Fields To Add you can pick which fields from the MDB you want to copy. That should do the trick.
+5template-aspen.zip
Actually, I want to copy table structure and join attribute (.mdb). May be, it will not match column (can be chose by manual).
I tried DatabaseJoiner, it's okie. I chose a field join, and add fields on a list attribute.
And I will connect some field with writer :). Thank you so much :)
+5I have a question about connect fields.
For example: I have an excel file that description what is connected the same screenshot.
How to the way to connect fields automatically? Thank you
+49I have a question about connect fields.
For example: I have an excel file that description what is connected the same screenshot.
How to the way to connect fields automatically? Thank you
There's some tutorials on the SchemaMapper here.
.
+5I have a question about connect fields.
For example: I have an excel file that description what is connected the same screenshot.
How to the way to connect fields automatically? Thank you
+5I have a question about connect fields.
For example: I have an excel file that description what is connected the same screenshot.
How to the way to connect fields automatically? Thank you
I tried the example attribute Mapping by SchemaMapper. I see that writer have attribute replace (red box). And I tried other writer, I can't get the same.
In my mind, the writer will make automatically from SchemaMapper, but my writer test can't.
Could you tell me why? Thank you
+49I tried the example attribute Mapping by SchemaMapper. I see that writer have attribute replace (red box). And I tried other writer, I can't get the same.
In my mind, the writer will make automatically from SchemaMapper, but my writer test can't.
Could you tell me why? Thank you
Alternatively, you can add, remove and rename attributes there.
+5
+5I tried the example attribute Mapping by SchemaMapper. I see that writer have attribute replace (red box). And I tried other writer, I can't get the same.
In my mind, the writer will make automatically from SchemaMapper, but my writer test can't.
Could you tell me why? Thank you
+49
+5
So I can't do it
+5Ah, I have a question like update field values.
I want to update values field from shapefile to .mdb table by automatically, no need change fieldname.
This is an example. I want to update all values from fields: Fromnode , ToNode to bus1_name and bus2_name, and I have excel description columns to connect together.
Could you tell me how to do it automatically? Thank you
+49Ah, I have a question like update field values.
I want to update values field from shapefile to .mdb table by automatically, no need change fieldname.
This is an example. I want to update all values from fields: Fromnode , ToNode to bus1_name and bus2_name, and I have excel description columns to connect together.
Could you tell me how to do it automatically? Thank you
+5
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
