Resolved Timeout on import

Hello,

m attempting to setup an article import for form2content but am currently receiving a timeout as per error below on importing, but unfortunetly its not creating a log file for the process.
---
An error has occured during the import. Below the information received from the server.
Status error: 504
Status message: Gateway Timeout
Gateway Timeout

The gateway did not receive a timely response from the upstream server or application.

Have a look at Manage Timeouts document. It explains on how to configure your template to avoid timeout in imports.

I have a feeling this may be related to the alias and would like to ask how I can setup a rule to insert dashes (-) inbetween words imported from a field for the alias, or will this be done automatically when articles are created on import?

Replacing spaces with - will be automatically done by CSVI on import.

Also I wish to import the created date, currently I have the date in the following format within my import file ' 15/05/2015 17:29:38' (with the space at the beginning) but am aware the format in form2content is '21-08-2014 07:55:05' therefore I need to remove a space from the beginning and one from inbetween the date and time, (and obiously replace the - with a /) I wondered how I might go about setting up a rule to remove spaces as necessary, would I have to setup a rule ' 01/' to ' 31/' replace with '01-' to '31-' and another for '/2015 ' to '/2018 ' replace with '-2015' to '-2018' would this work and form2content recognise this as a date?

You need to create two rules using CSVI Multireplace rule plugin. The first rule will use Find and Replace operation to look for space and replace with nothing so in your Find field give a space and Replace should be nothing and save the rule. The second rule will be using the Operation Custom date format where you enter date format like 'Y-m-d H:i:s' and save the rule. Apply both the rules on created_on field in the order that first rule will be replace space and the next will be date format. Run the import and check.

Hi, Many thanks for your quick response and help.

Regarding the created date, ive done as you said but unfortunetly in the import preview its showing the created date as '15/05/201517:29:38' therefore it seems the first rule has taken effect but not the second.
I tried removing the first rule to see to test but still the date format wasn't changed, also I tried creating another rule (ordered 2nd (inbetween the other 2 rules) to add back a space between the date and the time, which when previewing the import the data for the created field was '15/05/2015 17:29:38' but unfortunetly the date format change didn't happen.
I then tried creating another rule replacing '/' with '-' which was showing the date in the correct format within the import preview '15-05-2015 17:29:38' and imported with success, but when viewing the article imported via form2content article manager the created date shows as '30-11--0001' and when I click the article to edit I get a blank white page (with error reporting set to development it shows no errors).

Your advice would be much appreciated, thanks in advance!

Also I was wondering how to assign (which f2c field it is) a form2content content type to articles being imported, this might well be related to the white page error when viewing articles ..as these articles imported currently have no content type.

Once again many thanks in advance!

Hello,
For the rule, can you post a screenshot on how you have the rule set up?

Also I was wondering how to assign (which f2c field it is) a form2content content type to articles being imported, this might well be related to the white page error when viewing articles ..as these articles imported currently have no content type.

The field for content type is projecttitle but i see that your import template has this field and without this field CSVI will not run the import and would have thrown error that missing required field. It is very much possible that you are having a 500 Internal server error while viewing the articles. Can you check in your server error logs and see what is logged in for this error?

Hi, Thanks again for your response/help!

Please see attached for the rules setup as you explained.



Also regarding the error logs unfortunetly I could not find any messages in the error log that had been added during the past week (whilst working on this).

Once again thanks for your help!

Hello,
Your rule setup looks good. So looking at your screenshot, You have CSVI 7.6.1 version installed and there was a issue which was fixed with date format in CSVI 7.6.2 version for Multi replace plugin. Can you update to this version and check?

Also regarding the error logs unfortunetly I could not find any messages in the error log that had been added during the past week (whilst working on this).

While you work on this, you can also try creating a test article manually and see how it goes.

HI, Thanks again for your response.

Ive updated to 7.6.2 and also added a couple of additional fields to form2content and then attempted to update the available fields on CSVI (ive done this successfully many times before) but unfortunetly im getting the following error:

Error
Duplicate entry 'access-f2c_form-com_form2content-export' for key 'component_name_table'
The list of available fields is out-of-date for extension com_form2content. Update the list to ensure you have all fields available.

Also now when I attempt an import preview, strangly it now stops on category_path with no data shows for this field, when prior to the update/adding fields to f2c it was loading the import preview fine.

Once again many thanks for your help!

Hello,
Did you also update your Form2Content extension to 7.6.2 version?

Hi, Many thanks for your quick response, you were right, no I hadn't updated the csvi f2c extension and it fixed many of the issues I described in my last post. Many thanks!

But unfortunetly the date format still isn't working correctly as its still showing as '15/05/201517:29:38' in the import preview.

Thanks in advance!

Hello,

But unfortunetly the date format still isn't working correctly as its still showing as '15/05/201517:29:38' in the import preview.

Is the date format rule applied on Date field? Because last time when i checked your site there was no date format rule applied on it. Can you check that?

Hi, Thanks again for your help/response!

I have a Date field which will display the date in the original 15/06/2015 15:05 format but have a rule created on the date field to copy the value to the created field where I have the 2 rules setup as you outlined in a previous post to change the date to the format recognised by f2c/joomla,... on the created field the 1st rule is taking effect and removing the spaces its just the 2nd rule which isn't taking effect/changing the date format.

Thanks again!

Hello,
I tried to do few changes to your template and can see the date format not changed. Can you send me the FTP access to the site?

Hi, Once again thanks for your help!

Hello,
Please check your site for date format. I did few changes to your date_format_f2cdate rule. Preview looks good to me. Run the import and let me know.

Hi, Thanks again for your quick response/help!

Yep thats fixed the date issue, thanks! The import seems fine now and articles are being created correctly... EXCEPT they are all being set to unpublished, although I have the published field setup with the default value set to 1 ..which is showing fine in the import preview.

Once again your help would be much appreciated, thanks in advance!

Hello,
Glad to know that date issue is fixed. Can you post the latest debug log to check? To know to get the debug log check How to collect debug information document.

Hi, Yep sure please see attached, many thanks!

com_csvi.log.92.zip

Hello,
The field name to be used to publish articles is state and not published. Try adding this field with value set to default 1.