Latest Inquiries - Data Extraction Software

www,siamestate.eu

Submitted: 1/29/2013

Hi

I am testing you software at the moment as I need some like this in order to import properties to my web site

It works very good and I created some projects but have now run into to problems.

  1. how do I extract the url for the pictures?ยจ
  2. How can I extract the calendar dates?

Peter

Replied: 1/29/2013 4:15:52 PM
Please attach your project, then give more details with the two points that you're asking.
Replied: 2/2/2013 11:56:25 PM
I'm don't seem to see where has the date intervals in the URL - http://www.roombyroom-thailand.com/property_for_rent/view/710

By your screenshot, thought you can first get the month, then combine it into a date element,
maybe content transofrmation script can help you to make the transformation in the date element.

F.Y.I:

Content Transformation
Replied: 2/2/2013 12:24:09 AM
Hi

Thanks for the demo for extracting the pictures. I haven't figured out how it works excatly yet but i will have a look in to the documentation of Visual Web Ripper.

Concerning the Calendar part see attached screen dump (RBR Calender) og the corresponding link http://www.roombyroom-thailand.com/property_for_rent/view/710.

Date intervals marked with a red background colour should be transformed into a start date and a end date of the booking that I can import daily in my database. Se attached screen dump (SiamEstate Calender).

Br

Peter

RBR Calender.png
SiamEstate Calender.png

Replied: 2/3/2013 4:39:51 PM
Concerning the extract_pic_demo I am totally lost. I not an expert at all on these things and here you really lost me.

It seems to me that you used my CSV file as input file. Is that correct ?
=====================================================================
Basically, I've answered ALL at first reply:

"See the attached demo project - extract_pic_demo.rip, I use input data source to feed in the csv file , then creating a 'photos' group template to further feed in the 'photos' column from the input data source , detailedly, the setting for 'photos' group is finished by c# script in Advanced tab > Input data section, after the 'photos' group template, there is the actual 'image' element to get each photo url genearted by the 'photos' group template, this is finished by content transformation script."

The CSV-file is a standard CSV-file which I can use to upload properties from the admin part of my web site. What I was looking for was the posibility to create such a file with the required informations which I then could upload in to my database via the admin part.
=======================================
What required informations? are you talking about the extracted pictures? you can export data as file archive, you also can directly export data to database..

F.Y.I:

Replied: 2/4/2013 10:05:00 AM
Hi

Please see attached project.

I can't get it to extract all the pictures links as I want it to do. What am I doing wrong?

Br

Peter
Roombyroom-thailand pic.rip

Replied: 1/30/2013 10:20:08 AM
Hi

Please find enclosed my project as requested,

I am running a web site www.siamestate.eu which as standard can import properties by using a CSV-file. I have atached an exempel of the CSV-file.

As you can see from the CSV-file the program can import the pictures via a URL-link to the picture. So my question is "How can I extract the URL to the picture?"

Further I would like to extract the date intervals in which the property is booked. How can that be done?

The later one will in the end be a separate extraxtion at the end as that has to be done and uploaded in my own database daily.

Hope you can help me. Thanks in advance

Peter
Roombyroom-thailand-Ver03.rip
1_export_ads (2).csv

Replied: 2/4/2013 4:30:20 PM
You need to create a list of all image elements as page area template.

F.Y.I:

Creating Lists
Roombyroom-thailand pic.rip

Replied: 1/30/2013 5:36:49 PM
As you can see from the CSV-file the program can import the pictures via a URL-link to the picture. So my question is "How can I extract the URL to the picture?"
=================================
See the attached demo project - extract_pic_demo.rip, I use input data source to feed in the csv file , then creating a 'photos' group template to further feed in the 'photos' column from the input data source , detailedly, the setting for 'photos' group is finished by c# script in Advanced tab > Input data section, after the 'photos' group template, there is the actual 'image' element to get each photo url genearted by the 'photos' group template, this is finished by content transformation script.

F.Y.I:

Using an input data source

Input Data Script

Content Transformation


Further I would like to extract the date intervals in which the property is booked. How can that be done?
================================
Can you please attach a screen-shot show me an example where the date intervals is? which one template / element content is associated with the date intervals that you expect?

Regarding the last question, you can set up the export target as your remote database:

F.Y.I:

Data Export Targets

Also, you can schedule your project daily:

F.Y.I:

Scheduling
extract_pic_demo.rip

Replied: 2/3/2013 5:59:57 AM
Hi

Concerning the extract_pic_demo I am totally lost. I not an expert at all on these things and here you really lost me.

It seems to me that you used my CSV file as input file. Is that correct ?

The CSV-file is a standard CSV-file which I can use to upload properties from the admin part of my web site. What I was looking for was the posibility to create such a file with the required informations which I then could upload in to my database via the admin part.

Peter