topic Re: Shape to PostGIS in Talend Studio

Shape to PostGIS

Anonymous — Sat, 16 Nov 2024 14:23:53 GMT

If I have a shape file with one or more fields "string" type and I import into PostGIS get all fields string set to varchar (10485760): why? How do I get a value other than 10485760 (for example varchar (30)? Is Possible?
Another question: can I import into PostGIS more shape files in one job?
Thanks
Best regards
I use:
SDI 2.3.2
sShapefileInput
sPostgisOutput

Re: Shape to PostGIS

Anonymous — Tue, 15 Apr 2008 08:15:52 GMT

Hi, For the time being String fields are mapped to varchar(10485760) as this is the default GeoTools mapping. We are currently working on improving that point and allowing to insert/update/append data to an existing PostGIS table.
> Another question: can I import into PostGIS more shape files in one job?
Yep, just add another ShapefileInput and another sPostgisOutput components.
If you want to merge two Shape into one postgis table use a tMerge Component in between.
Ciao.
Francois

Re: Shape to PostGIS

Anonymous — Tue, 15 Apr 2008 08:43:13 GMT

Hi Fxp,
for the second answer: if I have a list of shape file (more then 10-20) and I want to put in PostGis in which mode I can put them in one time?
Thanks
Bye

Re: Shape to PostGIS

Anonymous — Fri, 18 Apr 2008 07:16:29 GMT

Hi,
For more than 10 shapefiles, you could use a tFileList component, select your directory, search pattern will be *.shp and could be recursive. Then iterate tFileList on tShapefileInput and then use tMerge to append all shape's features.
That way, it will search for all file *.shp, read all shape one after the other and the tMerge will append all geometries. You should have shapefile with the same attributes.
HTH.
Francois

Re: Shape to PostGIS

Anonymous — Fri, 18 Apr 2008 09:13:26 GMT

Hi,
if I have, for example, more than 10 different shapefiles and I want to put in more 10 different PostGIS layers how I can to do? How to set different schema in automatic mode?
Thanks
Bye

Re: Shape to PostGIS

Anonymous — Mon, 21 Apr 2008 16:28:37 GMT

Hi, what is automatic mode ?
If you have 10 inputs and 10 outputs components, just define all transformations on the workspace.
Schema will be defined for each inputs and outputs components. If you always use the same schema, you can save it as a flat XML file (from the schema editor) or use the metadata section in the repository to save it.
HTH.
Francois

Re: Shape to PostGIS

Anonymous — Wed, 23 Apr 2008 18:59:05 GMT

Hi,
If I have more than 10 different inputs and many different outputs? Is there an automatic mode for retrieve the schema of all inputs?
Thanks
Bye

Re: Shape to PostGIS

Anonymous — Wed, 30 Apr 2008 18:52:09 GMT

I have the same interest.
My question is... How can I retrieve a Shape's Schema?
Thanks,
Bye

Re: Shape to PostGIS

Anonymous — Wed, 14 May 2008 10:08:13 GMT

Hi,
There is no "automatic mode" at this time in SDI as Metadata for DB, csv files....
This functionality will be available soon in SDI.
--
Mathieu