how can manually import webcontent, I try using lar but its giving me errors and doesnt import nothing, which tables do I have to import data from?

Thanks in advance. (liferay 6.1.1 tomcat 7.0.25 ubuntu 11.10 java sun 1.6, Mysql Ver 14.14 Distrib 5.1.61

Never touch the tables directly. Liferay is the only entity that should be modifying the tables. Only use Liferay APIs for the import.

Rather than trying to backdoor the inserts in, how about sharing the errors and maybe we can help with those.

here is the error may is about a content structure, I have the default-web-content-hook could this hook be the couse of the error..?

Caused by: com.drew.metadata.MetadataException: Unsupported component id: 67
at com.drew.metadata.jpeg.JpegComponent.getComponentName(Unknown Source)
at com.drew.metadata.jpeg.JpegDescriptor.getComponentDataDescription(Unknown Source)
at com.drew.metadata.jpeg.JpegDescriptor.getDescription(Unknown Source)
at com.drew.metadata.Directory.getDescription(Unknown Source)
at com.drew.metadata.Tag.getDescription(Unknown Source)
at org.apache.tika.parser.image.ImageMetadataExtractor$CopyUnknownFieldsHandler.handle(ImageMetadataExtractor.java:191)
at org.apache.tika.parser.image.ImageMetadataExtractor.handle(ImageMetadataExtractor.java:133)
at org.apache.tika.parser.image.ImageMetadataExtractor.handle(ImageMetadataExtractor.java:120)
at org.apache.tika.parser.image.ImageMetadataExtractor.parseJpeg(ImageMetadataExtractor.java:90)
... 193 more
14:58:22,570 ERROR [ExportImportAction:299] com.liferay.portal.kernel.lar.PortletDataException: com.liferay.portlet.journal.StructureNameException
com.liferay.portal.kernel.lar.PortletDataException: com.liferay.portlet.journal.StructureNameException
at com.liferay.portal.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:78)
at com.liferay.portal.lar.PortletImporter.importPortletData(PortletImporter.java:956)
at com.liferay.portal.lar.PortletImporter.importPortletData(PortletImporter.java:896)
at com.liferay.portal.lar.PortletImporter.doImportPortletInfo(PortletImporter.java:457)
at com.liferay.portal.lar.PortletImporter.importPortletInfo(PortletImporter.java:131)
at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importPortletInfo(LayoutLocalServiceImpl.java:1451)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:320)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.liferay.portal.service.impl.LayoutLocalServiceVirtualLayoutsAdvice.invoke(LayoutLocalServiceVirtualLayoutsAdvice.java:152)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice.invoke(LayoutLocalServiceStagingAdvice.java:102)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy26.importPortletInfo(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at $Proxy27.importPortletInfo(Unknown Source)
at com.liferay.portal.service.impl.LayoutServiceImpl.importPortletInfo(LayoutServiceImpl.java:684)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)

The first error seems to be related to meta data within the jpeg itself. Looking at the code for metadata-extractor-2.4.0-beta-1 (the version used in Liferay 6.1 CE GA 1), 67 is definitely not a correct component id and would seem to indicate that the jpeg itself is somehow corrupted.

The second one is related to a structure name (perhaps a missing structure?), but would need the root cause info to track down where it's getting thrown from.

I have the default-web-content-hook that maybe related to the error, I have only one structure and template that I created.

the jpeg issue is fixed, there were pics created with coreldraw, I remove removed the default_web_content portlet structures and created manually but the error it's still happening.

Do you still get the error when you delete the structure and try to export? How about when you use a different name with only alphabets. Names containing others characters sometimes result in error.